Administrator (Support & Operations)
India
Apply now
Job Description
Administrator (Support & Operations)
Madurai, Tamil Nadu

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.
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.