Vista previa generada por IA
Senior Oracle Database Developer – Lead design, development, and performance tuning for Citi’s enterprise databases.
Full-time role in Pune with focus on PL/SQL, CI/CD, and cloud database technologies like OCI and AWS RDS.
Job Overview
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.
Required Qualifications
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.
Preferred Qualifications
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
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.