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