We are seeking a highly skilled and motivated Infrastructure & SQL Automation Engineer to join our Technical team. The ideal candidate will have deep expertise in:
- PowerShell scripting,
- SQL Server management and development,
- Server infrastructure administration,
- Automation of SQL deployments
This role requires a strong understanding of cloud environments, data synchronization, and data modelling, with a focus on scalability, security, and efficiency.
Key Responsibilities:
Server & Infrastructure Management:
· Manage on-premise and cloud-based server infrastructure (Windows Server preferred)
· Perform routine system updates, patches, and security audits.
· Administer SQL Server instances and environments across dev, test, and production.
SQL Server Expertise:
· Develop and optimize complex SQL queries, stored procedures, and functions.
· Analyze and synchronize large-scale data across systems using SQL tools.
· Design and maintain logical and physical data models to support business needs.
Automation & Scripting:
· Use PowerShell to automate server and SQL deployments, configurations, and monitoring.
· Build and maintain scripts for backup, disaster recovery, and routine database tasks.
Cloud Deployment & Management:
· Manage deployments in cloud environments (Azure, AWS, or GCP).
· Automate provisioning and scaling of SQL instances in the cloud.
· Implement best practices for cloud security, storage, and performance.
Monitoring & Reporting:
· Implement proactive monitoring and alerting solutions for server and database performance.
· Prepare system documentation, performance reports, and capacity planning.