Oracle Database PL/SQL Developer, Assistant Vice President

Citi • Tampa, FL

9d • $96,960 - $145,440 • Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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.

Benefits

• 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.
• medical, dental & vision coverage
• 401(k)
• life, accident, and disability insurance
• wellness programs
• paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level