ABOUT NEXTWEBI
Nextwebi is an AI-enabled digital transformation company delivering enterprise-grade web applications, SaaS platforms, cloud solutions, and custom software development services to clients across multiple countries. We are looking for a skilled Database Administrator with strong expertise in MySQL and AWS RDS to manage mission-critical production databases.
JOB OVERVIEW
We are seeking an experienced Database Administrator (MySQL & AWS RDS) who can manage, optimize, secure, and scale production database environments. The ideal candidate should have hands-on experience in MySQL performance tuning, replication, backups, disaster recovery, AWS RDS, Aurora, and high-availability architectures.
KEY RESPONSIBILITIES
• Install, configure, and maintain MySQL databases (5.7 / 8.0 / 8.4) in Linux production environments.
• Administer Amazon RDS MySQL and Aurora (Multi-AZ, Read Replicas, Snapshots) on AWS.
• Monitor and optimize database performance using slow query logs, EXPLAIN plans, index tuning, and Percona Toolkit.
• Perform InnoDB engine tuning: buffer pool sizing, redo log configuration, thread concurrency, and I/O optimization.
• Design and implement backup and disaster recovery strategies using XtraBackup (physical), mysqldump (logical), and Point-in-Time Recovery (PITR).
• Configure and manage MySQL replication environments:
◦ GTID-based Replication
◦ Semi-Synchronous and Asynchronous Replication
◦ Group Replication / InnoDB Cluster
◦ Read Replicas and Failover Management
• Troubleshoot database issues including deadlocks, lock contention, replication lag, and slow queries.
• Implement high-availability and failover solutions using ProxySQL, MySQL Router, or MHA.
• Perform database upgrades, schema migrations, version updates, and capacity planning.
• Enforce database security best practices: RBAC, SSL/TLS encryption, MySQL Audit Plugin, and access control reviews.
• Monitor database health using PMM (Percona), Prometheus, Grafana, and AWS CloudWatch.
• Collaborate with application developers to optimize database design, schema, and queries for SaaS and enterprise applications.
• Create and maintain technical documentation, runbooks, and Root Cause Analysis (RCA) reports.
• Ensure maximum uptime and reliability for business-critical applications (target: 99.9%+).
• Automate routine DBA tasks using Shell scripting, Ansible, or Chef.
REQUIRED SKILLS
MySQL & Database Technologies
• MySQL 5.7 / 8.0 / 8.4 – Installation, configuration, administration
• InnoDB engine internals: buffer pool, redo logs, tablespace, locking mechanism
• Slow query log analysis, EXPLAIN / EXPLAIN ANALYZE, query profiling
• Index design: B-Tree, composite, covering, partial, and functional indexes
• Table partitioning (RANGE, LIST, HASH, KEY) and archiving strategies
• Amazon RDS MySQL and Amazon Aurora (Multi-AZ, Serverless)
• MariaDB (Good to Have)
High Availability & Replication
• GTID-based Replication setup and troubleshooting
• Semi-Synchronous and Asynchronous Replication
• Group Replication / InnoDB Cluster
• ProxySQL, MySQL Router for load balancing and failover
• MHA (Master High Availability Manager)
• Galera Cluster / Percona XtraDB Cluster (Nice to Have)
Backup & Recovery
• Physical backups using Percona XtraBackup
• Logical backups using mysqldump and mysqlpump
• Point-in-Time Recovery (PITR) using binary logs
• Backup validation, restore drills, and RTO/RPO planning
Performance & Optimization
• Query optimization using EXPLAIN, Percona Toolkit (pt-query-digest, pt-online-schema-change)
• InnoDB buffer pool tuning, innodb_io_capacity, thread pool configuration
• Connection pooling with ProxySQL or MySQL Router
• Capacity planning, table statistics, and histogram analysis
Monitoring & Security
• PMM (Percona Monitoring and Management), Prometheus, Grafana
• AWS CloudWatch metrics, alarms, and log insights
• RBAC, user privilege management, SSL/TLS configuration
• MySQL Enterprise Audit Plugin / MariaDB Audit Plugin
Cloud & Automation
• AWS (Mandatory): RDS, Aurora, EC2, S3, CloudWatch, IAM
• Azure or GCP exposure (Added Advantage)
• Shell scripting, Ansible, or Chef for automation
• Linux administration (RHEL, CentOS, Ubuntu)
PREFERRED QUALIFICATIONS
• Bachelor's Degree in Computer Science, Information Technology, or related field.
• AWS Certifications (e.g. AWS Certified Database Specialty) are a plus.
• Oracle Certified MySQL 8.0 Professional is highly desirable.
• Experience managing high-traffic production environments.
• Experience supporting SaaS platforms or enterprise applications.
• Strong troubleshooting and analytical skills.
NICE TO HAVE
• MaxScale or Galera Cluster administration
• Percona XtraDB Cluster (PXC) setup and management
• DevOps exposure: Docker, Kubernetes
• Infrastructure automation with Terraform or CloudFormation
WHAT YOU'LL WORK ON
• Large-scale web applications and SaaS products
• Enterprise ERP / CRM systems
• AI-powered business applications
• High-availability cloud infrastructure
• Multi-tenant production environments
WHY JOIN NEXTWEBI?
• Work on global projects with international clients
• Exposure to enterprise-scale cloud and AI technologies
• Collaborative, growth-oriented environment
• Opportunity to work directly with architects and leadership
