Sr. Database Administrator

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