Database Administrator (MSSQL AND MONGODB)

Atain; Haryana; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Atain in Gurgaon is seeking a Database Administrator to manage SQL Server and MongoDB in a 24x7 on-site setting. You will handle provisioning, upgrades, migrations, and cloud/on-prem deployments with a focus on performance and reliability.

The role emphasizes tuning, incident resolution, DR readiness, and automation using T-SQL, PowerShell, Python, and Bash. Collaboration with DevOps and infrastructure teams is key.

Qualifications

• 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).

Responsibilities

• Install, configure, and manage databases for SQL Server and MongoDB.
• Performance tuning of queries, indexing, and procedures.
• Troubleshoot slow queries, high CPU/memory usage, locks, and replication lag.
• Maintain high availability, DR drills, and backups for both platforms.
• Automate routine tasks with T-SQL, PowerShell, Python or Bash.

Skills

MSSQL Server

MongoDB

Performance tuning

PowerShell

Python

Shell scripting

Replication/DR

Tools

SSMS

Extended Events

Redgate

SCOM

MongoDB Atlas

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