SQL Database Administrator at Dark Fibre Africa

Roles and Responsibilities

• Install, configure, and upgrade SQL database management systems and implementation of best practices for database server setup and configuration
• Optimizing database performance by monitoring and fine-tuning SQL queries, indexing, and other database components to ensure efficient data retrieval
• Implementation and maintenance of database security measures, including user access controls, encryption, and auditing, to protect sensitive data
• Applying patches and updates to keep the database software current, reducing vulnerabilities and ensuring stability
• Maintaining comprehensive documentation of database configurations, processes, and procedures is crucial for future reference and compliance
• Establish and execute data backup and recovery procedures to ensure data integrity and availability, including disaster recovery plans.
• Collaborate with developers, system administrators, and other teams to meet database requirements and provide technical support.
• Maintain a knowledge repository of emerging technology and industry best practices trends, pursue relevant certifications, and expand technical capabilities to match evolving organisational needs.
• Monitoring of database growth trends and plan for scalability by assessing hardware requirements and making recommendations
• Assisting in data migration projects, ensuring data is moved accurately and efficiently between systems.

Qualification

• A Btech or bachelor's in a relevant field, such as Computer Science, Information Technology, or a related discipline.
• Demonstrates a foundational understanding of IT service management
• Cloud and/or on-premises certification in SQL Server administration

Experience:

• 5-7 years of Hands-on experience in designing, managing, and optimizing both relational and/or NoSQL databases. Experience in backup and recovery processes and disaster recovery planning.
• Skills in optimizing SQL queries and database performance by analyzing query execution plans, indexing strategies, and database configuration
• Demonstrate competency in SQL server auditing, access control, and role membership. Database encryption methods
• 5 -7 years of experience with SQL Server Reporting Services and SQL Server Analysis Services
• 3 years of experience in data virtualization tools like Tableau, Power BI, Business Objects
• Knowledge of ETL (Extract, Transform, Load) processes to integrate data from various sources into a centralized database system