Oracle Database PL/SQL Developer, Assistant Vice President

Citi is looking for an Oracle Database PL/SQL Developer (Applications Development Senior Programmer Analyst - C12) to design and deliver high-performance Oracle database solutions that power critical business operations across a global financial institution. In this role, you will work at the intersection of database engineering and data delivery, collaborating with cross-functional teams to translate complex business requirements into scalable, production-grade Oracle solutions.

Responsibilities

• Design and build Oracle database solutions including PL/SQL packages, stored procedures, functions, triggers, views, materialized views, and sequences, engineered for high performance, scalability, and long-term maintainability.
• Develop and maintain ETL workflows, data transformation pipelines, validation frameworks, and batch processing solutions that ensure reliable and accurate data movement across systems.
• Create and manage database migration scripts, schema updates, and automated deployment packages to support consistent and repeatable release processes.
• Tune and optimize database performance using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic tools to eliminate bottlenecks and improve throughput.
• Build and maintain database unit tests, regression tests, and data validation tests to verify the integrity of SQL, PL/SQL, ETL, and migration changes across all environments.
• Integrate database solutions into CI/CD pipelines, applying automated testing, deployment, and monitoring practices to support continuous delivery of quality database changes.
• Use AI-powered development tools, including GitHub Copilot and similar assistants, to accelerate SQL and PL/SQL development, code review, documentation, and knowledge sharing.
• Partner with business analysts and stakeholders to capture requirements and translate them into clear, implementable technical specifications.

Required Qualifications & Skills

• Bachelor’s degree in computer science, information technology, or a related field or equivalent experience.
• 5 or more years of hands-on Oracle development, with demonstrated experience designing and delivering complex database solutions in production environments.
• Advanced proficiency in SQL and PL/SQL, including complex query design, table design, data analysis, and table partitioning.
• Practical experience with database performance tuning, covering execution plan analysis, indexing strategies, partitioning techniques, and the use of Oracle monitoring and diagnostic tools.
• Exposure to cloud technologies and platforms (OCI, AWS, or Azure), including an understanding of cloud-hosted database architectures, deployment models, and operational best practices.
• Familiarity with Agile development methodologies and the ability to deliver iteratively within sprint-based workflows.
• Clear and effective communication skills, with the ability to collaborate across engineering, business, and analytical teams.

Beneficial Skills & Qualifications

• Oracle Certification demonstrates a validated depth of platform knowledge and is considered an advantage.
• Familiarity with additional database technologies such as MongoDB or SQL Server broadens the ability to work across hybrid data environments.
• Experience participating in automated deployment and release processes utilizing Git and CI/CD tooling.
• Exposure to data virtualization technologies such as Starburst or comparable platforms.
• Python development skills that complement database workflows and support automation or data engineering tasks.

What We Offer

At Citi, you will work on technically demanding database challenges on a global scale, with the tools, flexibility, and support to do your best work and grow your career over the long term.

• A hybrid working model with 3 days in the office and 2 days working remotely, providing flexibility while maintaining strong team connection.
• Access to AI-powered development tools and modern engineering practices that keep your technical skills current and your work efficient.
• Exposure to complex, large-scale Oracle environments where your contributions directly support business-critical operations across global markets.
• Structured learning and development opportunities to deepen your technical expertise and advance your career within a global organization.
• Competitive financial rewards and a comprehensive benefits package designed to support your long-term financial wellbeing.
• Wellbeing and work-life balance support, including resources tailored to help you thrive professionally and personally.
• Collaboration with cross-functional teams spanning engineering, data, and business functions, giving you broad exposure and meaningful impact.

Apply now to bring your Oracle expertise to a global team where the scale of the work, and the opportunity to grow, is genuinely significant.

Note: Applicants must be authorized to work in the U.S for this position; Citi will not sponsor applicants for U.S. work authorization for this role. Candidate must be located within commuting distance or be willing to relocate to the area.

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

------------------------------------------------------

------------------------------------------------------

------------------------------------------------------

------------------------------------------------------

------------------------------------------------------

In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.

------------------------------------------------------

------------------------------------------------------

------------------------------------------------------

------------------------------------------------------

We use automated processing, including artificial intelligence, for our legitimate business interests (or our reasonable and appropriate business purposes) to identify and align the candidate's skills and abilities with a specific job opening. Additionally, if you so choose, or consent, we can match your skills and abilities to other suitable roles at Citi.

Importantly, all our hiring processes and decisions, including determining your suitability for a role, are conducted, checked, and decided by individuals. Our automated processing and AI do not involve relying on automatic or autonomous decision-making. Please refer to any Jurisdictional Considerations, with specific provisions for your country (where relevant) for further details.

Illinois residents – AI Notice and Right

------------------------------------------------------

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.