Intermediate SQL Administrator

Intermediate SQL Administrator

ROLE AND RESPONSIBILITIES

• Database Administration and Maintenance:
  Overseeing the installation, configuration, and ongoing maintenance of SQL Server instances, including patching, updates, and regular health checks.

• Performance Tuning and Optimization:
  Monitoring database performance, identifying bottlenecks, and implementing solutions such as index optimization, query tuning, and capacity planning to ensure efficient data flow and application responsiveness.

• High Availability and Disaster Recovery:
  Designing, implementing, and managing high availability solutions (e.g., AlwaysOn Availability Groups, replication, log shipping) and disaster recovery strategies, including regular backups, restores, and recovery plan testing.

• Security and Compliance:
  Enforcing database security policies, managing user access and permissions, and ensuring compliance with relevant data security standards and regulations.

• Collaboration and Support:
  Working closely with development teams, infrastructure teams, and other IT professionals to support application development, data integration, and system upgrades.

• Troubleshooting and Issue Resolution:
  Proactively identifying and resolving database-related incidents and performance issues, often within defined service level agreements (SLAs).

• Mentorship and Guidance:
  Providing technical guidance and mentorship to junior DBAs and other team members.

• Strategic Planning:
  Contributing to the development of database architecture strategies and aligning database management practices with overall business objectives and technology roadmaps.

COMPETENCIES

• Strong problem-solving and analytical skills

• Excellent communication and collaboration abilities

• High attention to detail and a proactive mindset

• Ability to work under pressure and manage multiple tasks simultaneously

• Solid understanding of database structures, theories, principles, and practices

MINIMUM REQUIREMENTS

• Grade 12 / Matric

• BSc Computer Science or similar qualification (advantageous)

• Proven experience in SQL code creation

• Demonstrated process analysis experience

• Solid systems understanding and test experience