"Should be involved in the planning, design, and deployment of MS-SQL solutions.
Extensive knowledge on Standalone and cloud solutions in Azure Platform [Cloud Database as a Service].
The ideal candidate will have an understanding of MSSQL query language, Database Administration, Performance Tuning, Clustering, Backup and restoration.
Proficient scripting and automation of SQL administration using PowerShell/Azure CLI "
Role & Responsibility
Install, configure, administer, manage, and support MS-SQL, SQL Backup, Clustering, log shipping, mirrioning and Load Balancers.
Strong knowledge of Backup , Validation to meet RTO[Recovery Time Objectives], Restore, Recovery, DR, high availability strategies, performance analysis and performance tuning.
Should be able to configure SQL Server monitoring utilities or monitoring rules to detect and understand the alarms.
Hands-on experience of administration of Windows server-side infrastructure, virtual machines, and associated technologies on physical servers / Cloud will be prefered.
In support of the deployed cloud systems and environments, create custom scripts to automate support processes where applicable
Ability to identify issue at SQL and resolve. If needed escalate to Microsoft and coordinate with them
Manage SQL subscription and profiles
Adapts existing methods and procedures to create possible alternative solutions to moderately complex problems.
Architectural exposure to Windows or Unix, Hyper-V, SAN, NAS and other technologies would be added advantage
Knowledge of Server Operating Systems (Windows or Unix) and Virtualization Platforms (e.g. VMWare, Hyper-V, etc.) will be added advantage
Assists in developing, testing, evaluating, and installing new software and enhancements.
Proficient scripting and automation of deployment using PowerShell/Azure CLI
MCDBA / MCSA Certification preferred.