Senior Database Consultant PostgreSQL
Senior Database Consultant PostgreSQL
Posted on :
17-04-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Senior Database Consultant
EST/GMT Remote #LI Remote
Why Pythian:
At Pythian we are experts in strategic database and analytics services driving digital transformation and operational excellence. Pythian a multinational company was founded in 1997 and started by ensuring the reliability and performance of missioncritical databases. We quickly earned a reputation for solving tough data challenges. We were there when the industry moved from onpremises to cloud environments and as enterprises sought more from their data we expanded our competencies to include advanced analytics.
Today we empower organizations to embrace transformation and leverage advanced technologies including AI to stay competitive. We deliver innovative solutions that meet each clients data goals and have built strong partnerships with Google Cloud AWS Microsoft Oracle SAP and Snowflake. The powerful combination of our extensive expertise in data and cloud and our ability to keep on top of the latest bleeding edge technologies make us the perfect partner to help mid and largesized businesses transform to stay ahead in todays rapidly changing digital economy.
Why You:
The Senior Database Consultant will as part of a teambased approach supply complete support for all aspects of database and application infrastructure to a variety of clients as assigned. The Senior Database Consultant will play a critical role in the following key areas of responsibility:
consulting and bringing improvements and optimization to managed services customers
leadership
What you will be doing:
- Provides all aspects of client service generally associated with Database Consultants (DBC) such as the coordination analysis design implementation and administration of IT solutions including database server configuration and maintenance. Analyzes clients infrastructure and processes and recommends to clients as appropriate best practices for improvements to current operational processes and procedures to ensure that databases remain operational for maximum uptime and are recoverable.
- Provides administration of backup procedures and disaster recovery plans provides proactive monitoring to head off potential issues before they become incidents responds to monitoring alerts and carries out troubleshooting of operational problems.
- Oversees backup clustering mirroring replication failover and restoration and recovery of corrupted databases develops and reviews action plans (such as maintenance deployment upgrades etc. and completes all relevant client documentation. Develops a thorough understanding of all relevant client information including warnings handoffs briefing notes etc.
- Develops implements and maintains complex data architectures such as normalized and/or dimensional data models and DDL generation; carries out transformation and migration of data through scripts or stored procedures.
- Owns Problem Management whereby incidents are assessed for any recurring patterns designs technical procedures for regular requests/changes develops and reviews action plans (such as maintenance deployment upgrades etc) and associated documentation.
- Provides technical oversight of Incident Management to the team members and assists team members in the design of technical procedures for complex scheduled changes to ensure that best practices are being used.
- Assists the Team Manager in reviewing the teams work for quality and adherence to technical processes and standards and in overseeing client capacity and change management.
- Makes manages and meets client commitments in conjunction with fellow team members. Prepares client status and incident reports reviews client reports on a recurring basis responds to client requests and enquiries and maintains alignment with a clients operating procedures. Takes on technical client affinity as assigned by the Team Manager aligns to client operating procedures as required e.g. change control follows hourly requirements of client allotments and alerts Team Manager to any pacing concerns.
- Participates in and at times takes on a leadership role in suggesting recommending and possibly designing/implementing new monitoring checks enhancements to DBC toolkits and other process improvements such as Initial Reviews Performance Reviews Audits etc. especially but not limited to those that increase the value of the service that Pythian brings to its clients.
- As agreed upon with Sales and with the approval of ones manager participates in presales activities such as proposal preparation and tech calls as well as presales visits to client sites on an occasional basis as required.
- Takes on a leadership role in the help and mentoring of team members.
- Participates in the preparation and presentation of employee training courses or wiki material for the enhancement of Pythians knowledge base as agreed upon with ones manager.
- Be available for 24/7 escalations from the DBC team.
What we need from you:
- 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.
- Previous remote working experience is a plus.
- 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.
- Handson experience in monitoring PostgreSQL databases using industrystandard tools such as Prometheus Grafana SolarWinds pgAdmin Zabbix Nagios and Datadog.
- Experience with cloudnative 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.
- Nice to have experience in setting up configuring and administering PostgreSQL on Kubernetes.
- 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 multimaster replication and EDB BigAnimal for managed PostgreSQL in the cloud would be highly beneficial. Familiarity with automatic failover strategies consensusbased leader election and cloudbased database resilience is a plus.
- Experience with PostgreSQL backup tools including Barman pgBackRest pgbasebackup etc. is required. The candidate should be proficient in configuring full incremental and differential backups as well as managing PointinTime 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 CDCbased techniques to ensure a smooth transition with minimal downtime.
- Experience migrating between onpremises and cloudbased databases.
- Experience analyzing and optimizing schema conversions SQL compatibility issues and performance tuning postmigration. Experience with Debezium and Striim is not mandatory but beneficial.
What you get in return:
- Love your career: Competitive total rewards package. Blog during work hours; take a day off and volunteer for your favorite charity.
- Love your work/life balance: Flexibly work remotely from your home theres no daily travel requirement to an office! All you need is a stable internet connection.
- Love your coworkers: Collaborate with some of the best and brightest in the industry!
- Love your development: Hone your skills or learn new ones with our substantial training allowance; participate in professional development days attend training become certified whatever you like!
- Love your workspace: 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!
- Love yourself: Pythian cares about the health and wellbeing 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.
HiringDisclaimer
Pythian is looking to fill this position as soon as possible as this position is for an active and open position.
The successful applicant will need to fulfill the requirements necessary to obtain a background check.
Accommodations are available upon request for candidates taking part in any aspect of the selection process.
Required Experience:
Senior IC
Employment Type
Full-Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
