Responsibilities
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
Install, configure and deploy new SQL Servers
Deploy database change scripts provided by third party vendors
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
Document the company’s database environment
Manage Windows servers
Provide application support to end users
Build and deploy new Windows servers
Job Qualifications
Bachelor’s Degree In IT, Software Engineering, IT Or Related Fields From A Recognized University
Experience managing virtual servers using VMWare or HyperV platforms
Experience working with Windows server, including Active Directory and proper disk configurations.
Microsoft SQL DBA Certification will be considered a big plus
MCSE certification will be considered a plus
Experience in troubleshooting and resolving database issues such as database integrity, performance, blocking and deadlocking, replication amongst others.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Experience with backups, restores and recovery models.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
Knowledge of indexes, index management, and statistics.
Ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
Knowledge in a scripting language like PowerShell will be a plus
At least 3 years’ experience in performing in a similar role
Ability To Communicate Technical Issues With Non-Technical Users
Sound Analytical, Interpersonal And Communication Skills
