Oracle PLSQL Lead Developer

Citigroup Inc.; Pune District; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Citigroup Inc. in Pune invites a Senior Oracle PL/SQL Developer / Oracle Lead to design, develop, test, and implement Oracle-based solutions aligned with business needs. You will collaborate with cross-functional teams to translate requirements into scalable database designs.

The role emphasizes performance tuning, CI/CD for database work, and mentoring juniors while leveraging AI-assisted tools to accelerate SQL/PL/SQL development.

Qualifications

• Bachelor’s degree in computer science or related field.
• 8+ years of experience as an Oracle developer with complex database solutions.
• Experience in Agile environments and CI/CD pipelines.

Responsibilities

• Design, develop, test, and optimize Oracle DB solutions including PL/SQL packages and procedures.
• Develop and support ETL workflows, data migration scripts, and performance tuning.
• Troubleshoot data issues and optimize across environments; support CI/CD for databases.
• Collaborate with analysts to translate requirements into technical specs; review code and performance.
• Leverage AI-powered tools to accelerate SQL/PL/SQL development and documentation.

Skills

Oracle PL/SQL

SQL

Agile methodologies

Git

CI/CD pipelines

Problem solving

Communication

Education

Bachelor's degree in computer science or related field

Tools

GitHub Copilot

Tableau

Data virtualization (Starburst)

Python

MongoDB

SQL Server

Job description

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.