Senior Software Engineer

Location Name: Pune Corporate Office - Mantri

Job Purpose

The Database Administrator (DBA) will be responsible for designing, managing, and optimizing the organization's database infrastructure with a strong focus on MongoDB and SQL-based databases. This role ensures high availability, performance, security, and reliability of databases supporting critical business applications. The DBA will work closely with development, infrastructure, and product teams to ensure efficient data storage, retrieval, and integration across enterprise systems.

Duties And Responsibilities

• Database Administration & Architecture (MongoDB & SQL)
•  Design, implement, and maintain scalable database architectures using MongoDB and SQL databases (MySQL/SQL Server/PostgreSQL).
•  Install, configure, and manage database instances across development, staging, and production environments.
•  Design efficient database schemas, collections, and indexing strategies.
•  Monitor database performance and implement tuning strategies to optimize query execution and system performance.
•  Manage database upgrades, patches, and migrations while ensuring minimal downtime.
  
  

________________________________________

• Performance Optimization & Query Tuning
•  Analyze slow queries and optimize database performance through indexing, query restructuring, and configuration tuning.
•  Monitor database metrics such as CPU, memory usage, disk I/O, and query latency.
•  Implement index optimization, sharding strategies, and replication setups for MongoDB.
•  Optimize SQL queries, stored procedures, and database objects for performance and scalability.
  
  

________________________________________

• High Availability, Backup & Disaster Recovery
•  Configure and maintain MongoDB replica sets and sharded clusters to ensure high availability.
•  Implement database backup strategies, automated backups, and recovery mechanisms.
•  Conduct disaster recovery planning and perform periodic recovery testing.
•  Ensure data redundancy and failover mechanisms are in place.
  
  

________________________________________

• Security & Access Management
•  Implement database security best practices including authentication, encryption, and access control.
•  Manage role-based access control (RBAC) and user permissions.
•  Ensure compliance with organizational security standards and data governance policies.
•  Monitor database access logs and audit activities to detect anomalies.
  
  

________________________________________

• Monitoring & Maintenance
•  Implement monitoring tools to track database health, performance, and availability.
•  Set up alerts and automated monitoring dashboards.
•  Conduct periodic database maintenance activities such as index rebuilding, log cleanup, and storage optimization.
•  Troubleshoot database-related incidents and provide root cause analysis.
  
  

________________________________________

• Collaboration & Development Support
•  Work closely with application developers to design efficient data models and database queries.
•  Support development and QA teams with database scripts, test data generation, and troubleshooting.
•  Participate in Agile/Scrum ceremonies and provide database architecture guidance during feature development.
•  Assist in production deployments, schema changes, and database migrations.
  
  

Key Decisions / Dimensions

•  Approach for interfaces to send / receive data between multiple DBs / Applications
•  Preparing data structure
•  Creation of implementation plan and planning deployment
•  Development Planning and resource planning
  
  

Major Challenges

•  Keeping up to date with the latest technology
•  High volume transaction management and application support
•  Handling Production issues and responsible to communicate to business teams
•  Maintaining the system uptime to 100%
  
  

Required Qualifications And Experience

•  Qualifications
  
  

BE / B.Tech / M.Tech / PG in technology from a reputed institute with min. 6 years of experience

in tech solutions design development, implementation, Delivery management, TechOps and support

management

•  Work Experience
  
  

Minimum 3+ years of hands-on experience as a Database Administrator or Database Engineer working with MongoDB and SQL databases.

•  Mandatory Skills (tasks may differ basis the below mentioned skill sets)
  
  

Must Have


Experience and Essential Expertise:

•  3+ years of hands-on experience managing MongoDB and SQL databases in production environments.
•  Experience handling large-scale transactional databases and high-volume data systems.
•  Experience in database monitoring, troubleshooting, and performance tuning.
•  Experience working in Agile development environments.
•  Experience supporting application teams in database design and troubleshooting.
  
  

Core Database Skills

•  Strong hands-on experience with MongoDB (required).
•  Strong experience with SQL databases (MySQL / SQL Server / PostgreSQL).
•  Expertise in:
  
  

o Query optimization and performance tuning

o Indexing strategies

o Data modeling and schema design

o Stored procedures and triggers (SQL)

o Aggregation pipelines (MongoDB)

•  Experience with replication, sharding, and clustering in MongoDB.
  
  

________________________________________

Database Operations Skills

•  Backup and restore management.
•  High availability and disaster recovery planning.
•  Database monitoring and alerting tools.
•  Database migration and version management.
•  Capacity planning and performance monitoring.
  
  

________________________________________

Integration & Data Handling

•  Experience handling JSON data structures and document-based data models.
•  Familiarity with ETL processes and data migration strategies.
•  Experience integrating databases with APIs and backend services.
  
  

________________________________________

General Technical Skills