Senior Database Consultant

Employment Type: Full Time Location Type: Remote Time Zone: PST or EST

Why Pythian:

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. Founded in 1997, Pythian initially focused on ensuring the reliability and performance of mission-critical databases, quickly earning a reputation for solving tough data challenges. We adapted to the industry's shift from on-premises to cloud environments and expanded our competencies to include advanced analytics as enterprises sought more from their data.

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, coupled with our ability to stay on top of the latest bleeding-edge technologies, makes us the ideal partner to help mid and large-sized businesses transform and stay ahead in today’s rapidly changing digital economy.

Why You:

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:

1. Presales
2. Delivery, consulting, and bringing improvements and optimization to managed services customers
3. 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 inquiries, and maintains alignment with a client’s operating procedures.
• Takes on technical client affinity as assigned.