Design, develop, and maintain MSSQL databases, perform capacity planning, and ensure database performance and integrity. Collaborate with stakeholders to implement security measures and support development teams in optimizing database queries.

• 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.

• Ensure the integrity, security, and performance of our databases. • Monitor and optimize SQL queries. • Verify database configurations. • Perform database migrations and upgrades. • Collaborate closely with development and operations teams for smooth database operations.

• Design and manage complex SQL queries, stored procedures, views, and functions to support data analysis, reporting, and business intelligence • Architect scalable and robust database schemas to support business data requirements • Apply expertise in SQL performance tuning to optimize database operations and enhance data retrieval and manipulation speed • Implement SQL database security measures, including robust access controls, encryption, and auditing policies • Lead data migration and integration projects • Develop strategies utilizing SQL expertise to ensure business continuity • Manage SQL databases across various platforms • Create comprehensive documentation for SQL database architectures and coding standards