Job Title: Database Administrator (L1)

Job Location: Hinjewadi Phase 1, Pune (WFO)

Experience: 2-4 Years

Shift: 24x7 Rotational Shift

Job Summary:

We are looking for a skilled Database Administrator (L1) with 2 to 4 years
of hands-on experience in supporting and managing databases such as MySQL,
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:

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 hi

📌 Database Administrator (India)
🏢 Praful M- IMS Support
📍 India