Senior Database Consultant, PostgreSQL

🕒 May 14

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Pythian

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 1997

🤖 Artificial Intelligence

🤝 B2B

🏢 Enterprise

Artificial Intelligence • B2B • Enterprise

<Pythian> Pythian is a global consulting firm specializing in data, analytics, cloud, and AI solutions. With decades of experience and a large team of domain experts, they provide strategy, custom AI development, advanced analytics, database and cloud consulting, migrations, and managed services (including AIOps and DBA services) to enterprise customers across industries. Pythian focuses on helping organizations modernize their data platforms, deploy generative AI use cases, and optimize cloud and database operations through partnerships with major cloud and data technology providers.

📋 Description

• 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 operational procedures. • Ensure maximum uptime and recoverability for all databases. • Administer backup procedures and disaster recovery plans, including proactive monitoring to prevent issues. • Oversee backup, clustering, mirroring, replication, failover, and restoration of corrupted databases. • 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. • 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. • Lead problem management efforts by assessing incidents for recurring patterns and designing technical procedures. • Participate equally in the team’s on call rotation, typically one weekend per month. • Make, manage, and meet client commitments in collaboration with team members. • 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.

🎯 Requirements

• 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. • This includes configuring monitoring solutions, analyzing performance metrics, setting up alerts, and troubleshooting database issues in cloud environments. • 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. • Additionally, 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! • All you need is a stable internet connection. • Collaborate with some of the best and brightest in the industry! • 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). • Additionally, you will receive a generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity.