Database Administrator (MSSQL AND MONGODB)

Atain; Gurugram District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Atain is seeking a Database Administrator to manage MSSQL Server and MongoDB in Gurgaon. The role covers provisioning, upgrades, patching, migrations, and hybrid cloud/infrastructure across Azure SQL and Atlas.

You will optimize queries, ensure high availability, and drive DR drills while supporting 24x7 production systems. Responsibilities include incident management, automation of routine tasks with PowerShell/Python, and collaboration with DevOps and application teams.

Qualifications

• Experience managing MSSQL Server and MongoDB in production environments.
• Proven ability to provision, upgrade, patch, and migrate databases.
• Hands-on with on-premises and cloud setups (Azure SQL, Atlas).

Responsibilities

• Install, configure, and manage MSSQL Server and MongoDB standalone/clusters.
• Provide performance tuning for queries, indexing, and aggregations.
• Maintain high availability with Always On, replicas, and DR drills.
• Handle incident management for 24x7 production environments.

Skills

SQL Server

MongoDB

Performance tuning

HA & DR

Automation scripting

Security & compliance

Monitoring

Collaboration

Tools

SSMS

Extended Events

Redgate

SCOM

MongoDB Atlas Monitoring

PowerShell

Python

Bash

T-SQL

Job description

Position : Database Administration (MSSQL Server & MongoDB)

Location : Gurgaon

Shift : Rotational 24*7

Onsite/ Work From Office

Database Administration (SQL Server & MongoDB)

• Install, configure, and manage Microsoft SQL Server and MongoDB Standalone/clusters
• Handle database provisioning, upgrades, patching, and migrations
• Manage both on-premises and cloud environments (Azure SQL, MongoDB Atlas)

Performance Tuning & Optimization

• Optimize SQL queries, indexing, stored procedures
• Analyze MongoDB performance using:
  • Query profiler
  • Indexing strategies
  • Aggregation pipeline optimization
• Troubleshoot:
  • Slow queries
  • High CPU/memory utilization
  • Locking/blocking issues (SQL)
  • Replication lag (MongoDB)

High Availability & Disaster Recovery

• SQL Server:
  • Always On Availability Groups
  • Failover Clustering
  • Log Shipping / Replication
• MongoDB:
  • Replica Sets configuration
  • Sharded cluster management
• Manage backup & restore strategies for both platforms
• Conduct DR drills and failover testing
• Windows Server Cluster configuration/Installation

Incident Management (L2 / L3 Support)

• Handle production incidents, outages, and escalations
• Perform Root Cause Analysis (RCA) and implement preventive measures
• Provide support for 24x7 critical environments

Automation & Scripting

• Develop automation scripts using:
  • T-SQL, PowerShell (SQL Server)
  • MongoDB Shell / Python / Bash
• Automate routine DBA tasks, monitoring, alerts

Security & Compliance

• MSSQL:
  • Roles, permissions, TDE encryption, auditing
• MongoDB:
  • Authentication (SCRAM, LDAP), RBAC, encryption
• Ensure compliance with data security standards

Monitoring & Maintenance

• Monitor database performance using tools like:
  • SQL: SSMS, Extended Events, Redgate, SCOM
  • MongoDB: Ops Manager, Atlas Monitoring
• Schedule and manage:
  • Index maintenance
  • DB health checks
  • Capacity planning

Collaboration & Documentation

• Work with application teams, DevOps, and infrastructure teams
• Maintain runbooks, SOPs, and architecture documents
• Participate in change and release management processes