- Knowledge of Failover clustering, SQL server AlwaysOn Groups, SQL server mirroring, SAN replication, and other high availability technologies
- Ensure all database servers are backed up in a way that meets the businesss 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 and configure 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 companys database environment.
MSSQL DBA Job Requirements:
- Experience on Microsoft SQL Server 2008,2012, 2014,2016,2017,2019,2022.
- Production Support Activities (Installation, Upgradation and Troubleshooting).
- Performance Tuning & troubleshooting
- SQL Server 2008/2012/2014/2016/2017/2019/2022 Migration.
- T-SQL Scripts for Administration and Monitoring tasks.
- Microsoft Clustering services (MSCS) knowledge- Install/Configure/support.
- Relevant knowledge of the operating system (2008, 2012,2016,2019) as far as MS-SQL databases is concerned.
- High Availability (Log shipping, Replication and Mirroring) Always ON
- User creation & maintenance, database log space monitoring and maintenance.
- Good knowledge on Always on and high availability
- Strong fundamentals of SQL.
- Strong in SQL Architecture, Backup & Restore process.
- Configuring CDC replication.
- Configuring TDE in always on servers.
- Knowledge on ITIL process.
- Good communication, should be able to clarify issues with customer
Skills Required
Ms Sql Dba, San, Itil, Sql