Assistant Manager - IT Operations & Infrastructure

Minimum qualification & experience

• Bachelor's Degree in engineering or equivalent qualification
• 4-7 years in IT operations
• Work from site
• Job Location : Pune-Dighi

Key Responsibilities

Role of a MySQL/MSSQL Database Administrator (DBA) with proficiency in Linux and MongoDB.
MYSQL Administrator Responsibilities
Database Design and Modeling:
Design, implement, and maintain database schemas.
Optimize database structures for performance and scalability

Performance Tuning and Optimization:
Identify and resolve performance bottlenecks.
Tune queries and database configurations for optimal performance.

High Availability and Replication:
Implement and manage high availability solutions such as replication and clustering.
Ensure data consistency across replicas.

Backup and Recovery:
Develop and maintain robust backup and recovery strategies.
Perform regular backup testing and validation.

Security and Access Control:
Implement security best practices for MySQL databases.
Manage user access and permissions.

Upgrades and Patching:
Plan and execute database upgrades.
Apply patches and updates to ensure security and stability

MongoDB Administration Responsibilities:
Data Modeling:
Design and implement MongoDB schemas.
Ensure efficient data storage and retrieval.

Sharding:
Implement and manage sharding to distribute data across multiple nodes.
Scale MongoDB clusters horizontally.

Indexing and Query Optimization:
Create and manage indexes for efficient query performance.
Optimize queries and aggregations