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