Database Administrator

VOLO Health, headquartered in Jupiter, FL, is a proactive healthcare technology company. We develop advanced tools to deliver predictive, personalized insights to empower individuals and organizations to make data-driven decisions, promoting longer, healthier lives. VOLO Health is dedicated to developing a data-science-driven approach to assess, track, and improve healthspan. Founded in 2023 with the same data science background that has propelled its sister company, Voloridge Investment Management, as an award-winning quantitative hedge fund. Summary of Job Functions Operations Ensure the integrity, security, availability, accessibility, stability, and performance of company Snowflake, PostgreSQL,ClickHouse, and SQL Server databases Create andmaintaindetailed SOPs, configuration documentation, and maintenance plans for the database environment Conduct troubleshooting of issues associated with supported Snowflake, PostgreSQL,ClickHouse, and SQL Server databases Ensure real-time monitoring and alerting of best practice KPIs across all supported database platforms, such as wait stats/query performance, CPU usage, memory usage, disk I/O, and queue lengths Import and export data to and from the database servers Provide after-hours production support Execute productiondeploymentscripts and procedures provided by other teams Define,maintain, and review audit trails and logs Ensure all database environments handling Protected Health Information (PHI) remain compliant with HIPAA Security and Privacy Rules, including encryption of data at rest and in transit, access controls, and data masking/de-identification where appropriate High Availability, Disaster Recovery, and Fail-Over Create and execute database backup and recovery policies andmaintainintegrity and reliability of access to information Create and manage Disaster Recovery of all Production environments using platform-appropriate best practices (e.g., Always On/Log Shipping for SQL Server, streaming replication for PostgreSQL, cross-region replication for Snowflake, replicated tables forClickHouse) Perform routine backup and recovery testing, including testing and documenting recovery scenarios Development Work with application/development teams toassistin overall database design, help developers tune queries, assign proper indexes, and aid developers in the creation of triggers and stored procedures Create tables, views, indexes, database links, views, materialized views, stored procedures, and other database objects as needed; create and assign database roles and privileges Perform performance tuning tasks across Snowflake, PostgreSQL,ClickHouse, and SQL Server Planning and management Manage the storage environments for the databases, includingoptimalsizing,monitoringspace, requestingadditionalstorage, and providing growth statistics, and capacity planning Assistinternal client teams with management of production server systems such as network security teams, data center teams, system security officers Understand andoptimizelicensing and consumption models across supported platforms (e.g., SQL Server licensing, Snowflake compute credits) Onboardnew technologyincluding hardware stress testing and software POCs Participate in audit reviews, penetration tests, and the like Support compliance efforts related to HIPAA, SOC 2, and HITRUST CSF frameworks, including evidence collection and remediation of database-related findings Maintain a database platformlife-cycleand upgrade roadmap across Snowflake, PostgreSQL,ClickHouse, and SQL Server Support, manage and develop junior team members MinimumRequirements Bachelors’ degree in computer scienceor technical discipline 7+ years of experience supporting large,highly availabledatabase installations as a DBA, ideally spanning multiple engines (Snowflake, PostgreSQL,ClickHouse, SQL Server) Solid understanding of relational database design and concepts An excellent grasp of HA & DR solutions available across Snowflake, PostgreSQL,ClickHouse, and SQL Server, and experience implementing them (e.g., Always On/FCI/Log Shipping/Mirroring/Availability Groups for SQL Server, streaming replication for PostgreSQL, replicated tables forClickHouse, multi-cluster warehouses and cross-region replication for Snowflake) Extensive experience in leading projects such as server migrations, version upgrades, and shared development environment refreshes A deep understanding of performance tuning methodologies and experienceoptimizingfrom DB level objects through server/cloud infrastructure Experience with ETL and warehouse tools and processes Experience implementing and monitoring security best practices Demonstrated experience working within HIPAA-regulated environments, including safeguardingPHIand supporting compliance audits Willingness toparticipatein a rotating on-call schedule to support after-hours production issues Must be able to pass a background check as a condition of employment, consistent with handling of sensitive health information Must be able to work on-site in Jupiter FL Preferred Skills and PreviousExperience Experience with Azure and/or AWS Familiarity with EMR/EHR systems (e.g., Epic, Cerner) and healthcare data interoperability standards such as HL7 and FHIR is a plus Relevant certifications preferred, such as Microsoft Certified: Azure Database Administrator Associate,SnowProCore/Advanced, or AWS Certified Database - Specialty Hands-on experience with Snowflake, PostgreSQL, and/orClickHouse, in addition to SQL Server, is highly valued Experience with both OLAP and OLTP workloads and design implicationsispreferred, with emphasis on OLAP Experience with Big Data/NoSQL would be a plus Exceptional candidates will have experience working with MPP/columnar databases such as Snowflake andClickHousein the cloud or in a cluster Compensation and Benefits Health, dental, vision, life, disability insurance 401K Credit and Identity Monitoring Service VOLO Health is an Equal Opportunity Employer. All qualified applicants are encouraged to apply and will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristic or status. #J-18808-Ljbffr