Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9wzw9wbgvzb2x2zwqvanbnl2jhbm5lci1kzwzhdwx0lmpwzyjdxq

Junior Microsoft SQL DBA

Junior Microsoft SQL DBA

Job Title: Junior Microsoft SQL DBA
Location: Western Cape
Industry:
Salary: 323000.00
Reference: JN -102016-6911
Job Published: January 06, 2017 09:31

Job Description

TitleJunior MS SQL Database Administrator
DepartmentIT
Job TypePermanent
Work LevelSkilled
EE PositionNo
SalaryMarket Related
BranchWestern Cape
Description

The Junior Database Administrator will be responsible for the effective implementation, maintenance and repair of all databases (South Africa, United Kingdom, Mauritius and/or third party hosted database environments); monitoring and improving database performance and capacity, coordinate and implement security measures to safeguard the databases. The focus of the role will primarily be on OLTP, including performance management, assisting with effective design and development as well as the coordinating and communication of deployments to production.

Requirements

 

Key Performance Areas:

Database Administration and Design

  • Assist with the creation, configuration, upgrade, administration, monitoring, and deployment of databases in both development and live service environments
  • Assist with facilitating the best possible system performance from the perspective of the applications and reports using the databases
  • Perform regular database maintenance activities by following internal processes (data loads, data fixes, schema updates, database copies, software installs/upgrades/patches etc.) in a secure, accurate and timeous manner
  • Provide support and advice to development team for new and existing SQL code
  • Conduct daily routine tasks including Health Checks and assist with the automation of regular database support activities
  • Assist with providing an effective database security management support
  • Ensure that backups are done and restored when requested in a timeous manner
  • Assist with setting up new database environments, configuring in adherence with applications

Capacity Planning & Availability Measures

  • Assist with producing monthly reports

SQL Monitoring and Performance Optimization

  • Monitor SQL Server and ensure monitoring tools are in alignment with business KPA’s
  • Identify poor performing SQL code (stored procedures, function etc.)
  • Assist with code improvements on an ad hoc basis, problematic code will be investigated and improved
  • Follow deployment life cycle

Deployment planning, execution and roll back plan

  • Accurate and timeous implementation and communication of deployment schedule
  • Implement deploys and rollbacks, impact and interdependencies considered 

Business Continuity Planning

  • Assist with Disaster Recovery design, planning, setup and configuration; including database restores, mirroring, availability group configuration, application configuration, testing

Operational Incidents

  • Take care of existing operational incidents and tickets timeously and correctly
  • Provide an efficient 2nd line support and assist with database related queries
  • Assist with documenting all DB processes
  • Adhere to company policies and operating procedures
  • Adhere to Response and Resolution SLAs
  • Ensure that Incident management is adhered to in accordance with (ITIL)

Qualification:

  • Strongly recommended: MCSA: SQL Server and or MCSE: Data Platform
  • Recommended diploma or degree in IT, BSc IT from recognized SA Technikons or Universities

Experience:

  • 1 – 3 years MS SQL DBA experience
  • Experience as a Software Developer (advantageous)

Functional Competencies:

  • Knowledge of MS SQL Server 2008 R2, MS SQL Server 2012
  • System Administration (Windows), Systems Design
  • Proficient technical and SQL troubleshooting skills
  • Understanding of enterprise architecture
  • Knowledge of servers, networks, desktop technologies and server virtualisation
  • Change control processes and procedures

Behavioural Competencies:

  • Proactive
  • Teamwork
  • Information Gathering and Problem Analysis
  • Quality and Detail Orientation
  • Coping with Pressures and Setbacks

Get similar jobs like these by email

By submitting your details you agree to our T&C's