MID-TIER DATABASE ADMINISTRATORJOB PURPOSE STATEMENTThe Mid-Tier Database Administrator is responsible for the day-to-day administration, maintenance, optimisation, and support of the organisation's database systems. This role ensures database performance, security, and availability, while also contributing to database development projects and supporting application teams with database-related queries.Duties & Responsibilities1. Database Administration & MaintenanceInstall, configure, and maintain database management systems (primarily SQL Server, MySQL, PostgreSQL, or Oracle, depending on environment).Perform regular health checks, tuning, and optimisation for performance and reliability.Apply database patches and upgrades as required.Monitor database storage, growth, and capacity.2. Performance Monitoring & OptimisationIdentify slow-running queries and work with developers to optimise SQL code.Maintain and update indexes, statistics, and execution plans.Use monitoring tools to proactively address performance issues.3. Backup & RecoveryManage database backups, recovery plans, and high-availability configurations.Test and validate disaster recovery (DR) and business continuity plans.Ensure compliance with Recovery Time Objectives (RTOs) and Recovery Point Objectives (RPOs).4. Security & ComplianceImplement and maintain database security best practices, including access control, encryption, and auditing.Ensure compliance with data protection laws (e.g., POPIA, GDPR).Manage database user accounts, permissions, and roles.5. Development & SupportAssist in designing and implementing database solutions for new projects.Support application and development teams with database queries and schema changes.Develop scripts, stored procedures, and triggers where necessary.6. Incident & Problem ManagementTroubleshoot and resolve database-related incidents and service requests.Participate in after-hours support rotation for critical systems.Document troubleshooting steps, solutions, and lessons learned.7. Continuous ImprovementKeep up-to-date with emerging database technologies and best practices.Recommend and implement improvements to database architecture and processes.Mentor junior DBAs and contribute to internal knowledge sharing.Key Skills & CompetenciesTechnical Skills:
