Senior Database Administrator

PDQ

1d • Remote

About The Position

As a Senior Database Administrator at PDQ, you will be responsible for building, managing, and optimizing PDQ databases. This role is crucial in establishing best practices, ensuring data availability and reliability, and driving performance at scale. You will play a key role in safeguarding data integrity, supporting mission-critical business applications, and enabling data-driven decision-making.

Requirements

• 6+ years of experience managing databases at scale
• Experience working in SaaS environment with high-availability requirements
• Strong grasp of OLTP databases, specifically PostgreSQL in high-volume environments
• Experience with database replication, partitioning, sharding and clustering
• Proficiency in SQL performance tuning, query optimization and schema design
• Experience with automation tools and scripting languages (Bash, Python, or similar)
• Knowledge of backup and recovery tools and methodologies
• Ownership: You take responsibility for projects, drive results, and deliver on commitments
• Honesty: You demonstrate integrity, transparency, and ethical behavior in all interactions
• Collaboration: You work effectively with cross-functional teams and foster a culture of teamwork
• Improvement: You continuously seek opportunities for growth, innovation, and personal development
• Detail-oriented, organized and a good team player
• Independent, highly motivated, and solution-driven mentality to all activities
• Excellent interpersonal skillset, particularly with the ability to build authentic business relationships

Nice To Haves

• Experience with cloud platforms (specifically GCP and Cloud SQL)
• Knowledge of containerization and orchestration (Docker, Kubernetes)
• Experience with monitoring tools (Prometheus, Grafana, GCP SQL Query Insights)
• Certifications in PostgreSQL or related technologies
• Experience troubleshooting PostgreSQL WAL and VACUUM behavior
• Experience with OLAP (columnar) databases (ClickHouse)

Responsibilities

• Designing and implementing database architecture solutions that scale with our growing SaaS platform
• Leading database performance tuning, optimization, and troubleshooting initiatives
• Investigating and resolving complex production database performance and availability issues, including identifying root causes, mitigating incidents, and driving long-term improvements
• Collaborating with software development teams to optimize database queries and schema designs
• Collaborating with DevOps teams to automate routine database administration tasks and maintenance procedures
• Extending and maintaining database observability tools to monitor performance and capacity, and analyze historical data to identify trends and proactively address issues
• Implementing and maintaining database security measures and access controls
• Mentoring and teaching engineering teams in writing optimized and performant database queries

Benefits

• 4-Day Work Week
• Equity Participation
• Managers who champion professional development
• 100% Premium Coverage for medical, dental and vision for you and your dependents
• 100% Premium Coverage for Short Term Disability, Long Term Disability, Life, and AD&D Insurance
• Company Match of the first 6% of your employee deferrals
• Flexible Paid Time Off Policy that treats you like the adult that you are
• Health Savings Account (HSA) and wellness incentives
• Quarterly Company Values Award (team member nominated)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed