Senior MSSQL Database Administrator

Soft tech Career Info system Pvt. Ltd
  • Bangalore, Chennai, Chandigarh, Gurgaon
  • 10-20 lakh
  • 8-10 years
  • Views
  • 14 Dec 2016

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

• Document and define the database approach and requirements for Refresh, Swing and Lift and Shift migrations
• Ensure Company best practice is applied
• Analyse database maintenance, management and enhancement plans (including upgrades, tuning and capacity planning)
• Identify High Risk and Low Risk services and plan accordingly
• Attend migration workshops to gather information and understand requirements fully as well as raising concerns / issues with the application teams
• Analysis and planning of migration to ensure contingency plans are not affected by the migration
• For swing migrations work with Application teams to migrate and upgrade SQL Server to new VM assisting Application teams with testing, extraction of DTS packages, migration to Autosys scheduling , conversion of DTS to SSIS and handover to BAU support teams
• 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

Competencies/Skill sets for this job

Transition Server Dts Ssis Contingency

Job Posted By

O.P. Chawla