Senior Oracle Developer

Cognizant • Charlotte, NC

Company

Cognizant

Location

Charlotte, NC

Type

Full Time

Job Description

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.

Date Posted

05/10/2023

Views

5

Back to Job Listings ❤️Add To Job List Company Info View Company Reviews
Positive
Subjectivity Score: 0.8

Similar Jobs

Senior Data Analyst - LingaTech

Views in the last 30 days - 0

The job description is for a Senior Data Analyst position that involves creating maintaining and tuning complex SQL scripts developing database soluti...

View Details

Managing Consultant, Back of House Restaurant Technology - Point B

Views in the last 30 days - 0

Point B is a business innovation firm that specializes in transformation by combining advanced technologies and industry expertise They aim to help bu...

View Details

Managing Consultant, Front of House Restaurant Technology - Point B

Views in the last 30 days - 0

Point B is a business innovation firm that specializes in transformation by combining advanced technologies and industry expertise They aim to help bu...

View Details

Lead Developer - Brightspeed

Views in the last 30 days - 0

Brightspeed is a company that aims to revolutionize internet connectivity in rural markets by upgrading copper to fiber optic technologies They are cu...

View Details

Data Engineer - GCP - Lowe’s

Views in the last 30 days - 0

This role involves building components and pipelines for delivering endtoend data solutions for mediumcomplex business problems The individual will un...

View Details

Sr Data Scientist - Supply Chain - Lowe’s

Views in the last 30 days - 0

The Sr Data Scientist role at Lowes involves providing advanced analytical capabilities to support data science initiatives at scale The position invo...

View Details