Senior Oracle Developer

Description

Job Title: Senior Oracle Developer

Location: Charlotte, NC, USA

Full Time

Technology: PL/SQL and Database SQL, UNIX scripting

Job Summary:

Customer is looking for Oracle Senior Developer that support Oracle DBs and have PL/SQL development experience. They will be migrating to the cloud over the next few years, but they need someone that has experience to support the current technologies as they begin to shift to the cloud.

Job Responsibilities:

The Senior Oracle Developer will be a part of team that supports Oracle databases and PL/SQL development. • Design, implement, code, test and maintain Oracle PL/SQL and Unix Script code and functionality. • Prepare and review system documentation composed by development teams.• Perform modifications to and maintenance of operational programs and procedures. • Develops effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications. • Applies best practice for tuning for overall system performance. • Supports software development and test teams throughout the software development lifecycle. Includes incremental script execution and defect resolution. • Provides support for software releases • Researches interfaces to identify and code required updates to support integration • 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• The Senior Oracle Developer will be a part of team that supports Oracle databases and PL/SQL development. • Design, implement, code, test and maintain Oracle PL/SQL and Unix Script code and functionality. • Prepare and review system documentation composed by development teams. • Perform modifications to and maintenance of operational programs and procedures. • Develops effective and efficient PL/SQL packages, procedures, triggers and functions according to design specifications. • Applies best practice for tuning for overall system performance. • Supports software development and test teams throughout the software development lifecycle. Includes incremental script execution and defect resolution. • Provides support for software releases • Researches interfaces to identify and code required updates to support integration • 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 • 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.

Minimum Qualifications:

Experience in

1) Oracle SQL scripting and database stored code (triggers, packages, procedures, and functions)

2) UNIX Shell scripting

3) Oracle Database core concepts

4) Oracle Performance tuning

Preferred Qualifications:

NiFi, AWS, Snowflake

Years of Experience Needed:

12-13 Years

Qualifications

Technical Skills

SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 Database and SQL PL4 Required 2 PL/SQL PL3 Required

* Proficiency Legends

Proficiency Level Generic Reference PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels. PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects. PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects. PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.