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