Talent.com
This job offer is not available in your country.
Senior Database Administrator

Senior Database Administrator

Futurism Technologies, INC.Pune, Maharashtra, India
15 days ago
Job description

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 vaishnavin@futurismtechnologies.com or can connect on 8329413449

    Create a job alert for this search

    Database Administrator • Pune, Maharashtra, India