Job Title

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 DBA Oracle Certified Professional (OCP) for MySQL AWS Certified Database - Specialty Microsoft Certified: Azure Database Administrator Associate Percona Certified MySQL DBA or Percona XtraDB Cluster Specialist If you are interested share the updated resume on or can connect on 8329413449