What are the responsibilities and job description for the Database Automation Engineer (PowerShell Automation) position at INGENworks?
Job Details
Job Title: Database Automation Engineer
Location: San Antonio, TX / Irvine, CA (Hybrid)
Duration: 12 months (Extendable)
on c2c
Note : Strong experience with AWS, Powershell Automation, and Always On
Need someone who is strong on PowerShell Automation.
- 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.
