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