Database Service Manger at Shoprite Group of Companies

Purpose of the Job    

The purpose of the Database Services Manager is to oversee and manage all aspects of the organization's database systems, encompassing both SQL and NoSQL technologies. This role involves managing a team responsible for designing, implementing, and maintaining efficient and secure database environments to support the organization's business operations. The Database Services Manager collaborates with other IT professionals, department heads, and stakeholders to ensure that database systems meet the organization's needs and adhere to best practices.

Job Objectives    

Database Design, Implementation and Administration:

• Oversee the design, planning, and implementation of robust and scalable architectures for both
• SQL and NoSQL databases.
• Ensure proper database normalization, indexing, and optimization to enhance system
• performance for various data models.
• Oversee day-to-day administration tasks for both SQL and NoSQL databases, including backup
• and recovery, performance monitoring, and troubleshooting.
• Implement and enforce security policies and access controls for both SQL and NoSQL
• databases.
• Database Performance Optimization and Capacity Planning:
• Monitor and analyse performance metrics for SQL and NoSQL databases, identifying areas for
• improvement.
• Implement performance tuning strategies to optimize query performance and overall system
• responsiveness for diverse data structures.
• Conduct capacity planning assessments for both SQL and NoSQL databases to anticipate future
• growth and resource requirements.
• Propose and implement scalable solutions to accommodate growing data needs for various
• data models.

Data Integrity, Compliance and Documentation:

• Ensure the integrity and accuracy of data within both SQL and NoSQL databases.
• Collaborate with compliance and regulatory teams to ensure adherence to industry and legal
• standards across different database technologies.
• Maintain comprehensive documentation of configurations, processes, and procedures for both
• SQL and NoSQL databases.
• Develop and update disaster recovery plans considering the specific characteristics of each
• database technology.

People Management:

• Manage a team of Database Administrators and Specialists proficient in both SQL and NoSQL
• technologies, providing leadership, mentorship, and professional development opportunities
• to the team members.
• Identify training needs for the database services team in both SQL and NoSQL technologies.
• Facilitate relevant training programs to keep team members updated on industry best practices
• and emerging technologies.

Vendor Management:

• Collaborate with database vendors for SQL and NoSQL technologies to stay informed about
• updates, patches, and new features.
• Manage vendor relationships and contracts to ensure cost-effective solutions and timely
• support across different database platforms.

Collaboration and Communication:

• Collaborate with IT teams, software developers, and business stakeholders to understand and
• address database-related requirements for both SQL and NoSQL databases.
• Communicate effectively with non-technical stakeholders to explain database-related concepts
• and decisions, considering the nuances of different database technologies.

Qualifications    

• Bachelor's degree in computer science, information technology, or a related field – (essential)
• Relevant SQL or NoSQL database certification – (essential)

Experience    

• +5 years of experience in database administration, with a proven track record driving the delivery
• and execution of database services across of complex and large SQL and NoSQL infrastructure
• environments – (essential)

Experience with cloud-based database solutions - (essential)

Knowledge and Skills    

• Relevant SQL or NoSQL database certification – (essential)
• Proficiency in SQL and NoSQL database management systems, such as Oracle, Microsoft SQL Server,
• MySQL, PostgreSQL, MongoDB, Cassandra, etc. – (essential)
• Knowledge of data security and compliance standards – (essential)