Key Responsibilities :
- Requirements Gathering : Collaborate with business stakeholders to collect, document, and review database requirements.
- Database Design & Development : Architect, develop, and implement scalable, reliable databases that meet business demands.
- Database Programming : Write and optimize complex T-SQL queries to support operational requirements.
- Database Maintenance & Optimization : Ensure database performance, availability, and installation of database management systems (DBMS) tailored to business data needs.
- Database Security : Implement strict security policies and controls to safeguard data.
- Compliance & Regulations : Ensure databases adhere to policies, procedures, and standards like POPIA, while mitigating risks related to data loss or downtime.
- Capacity Planning : Anticipate growth and plan to ensure databases can scale to meet future demand.
- Backup & Recovery : Develop and execute backup and recovery strategies to ensure fast recovery in case of disruptions.
- Data Migration : Perform complex migrations, ensuring data integrity and accuracy across systems.
- Data Lake Administration : Manage the data lake platform to support data operations.
- Data Architecture Design : Contribute to the development of the overall data architecture.
- User Support : Provide technical assistance to users for database-related issues.
- Technical Writing : Create and maintain technical documentation, policies, and procedures.
- Data Governance : Implement data governance principles and ensure data integrity and security.
- Service Provider Management : Manage relationships with external service providers supporting data-related services.
- Project Management : Oversee database-related projects adhering to best project management practices.
- Risk Management : Identify risks and provide timely mitigations.
- Technical Leadership & Mentoring : Lead and mentor junior team members, ensuring efficiency and knowledge sharing.
- Cloud Database Administration : Administer cloud-based database systems, optimizing for performance and security.
Qualifications & Experience :
- National Diploma in ICT.
- MSSQL Database Administration Certification.
- 5+ years of experience in:
- Database design, development, and implementation of complex and scalable databases.
- Database programming using T-SQL.
- Database maintenance, performance optimization, and security in MSSQL.
- Backup and recovery planning.
- Capacity planning and user support.
- Data migration and technical writing.
- 3+ years of experience in ensuring compliance with data laws and regulations (e.g., POPIA).
- 2+ years of experience in:
- Data governance implementation.
- Requirements gathering and project management.
- Risk management and mentoring junior staff.
- Knowledge of data architecture design and managing service providers.
- Experience in cloud-based database administration and data lake platform administration is an advantage.
Why Join Us? Be at the forefront of securing and optimizing critical data infrastructure. This is a role of responsibility, trust, and the highest standards of security.