Oracle Database Developer (PLSQL) - Assistant Vice President - C12 - Pune

Should have 8-12 years relevant experience as Database Developer (PLSQL)

Must to have skills - Oracle, PLSQL , Complex SQL writing, basic DBA skills

Complex queries, Advanced P/SQL Development (collections, mviews, partitioning etc.), Performance tuning (strong), Data Modeling (medium)

Stored Procedures, functions, packages, triggers, views, and Materialized views

Key skills:

• Understanding of Relational Database concepts
• Strong SQL analytical skills
• Good understanding of Data modelling concepts and Performance Optimization.
• Working knowledge on Database design
• Identify data quality issues and root causes.
• Experience in database objects like Stored Procedures, functions, packages, triggers, views, and Materialized views.
• Hands on with indexing and partition strategies that helps in query performance.
• Experience in Advanced PL/SQL,  bulk Operations and SQL Loader
• Exposure to analysis of Oracle Database AWR/ADDM reports and troubleshooting of database performance issues.
• Assist in the execution/analysis of integration, user acceptance and performance testing.
• Review/Analyze test case results to ensure functionality meets the documented requirement.
• Working knowledge of Jira, Bitbucket, DevOps exposure for CI/CD pipelines and RLM process.
• Ability to work independently and as part of a team, and strong communication skills(verbal and written)
• Performance tuning

Education:

• Bachelor’s degree/University degree or equivalent experience

------------------------------------------------------

Job Family Group:

------------------------------------------------------

Job Family:

------------------------------------------------------

Time Type:

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.