Authentic8

Database Administrator, DBA

Authentic8

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $175,000 - $195,000 per year

Job Level

About the role

  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
PostgreSQLSQLETLELTdata modelingperformance optimizationschema designautomation toolsdata integrationmonitoring and alerting
Soft Skills
communicationdocumentationcollaborationproblem-solvingleadership