SQL Server DBA - Technical Specialist

Overview

A SQL Server DBA will be responsible for working on database project delivery and/or production support operations from a technical standpoint for our customer in investment management. This would often involve routine tasks that support database infrastructure, such as resolving production and pre-production difficulties, tackling changes, incidents, and problems, as well as working on engineering or service enhancement projects.

Key Responsibilities

1. 24x7 business support estate for production databases. This covers all environments for production, disaster recovery, urgent bug fixes, user acceptance testing, and development.
2. Rapid reaction to occurrences of high severity (severity 1, 2, and 3H).
3. Delivering and supporting the allocated project work.
4. Service monitoring and proactive issue discovery and resolving.
5. After unplanned interruptions or outages, service restoration.
6. Administration and development of action items.

Skills and Qualifications

1. 4-5 years of progressive working knowledge of SQL Server technologies.
2. SQL Server (minimum 2014, 2016, 2017).
3. A thorough knowledge of capacity planning, high availability and disaster recovery technologies, such as SQL Server Always On, Windows Clustering, and database mirroring.
4. Able to write T-SQL and PowerShell with ease.
5. Possess a thorough grasp of Active Directory and the Windows Operating System.
6. Knowledge of database backup, restore, and recovery methods Good database performance and query tuning.
7. Basic familiarity with SCOM.