Senior Database Administrator, PostgreSQL

About Pythian

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.

Employment Type: Full Time

Location: India | Bengaluru | Remote

About the Role

The Senior Database Consultant will, as part of a team-based approach, supply complete support for all aspects of database and application infrastructure to a variety of clients, as assigned. The Senior Database Consultant will play a critical role in the following key areas of responsibility:

• Presales
• Delivery, consulting, and bringing improvements and optimization to managed services customers
• Thought leadership

What You Will Be Doing

• Provides all aspects of client service generally associated with Database Consultants (DBC) such as the coordination, analysis, design, implementation, and administration of IT solutions, including database server configuration and maintenance.
• Analyzes client’s infrastructure and processes and recommends to clients, as appropriate, best practices for improvements to current operational processes and procedures to ensure that databases remain operational for maximum uptime and are recoverable.
• Provides administration of backup procedures and disaster recovery plans, provides proactive monitoring to head off potential issues before they become incidents, responds to monitoring alerts, and carries out troubleshooting of operational problems.
• Oversees backup, clustering, mirroring, replication, failover, and restoration and recovery of corrupted databases, develops and reviews action plans (such as maintenance, deployment, upgrades, etc.), and completes all relevant client documentation.
• Develops a thorough understanding of all relevant client information including warnings, handoffs, briefing notes, etc.
• Develops, implements and maintains complex data architectures such as normalized and/or dimensional data models and DDL generation; carries out transformation and migration of data through scripts or stored procedures.
• Owns Problem Management whereby incidents are assessed for any recurring patterns, designs technical procedures for regular requests/changes, develops and reviews action plans (such as maintenance, deployment, upgrades, etc) and associated documentation.
• Provides technical oversight of Incident Management to the team members and assists team members in the design of technical procedures for complex scheduled changes to ensure that best practices are being used.
• Assists the Team Manager in reviewing the team's work for quality and adherence to technical processes and standards, and in overseeing client capacity and change management.
• Makes, manages and meets client commitments in conjunction with fellow team members.
• Prepares client status and incident reports, reviews client reports on a recurring basis, responds to client requests and enquiries, and maintains alignment with a client’s operating procedures.
• Takes on technical client affinity as assigned by the Team Manager.