PL/SQL Developer in Atlanta, GA at HUNTER Technical Resources

Date Posted: 10/27/2020

Job Snapshot

Job Description


Job Details:
  • Develops basic to moderately complex code using front and / or back end programming languages within multiple platforms as needed in collaboration with business and technology teams for internal and external client software solutions.
  • Designs, creates, and delivers routine to moderately complex program specifications for code development and support on multiple projects/issues with a wide understanding of the application / database to better align interactions and technologies.
  • Analyzes, modifies, and develops moderately complex code/unit testing in order to develop concise application documentation. Performs testing and validation requirements for moderately complex code changes.
  • Performs corrective measures for moderately complex code deficiencies and escalates alternative proposals.
  • Provides support to leadership for the design, development and enforcement of business / infrastructure application standards to include associated controls, procedures and monitoring to ensure compliance and accuracy of data.
  • Applies a full understanding of procedures, methodology and application standards to include Payment Card Industry (PCI) security compliance.
  • Conducts and provides basic billable hours and resource estimates on initiatives, projects and issues.
  • Assists with on-the-job training and provides guidance to other software engineers.

 

Qualifications:
  • Bachelor' s degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field and/or 6 – 8 years of development experience using PL/SQL
  • Very good knowledge of SQL (aggregation functions, Joins and various built-in SQL functions and data types).
  • Experience in a high volume, highly scalable transaction processing environment.
  • Sound knowledge of advanced SQL, which includes analytical SQL, hierarchical SQL, dynamic SQLs and regular expressions.
  • Sound knowledge of advanced PL/SQL, PL/SQL collections, external subroutines, web-interface, n/w interface, file handling functions.
  • Sound knowledge for SQL performance tuning, analyzing SQL joins execution plan, indexing, partitioning and optimizer hints.
  • Sound knowledge of PL/SQL performance tuning, AWR, ASH analysis, database statistics gathering.

 

Minimum Qualifications:
  • Must have good problem-solving, troubleshooting and communication skills
  • Flexible with multitasking in a rapidly changing environment
  • Ability to work well within a team
  • In-depth knowledge of Oracle database objects – tables, indexes, collections, directories, sequences, triggers, packages, etc

 

Preferred Qualifications:
  • Basic knowledge of Oracle database administrations.
  • Good knowledge of UNIX commands, basic understanding of Shell scripting.
  • Good knowledge of Advanced Queuing, DBMS_SCHEDULER and setting up CRON jobs.
  • Experience with Oracle Database 11g and above
  • Experience using software development tools including source control (Git, SVN), quality management ( Agile Central), and Continuous Integration tools (Jenkins, XL Release) is a plus.
  • Experience with Java or other object-oriented languages helpful