Sr. Database Administrator

Job description

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. The Sr Database Administrator (DBA) will administrate HHA’s enterprise-wide database environments within our SaaS-based ecosystem. This role focuses on supporting high-availability systems, executing complex disaster recovery (DR) strategies, and managing data replication and retention to support critical business operations. To perform this job successfully, an individual must be able to perform each essential job duty satisfactorily with or without reasonable accommodation. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. **This is a fully remote opportunity for candidates located in the EST or CST time zones within the US only.** ### Essential Job Duties - 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 Job Duties - Other duties as assigned by supervisor or HHAeXchange leader. ### Travel Requirements - Travel up to 10%, including overnight travel ### Required Education, Experience, Certifications and Skills **Education:** Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field and applicable experience. **Experience:** - 6+ years in database administration, with at least 4 years within an enterprise SaaS environment. - Expertise in Cloud Data Platforms (e.g., AWS RDS/Aurora, Azure SQL, OCI) and relational systems (PostgreSQL, MySQL, Oracle, or SQL Server) in both Cloud and On-Prem environments. - Experience with No-SQL solutions (e.g., Redis, Couchbase, MongoDB, Cassandra) - Advanced Automation/Scripting skills (Python, Bash, Terraform, or Ansible) for infrastructure-as-code and task automation. - Proven experience with Large-Scale Data Migration and zero-downtime upgrades. **Skills:** - Ability to lead a "War Room" during critical outages, collaborating with opertaion staff,between operations staff and executive stakeholders; - Collaborating with distributed or offshore operations teams in a follow-the-sun support model; - Analyzing license and hosting agreements from a performance and cost perspective; - Strong analytical thinking, complex problem-solving, and the ability to communicate technical strategies to non-technical stakeholders; - Willingness to explore and adopt AI tools responsibly to enhance productivity and innovation in your role