This role will present the successful candidate with an opportunity to expand their knowledge within the DBA environments. The DBA will be responsible for providing technical support for the database environment including overseeing the implementation and organization of the databases.
- - - - - - - - - - - - - -
Minimum Requirements Qualification: BSc IT or similar Experience: Minimum 4 years MS SQL Server DBA experience
Responsibilities Database Administration and Design • Responsible for the installation, configuration, upgrade of the database environments • Maintain the database environments, including o Replication o Log Shipping o Always On Availability Groups o Mirroring • Maintain database security in accordance to policy • Conduct daily checks on the database servers • Configuration and Monitoring of the SQL Server backups • Undertake capacity planning of the database servers • Perform database deployments in accordance to change control methodology
Monitoring and Performance Tuning • Proactive monitoring of the database environment • Responsible for troubleshooting and assisting with database related errors and performance issues • Identify and recommend changes for poor performing queries
Operational Incidents • Carry out customer requests accurately and timeously • Adhere to company policies and operating procedures Database Development • Advise developers on best practice for database design • Develop optimal SQL code • Design and develop ETL packages • Design and develop reports
Skills and Knowledge Essential knowledge • MS SQL Server 2008 R2, 2012, 2014 & 2016 • SSIS • SSRS • Proficient technical and SQL troubleshooting skills
Behavioural Competencies • Pro-Activity • Teamwork • Strong communicator • Information Gathering and Problem Analysis • Planning and Organising • Quality and Detail Orientation