Senior Database Consultant, PostgreSQL
Pythian
full-time
Posted on:
Location Type: Remote
Location: India
Visit company websiteExplore more
Job Level
Tech Stack
About the role
- Provide comprehensive support for all database and application infrastructure aspects to a diverse client base.
- Deliver and consult on services, as well as implement improvements and optimizations for managed services customers.
- Coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance.
- Analyze client infrastructure and processes, recommending best practices to enhance current operational procedures.
- Ensure maximum uptime and recoverability for all databases.
- Administer backup procedures and disaster recovery plans.
- Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases.
- Develop and review action plans for maintenance, deployment, and upgrades.
- Develop, implement, and maintain complex data architectures (e.g., normalized and/or dimensional data models and DDL generation).
- 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.
- Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries.
- Maintain alignment with client operating procedures, including change control, and manage client allotments, alerting the Team Manager to any pacing concerns.
- Participate equally in the team’s on call rotation, typically one weekend per month.
- Suggest, recommend, and potentially design/implement new monitoring checks, enhancements to DBC toolkits, and other process improvements.
Requirements
- 10+ years of related experience
- 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)
- Automation technologies such as Ansible, Terraform, Puppet, Chef, SALT experience.
- Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues
- Very good documentation skills.
- Nice to haves include; Understanding of current IT service standards such as ITIL.
- Being a contributor to projects relevant to PostgreSQL, or other database or infrastructure software.
- Hands-on experience in monitoring PostgreSQL databases using industry-standard tools such as Prometheus, Grafana, SolarWinds, pgAdmin, Zabbix, Nagios and Datadog.
- Experience with cloud-native and managed database monitoring tools, including AWS CloudWatch, Google Cloud Operations (Stackdriver), and Azure Monitor.
- Experience in setting up, configuring, and administering PostgreSQL on Kubernetes is a nice-to-have.
- Knowledge in monitoring and observability solutions with Prometheus, Grafana is a nice-to-have.
- Experience with High Availability (HA) solutions for PostgreSQL, including Patroni, and repmgr, is required.
- The candidate should be proficient in configuring and managing automated failover, replication, and cluster health monitoring to ensure database resilience and minimal downtime.
- Experience with EnterpriseDB (EDB) solutions, such as EDB Postgres Distributed (PGD) for multi-master replication and EDB BigAnimal for managed PostgreSQL in the cloud, would be highly beneficial.
- Familiarity with automatic failover strategies, consensus-based leader election, and cloud-based database resilience is a plus.
- Experience with PostgreSQL backup tools, including Barman, pgBackRest, pg_basebackup, etc. is required.
- The candidate should be proficient in configuring full, incremental, and differential backups, as well as managing Point-in-Time Recovery (PITR) and WAL archiving for disaster recovery.
- Experience in database migrations from different database engines, including Oracle, MySQL, and MSSQL, to PostgreSQL.
- Using migration tools such as ora2pg, AWS/GCP/Azure Database Migration Services (DMS), and other CDC-based techniques to ensure a smooth transition with minimal downtime.
- Experience migrating between on-premises and cloud-based databases.
- Experience analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post-migration.
- Experience with Debezium and Striim is not mandatory but beneficial.
Benefits
- Competitive total rewards package
- Blog during work hours; take a day off and volunteer for your favorite charity
- Flexibly work remotely from your home, there’s no daily travel requirement to an office!
- Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!
- We give you all the equipment you need to work from home including a laptop with your choice of OS, and an annual budget to personalize your work environment!
- Pythian cares about the health and well-being of our team. You will have an annual wellness budget to make yourself a priority (use it on gym memberships, massages, fitness and more)
- You will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favourite charity.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
PostgreSQL administrationscriptingbashpythonC++JavaGoHigh Availability (HA) solutionsdatabase migrationsbackup and recovery
Soft skills
documentation skillsproblem managementanalytical skillscommunication skillsteam collaboration