Administrator (Support & Operations)

Job Summary

L2 MariaDB Admin Responsibilities\\r\\n1. Installation & Configuration: Deploying MariaDB on various Linux distributions and optimizing the my.cnf configuration for specific workloads.\\r\\n2. Cluster Management: Configuring and managing high-availability clusters, specifically MariaDB Galera Cluster and Max Scale for load balancing.\\r\\n3. Performance Tuning: Identifying slow queries using the Slow Query Log and analyzing engine-level metrics (InnoDB buffer pool, thread cache) to improve throughput.\\r\\n4. Backup & Recovery: Implementing robust backup strategies using MariaDB Backup (Mariabackup) or mysqldump and performing regular restoration drills.\\r\\n5. Security Hardening: Applying security patches, managing User Privileges/RBAC, and implementing Data-at-Rest and Data-in-Transit encryption.\\r\\n6. Replication Setup: Configuring and troubleshooting various replication topologies, including Master-Slave (Asynchronous) and Multi-Source replication.\\r\\n7. System Monitoring: Setting up and responding to alerts from monitoring tools like Prometheus/Grafana, Zabbix, or MariaDB SkySQL monitoring.\\r\\n8. Storage Engine Management: Managing different storage engines (primarily InnoDB and Aria) and performing table maintenance like defragmentation (OPTIMIZE TABLE).\\r\\n9. Automation: Writing Bash or Python scripts to automate routine tasks such as log rotation, health checks, and user auditing.\\r\\n10. Troubleshooting & RCA: Performing Root Cause Analysis (RCA) for database crashes, connection spikes, and deadlocks to prevent recurrence.

Key Responsibilities

L2 MariaDB Admin Responsibilities 1. Installation & Configuration: Deploying MariaDB on various Linux distributions and optimizing the my.cnf configuration for specific workloads. 2. Cluster Management: Configuring and managing high-availability clusters, specifically MariaDB Galera Cluster and Max Scale for load balancing. 3. Performance Tuning: Identifying slow queries using the Slow Query Log and analyzing engine-level metrics (InnoDB buffer pool, thread cache) to improve throughput. 4. Backup & Recovery: Implementing robust backup strategies using MariaDB Backup (Mariabackup) or mysqldump and performing regular restoration drills. 5. Security Hardening: Applying security patches, managing User Privileges/RBAC, and implementing Data-at-Rest and Data-in-Transit encryption. 6. Replication Setup: Configuring and troubleshooting various replication topologies, including Master-Slave (Asynchronous) and Multi-Source replication. 7. System Monitoring: Setting up and responding to alerts from monitoring tools like Prometheus/Grafana, Zabbix, or MariaDB SkySQL monitoring. 8. Storage Engine Management: Managing different storage engines (primarily InnoDB and Aria) and performing table maintenance like defragmentation (OPTIMIZE TABLE). 9. Automation: Writing Bash or Python scripts to automate routine tasks such as log rotation, health checks, and user auditing. 10. Troubleshooting & RCA: Performing Root Cause Analysis (RCA) for database crashes, connection spikes, and deadlocks to prevent recurrence.

Skill Requirements

L2 MariaDB Admin Responsibilities 1. Installation & Configuration: Deploying MariaDB on various Linux distributions and optimizing the my.cnf configuration for specific workloads. 2. Cluster Management: Configuring and managing high-availability clusters, specifically MariaDB Galera Cluster and Max Scale for load balancing. 3. Performance Tuning: Identifying slow queries using the Slow Query Log and analyzing engine-level metrics (InnoDB buffer pool, thread cache) to improve throughput. 4. Backup & Recovery: Implementing robust backup strategies using MariaDB Backup (Mariabackup) or mysqldump and performing regular restoration drills. 5. Security Hardening: Applying security patches, managing User Privileges/RBAC, and implementing Data-at-Rest and Data-in-Transit encryption. 6. Replication Setup: Configuring and troubleshooting various replication topologies, including Master-Slave (Asynchronous) and Multi-Source replication. 7. System Monitoring: Setting up and responding to alerts from monitoring tools like Prometheus/Grafana, Zabbix, or MariaDB SkySQL monitoring. 8. Storage Engine Management: Managing different storage engines (primarily InnoDB and Aria) and performing table maintenance like defragmentation (OPTIMIZE TABLE). 9. Automation: Writing Bash or Python scripts to automate routine tasks such as log rotation, health checks, and user auditing. 10. Troubleshooting & RCA: Performing Root Cause Analysis (RCA) for database crashes, connection spikes, and deadlocks to prevent recurrence.

Other Requirements

L2 MariaDB Admin Responsibilities 1. Installation & Configuration: Deploying MariaDB on various Linux distributions and optimizing the my.cnf configuration for specific workloads. 2. Cluster Management: Configuring and managing high-availability clusters, specifically MariaDB Galera Cluster and Max Scale for load balancing. 3. Performance Tuning: Identifying slow queries using the Slow Query Log and analyzing engine-level metrics (InnoDB buffer pool, thread cache) to improve throughput. 4. Backup & Recovery: Implementing robust backup strategies using MariaDB Backup (Mariabackup) or mysqldump and performing regular restoration drills. 5. Security Hardening: Applying security patches, managing User Privileges/RBAC, and implementing Data-at-Rest and Data-in-Transit encryption. 6. Replication Setup: Configuring and troubleshooting various replication topologies, including Master-Slave (Asynchronous) and Multi-Source replication. 7. System Monitoring: Setting up and responding to alerts from monitoring tools like Prometheus/Grafana, Zabbix, or MariaDB SkySQL monitoring. 8. Storage Engine Management: Managing different storage engines (primarily InnoDB and Aria) and performing table maintenance like defragmentation (OPTIMIZE TABLE). 9. Automation: Writing Bash or Python scripts to automate routine tasks such as log rotation, health checks, and user auditing. 10. Troubleshooting & RCA: Performing Root Cause Analysis (RCA) for database crashes, connection spikes, and deadlocks to prevent recurrence.