Database Admin

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