SQL Database Administrator - Randburg at Tracker Connect (Pty) Ltd

Job description
KEY DUTIES AND RESPONSIBILITES:
Databases

•  Responsible for providing operational application database services to the organization.
•  Responsible for designing and optimizing methods to store, analyze, utilize, and organize data associated with the applications portfolio.
•  Owns, tracks and resolves database related incidents and requests.
•  Exemplify the desired culture and philosophies of the organization.
•  Fulfills requests and resolves incidents within SLAs.
•  Reviews service-related reports (database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLAs.
•  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

•  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 DR.
•  Ensure All recovery systems are replicated at DR, including Infrastructure, DB replication and Software.
•  Manage Infrastructure DR Plan.
•  Manage DR Datacenter availability and stability.
•  Manage DR connectivity.
•  Manage DR capacity.
•  Support application teams as a database administrator running RDBMS technologies multi-node instance(s)
•  ITIL Change Management, Problem Management, Incident Management etc. procedures using tools (Service Now, BMC Remedy).
•  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.
•  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.
•  RDBMS patching, upgrading, applying CPUs, resolving patching conflicts etc.
•  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.
•  Responsible for staff training of new applications and features.
•  Responsible for maintaining availability, security, and data integrity of applications.

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