Position overview
- The main purpose of the role is to support, maintain and troubleshoot SQL, develop SQL reports and support all integrated applications.
Key Responsibilities:
- Database Management and Maintenance. Responsibilities include but are not limited to.
- Manage, maintain, and administer SQL databases to ensure high performance, availability, and security.
Backup and Recovery: Responsibilities include but are not limited to.
- Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
- Test backups to ensure the business can meet Recovery Time Objectives (RTO).
Troubleshooting and outage Management: Responsibilities include but are not limited to.
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
Performance Tuning and Optimization: Responsibilities include but are not limited to.
- Monitor and optimize database performance.
- When performance issues arise, determine the most effective way to increase performance, including hardware purchases, server configuration changes, or index/query changes.
Security Management: Responsibilities include but are not limited to.
- Ensure database security by managing access controls, encryption, and monitoring for unauthorized activities.
Database Design and Architecture: Responsibilities include but are not limited to.
- Design and implement database structures to support application development and ensure data consistency and integrity.
Disaster Recovery: Responsibilities include but are not limited to.
- Develop and test disaster recovery plans to minimize data loss and downtime in case of a major incident.
Instillation and Configuring: Responsibilities include but are not limited to.
- Install and configure SQL Servers, including deploying database change scripts provided by third-party vendors.
Monitoring and Reporting: Responsibilities include but are not limited to.
- Configure SQL Server and Monitoring Server Application utilities to minimize false alarms.
- Continuously monitor database health, performance, and usage, providing regular reports to stakeholders.
Technology Knowledge and Integration: Responsibilities include but are not limited to.
- Maintain knowledge of Analysis Services, Integration Services, and Reporting Services.
- Document the company’s database environment in the company’s EDMS system.
- Configure, test, and manage changes in integrated systems.
Occupational Health and Safety: Responsibilities include but are not limited to.
- Responsible for compliance with the department.
Education and Experience
- Matric or NQF equivalent.
- Bachelor’s degree in computer science, Information Technology, Software Engineering, or a related field.
- Minimum 2 years prior experience in a similar role.
- Basic SQL query writing and database management experience.
- Exposure to relational database management systems.
Technical experience in:
SQL query writing and optimization.
- Stored procedures, functions, triggers, and indexing.
- Database Administration Tools.
- Performance tuning and optimization.
- Backup and recovery processes.
- Security and compliance procedures.
Skills and Competencies
- Strong attention to detail and excellent observation skills.
- Good problem-solving and analytical skills.
- Strong administration skills.
- Good communication skills for interacting with team members, law enforcement, and other stakeholders.
- Enjoy working in a team but also can work independently.
- Be patient, tactful, diplomatic, and approachable.
- Demonstration of customer service orientation.
Gmail
Yahoomail