Senior Oracle Developer
Company
Cognizant
Location
Charlotte, NC
Type
Full Time
Job 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
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 DetailsManaging 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 DetailsManaging 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 DetailsLead 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 DetailsData 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 DetailsSr 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