Job Summary
PURPOSE:
|
Responsible for performance, integrity, support, maintenance and security of MS SQL databases. The SQL Database Administrator is involved in the planning and development of a database, as well as in troubleshooting any issues on behalf of the users. |
FORMAL EDUCATION:
- Diploma / Bachelor’s degree in Computer Science, Information Systems, Business Management, Electrical Engineering, Electronics Engineering, or related discipline from an accredited tertiary institution.
- MS SQL Certification in database administration will be advantageous and a definite plus Grade 12 (NQF4)
- Tertiary Qualification in Information Technology (NQF6) or relavent experience / techcical certification
|
_____________________________________________________________________________________________
EXPERIENCE:
- 6+ years of experience developing data management systems, tools and architectures using MS SQL tools.
- Experience designing and operating very large Data Warehouses and web facing online transaction processing databases.
- Demonstrable proficiency and experience in MS SQL Server, DB2, Linux, and programming languages such as R, Python, Ruby or Java.
TECHNICAL / LEGAL CERTIFICATION
- MCITP Enterprise Administrator/MCDBA
- ITIL v3 Foundation Certification
- OEM certification/relevant database solutions certification
- Certification in specialised track based on area/environment
|
RESPONSIBILITIES:
- Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
- Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
- Troubleshoot SQL Database Server service outages as they occur, including after-hours and weekends.
- Configure SQL Database Server monitoring utilities to minimize false alarms.
- As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, or other appropriate technologies.
- Upgrading the SQL database software as and when required.
- Deploy database change scripts provided by third party vendors.
- When performance issues arise, determine the most effective way to increase performance including tuning, hardware purchases, server configuration changes, or index/query changes.
- Document the Department’s database environment.
- Failover clustering, SAN replication, and other high availability technologies.
- Root Cause Analysis of production-related database issues.
- Daily maintenance, monitoring, problem resolution and internal customer/development support.
- Review, design and develop data models in conjunction with the application development teams.
- The role might require traveling nationally and work after hours as and when required.
Skills and Competencies
- Demonstrated experience with database technologies and API interfaces to WebApps and Administration in one or more of the following – MS SQL, PL/SQL, MySQL, or NoSQL (minimum of 3 years).
- Experience in Unix AIX, Linux and MS Windows operating systems will be advantageous.
- A results-oriented individual who thrives working in a fast paced environment and under pressure.
- Strong written and oral communication skills.
- Strong organizational and project management skills with effective results focus within an information systems environment.
- Strong analytical and problem-solving skills.
- Self-motivated with the ability to manage changing priorities and meet deadlines.
- Proven ability to be flexible and work hard, both independently and in a team environment, in a high priority customer service, on-call environment with changing priorities.
- Willingness to work occasionally outside of normal business hours in response to needs of the systems being supported.
|
| |
Learning and Growth Perspective
|
|
|
Talent database |
- Ensure CV updated and remains current on talent management system
|
|
Execute personal development plan (PDP) |
- Participate in activities as described in personal development plan
- Keeping aware of changing business needs
|
| |
|
Knowledge sharing |
- Participate in opportunities for knowledge sharing within the team and relevant communities of practice (COP's)
- Staying abreast with most current technical and methodological changes and advances
|
| |
|
Maintain accreditation status |
- Relevant training programme attended
|
