Description
MS SQL Admin
Mandatory Skills
At least SQL DBA experience, 6+ years required
Thorough Knowledge of Windows Operating System, Networks and Active Directory
Knowledge of creating and maintaining standby/replication setup
Strong in SQL fundamentals
Knowledge of using Enterprise Manager and Query Analyzed for basic administration
Knowledge of configuring and setting up maintenance activities for DB
Knowledge of SQL statements tuning and DB Tuning
Knowledge on DB structures (filegroups, Indexes - clustered/non clustered/fillfactor)
Knowledge on Memory structures (configurable parameters)
Knowledge of complete/differential/transactional backups and their recovery scenarios
Knowledge on High Availability configuration like replication and log shipping, cluster setup
Desired Skills
MCSE MSSQL Certification is added advantage.
Technically sound knowledge on Clustering, Log Shipping, Mirroring, Always on
In depth Knowledge on SQL server 2000, 2005, 2008, 2012, 2014 Versions.
Years of exp needed
Roles and Responsibilities post joining
Provide database administration service.
Following standard team processes and defines new ones with corrections.
The individuals will be expected to be fully-functional DBA's who can perform traditional DBA activities independently and guide team members too.
Able to provide escalation support whenever required.
From an operational perspective, responsibilities include troubleshooting problems, working maintenance windows and providing 24x7 on-call supports on a rotational basis. Pre-installation Tasks
Pre-installation Tasks
Installing SQL Server and Patch Mgmt
Installing & Maintaining DB Tools
Uninstallation
Database Upgrade
Database Migration
Database Patch Installation
Physical Database Design and Implementation
Database Setup in 32 and 64 architecture
Database Clean-up/Removal
DB Cloning
Design Database, RAID configuration & Capacity Planning for Large Databases
Setup and implement Cluster Setup in multiple nodes environment
Implement High Availability configuration like replication and log shipping
Start up and shutdown of Database instances
Maintaining Database replication/standby/clusters
Job scheduling
Verify all Instances and dependent services are running
Look for any new error log entries
Session/Process Monitoring
Query or Transaction monitoring
Lock and Deadlock monitoring
Activity/Transaction Log monitoring
Job monitoring and Purging Job history
Replication/Log shipping monitoring
Monitor Space usage/growth of Database objects
Verify free space in file groups/databases
Monitor transaction log growth and truncate schedule
Reorganization of DB to remove fragmentation
Update Stats for hot objects
Purging of DB logs and trace files
Schedule maintenance plans for maintenance like DBCC REINDEX/INDEX DEFRAG
Creation and schedule maintenance plans and jobs for update stats, defragmentation, checking database integrity
Verify that Server has enough resources for acceptable performance
Periodic Report Generation on Database Health
Identify bad growth projections
Identify space-bound objects
Review contention for CPU, memory, network, and disk resources
Generating statistics
Look for objects that break rules.
Ensure that all indexes use an index table space
Ensure that all tables have unique primary keys.
Look for harmful growth rates
Examine tuning opportunities.
Look for I/O Contention
Review fragmentation by investigating row chaining and other areas of fragmentation
Database Objects Creation/Review
Capture Performance Statistics of Instance like IO, Waits, Paging, Buffer Hit Ratio, Full Scans etc
Capture Performance Statistics using performance monitors
User/Schema Creation
User Management
Roles and Privileges Management
Look for security policy violations
Privileges & Access controls on Database
Verify that the database backup was successful
Backup execution and monitoring
Define Backup policy and retention policy for complete/differential/transaction backup
Conduct Backup, restoration drills for backup verification in different scenarios
Database Connectivity issues
Slow response
Operations timed out
Dead locks
Database Hangs
Database incident and error resolution
Transaction Log Backup Stuck for Space
Database incident and error resolution
Vendor Management
System Performance Monitoring
Maintaining Environment details and change management
Windows Scripting for automations of DB related work
SSIS and SSRS
Implement ITIL processes & Maintain Transition Management Docket
Adherence to Change Management Process
Presales knowledge/experience is added advantage.
Implement ITIL processes & Create Transition Management Dockets
Presales knowledge/experience is added advantage.