SQL Server DBA - J35521

Sampoorna Computer People
  • Chennai
  • 10-15 lakh
  • 4-8 years
  • 208 Views
  • 07 Sep 2015
dfdf

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

Experience and Qualities
4+ Years combined experience of SQL Server 2008R2 and SQL Server 2005
Knowledge of SQL Server 2000 advantageous but not essential
Typically educated to degree level (BSc or equivalent)
Self-starter capable of working under their own direction with good attention to detail
Good oral and written communication skills
Analytic mind and good problem solver
Committed knowledge sharer both via documentation and other less formal communications
Keen to learn from experience, formal training and tailored self-betterment
Certification: MCTS; MCITP; MVP is a plus, but only in addition to proven experience

SQL Server DBA Responsibilities

Backup, Restore and Recovery strategy and execution
Daily, Weekly, Monthly routine DBA Tasks
Troubleshooting and resolving database problems

Performance Monitoring and Tuning

oSQL Server in general
oIdentify poorly performing SQL statements and recommending actions
oAnalysis using DMVs for identifying trends over longer term for capacity planning
oSetting up automatic alerts for critical metrics.

User Administration and Security
Space Monitoring and Capacity Planning

Other DB Project Work

oMigration/Upgrades/Server Consolidation
oData Integration/ETL/Interfaces using SSIS Package

Replication

oTransactional Replication

Installing and Configuring new SQL Servers

oSingle Node
oActive-Passive Clusters
oActive-Active Clusters

Periodic refreshes of Development and Test Systems from Production


Competencies/Skill sets for this job

Sql Dba SQL MCTS

Job Posted By

About Organisation

Sampoorna Computer People