Senior Database Consultant

April 9

Apply Now

Receive Emails with Similar Jobs

Pythian

WebsiteLinkedInAll Job Openings

Pythian is a global data and analytics services company that specializes in helping organizations transform by leveraging data, analytics, AI, and the cloud. Pythian offers services in database management, cloud solutions, digital workplaces, and enterprise applications, working with partners like AWS, Google, and Microsoft. The company enables clients to optimize their data estates, secure their data, and drive better business outcomes through advanced analytics and artificial intelligence. Pythian serves a variety of industries, including financial, healthcare, manufacturing, retail, and education, providing tailored solutions that enhance operational efficiency, security, and innovation.

Oracle • Microsoft SQL Server • MySQL • NoSQL • Big Data

201 - 500 employees

Founded 1997

🤖 Artificial Intelligence

💰 $15M Venture Round on 2017-05

📋 Description

• Senior Database Consultant • PST| 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 mission-critical databases. We quickly earned a reputation for solving tough data challenges. We were there when the industry moved from on-premises 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 client’s 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 large-sized businesses transform to stay ahead in today’s rapidly changing digital economy. • Why You: • The Senior Database Consultant will, as part of a team-based 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: • 1.Presales • 2.Delivery, consulting, and bringing improvements and optimization to managed services customers • 3.Thought leadership

🎯 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. • 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. • 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. • 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 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

• Love your career: Competitive total rewards package. • Love your work/life balance: Flexibly work remotely from your home, there’s 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 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.