Sr Database Administrator (DBA)

HHAeXchange is the leading technology platform for home and community-based care. Founded in 2008, HHAeXchange was born out of an idea to create a fully comprehensive end-to-end homecare solution to help people who are aging or have disabilities thrive in their homes and communities. Our employees are passionate about transforming the healthcare space by building the only homecare ecosystem that fully connects patients, personal care providers, managed care organizations, and states.

• Maintain complex replication models (e.g., multi-region, real-time) and high-availability solutions like clustering or multi-AZ deployments.
• Act as the subject matter expert for the design, implementation, and maintenance of our primary SQL Server infrastructure, maximizing uptime and reliability.
• Multi-Platform Administration: Support, monitor, and maintain auxiliary database platforms including Oracle Exadata@AWS, AWS Aurora MySQL, and PostgreSQL.
• Ensure data consistency across distributed SaaS environments and hybrid-cloud infrastructures.
• Design and implement end-to-end Disaster Recovery (DR) strategies, ensuring compliance with Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Participate in regular DR exercises, automated failover testing, and demonstration of no-outage resiliency.
• Establish and enforce automated data retention, archiving, and purging policies aligned with industry compliancy, including healthcare industry requirements.
• Implement and support security measures, including transparent data encryption (TDE), role-based security, and unified auditing.
• Lead proactive performance tuning, query optimization, and capacity management for high-volume, transactional SaaS workloads.
• Monitor and analyze advanced performance metrics to identify and resolve resource contention.
• Serve as a technical advisor for database modernization roadmaps, transitioning legacy systems to cloud-native or containerized architectures.
• Develop standards for database schema design, storage structures, and automated deployment pipelines (CI/CD).
• Establish Standard Operating Procedures for the database operations team, covering routine maintenance, patching, and ticket escalation paths.
• Build and promote our 'Operations-as-Code' model, mentoring the team in using tools like Terraform, Ansible, and utilizing CI/CD pipelines to automate repetitive tasks.

• Other duties as assigned by supervisor or HHAeXchange leader.