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:
Technology------------------------------------------------------
Job Family:
Applications Development------------------------------------------------------
Time Type:
Full time------------------------------------------------------
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.
Featured Career Areas
Saved Jobs
You have no saved jobs
Previously Viewed Jobs
You have no viewed jobs