Sr. Database Administrator

Your tasks

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.

Requirements

Education: Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field and applicable 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.

• 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

Other

Travel Requirements

• Travel up to 10%, including overnight travel