← back to jobs
> job detail
C
👽Other

Senior Oracle Database Developer

Citi · Pune Maharashtra India
// classified as
Other (Adjacent or hard to classify.)
posted
1d ago
location
Pune Maharashtra India
languages
java, python, sql
tools
aws, oracle
> stack
javapythonsqlawsoracle
> description

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

Apply at Citi →