JB058965 - Database Automation Engineer
Apply NowCompany: USM Business Systems
Location: Irvine, CA 92620
Description:
- PowerShell Automation & Scripting
o Develop and maintain PowerShell scripts for automating routine database administration tasks, such as backups, restores, replication, and monitoring.
o Automate the configuration and management of SQL Server Always On Availability Groups, including failover processes, health checks, and scaling operations.
o Develop custom scripts for health monitoring and alerting for SQL Server instances, clusters, and Availability Groups.
o Leverage PowerShell to interact with SQL Server and Azure SQL environments for consistent and reliable performance.
- SQL Server Always On Availability Groups in Cloud (AWS)
o Implement, configure, and maintain SQL Server Always On Availability Groups for high availability and disaster recovery.
o Troubleshoot and resolve Always On Availability Group issues, including failovers, data synchronization, and replica health.
o Manage the deployment and monitoring of Always On Availability Group replicas, including primary and secondary replicas.
o Perform routine checks on Availability Groups to ensure proper synchronization and optimal performance.