Job Description
- To be responsible for monitoring database activity and ensuring that index statistics, database growth/storage, replication, archiving, back-up and recovery procedures are in place and functioning correctly.
- Monitor and manage the environment ensuring high availability is always maintained.
- Ensure that any issues related to HA/DR processes (Clustering, database mirroring, log shipping and transactional replication) are investigated and resolved.
- Assist other teams with database backups/restores and other activities
- 1st and 2nd line support incidents and requests logged with the DBA team
- Liaise with external vendors in support of 3rd party software solutions.
- Ensure that database security and permissions are managed according to best practices.
- Take an active role in improving the SQL Server database estate.
- Ensure that the DBA documentation set is updated and expanded where necessary.
- Perform SQL Server patching as required.
- Create management information reports from managed databases (Desirable).
Required skills and capabilities:
- Strong skills in data modelling (logical, physical, ERD).
- Understanding of object-oriented programming languages
- Working experience of the following technologies:
- SQL Server 2008 to 2014 including T-SQL, SSIS, SSRS and SSAS
- Power BI (Desirable)
- 3rd party or open source ETL tools (Desirable)
- Replication / High Availability
- T-SQL, Triggers, Stored Procedures
- Demonstrable experience of performance tuning and query optimization
- Experience of working in a virtualized environment
- knowledge of Failover Clustering, Log shipping, Database Mirroring and Transactional Replication
- Experience of the full Software Development Lifecycle.
Company Profile:
Salary: Not disclosed
Industry: IT / Telecom
Functional Area:
Role Category: Others
Employment Type: Full time
Keyskills
