Database Administrator, DBA
Job Description:
- Own the availability, incident response, and operational health of the company’s PostgreSQL platform databases (Eng, QA, and Production)
- Ensure high availability and disaster recovery processes are tested and functioning.
- Implement PostgreSQL changes with minimal service interruption.
- Perform live schema updates and patches in coordination with Engineering and DevOps.
- Plan for database growth, execute tuning analysis, and conduct performance optimization.
- Review and assist with SQL query optimization, identify and resolve deadlocks.
- Coordinate schema deployments with DevOps.
- Support ad hoc query needs from Customer Success, Sales, and Marketing teams.
- Ensure all PostgreSQL security best practices are applied and monitored.
- Help restructure or re-architect current and future databases to support performance and scalability.
- Lead data integration projects that centralize company data from multiple systems into one or more centralized data pools (e.g., BigQuery).
- Architect and implement data pipelines (ETL/ELT) from systems such as Salesforce (CRM), Zuora (billing and revenue management), PostgreSQL (service data), Pendo.io (product analytics), Freshdesk (customer support/ticketing), Jira (work management and issue tracking).
- Partner closely with Business Operations analysts to: Align on data models and schema designs that support reporting and analytics as well as build performant queries and transformations for ongoing business intelligence.
- Ensure centralized data repositories are clean, consistent, and optimized for analysis.
- Implement monitoring and alerting for data pipeline health and performance.
Requirements:
- 8+ years of experience as a DBA
- 8+ years of experience supporting SaaS platforms
- 4+ years of experience working with automation tools and workflows
- Hands-on experience with PostgreSQL (strongly preferred)
- Ability to design and maintaining ETL/ELT pipelines
- Ability to work with APIs and third-party integrations for platforms like Salesforce and Jira
- Strong SQL skills and proficiency with data modeling
- Familiarity with cloud-based data warehousing solutions (e.g., BigQuery, Kestrel)
- Experience working in cross-functional teams including Engineering, DevOps, and Business Operations
- Excellent documentation and communication skills
Benefits:
- medical
- dental
- vision
- flexible PTO
- 401k program
- stock options