Job Description

Key Responsibilities:

Design, develop and maintain complex

PL/SQL

code and stored procedure to support business logic and data processing requirements. Develop and maintain

data models

for new and existing applications ensuring scalability, flexibility and integrity. Perform

database performance tuning

and

query optimizations

to enhance system efficiency. Ensure

data quality

standards are met through robust validation, transformation and cleansing processes. Administer and support

Oracle

databases ensuring high availability, backup and recovery and proactive monitoring. Provide

database maintenance and support

including patching, upgrades and troubleshooting production issues. Monitor system health and implement proactive alerts and diagnostics for performance and capacity management. Support and implement solutions using

NoSQL database

(e.g. MongoDB, Cassandra) where appropriate for specific use case. Collaborate with development teams to ensure

code quality

and best practices in PL/SQL development. Develop and maintain documentation related to data architecture, data flow and database processes.

Required Skills and Qualificatioons:

8-12 years

of experience in

Oracle database

development and administration

, Mondgo DB

Development and administration String proficiency in

PL/SQL,

SQL, Indexes, Triggers, Sequences, procedures, functions and Oracle database internals. Proven experience with

data modeling

(logical and physical), normalization and schema design Expertise in

performance tuning, query optimization

and indexing strategies. Hands-on experience with

relational database

(Oracle, PostgresSQL, MySQL) and

NoSQL database

(e.g. MongoDB, Cassandra) Solid understanding of

database monitoring tools

and

tunning methodologies.

Experience in

data quality management

practices and tools Strong exposure to

code quality standards

and tools for PL/SQL development (e.g. TOAD, SQL Developer, SonarQube) Knowledge of backup and recovery strategies, high availability and disaster recovery planning Familiarity with

DevOps practices,

including database CI/CD integration. Familiarity with

Liquibase

for database versioning and deployment automation.

Preferred Skills:

Experience in

cloud-based databases

(e.g. Oracle Cloud, AWS RDS, Azure SQL) Exposure to

ETL tools

and data integration platforms. Familiarity with regulatory compliance standards (e.g. GDPR, HIPPA) related to data management.

Soft Skills:

Strong analytical and problem-solving skills. Excellent communication and documentation abilities. Ability to work independently and as part of a cross-functional team. String attention to detail and commitment to data integrity.

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.