MYSQL Database Administration

Futurism Technologies, INC.; Pune District; Vor Ort; INR 1.500.000 - 1.900.000; Vollzeit

Zusammenfassung

Futurism Technologies, INC. is seeking an experienced Database Administrator (L2) to support and manage multiple databases across Development, QA, UAT, and Production environments. You will lead day-to-day DBA activities, design HA/DR solutions, and drive performance improvements.

The role requires hands-on experience with MySQL and related databases, backups, monitoring, and on-call support in a fast-paced setting. Remote work is not listed; office-based collaboration is expected.

Qualifikationen

• 5 to 10 years of experience in database administration with a focus on MySQL, MariaDB, PostgreSQL, MongoDB, and Oracle databases.
• Hands-on experience with database backups, performance tuning, query optimization, and troubleshooting.
• Knowledge of high availability (HA) setups for databases and systems.
• Good understanding of security best practices for database environments.
• Strong problem-solving and communication skills.
• Ability to work in a fast-paced, collaborative environment.

Aufgaben

• Working as a DBA Technical lead to deliver day to day DBA support activities.
• Architecting Infrastructure and databases as per application needs.
• Design MySQL HA and DR solutions.
• POCs on new MySQL products to understand their functionalities.
• Reviewing and selecting latest MySQL versions for new builds/upgrades.
• Work on new MySQL builds with monitoring and backup configurations.
• Work on MySQL version upgrade planning and execution without database downtime.
• Automating repeatable tasks to avoid manual work.
• Handling P1/P2 tickets whenever required.
• Troubleshoot performance issues.
• Work with vendor (Oracle) support to get patches for encountered issues.
• On-call DBA in 24x7 format.
• Design and implement AWS database solutions for MySQL.
• End-to-End Database Administration.
• Install, configure, and perform version upgrades of databases.
• Manage user accounts and permissions.
• Collaborate with senior teams on schema design and optimization.
• Set up and maintain environments across Dev, QA, UAT, Production.
• Performance Optimization: query tuning, indexing strategies.
• Resource usage analysis to identify bottlenecks.
• Conduct database structure and normalization reviews.
• Participate in proactive performance audits and implement recommendations.
• Monitoring & Alerting: real-time health, dashboards, alerts.
• Integrate database monitoring with Prometheus, Grafana, Nagios.
• Backup & Recovery: scheduled backups, point-in-time recovery, offsite storage, restore tests.
• High Availability & Failover: replication, Group Replication, InnoDB Cluster; MongoDB Replica Sets & Sharding; zero-downtime maintenance.
• Ongoing Maintenance & Support: 24x7 incident response, security updates, capacity planning, SOP documentation.
• Collaboration and Team Support: work with senior architects, troubleshoot incidents, disaster recovery drills.

Kenntnisse

MySQL

MariaDB

PostgreSQL

MongoDB

Oracle

Backup & Recovery

Performance Tuning

HA/DR

AWS DB

On-call Support

Ausbildung

Bachelor's degree in Computer Science/IT

Tools

PMM

MongoDB Ops Manager

Prometheus

Grafana

Nagios

Jobbeschreibung

Mode of Work :: Work from Office(Monday to Friday)

Job Summary:

We are looking for a skilled Database Administrator (L2) with 5 to 9 years of hands-on experience in supporting and managing databases such as MySQL, Secondary skill (MariaDB, PostgreSQL, MongoDB, and Oracle). The role involves database administration, performance optimization, backup, and recovery management, and ensuring high availability across various environments like Development, QA, UAT, and Production.

Key Responsibilities:

• Working as a DBA Technical lead to deliver day to day DBA support activities.
• Architecting Infrastructure and databases as per application needs.
• Design MySQL HA and DR solutions.
• Doing POCs on new MySQL products to understand their functionalities.
• Reviewing and selecting latest MySQL versions for new builds/upgrades.
• Work on new MySQL builds with monitoring and backup configurations.
• Work on MySQL version upgrade planning and execution without database downtime.
• Automating repeatable tasks to avoid manual work.
• Handling P1/P2 tickets whenever is required.
• Troubleshoot performance issues.
• Work with Vendor (Oracle) support to get the required patches to fix the bugs which are encountered in the environment.
• Working as an on call DBA in 24*7 format.
• Design and implement AWS database solutions for MySQL.
• End-to-End Database Administration
• Install, configure, and perform version upgrades of databases.
• Manage user accounts and permissions.
• Collaborate with senior teams on schema design and optimization.
• Set up and maintain environments across Dev, QA, UAT, and Production.
• Performance Optimization
• Assist in query tuning and create indexing strategies to improve database performance.
• Perform resource utilization analysis (CPU, memory, I/O) to identify and mitigate performance bottlenecks.
• Conduct database structure and normalization reviews to ensure optimal performance.
• Participate in proactive performance audits and implement recommendations.
• Monitoring & Alerting
• Monitor real-time database health and performance metrics.
• Set up custom dashboards and alert thresholds for critical databases.
• Monitor database replication and replication lag, escalating issues when necessary.
• Integrate database monitoring with enterprise tools like Prometheus, Grafana, and Nagios.
• Backup & Recovery
• Support scheduled database backups and configure point-in-time recovery.
• Manage offsite/cloud backup storage and ensure regular restore tests for disaster recovery readiness.
• Troubleshoot backup failures and recovery issues.
• High Availability (HA) & Failover Support
• Assist in configuring MySQL replication, Group Replication, or InnoDB Cluster.
• Support MongoDB Replica Sets and Sharding for high availability.
• Contribute to failover strategy planning and execution.
• Assist in performing zero-downtime maintenance for critical systems.
• Ongoing Maintenance & Support
• Provide 24x7 incident response and troubleshoot database-related issues in production environments.
• Apply regular patching and security updates to maintain database health.
• Assist in capacity planning and growth analysis to ensure systems can scale as required.
• Contribute to the documentation of processes, SOPs, and knowledge transfer sessions for team members.
• Collaboration and Team Support
• Work closely with senior database architects and other teams to ensure smooth system operations.
• Help troubleshoot incidents and provide support for application/database issues.
• Support the development and execution of disaster recovery drills.

Required Skills & Experience:

• 5 to 10 years of experience in database administration with a focus on MySQL, MariaDB, PostgreSQL, MongoDB, and Oracle databases.
• Hands-on experience with database backups, performance tuning, query optimization, and troubleshooting.
• Knowledge of high availability (HA) setups for databases and systems.
• Good understanding of security best practices for database environments.
• Strong problem-solving and communication skills.
• Ability to work in a fast-paced, collaborative environment.

Preferred Skills:

• Experience with database management tools (e.g., Percona Monitoring and Management (PMM)).
• Experience with MongoDB Ops Manager and database replication strategies.
• Certifications in database management or related technologies are a plus.

Educational Qualification:

• Bachelor's degree or equivalent in Computer Science, Information Technology, or a related field.