Back to Job Search

PL SQL Developer REMOTE

  • Location: Alpharetta, 30005
  • Salary: 112000.0
  • Job Type:Permanent

Posted 3 months ago

PL /SQL Developer - 100% Remote

Fortune500 firm seeking a PL SQL Developer for their global Production environment.  This PL SQL Developer works throughout the software development life cycle and performs in a utility capacity to create, design, code, debug, maintain, test, implement and validate applications with a broad understanding of a variety of languages and architectures. Analyzes existing applications or formulate logic for new applications, procedures, flowcharting, coding and debugging programs. Maintains and utilizes application and programming documents in the development of code. Recommends changes in development, maintenance and system standards. Creates appropriate deliverables and develops application implementation plans throughout the life cycle in a flexible development environment.

Job Details:

  • Create, design, code, debug, maintain, test, implement and validate applications 
  • Analyze existing applications or formulate logic for new applications, procedures, flowcharting, coding and debugging 
  • Maintain and utilize documents in the development of code. Recommends changes in development, maintenance and system standards.
  • Owns appropriate deliverables and develops application implementation plans throughout the life cycle in an Agile development environment.

Essential functions:

  • 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 / DB to better align interactions and technologies.
  • 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. 

Required Experience:

• 6 – 8 years of development experience using PL/SQL in Oracle environment
• 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 (very large tables)
• 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.
• Good problem-solving, troubleshooting and communication skills
• Flexible with multitasking in a rapidly changing environment
• Ability to work well within a team/good collaboration skills
• In-depth knowledge of Oracle database objects – tables, indexes, collections, directories, sequences, triggers, packages, etc

Preferred Qualifications:

• Basic knowledge of Oracle database 11g and above
• Good knowledge of UNIX commands, basic understanding of Shell scripting.
• Good knowledge of Advanced Queuing, DBMS_SCHEDULER and setting up CRON jobs.
• 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

Excellent benefits including full suite of medical benefits, matching 401(k), 100% remote work, excellent growth potential and much more.  Please send your LinkedIn profile & detailed resume today!

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer including disability and veteran and provides reasonable accommodations for all qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual you may request a reasonable accommodation under the American Disability Act (ADA). If you are a person with a disability needing assistance applying, or at any point in the hiring process, please email us at MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.