Senior/Staff DBA (PostgreSQL)

Remote - North American Timezones

About Shopmonkey

Shopmonkey is the leading auto-repair shop software company; it is a cloud-based solution that helps auto-repair shops consolidate tools, save time, and streamline their entire operation onto a simple, easy-to-use platform. Headquartered in Silicon Valley and trusted by more than 3,500+ auto shops across the U.S. and Canada, Shopmonkey aims to change the status quo of the global car repair market, estimated to be worth more than $500B.

The Role

We are seeking a Senior/Staff Database Administrator (PostgreSQL) to lead the adoption and management of PostgreSQL within our platform team. This role is pivotal in establishing best practices, optimizing performance, ensuring security, and spearheading our migration from CockroachDB to PostgreSQL. As part of the Site Reliability Engineering (SRE) and Platform team, you will collaborate closely with application engineers, platform engineers, and leadership to ensure our database infrastructure is robust, scalable, and efficient.

You Will Have The Opportunity To
• Lead Migration Efforts: Plan and execute the migration from CockroachDB to PostgreSQL, aiming for completion by July 1.
• Establish Best Practices: Develop and implement best practices for PostgreSQL database management, including query optimization, indexing strategies, and schema design reviews.
• Collaborate with Engineering Teams: Work closely with platform and application engineers to audit application code and optimize database interactions.
• Enhance Disaster Recovery: Improve our disaster recovery tooling and documentation to ensure data integrity and business continuity.
• Mentor Team Members: Provide mentorship and guidance to engineers on database best practices, fostering a culture of continuous learning and improvement.
• Manage High Availability: Design and maintain high availability (HA) and replication strategies, including expertise with replication streams.
• Automate Monitoring and Alerts: Implement and maintain monitoring, alerting, and automated remediation processes for database health and performance.
• Participate in On-Call Rotation: Be part of a business-hours on-call rotation and be available for high-severity incident responses as the database owner.

We Are Looking For You If You Have
• Extensive PostgreSQL Experience: 5+ years as a Database Administrator with a focus on PostgreSQL, including experience with query optimization, indexing strategies, and performance tuning.
• Migration Expertise: Proven experience leading database migrations, ideally from distributed SQL databases (e.g., CockroachDB) to PostgreSQL.
• High Availability Knowledge: Strong understanding of high availability, disaster recovery, and replication strategies, including replication streams.
• Cloud Proficiency: Hands-on experience managing PostgreSQL in Google Cloud Platform’s Cloud SQL.
• Infrastructure-as-Code Familiarity: Experience with Infrastructure-as-Code tools, particularly Pulumi.
• Soft Skills: Proactive approach to driving database best practices, strong communication skills for cross-team collaboration, and the ability to make autonomous decisions.