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