Sr. PSQL Developer - C12 - Pune
Citi
This job is no longer accepting applications
See open jobs at Citi.See open jobs similar to "Sr. PSQL Developer - C12 - Pune" AnitaB.org.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.
This job is no longer accepting applications
See open jobs at Citi.See open jobs similar to "Sr. PSQL Developer - C12 - Pune" AnitaB.org.