Install, configure and manage MS SQL clusters. Patch and upgrade databases. Responsibilities & Deliverable : Your deliverable will include, but are not limited to, the following : Responsible for solution designs and documentation for projects Support ON CALL rotation 24x7 Responsible for performance tuning.
Create & manage / administer / maintain monitoring tools like Diagnostic Manager for SQL Server by IDERA, and or Microsoft Azure’s OMS.
Responsible for enhancement or solution designs, documentation and / or training team members on new technologies Responsible for configuration and implementation of databases backups.
Configure, setup, maintain database security and auditing. Disaster Recovery planning and implementation Required Experience : Must have 10+ years of experience managing large and / or complex OLTP and warehouse databases using MS SQL 2012 to SQL 2016 Must have 3+ years of experience in setting up and managing MS SQL in Azure Azure (and Azure Portal), IaaS, PaaS Must have 3+ years of extensive hands on PowerShell experience Must have hands on experience and sound knowledge in cloud technologies and architecture Extensive experience in monitoring (using DMV), tuning, and securing MS SQL databases Expertise in designing, managing and tuning OLTP / DW databases Experience MS SQL Clusters, Always On and stretch clusters, Database Mirroring, Transaction Log shipping, Replication Expertise in SQL / T-SQL development and tuning Expertise in operational and incident management / resolution Strong documentation skills Strong architecture and infrastructure design for MS SQL databases and ability to set and implement standards Preference given to Expertise in PowerShell, IAC, VSTS Azure experience with IaaS, PaaS and OMS ITIL v3 Education and Soft skills : University degree / College diploma in computer science or a related field of study.
Ability to troubleshoot and, diagnose and resolve complex database issues Self-motivated individual who enjoys technical challenges and takes pride in delivering high quality work Proven ability to work in a fast paced, results oriented environment Strong business / technology decision making skills Strong interpersonal skills to effectively influence decisions and positively impact progress Ability to work with a global team, yet work independently Excellent oral communication skills with experience in creating clear concise documentation Strong analytical skills