The Database administrator is responsible for the maintenance and support of all Maxicare Databases including troubleshooting of any issues that may arise. The post holder will work in an environment of continuous change while minimizing disruption to system users ensuring that all data is retrievable in an emergency.
Database Administration -Installation, configuration, maintenance, and administration of databases
Database Technologies - Strong knowledge of SQL Server, Oracle, MySQL, PostgreSQL, or other enterprise databases
SQL - Advanced SQL querying, stored procedures, functions, views, and optimization
Performance Tuning - Query optimization, indexing, execution plans, database performance monitoring and tuning
Backup & Recovery - Database backup, restore, recovery procedures, and disaster recovery
High Availability - Replication, clustering, Always On, Data Guard, RAC, or equivalent HA technologies
Database Security - User/access management, roles and privileges, encryption, auditing, and security hardening
Troubleshooting - Diagnosis and resolution of database errors, performance issues, connectivity problems, and incidents
Database Monitoring - Monitoring database health, capacity, availability, performance, and resource utilization
Data Integrity Ensuring database consistency, integrity, availability, and reliability
Change Management - Proper implementation and documentation of database changes following ITSM/change management processes
Automation & Scripting - PowerShell, Bash, Python, SQL scripting, and automation of routine DBA tasks
Cloud Database - Administration of AWS/Azure/OCI database services and cloud-based database environments
Disaster Recovery - Database DR planning, replication, failover/failback, and recovery testing
Capacity Planning - Database sizing, storage forecasting, growth monitoring, and resource planning
Documentation- Maintaining database architecture, procedures, configurations, recovery plans, and operational documentation
PH
