SQL DBA - Database Administrator

The MS SQL DBA is primarily responsible for providing operational and SQL database services to the organization.

As a DBA, this person is primarily responsible for the maintenance and support of databases on large scale database servers running on Microsoft SQL Server.

Responsibilities:
1. Owning, tracking, and resolving database related incidents and requests.
2. Fulfilling requests and resolving incidents within SLAs
3. Perform regular database maintenance activities by following internal processes (data loads, data fixes, schema updates, database copies, software installs, upgrades and patches).
4. Running daily database checks.
5. Assist with the automation of regular database support activities.
6. Maintain code in centralised repositories appropriate to each project.
7. Support and implement database solutions in Microsoft SQL Server. This will involve a complete understanding of our core software components and how they interact with the back-end database.
8. Interact with the CRM Development team to coordinate resolution of model-related problems that may be affecting the back-end database.
9. Work directly with the Research and Development team in New Zealand or India to implement and test newly created system files and core software components.
10. Provide ongoing support and technical guidance to users at various levels within the organization.
11. Work on rostered shifts (including weekends) providing 24x7 DBA services.

Essential Qualifications:
1. Has 2+ years of experience in database development and support in MS SQL Server environments.
2. Experience in Database Administration in SQL Server (2008 and 2012).

Essential Requirements:
1. Experience in writing SQL queries, Stored Procedures, Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
2. Knowledge of backups, restores, recovery models, shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
3. Knowledge of how indexes, index management, integrity checks, configuration, patching work, how indexes are stored, how they can be created and managed effectively.
4. Knowledge of SQL Server tools.