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., * 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.

• 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., * 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., 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.

• 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., $96,960.00 - $145,440.00

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.

Working at Citi is far more than just a job. A career with us means joining a team of approximately 219,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact., 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.