Senior Database Consultant, PostgreSQL

Senior PostgreSQL Database Consultant

Hyderabad | Bengaluru | India | Remote | EST time | #LI - Remote

Available Shift - EST

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Pythian, a multinational company, was founded in 1997 and started by ensuring the reliability and performance of mission-critical databases. We quickly earned a reputation for solving tough data challenges. We were there when the industry moved from on-premises to cloud environments, and as enterprises sought more from their data, we expanded our competencies to include advanced analytics.

Today, we empower organizations to embrace transformation and leverage advanced technologies, including AI, to stay competitive. We deliver innovative solutions that meet each client's data goals and have built strong partnerships with Google Cloud, AWS, Microsoft, Oracle, SAP, and Snowflake. The powerful combination of our extensive expertise in data and cloud and our ability to keep on top of the latest bleeding edge technologies make us the perfect partner to help mid and large-sized businesses transform to stay ahead in today's rapidly changing digital economy.

Why You :

The Senior Database Consultant will provide comprehensive support for all database and application infrastructure aspects to a diverse client base. This role is crucial for delivering and consulting on services, as well as for implementing improvements and optimizations for managed services customers.

If this is you, and you wonder what it would be like to work at Pythian, reach out to us and find out!

Intrigued to see what a life is like at Pythian Check out #pythianlife on and follow on Instagram!

Not the right job for you Check out what other great jobs Pythian has open around the world!

What you will be doing :

• Database Management & Technical Expertise :
• Solution Design & Implementation : Coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance.
• Infrastructure Analysis & Improvement : Analyze client infrastructure and processes, recommending best practices to enhance current operational procedures. This includes ensuring maximum uptime and recoverability for all databases.
• Backup & Disaster Recovery : Administer backup procedures and disaster recovery plans. This involves proactive monitoring to prevent issues, responding to alerts, and troubleshooting operational problems.
• Data Integrity & Recovery : Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases.
• Action Plan Development : Develop and review action plans for maintenance, deployment, and upgrades, ensuring all relevant client documentation is completed. Maintain a thorough understanding of client information, including warnings, handoffs, and briefing notes.
• Data Architecture : Develop, implement, and maintain complex data architectures (e.g., normalized and / or dimensional data models and DDL generation). Perform data transformation and migration using scripts or stored procedures.
• Problem Management : Lead problem management efforts by assessing incidents for recurring patterns, designing technical procedures for regular requests and changes, and developing / reviewing action plans and associated documentation.
• Oncall : Participate equally in the team's on call rotation, typically one weekend per month.

Client Engagement & Communication :

Process Improvement :

What we need from you :

What you get in return :

Disclaimer

The successful applicant will need to fulfill the requirements necessary to obtain a background check.

Accommodations are available upon request for candidates taking part in any aspect of the selection process.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.