Oracle Database Developer (PLSQL) - Assistant Vice President - C12 - Pune
Citi
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 and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. 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 the "EEO is the Law" poster. View the EEO is the Law Supplement.
View the EEO Policy Statement.
View the Pay Transparency Posting