Position : L3 Database Administrator
Location : Hinjewadi Phase-1, Pune (WFO)
Experience : 7 + years
Shift : 12 : 00 PM to 9 : 00 PM(Rotational Shift)
Working Days : Monday to Friday
Notice Period : Immediate to 15 Days
ob Overview :
We are seeking an experienced L3 Database Administrator (DBA) with 7+ years of hands-on experience to join our dynamic team. The ideal candidate will have a deep technical understanding of MongoDB , MySQL , Percona-flavored MySQL , Percona XtraDB Cluster , and Percona Arbitrator . You will be responsible for managing, maintaining, optimizing, and troubleshooting complex database environments while ensuring the highest levels of availability, security, and performance. As a senior member of the team, you will be involved in architecting and implementing high-performance, scalable database solutions, and mentoring junior DBAs.
Key Responsibilities :
1. Database Architecture & Design :
- Design, implement, and maintain high-performance database architectures for MySQL, MongoDB, and Percona.
- Implement multi-region and multi-cloud architectures using Percona XtraDB Cluster and MongoDB sharded clusters.
- Collaborate with application teams to ensure optimal database models and data access patterns.
2. Database Management (MySQL, Percona-flavored MySQL) :
Manage MySQL and Percona-flavored MySQL instances, ensuring optimal configurations for high availability and performance.Design and implement MySQL replication strategies, including master-slave , master-master , and GTID-based replication for scalability and redundancy.Configure and optimize InnoDB settings and query execution plans for optimal performance.Implement backup and recovery strategies using Percona XtraBackup , ensuring point-in-time recovery and minimal downtime.3. Performance Tuning & Optimization :
Analyze and optimize complex queries and schemas for MySQL , Percona , and MongoDB to improve query performance, indexing strategies, and resource utilization.Utilize tools such as Percona Toolkit , EXPLAIN , and Mongotop to diagnose and resolve performance bottlenecks.Implement indexing , partitioning , sharding , and caching strategies to maximize the performance of high-traffic systems.4. High Availability & Cluster Management (Percona XtraDB Cluster & MongoDB) :
Manage and support Percona XtraDB Cluster for synchronous replication, ensuring high availability and zero downtime during maintenance.Implement automatic failover , node joining , and load balancing using tools like HAProxy or ProxySQL .Use Percona Arbitrator to prevent split-brain situations by providing quorum support and ensuring data consistency.Design, implement, and maintain MongoDB replica sets and sharded clusters , ensuring data availability and consistency.5. Security & Compliance :
Implement security best practices for MySQL , Percona , and MongoDB , including role-based access control (RBAC) , SSL encryption , and data encryption at rest and in transit .Set up audit logging and access control policies to comply with industry regulations (e.g., GDPR , HIPAA ).Regularly apply patches and security fixes to maintain system integrity.6. Backup, Recovery, and Disaster Recovery :
Implement highly-available backup solutions for MySQL and MongoDB databases using Percona XtraBackup and Mongodump / Mongorestore .Test and validate backup recovery procedures to ensure rapid restoration of databases.Design and manage disaster recovery (DR) plans and perform regular drills to ensure business continuity.7. Database Migration & Upgrades :
Plan and execute database migrations from on-premise to cloud environments (AWS, GCP, Azure).Oversee the migration of MySQL to Percona XtraDB Cluster , ensuring minimal downtime and data consistency.Coordinate schema upgrades and version upgrades across MySQL and MongoDB environments.8. Monitoring, Automation, and Incident Management :
Use monitoring tools like Percona Monitoring and Management (PMM) , MongoDB Atlas , and Nagios to monitor database performance, availability, and health.Automate database maintenance tasks (backups, health checks, etc.) using Python , Bash , or PowerShell .Respond to and resolve escalated incidents related to database performance, replication, and availability issues.9. Mentorship & Knowledge Sharing :
Mentor junior DBAs (L1 / L2) and provide guidance on best practices for database performance , tuning , and troubleshooting .Lead knowledge-sharing sessions on new technologies , cloud architectures , and database innovations .Review and improve database management policies, procedures, and documentation.Required Skills and Qualifications :
Technical Skills :
MongoDB :Expertise in MongoDB architecture, replica sets , sharding , and aggregation framework .Deep knowledge of backup strategies , security management , and performance optimization in MongoDB.MySQL and Percona MySQL :Advanced understanding of MySQL / Percona Server architecture, including query optimization , indexing , and InnoDB performance tuning .Proficient in MySQL replication (master-slave, master-master) and GTID-based replication .Experience using Percona XtraBackup for backup and recovery.Familiarity with Percona Toolkit for automating tasks like schema changes, query analysis, and performance diagnostics.Percona XtraDB Cluster :Extensive experience with Percona XtraDB Cluster for multi-master and synchronous replication .Expertise in managing Galera Cluster , handling write-set replication , and conflict resolution .Strong understanding of Percona Arbitrator for quorum management and split-brain prevention.Cloud and Virtualization :Experience with cloud-based databases and services (e.g., AWS RDS , Google Cloud SQL , Azure SQL Database , MongoDB Atlas ).Experience deploying and managing databases in cloud environments (AWS, GCP, Azure) using Kubernetes and Docker .Scripting & Automation :Strong knowledge of automation tools (e.g., Ansible , Chef , Puppet ) and scripting languages like Python , Bash , or PowerShell .Experience with CI / CD pipelines for automated database deployment and integration.Monitoring & Performance Tuning :Proficiency in using monitoring tools like Percona Monitoring and Management (PMM) , Mongotop , Nagios , and Datadog for real-time database health tracking.In-depth knowledge of query optimization , indexing strategies , query profiling, and database performance tuning .Soft Skills :
Excellent communication and problem-solving skills .Ability to work collaboratively in a team environment and under tight deadlines.Strong documentation and report-generation skills.Mentoring and leadership skills to guide junior team members.Ability to manage high-pressure incidents and provide rapid resolution .Education & Certifications :
Bachelor’s degree in Computer Science , Information Technology , or a related field (or equivalent work experience).Certifications (Preferred) :MongoDB Certified DBAOracle Certified Professional (OCP) for MySQLAWS Certified Database - SpecialtyMicrosoft Certified : Azure Database Administrator AssociatePercona Certified MySQL DBA or Percona XtraDB Cluster SpecialistIf you are interested share the updated resume on vaishnavin@futurismtechnologies.com or can connect on 8329413449