SQL Database Administrator

Full Time
- Johannesburg
- Posted 4 hours ago

Job Position: SQL Database Administrator

Ref: 4493

Location: Randburg (Johannesburg)

**Salary**: R45 000 to R60 200 per month commensurate with qualification and experience

Qualifications / Requirements:

- Bachelor’s Degree or equivalent IT Qualification or Diploma
- Minimum of 3 years in similar position
- Mandatory: Microsoft Training and Certifications in Data Management
- ITIL
- CobIT
- Willing to work extended hours
- Willing to travel

Key Performance Areas:

- Databases:

- Own, track and resolve database related incidents and requests
- Exemplify the desired culture and philosophies of the organization
- Fulfil requests and resolves incidents within SLA’s
- Review service-related reports (database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLA’s
- Respond to investigate database related alerts and escalations and work with others within the organization to come up with strategic solutions to recurring problems
- Backups and restores:

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

- Ensure all critical business systems are replicated at Disaster Recovery
- Ensure all recovery systems are replicated at Disaster Recovery, including Infrastructure, database replication and software
- Manage infrastructure Disaster Recovery plan
- Manage Disaster Recovery data centre availability and stability
- Manage Disaster Recovery connectivity and capacity
- Support one NoSQL technology as a DBA desired
- ITIL change management, problem management, incident management etc procedures using tools (Service Now, BMC Remedy)
- Migrate 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
- Manage projects of limited scope or portions of large and/or complex projects
- Guide technical staff on a project basis