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