Sr. Database Administrator
HHA Exchange · United States · remote
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:
- 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.
- 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