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 solutions for clients at Pythian. Aiming to enhance operational procedures and ensure data integrity.
Responsibilities:
- Provide comprehensive support for all database and application infrastructure aspects to a diverse client base
- 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
- Administer backup procedures and disaster recovery plans, involving proactive monitoring to prevent issues
- 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
- 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
- Participate in and, at times, lead efforts to suggest, recommend, and potentially design/implement new monitoring checks
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
- 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
- Experience with PostgreSQL backup tools, including Barman, pgBackRest, pg_basebackup, etc. is required
- Experience in database migrations from different database engines, including Oracle, MySQL, and MSSQL, to PostgreSQL
- 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!
- 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)
- A generous amount of paid vacation and sick days
Similar Jobs
Senior Database Consultant, PostgreSQL
Senior Database Consultant providing comprehensive support for all database aspects at Pythian. Collaborating with a diverse client base and leading improvements in managed services.
Senior Database Consultant, PostgreSQL
Senior Database Consultant at Pythian handling database management and technical expertise for diverse clients. Responsible for implementing improvements and optimizations for managed services customers.
Consultor/a de APIs – Remoto
API Consultant for IRIUM focused on defining and managing APIs in a full-remote project. Requires over 4 years of experience in API Management and WSO2 certification.
Senior Client Delivery Consultant
Consultant managing client delivery for performance-focused marketing agency. Overseeing strategy execution and ensuring client engagements succeed while leading cross-functional teams.
Power Platform Consultant, Senior
Power Platform Developer automating corporate solutions with Power Apps, Power Automate, and SQL. Focusing on process automation, system integrations, and application support in a collaborative setting.
General Management Consultant – Federal Healthcare System
Consultant supporting VHA’s mission to implement healthcare transformation initiatives. Collaborating across VHA program offices to deliver integrated solutions and manage healthcare priorities.
Senior Consultant, technische IT-Infrastruktur
Senior Consultant enhancing clients' cybersecurity strategies in IT infrastructure. Leading project teams and conducting assessments, audits, and security evaluations for effective solutions.
Consultor/a BPM, PEGA
Consultant specialized in Pega for a software development team in Latin America. Focus on delivering high-impact technology solutions within agile teams.
Staff Consultant, NetSuite
Staff Consultant supporting NetSuite implementations at Bryant Park Consulting. Focused on configuration tasks, data migration, and client communication in a remote role.
Senior NetSuite Consultant – EPM
Senior Consultant, EPM leading end-to-end Oracle NetSuite implementations for clients. Fostering digital transformation and delivering exceptional service in a collaborative environment.
Business Value Consultant
Business Value Consultant at Observe.AI owning customer lifecycle from value selling to realization. Collaborating with sales and customers to optimize and apply AI solutions.
Senior Consultant – Openshift Virtualization
Senior Consultant for OpenShift Virtualization at Red Hat. Leading architectural design for migration strategies and deploying OpenShift clusters.
Senior Consultant, Implementation & Enrollment Manager
Sr. Consultant managing implementation & enrollment for national market at Lincoln Financial. Driving client onboarding and employee education for group benefits with a collaborative approach.
Advisory Consultant
Consultant providing advisory services across data, analytics, and AI transformation initiatives for enterprise clients. Supporting assessments, developing strategies, and engaging with stakeholders in a remote setup.
Associate Regional Business Consultant
Entry-level Associate Regional Business Consultant for Kafene, focusing on merchant onboarding and account management with remote field visits.
Gender Consultant
Gender Consultant needed to strengthen gender integration in RFN's new strategy through analysis. Conducting external scoping and internal discussions with a focus on gender issues.
Lead Consultant
Lead Consultant for Cohesity Professional Services managing technical discussions and solution implementations across EMEA. Engaging directly with enterprise customers for effective technology solutions.
Ivalua Consultant – Project Delivery
Ivalua Consultant driving project implementation for digital procurement transformation in a family-oriented company. Engage in Ivalua projects focusing on delivery and client interaction while fostering personal growth.
Senior Consultant II
Senior Consultant II providing cybersecurity expertise for project tasks at ABS Consulting. Ensuring quality service delivery while maintaining client relationships and supporting business development.
Principal Consultant, Oracle Cloud HCM – OTL/Workforce Scheduling
Principal Consultant providing functional expertise in Oracle HCM Absence, Time & Labor, and Workforce Scheduling. Leading implementations and guiding clients through the application lifecycle.