We are seeking a highly skilled Senior Oracle PL/SQL Developer / Oracle Lead to join our dynamic team. As a Senior Oracle Developer, you will be responsible for designing, developing, testing, and implementing Oracle-based solutions to meet our business needs. You will work closely with our cross-functional teams to analyze requirements, develop technical specifications, and deliver high quality solutions.
Responsibilities:
- Design, develop, test, maintain, and optimize Oracle database solutions, including PL/SQL packages, procedures, functions, triggers, ETL processes, data migration scripts, and performance-tuned database objects.
- Develop and support Oracle database solutions, including packages, stored procedures, functions, triggers, views, materialized views, and sequences, ensuring high performance, scalability, and maintainability.
- Create and maintain database migration scripts, schema updates, release deployment packages, and automated database deployment processes.
- Design, build, and support ETL workflows, data transformation processes, validation frameworks, and batch data processing solutions.
- Troubleshoot and resolve database issues, data quality concerns, application integration challenges, and performance bottlenecks across environments.
- Perform database performance tuning and optimization using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools.
- Support CI/CD initiatives, implementing automated testing, deployment, monitoring, and compliance practices for database solutions.
- Develop and support database unit testing, regression testing, data validation testing, and automated test support for SQL, PL/SQL, ETL, and data migration changes.
- Leverage AI-powered development tools to accelerate SQL and PL/SQL development, code review, troubleshooting, documentation, testing, and knowledge-sharing activities.
- Experience in designing tables, data analysis, wiring complex queries (SQL and PL/SQL), performing tuning and table partitions.
- Experience with GitHub Copilot or other Dev Assist tools and capabilities
- Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications.
- Troubleshoot and debug issues.
- Conduct code reviews, performance tuning, and optimization to ensure code quality and efficiency.
Requirements
- Bachelor’s degree in computer science, information technology, or related field.
- 8+ years of experience as an Oracle developer, with a proven track record of designing and implementing complex database solutions
- Experience working in an Agile environment and familiarity with agile methodologies.
- Excellent problem-solving skills and attention to detail.
- Strong communication and interpersonal skills, with the ability to affectively collaborate with cross functional teams.
- Experience with Git and continuous integration / continuous deployment pipelines
Nice to have
- Oracle Certification
- Knowledge of other database technologies (e.g., MongoDB, SQL Server)
- Experience of using Tableau with Oracle
- Starburst or other Data virtualization technology experience
- Python Development experience
#LI-KR5
------------------------------------------------------
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
- Bachelor's degree in computer science, information technology, or a related field
- 8+ years of experience as an Oracle developer
- Experience designing and implementing complex Oracle database solutions
- Experience working in an Agile environment and familiarity with Agile methodologies
- Excellent problem-solving skills and attention to detail
- Strong communication and interpersonal skills for cross-functional collaboration
- Experience with Git and continuous integration and continuous deployment pipelines
- Oracle certification
- Knowledge of MongoDB or SQL Server
- Experience using Tableau with Oracle
- Experience with Starburst or other data virtualization technologies
- Python development experience
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.
