Database Administrator - SQL

Job Description :

• 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.
• Monitoring of database performance and stability
• Establish the baseline for system performance, recognize deviation, and suggest and implement improvements to slow running queries
• Develop and document technical processes and procedures as needed.
• Interact, meet, discuss, and troubleshoot issues with the engineering team.
• Report project status as required for all recurring and non-recurring efforts.
• Work under minimal direction and independently determine and develop approach to solutions.
• Administering SQL Server, the backup, integration, restore, reporting and maintenance processes.
• Diagnose and analyze using third-party diagnostic tools.
• SQL Server security configuration and management
• Work with the team on migrating older versions of SQL Server to new, if required.
• Administer and maintain Azure SQL managed instance.
• Development on Power BI, if required.
• Create Business Requirement document, KPI dimensions matrix, source to target mapping documents.

MSSQL DBA Job Requirements :

(ref : hirist.tech)