Oracle PL/SQL Developer

Company: ASB Resources
Location: Charlotte
Posted on: May 28, 2023

Job Description:

Requires bachelor's degree or equivalent experience.

Key hands-on team member with a minimum of 7+ years of strong programming experience with PL/SQL stored procedures and complex SQL to develop robust, reliable and high-performance solutions.

Experience with 19c features such as in-memory pinning

Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies

Prior experience working with Apache NiFi, AWS, Snowflake is preferred

Firm understanding of the overall architecture required to support common schema based objects used to store data and implement business logic.

Ability to perform PL/SQL coding assignments including stand-alone SQL scripting and database stored code (triggers, packages, procedures, and functions) in compliance with standards and procedures.

Ability to Setup, Maintain and Enhance Partitioning of Table Spaces

Ability to provide guidance, oversight, and peer review to more junior database developers.

Experience with managing and resolving problems on a live production system.

Solid understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports etc.

Experience working in an Agile delivery environment

Strong written and oral communication skills are essential

Solid work ethic, self-driven with the ability to work with minimal supervision

Aptitude for debugging problems in complex, unfamiliar code

Keywords: ASB Resources, Charlotte , Oracle PL/SQL Developer, IT / Software / Systems , Charlotte, North Carolina