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 MaxScale 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 MaxScale 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 MaxScale 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 MaxScale 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.