Lead Consultant-PostgreSQL Engineer
Genpact
5 - 10 years
Hyderabad
Posted: 13/03/2025
Job Description
Responsibilities
:1. Database Design and Development:
a. Design, develop, and maintain PostgreSQL databases
b. Create and optimize SQL queries, stored procedures, and functions
c. Design and implement database schemas, tables, and indexes to support business requirements
2. Database Migration
o Execution of database migration projects from legacy systems to PostgreSQL, ensuring alignment with product requirements and business objectives
3. Performance Tuning and Optimization
a. Monitor and analyze database performance
b. Identify and resolve performance bottlenecks
c. Implement best practices for database performance tuning and optimization.
4. Data Management:
a. Ensure data integrity, security, and availability
b. Develop and maintain data backup and recovery plans
c. Perform database migrations and upgrades
5. Collaboration and Support:
a. Collaborate with application developers to design and optimize database interactions
b. Provide technical support and troubleshooting for database-related issues
c. Participate in code reviews and provide feedback on database-related code
d. Collaborate with cross-functional teams to troubleshoot database issues, identify root causes, and implement solutions
6. Documentation and Compliance:
a. Create and maintain documentation for database designs, configurations, and procedures
b. Ensure compliance with data privacy and security regulations
c. Stay current with PostgreSQL features, updates, and industry trends, and recommend improvements to our database infrastructure and processes
About Company
Genpact is a global professional services firm that offers a wide range of digital transformation services and solutions. With a presence in over 30 countries, Genpact leverages its deep domain expertise in operations and analytics to help businesses transform their operations, improve efficiency, and enhance customer experience. The company combines digital technology, data science, and operational excellence to deliver business outcomes across various industries, including banking, insurance, manufacturing, and healthcare. Founded in 1997 as a subsidiary of GE, Genpact has grown into an independent, NYSE-listed company with a diverse workforce of over 90,000 employees globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).