- RoleMYSQL DBA \- Amazon RDS
- Industry TypeIT Services / Software Company
- Functional AreaDBA
- Employment TypeFull time
- Role CategoryDBA
- EducationAny Graduate
- Experience2\+ years
- Job LocationBangalore
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