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 workplace free from intimidation, harassment or bias based upon these grounds.

📌 Database Administration (Gurugram)
🏢 Atain
📍 Gurugram