Previous extensive experience of MSSQL RBDMS
Installation, management and production support of MSSQL 7, 2000, 2005, 2008, 2012 & 2014 on the following platforms Windows 2000, 2003 & 2008
Strong platform skills on Windows 2000, 2003, 2008, networking (TCP/IP, DNS) experience.
Experience in SQL Server Transactional and Merge replication required
Experience in DTS and SSIS required
Familiarity with Autosys scheduling
Experience in high availability database configuration including Clustering, SRDF, Log Shipping
BCP awareness & Change control awareness and industry best practices.
Backup / recovery technologies and industry best practices
Database checks and shutdown
Backup checks to ensure success / restarts
Working with Network Team for IP changes
Working with Vendor and engineers to troubleshoot issues
Resolve any OS issues/working with App Dev to help resolve issues
Produce transition plans and story boards where required as part of an overall schedule of events
Investigate application dependencies and identify migration priorities
Working with other teams (App Dev, BAU etc) to plan change dates and times
Arranging handover to BAU support teams (agreeing and documenting per migration requirements)
For virtual migrations Document and define the approach for VMware migrations.
Documentation Clear documentation needs to be produced pre and post migration
Problem ownership, with escalation as and when required