Job ID :
26669
Company :
Internal Postings
Location :
Springdale, AR
Type :
Contract
Duration :
24 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
22 Feb 2020
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