Sr. PSQL Developer - C12 - Pune

Citi

Citi

Software Engineering
Pune, Maharashtra, India
Posted on Jun 26, 2025

Key Responsibilities:

  • Design, develop and maintain complex PL/SQL code and stored procedure to support business logic and data processing requirements.
  • Develop and maintain data models for new and existing applications ensuring scalability, flexibility and integrity.
  • Perform database performance tuning and query optimizations to enhance system efficiency.
  • Ensure data quality standards are met through robust validation, transformation and cleansing processes.
  • Administer and support Oracle databases ensuring high availability, backup and recovery and proactive monitoring.
  • Provide database maintenance and support including patching, upgrades and troubleshooting production issues.
  • Monitor system health and implement proactive alerts and diagnostics for performance and capacity management.
  • Support and implement solutions using NoSQL database (e.g. MongoDB, Cassandra) where appropriate for specific use case.
  • Collaborate with development teams to ensure code quality and best practices in PL/SQL development.
  • Develop and maintain documentation related to data architecture, data flow and database processes.

Required Skills and Qualificatioons:

  • 8-12 years of experience in Oracle database development and administration, Mondgo DB Development and administration
  • String proficiency in PL/SQL, SQL, Indexes, Triggers, Sequences, procedures, functions and Oracle database internals.
  • Proven experience with data modeling (logical and physical), normalization and schema design
  • Expertise in performance tuning, query optimization and indexing strategies.
  • Hands-on experience with relational database (Oracle, PostgresSQL, MySQL) and NoSQL database (e.g. MongoDB, Cassandra)
  • Solid understanding of database monitoring tools and tunning methodologies.
  • Experience in data quality management practices and tools
  • Strong exposure to code quality standards and tools for PL/SQL development (e.g. TOAD, SQL Developer, SonarQube)
  • Knowledge of backup and recovery strategies, high availability and disaster recovery planning
  • Familiarity with DevOps practices, including database CI/CD integration.
  • Familiarity with Liquibase for database versioning and deployment automation.

Preferred Skills:

  • Experience in cloud-based databases (e.g. Oracle Cloud, AWS RDS, Azure SQL)
  • Exposure to ETL tools and data integration platforms.
  • Familiarity with regulatory compliance standards (e.g. GDPR, HIPPA) related to data management.

Soft Skills:

  • Strong analytical and problem-solving skills.
  • Excellent communication and documentation abilities.
  • Ability to work independently and as part of a cross-functional team.
  • String attention to detail and commitment to data integrity.


Education:

  • Bachelor’s degree/University degree or equivalent experience

------------------------------------------------------

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.