MSSQL DBA

Job Description

• Installation, Administration and Maintenance of SQL Server Instances
• Create Users and assign permissions based on the level of database access the user would need
• Design database backup and restore strategy
• Setup High-Availability as part of Disaster Recovery Strategy for the Databases
• Troubleshoot various problems that arise in the day-to-day operations and fix the issues
• Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizations
• Failover clustering, Always on, replication, high availability technologies
• Resource monitoring (I/O bottlenecks, memory pressure, CPU Pressure)
• SQL Server Migration from one version to another version