Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Experience on MS SQL Server Administration (preferably MCTS) as a primary skill set, secondary skill for MongoDB / Oracle Proficient in ITIL process (preferably ITIL Certified) and ticketing tools (Service-Now, Remedy etc) Administration of SQL Server databases in Production, Test, Integration and Development environments. Installation, Configuration & Maintenance, Patching, Upgradation. Database Migration (On-Prem to Azure) Database Backup and Restore, Re-Indexing, 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. 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. Shall deliver against agreed SLA’s including quality aspects for services. Working with Remedy Incident, Work Order, Change Request tickets and monitoring the mail alerts. Automating most of the administration tasks using Powershell and SQL Agent jobs. Use the appropriate support tools (e.g. Remedy including the Knowledge Base), forms and templates to support the ITIL processes. Following the ITIL process (Incident, Service desk, Incident and Problem Management)

Minimum years of experience*: 5

Interview Process (Is face to face required?) No