Senior MSSQL L3/SME DBA

Title: Senior MSSQL L3/SME DBA

Description:

Skills Requirement

• Mandatory skills - SQL Server & Cloud administration required skills.

• Senior level Microsoft SQL Server DBA with experience in large and critical environments.

• Knowledge of performance tuning at both server level and query level. Candidate must have knowledge of perfmon, SQL Server dynamic management views.

• Knowledge of SQL server internals.

• Knowledge of SQL partitioning and compression

• Hands-on experience on mirroring, replication and Always ON

• Must have automation experience. Good knowledge of scripting. Ability to write T-Sql scripts, Power Shell, or Python.

• Excellent knowledge of SSIS packages.

• Hands-on experience on SQL Server Clustering.

• Hands-on experience on Integration Services, Reporting services and Analysis services

• Must have good knowledge in SQL Server permission/security policies.

• At least 6 months experience with AWS Cloud RDS

• Good to have skills

• MySQL knowledge / experience.

• Linux Knowledge.

• Experience with Cloud services like Azure

• Experience with SnowFlake

• Certifications Desired

• MS certifications on MSSQL latest versions.

• High Level Role Responsibilities and Interpersonal skills needed for this role

• Ability to integrate data between SQL databases and NON-SQL dstabases to SQL databases

• Ability to think about a problem, identify what we have and implement solutions to solve the problem independently.

• Work with onsite client team / Application owners in US / UK to Migrate Applications, Database building and Decommissioning.

• Ability to take lead on some projects and works as part of a team (follow another leader on others)

• Strong verbal and written communication skills

• Ability to think in and out of the box. Come up with service improvement ideas and innovative solutions.

• Self-motivated, conscientious, dedicated individual who works equally well independently or as a member of a team.

• Must be willing to take responsibility and ownership instead of waiting to be assigned work

• The candidate must be willing to provide On-call and weekend support for SQL and MYSQL, the support is rotated among DBA's in US, UK and India

• Enable and support the team in resolving day-to-day production issues, application upgrades and patches, performance analysis, disaster recovery implementation, capacity planning and other activities as may be necessary.

• Work on Change implementations during UK, US business hours & weekends as per change management process

• Documentation & Operational performance reporting

• Own Service Improvements

• Execute on demand IT projects.

• Drive compliance to client and organization processes and policies

• Ensure Quality of deliverables

• The above is not a comprehensive list and could change based on business requirements

• Education & Experience Requirements

• Education - Bachelor or higher degree.

• 10+ years' experience in working in IT services organization.

• At least 8+ years of SQL DBA experience covering implementation, production support and project work.

• At least 5+ years of exposure as L3/SME support role .

• Knowledge and Understanding of the ITIl process.

• In client facing role(s) globally for at least 5 years.

• On call support for at least 5 years.

• Excellent Documentations skills in MS SharePoint 2010 /2013