Senior Database Consultant, PostgreSQL

About this role

Not quite right? These jobs in India match the same skills — apply to a few to improve your chances.

Data Engineer(Python/AWS/SQL)

LSEG

In OfficeIndia

Apply

Principal Software Engineer - AI Platform

G-P

RemoteIndia

Apply

PMO Analyst

WPP

In OfficeIndia

Apply

Data Steward - Quality Excellence

AlphaSense

RemoteIndia

Apply

Skills you'll use

What you'll do

• 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.
• On call: Participate equally in the team’s on call rotation, typically one weekend per month.

Who can apply

• Client Commitments: Make, manage, and meet client commitments in collaboration with team members.
• Reporting & Communication: Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries.
• Client Alignment: Maintain alignment with client operating procedures, including change control, and manage client allotments, alerting the Team Manager to any pacing concerns.
• Technical Client Affinity: Take on technical client affinity as assigned by the Team Manager.
• Innovation & Improvement: Participate in and, at times, lead efforts to suggest, recommend, and potentially design/implement new monitoring checks, enhancements to DBC toolkits, and other process improvements (e.g., Initial Reviews, Performance Reviews, Audits). Focus on initiatives that increase the value Pythian provides to clients.
• Knowledge and experience in installing, configuring and upgrading PostgreSQL databases & tools relevant in PostgreSQL Administration.
• Experience administering PostgreSQL in virtualized and cloud environments, especially AWS, GCP or Azure.
• Experience with scripting (bash/python) and software development (C++, Java, Go)

About Pythian

Searching for “Pythian jobs” or “jobs at Pythian”? You’re in the right place.