Job Seekers, Please send resumes to resumes@hireitpeople.com Must Have Skills: Experience on MS SQL Server Administration (preferably MCTS) as a primary skill set, secondary skill for MSSQL MySQL and Oracle. Proficient in ITIL process (preferably ITIL Certified) and ticketing tools (ServiceNow, etc) Administration of SQL Server databases in Production, Test, Integration and Development environments. Installation, Configuration & Maintenance, Patching, Upgradation and Vulnerability remediation. Database Migration (OnPrem to Azure)

Nice to have skills:

Database Backup and Restore, ReIndexing, Update Stats, Auditing, DB Size Monitoring, Compression DR (Disaster Recovery) Testing, Database Performance Tuning, Monitoring alerts. User Schema Service accounts and Password management in all the environments. Log Shipping, Analysis of Database growth for future planning, Replication Configuring and Maintaining the SQL Agents Jobs and Maintenance plan tasks, configuring alerts and monitoring.

Detailed Job Description:

Experience on MS SQL Server Administration preferably MCTS as a primary skill set, secondary skill for MSSQL MySQL and Oracle. Proficient in ITIL process preferably ITIL Certified and ticketing tools ServiceNow, etc. Administration of SQL Server databases in Production, Test, Integration and Development environments. Installation, Configuration Maintenance, Patching, Upgradation and Vulnerability remediation. Database Migration OnPrem to Azure

Minimum years of experience: 10 years

Certifications Needed: No

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

Performance Monitor, taking trace files using Profiler, getting DTA Database engine Tuning Advisor recommendations. Good exposure in Always on High Availability Clustered environment. Installing, Configuring, managing, monitoring, identifying deadlocks, long running queries, query tuning. Limited to SSIS and SSRS. Implemented DB growth trend chart using SSRS.

Interview Process (Is face to face required?): No

Does this position require Visa independent candidates only? No