SQL Database Administrator

**Listing reference**: track_001079

**Listing status**: Online

**Position summary**:
**Industry**:IT & Internet**Job category**:Database Administration**Location**:Randburg**Contract**:Permanent**Remuneration**:Market Related**EE position**:Yes**Introduction**:
**Job description**:
**KEY DUTIES AND RESPONSIBILITES**:
**Databases**
- o Owns, tracks and resolves database related incidents and requests.
- o Exemplify the desired culture and philosophies of the organization.
- o Fulfills requests and resolves incidents within SLAs.
- o Reviews service-related reports (database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLAs.
- o Responding to investigate database related alerts and escalations and working with others within the organization to come up with strategic solutions to recurring problems.

**Backups and Restores**
- o Regularly review and / or update backup and restore procedure and policy.
- o Maintain a record of system backup frequencies and backup times.
- o Perform regular tests of the ability to restore backed up data.
- o Collaborate with Team Leader: Hardware to ensure that backups conform to best practice retention cycles.

**Disaster Recovery**
- o Ensure All critical Business systems are replicated at DR.
- o Ensure All recovery systems are replicated at DR, including Infrastructure, DB replication and Software.
- o Manage Infrastructure DR Plan.
- o Manage DR Datacenter availability and stability.
- o Manage DR connectivity.
- o Manage DR capacity.
- Supporting one NoSQL technology as a DBA desired.
- ITIL Change Management, Problem Management, Incident Management etc. procedures using tools (Service Now, BMC Remedy).
- Migrating Relational / SQL environments to NoSQL environments
- Pro-actively evaluate evolving technologies and recommend solutions to business problems.
- Setting up, monitoring and troubleshooting popular Relational Databases.
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
- Master Performance Tuning, Query Optimization, leveraging appropriate monitoring and troubleshooting tools.
- Oracle performance monitoring tools and methods.
- Expertise with physical and logical schema design and troubleshoot common issues.
- Detect and troubleshoot potential database related issues and constraints (CPU, memory, I/O, disk space, etc.).
- Data loading into RDBMS from other non-RDBMS systems.
- Strong knowledge of backups, restores, recovery models, database shrink operations, Database commands, Clustering, Database mirroring, Replication.
- Index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
- Documentation skills for processes and procedures (creating Knowledge Transfer documents, run-books, topology etc.)
- Exemplify the desired culture and philosophies of the organization.
- Ability to be on call production support on a rotation basis.
- Leads / Participates in planning for system development and expansion.
- Leads / Participates in systems software and/or hardware projects.
- Manages projects of limited scope or portions of large and/or complex projects.
- Guides technical staff on a project basis.

**Minimum requirements**:

- A Bachelor's degree or Equivalent IT Qualification or Diploma
- A minimum of 3 years in similar position
- Mandatory: Microsoft Training and Certifications in Data Management
- ITIL
- CobIT