QUALIFICATIONS:

• 7+ years of hands-on experience in Oracle PL/SQL development.
• Proven experience leading technical development teams.
• Demonstrated expertise in architecting and delivering enterprise-grade solutions on Oracle databases (11g, 12c, 19c).
• Expertise in performance tuning, indexing strategies, and advanced SQL analytics functions.
• Strong understanding of database design principles, normalization, partitioning, and data modeling.
• Familiarity with data security, auditing, and compliance within Oracle environments.
• Proficiency with Oracle SQL Developer, TOAD, DataPump, RMAN, and AWR/ASH reports.
• Strong communication, leadership, and project management skills.

PREFERRED SKILLS:

• Experience with Oracle Cloud Infrastructure (OCI) or other cloud environments (AWS, Azure).
• Knowledge of Oracle APEX or integration with front-end technologies.
• Experience with Agile methodologies and DevOps practices for databases (CI/CD, Liquibase, Flyway).
• Exposure to RESTful APIs and integration patterns using Oracle technologies.
• Understanding of ETL tools (e.g., Informatica, Oracle Data Integrator - ODI) and data warehouse concepts.

EDUCATION:

• Bachelor’s degree in Computer Science, Engineering, or a related field.
  This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
  -

MOST RELEVANT SKILLS

Please see the requirements listed above.
-

OTHER RELEVANT SKILLS

Oracle, Oracle 11g SQL, Oracle Database, Oracle SQL, Toad Sql.
-
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

RESPONSIBILITIES:

• Lead the design, development, and implementation of complex Oracle PL/SQL solutions, ensuring high performance, scalability, and maintainability.
• Architect and deliver enterprise-grade solutions on Oracle databases (11g, 12c, 19c), translating business requirements into effective technical designs.
• Provide technical leadership and mentorship to a team of developers, fostering best practices in Oracle PL/SQL development and database design.
• Apply expert knowledge in performance tuning, indexing strategies, and advanced SQL analytics functions to optimize database queries and procedures.
• Ensure adherence to strong database design principles, including normalization, partitioning, and robust data modeling techniques.
• Implement and enforce data security, auditing, and compliance measures within Oracle environments to protect sensitive information.
• Utilize and guide the team in the effective use of Oracle development tools such as Oracle SQL Developer, TOAD, DataPump, RMAN, and analyzing AWR/ASH reports for performance diagnostics.
• Collaborate effectively with cross-functional teams, including architects, business analysts, and other developers, to ensure seamless integration and project success.
• Manage project tasks and priorities, ensuring timely delivery of high-quality database solutions.
• Contribute to the overall database strategy and architecture, promoting innovation and best practices.