Job details

Senior/Staff DBA (PostgreSQL)

Get a free resume review

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.

Average salary estimate

$115000 / YEARLY (est.)

min

max

$100000K

$130000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Senior/Staff DBA (PostgreSQL), G2i Inc.

Are you ready to take your career to the next level as a Senior/Staff Database Administrator (PostgreSQL) at Shopmonkey? Based in the heart of Silicon Valley, Shopmonkey is the leading auto-repair shop software taking the industry by storm. With a cloud-based solution trusted by over 3,500 auto shops in the U.S. and Canada, we're changing the game in the global car repair market—which is valued at more than $500 billion! In this remote position designed for North American timezones, you'll play a pivotal role in adopting and managing PostgreSQL within our platform team. Your mission? Lead the migration from CockroachDB to PostgreSQL while establishing best practices and optimizing performance along the way. Collaborate with our talented engineering teams to ensure robust database infrastructure, enhance disaster recovery tooling, and mentor your teammates. With your extensive PostgreSQL experience, high availability knowledge, and hands-on cloud management skills, you'll be instrumental in shaping our data strategy. If you're passionate about driving change in a fast-paced environment, Shopmonkey is the perfect place for you to shine. Join us and be part of a company that’s not just about repairing cars but is truly reshaping an entire industry!

Frequently Asked Questions (FAQs) for Senior/Staff DBA (PostgreSQL) Role at G2i Inc.

What responsibilities come with the Senior/Staff Database Administrator (PostgreSQL) role at Shopmonkey?

As a Senior/Staff Database Administrator (PostgreSQL) at Shopmonkey, you'll be charged with leading migration efforts from CockroachDB to PostgreSQL, establishing best practices for database management, enhancing disaster recovery processes, and collaborating closely with application and platform engineers. Your role also involves designing high availability strategies, automating monitoring, and mentoring team members to foster a culture of continuous improvement.