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:
- 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)
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
