Sr. PSQL Developer - C12 - Pune
Citi
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.