**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.
