Senior SQL DBA

Description• Strong proficiency in deploying and managing Microsoft SQL Server technologies/features including SQL Server 2007 through 2019 , Integration Services, Reporting Services, Analysis Services, Always-on, merge replication, and HA clustering .• Experience on Cloud knowledge is must. • Should have experience in automation and infrastructure as code including leverage of Ansible and Terraform toolsets. Familiarity with Github and Jenkins is a plus. • Solid hands-on experience in database patching, upgrades, and migrations.• Proficiency in SQL optimization and coding techniques to code efficient stored procedures and triggers.• Good architectural knowledge of relevant server OS, storage, networking, virtual machines, high availability.• Design, implement, and maintain complex database systems following industry standards and best practices to ensure highly available, secure, performant and scalable database systems .• Design and deploy high availability solutions, and proven disaster recovery and backup/recovery strategy. Create, maintain, and test backup and recovery processes and systems.• Advanced knowledge of database design to produce sound logical and physical data models.• Monitor and plan capacity and performance and proactively resolve problems.• Troubleshoot a wide range of database problems with complex interdependencies and provide/drive issue remediation in timely and professional fashion.• Strong aptitude to adopting standards and cloud native principles and best practices.• Good verbal and written communication skills, providing clear and precise instructions for complex technical tasks, manages post-outage recovery, root cause analysis and remediation.• Seasoned experience and skills in leading projects such as data center migrations, server consolidation, DR failover/failback, server configuration management, security, audit and compliance.• Professional and timely technical support delivery and active engagement in IT incident lifecycle management• Actively mentors less experienced team members, Regularly recommend process improvements and best practices.• Bachelor degree or equivalent work experience. Certifications in related IT and MSSQL technologies preferred

Qualifications
Technical Skills
SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 SQL Server DB Administration PL4 Required

Domain Skills
SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 Payments NA Desired

* Proficiency Legends
Proficiency Level Generic Reference PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels. PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects. PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects. PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.