Implement new Databases in line with design, including installation of DBMS! Design supporting processes to ensure a functioning database (e.g., user access, performance monitoring, backup, replication, patching). Troubleshoot incidents and events up to second level.
Role Purpose:

  • Implement new Databases in line with design, including installation of DBMS!
  • Design supporting processes to ensure a functioning database (e.g., user access, performance monitoring, backup, replication, patching)
  • Troubleshoot incidents and events up to second level.
  • Escalate performance, security, or availability issues.
  • Engage database vendor on troubleshooting urgent or complex incidents or events and troubleshoot.
  • Define, create, and maintain Client application database structures.
  • Ensure data recoverability, database availability, data integrity, agreed level of performance and capacity planning for physical databases.
  • Research on emerging trends, functionality and architecture related to the DBMS.
  • Ensure maintenance plans and documentation are in place, re-visited and updated at least once quarterly or after changes impacting the application area.
  • Process enhancements and improvements in supporting the database.
  • Plan for implementation of DBMS upgrades
  • Assist in / Develop Roadmap of DBMS future enhancements.
  • Provide feedback to clients on improvements in database design / use / work practices.
  • Reference best practices of DBMS reference documentation
  • Create database scripts to assist in the operation of the database.
  • Troubleshoot Security administration components including LDAP and Kerberos
  • User and security administration on the DBMS
    • Create and change users, assign, and remove role assignments, perform password resets, lock, and unlock accounts.
    • Create and change security roles by adding and removing relevant permissions.
    • Create, change, and troubleshoot analytical privileges (data dependent authorizations)
    • Troubleshoot security issues.
    • Log reviews and ongoing reviews of user privileges to databases

  • Design and execute process required to promote code and structures between databases in line with SLDC and company policies.
    • Create design and execute instructions for refresh of data in Dev and QA databases.

  • Design, and set up of monitoring tools of the DBMS.
  • Support application development teams in choosing and configuring databases correctly in support of application performance and security.

Qualification

  • Matric
  • BSc Computer Science/Information Systems Diploma or relevant DBA Certifications

Experience

  • 8-10 years’ experience in a similar role

Knowledge and Skills

  • DBMS Knowledge
  • MS SQL
    • Working knowledge of SQL Server, Sound working knowledge of the operating system SQL reside on and SQL’s usage of underlying infrastructure.
    • Knowledge of general database concepts
    • Understanding up to SQL Server 2019
    • Working knowledge and understanding of SQL2012 to 2019
    • Working knowledge and sound understanding of all available products, services, and resources in the SQL Server suite of products
    • Knowledge to advise and execute on integration to the MS SQL environment including REST, SOAP, ODBC, JDBC, ODBO and other MSSQL supported connectors.
    • Working Knowledge of SQL Server Always on Availability Groups
    • Working Knowledge of Database Mirroring

  • IT Data Analysis
  • Database Knowledge
  • Database Security
  • Project Coordination
  • Risk Management

Personal Attributes

  • Organizational savvy – Contributing through others.
  • Managing complexity – Contributing through others.
  • Plans and aligns – Contribution through others.
  • Optimizes work processes – Contributing through others.

Competencies

  • Being Resilient
  • Collaborates
  • Cultivates Innovation
  • Customer Focus
  • Drives Results

Desired Skills:

  • MS SQL
  • Senior SQL Database Administrator
  • IT Data Analysis
  • DBMS

Learn more/Apply for this position