**SQL Server DBA duties and responsibilities Principal Accountabilities**- Provide support for a large footprint of Microsoft SQL Server instances including AlwaysOn availability groups and failover clustering configurations.- Support SQL Server 2016/2019 on Physical and VMware Hypervisor.- Responsible for database backup and recovery methods, database access security and integrity, physical data storage design and database storage administration.- Involved in disaster recovery planning. Participate in several Business Continuity DR tests per year in coordination with the Business Continuity team. Document DR processes.- Provide Production support including Saturday Deployment support.- Support DB and OS Patching initiatives on a monthly/quarterly basis. Remediate MSSQL vulnerabilities identified by the Vulnerability Mitigation Team.- Participate in continuous process improvement, focusing on reduction of manual tasks via automation.- Implements and maintains configuration of each database instance to baseline standard access controls.- Make recommendations for database system architecture per Microsoft SQL Server best practice. - Deploy and manage updates to scheduled jobs within UC4 Scheduler and SQL Server Agent.- Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues promptly.- Tune T-SQL queries and provide guidance to developers on best practice.- Manage and coordinate database migrations and database software and hardware upgrades.- Create documentation and training for routine database administration activities, as well as train server operations employees on them- Support standard DBA security processes such as password rotation, TDE, SSL and DB Auditing- Attend Standup/Planning/Issues review/Change Control and Customer facing meetings as representative of the team.- Experience with Onprem to Cloud DB Migration on Compute Engine and Managed Services.Pay: Up to $70,000.00 per month**Experience**:- PowerShell: 4 years (preferred)**Language**:- English (preferred)Work Location: Hybrid remote in 44250, Guadalajara, Jal.
