Database Administration

ATAIN; Gurugram District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

ATAIN is seeking a skilled Database Administrator to oversee SQL Server and MongoDB administration in Gurugram. Key responsibilities include installation, configuration, performance tuning, and incident management for critical environments.

Ideal candidates will have expertise in automation scripting, security compliance, and collaboration with application teams. A commitment to non-discriminatory employment practices is essential.

Qualifications

• Proficient in managing Microsoft SQL Server and MongoDB.
• Strong skills in tuning SQL queries and troubleshooting issues.
• Experience in high availability and disaster recovery setups.

Responsibilities

• Install and configure SQL Server and MongoDB environments.
• Conduct performance tuning and optimization for databases.
• Manage security configurations and compliance audits.

Skills

SQL Server management

MongoDB management

Performance tuning

Incident management

Automation scripting

Data security compliance

Tools

T-SQL

PowerShell

MongoDB Shell

Python

Bash

SQL Server Management Studio (SSMS)

Ops Manager

Job description

Role: Database Administrator

Location: Gurugram

Mode: Work from office

JD:

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

• SQL Server:
  • 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

It is our policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these grounds.