We are seeking a highly skilled and experienced Senior Oracle Database Developer to join our dynamic team. The ideal candidate will have a strong background in Oracle database design, development, and performance tuning. You will be responsible for leading the development of database solutions, translating complex business logic into efficient PL/SQL code, and collaborating with cross-functional teams to deliver robust and scalable data-driven applications. This role requires a hands-on expert who can guide best practices, conduct thorough code reviews, and contribute to our CI/CD pipeline for database deployments.
Key Responsibilities- Database Design and Development: Lead the design, development, and implementation of database solutions, including schemas, tables, views, stored procedures, functions, and other database objects.
- Collaboration and Requirements Gathering: Actively participate in database design meetings, collaborating with application development teams, architects, and other stakeholders to define data requirements and architect effective solutions.
- Business Logic Implementation: Translate complex business logic from high-level languages like Java into efficient, scalable, and maintainable Oracle PL/SQL code.
- API Support: Design and create optimized data structures and database objects specifically to support API responses, ensuring fast and reliable data retrieval.
- Code Quality and Review: Conduct thorough code reviews for all database-related code (PL/SQL, SQL) to ensure adherence to best practices, performance standards, data quality, and security guidelines.
- Performance Tuning: Proactively identify and resolve performance bottlenecks in SQL queries and PL/SQL code. Optimize database performance through indexing, query optimization, and other tuning techniques.
- CI/CD and DevOps: Partner with the infrastructure and DevOps teams to design, build, and maintain robust CI/CD pipelines for seamless, automated database deployments and updates.
- Data Modeling: Develop and maintain logical and physical data models to ensure data integrity and alignment with business requirements.
- Troubleshooting and Support: Provide expert-level support for database-related issues, including troubleshooting production problems, and ensuring data integrity and availability.
- Mentorship: Mentor junior developers and team members on database best practices, coding standards, and performance tuning.
- Experience: 8+ years of hands-on experience in Oracle database development, with a focus on PL/SQL.
- PL/SQL Expertise: Expert-level proficiency in writing and optimizing complex PL/SQL packages, procedures, and functions.
- SQL Proficiency: Strong command of advanced SQL, including analytical functions and complex joins.
- Database Design: Proven experience in database design, data modeling, and creating database objects from scratch.
- Performance Tuning: Demonstrated experience with Oracle performance tuning, including using execution plans, AWR reports, and other diagnostic tools.
- Educational Background: Bachelor's degree in Computer Science, Information Technology, or a related field.
- CI/CD Experience: Hands-on experience with database CI/CD tools and concepts (e.g., Liquibase, Flyway, Jenkins, Git).
- High-Level Language Familiarity: Experience or familiarity with object-oriented programming languages such as Java or Python, particularly in how they interact with Oracle databases.
- Cloud Experience: Experience with Oracle databases in a cloud environment (e.g., AWS RDS, OCI).
- Agile Methodologies: Experience working in an Agile/Scrum development environment.
- Certifications: Oracle Certified Professional (OCP) or other relevant certifications are a plus.
- Communication Skills: Excellent verbal and written communication skills, with the ability to explain complex technical concepts to both technical and non-technical stakeholders.
------------------------------------------------------
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.
Skills Required
- 8+ years of hands-on experience in Oracle database development
- Expert-level proficiency in writing and optimizing complex PL/SQL packages, procedures, and functions
- Strong command of advanced SQL including analytical functions and complex joins
- Proven experience in database design, data modeling, and creating database objects
- Demonstrated experience with Oracle performance tuning using execution plans and AWR reports
- Bachelor's degree in Computer Science, Information Technology, or a related field
- Hands-on experience with database CI/CD tools and concepts (e.g., Liquibase, Flyway, Jenkins, Git)
- Experience or familiarity with Java or Python and their interaction with Oracle databases
- Experience with Oracle databases in cloud environments (e.g., AWS RDS, OCI)
- Experience working in an Agile/Scrum development environment
- Oracle Certified Professional (OCP) or other relevant certifications
- Excellent verbal and written communication skills
Citi Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.
-
Healthcare Strength — Benefits coverage is positioned as comprehensive, including health, dental, and vision insurance plus on-site clinics, prescription drug support, and disability coverage. Family-building support such as fertility assistance is described as a notable differentiator within the overall package.
-
Retirement Support — Retirement benefits are framed as strong, highlighted by a 401(k) with matching and additional plan options like a Roth 401(k). Financial support is reinforced through discounts and broader financial guidance resources tied to the benefits ecosystem.
-
Wellbeing & Lifestyle Benefits — Wellbeing support extends beyond insurance through programs like an Employee Assistance Program, counseling/legal resources, and gym or wellness reimbursement. These offerings increase the perceived total rewards value even when cash compensation sentiment varies by role.
Citi Insights
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
