Senior Database Consultant, PostgreSQL
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior Database Consultant providing comprehensive database support and consulting services to diverse clients at Pythian. Focused on database management and technical expertise for optimal operational performance.
Responsibilities:
- 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.
Similar Jobs
Managed Application Services Consultant
Managed Application Services Consultant at Evotix supporting clients in optimizing their EHS software. Collaborating with teams to ensure smooth application performance and enhancing customer solutions.
Principal Business Solution Consultant
Customer Solution Consultant at CSG focusing on telecommunications to deliver innovative solutions. Engage with clients to align strategic goals with CSG solutions.
Student Admissions Consultant – Bildungsberatung, Kundenbetreuung
Student Admissions Consultant at StartSteps guiding prospective students through admissions for online tech programs. Responsible for support and relationship building with public institutions.
Global Travel Consultant
Global Travel Consultant designing unforgettable escapes for adventure-seeking clients. Remote work opportunity with flexible schedule and no experience needed.
Global Travel Consultant
Global Travel Consultant working remotely to design unforgettable travel experiences for clients. No experience needed, just passion and bold energy for adventure.
Global Travel Consultant
Global Travel Consultant at Affinity Travels, designing unforgettable travel experiences for clients. Passion-driven role allowing for remote work and flexible schedules.
Energy Consultant
Independent Partner helping households save on everyday bills by introducing essential services like energy and broadband. Flexible self-employed role with training and support.
Technical PS Consultant
Professional Services Consultant responsible for driving customer success and effective Barista platform implementations. Collaborates with customers on requirements and guides deployment for optimal experience.
Technical PS Consultant
Professional Services Consultant ensuring successful implementations of Barista solutions. Partnering with customers to translate requirements into practical solutions and improve employee experience.
Clinical Consultant – Xper IM, Enterprise Informatics
Clinical Consultant optimizing healthcare IT solutions with Xper Hemodynamics. Assisting in training, workflow assessments, and customer support with a focus on clinical impact.
Senior Archiving & ILM Consultant
Senior Archiving & ILM Consultant specializing in SAP solutions, analyzing requirements and implementing concepts for data archiving.
Business Coach, Consultant – Exit Strategy
Business Coach assisting small to mid-sized businesses in increasing profit and value for sale. Engaging with clients through 1:1 consulting based on proprietary Exit Factor method.
Senior Consultant – Dynamics 365 F&SCM, Manufacturing
Join Argano as a Dynamics 365 F&SCM – Manufacturing Senior Consultant. Drive impactful solutions by collaborating with clients to optimize their business processes.
Consultant
Consultant at Argano, LLC devising methods for identifying data patterns and trends. Implementing Anaplan and mentoring junior team members in data integration and visualization.
Senior EAM Consultant – S/4HANA, Cloud, Innovation
Senior EAM Consultant driving SAP S/4HANA projects and innovative solutions in a digital environment at Evora IT Solutions.
Senior Media Consultant
Media Consultant creating 360° media strategies for clients. Covering analysis, implementation, and budget management for effective campaigns.
Energy Billing Consultant – m/f/d
SAP Consultant for the energy sector creating innovative solutions and optimizing billing processes. Joining a strong team and engaging in exciting SAP projects.
Tax Assistant, Consultant
Steuerassistent:in managing strategic tax consulting for clients including companies and wealthy individuals. Collaborating with tax experts on financial planning and legal frameworks.
Senior PS Consultant
Senior PS Consultant providing technical support for custom applications built on Genesys Cloud. Collaborating with customers for troubleshooting and implementation activities.
Professional Product Data Consultant – m/f/d
Product Data Consultant ensuring high-quality, scalable product data at INSPORT Digital GmbH. Collaborating with content, IT, and external partners to automate product data processes.