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------------------------------------------------------
Most Relevant Skills
Please see the requirements listed above.------------------------------------------------------
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------
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.
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
