**Should have 8-12 years relevant experience as Database Developer (PLSQL)** **Must to have skills - Oracle, PLSQL , Complex SQL writing, basic DBA skills** **C** **omplex queries, Advanced P/SQL Development (collections, mviews, partitioning etc.), Performance tuning (strong), Data Modeling (medium)** **S** **tored 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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi’s_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.