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.