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
MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.