Job Description Position : Database Administration (MSSQL Server & MongoDB)
N Location: Gurgaon
N Shift: Rotational 24*7
N Onsite/ Work From Office
NDatabase Administration (SQL Server & MongoDB)
N - Install, configure, andmanage Microsoft SQL Server and MongoDB Standalone/clusters
N - Handle database provisioning, upgrades, patching, and migrations
N - Manage both on-premisesand cloud environments (Azure SQL, MongoDB Atlas)
N
NPerformance Tuning & Optimization
N - Optimize SQL queries, indexing, stored procedures
N - Analyze MongoDB performance using:
No Query profiler
no Indexing strategies
No Aggregation pipeline optimization
N - Troubleshoot:
No Slow queries
no High CPU/memory utilization
No Locking/blocking issues(SQL)
No Replication lag (MongoDB)
N
NHigh Availability & Disaster Recovery
N - SQL Server:
No Always On Availability Groups
No Failover Clustering
no Log Shipping / Replication
N - MongoDB:
No Replica Sets configuration
No Sharded cluster management
N - Manage backup & restorestrategies for both platforms




N - Conduct DR drills and failover testing
N - Windows Server Cluster configuration/Installation
N
NIncident Management (L2 /L3 Support)
N - Handle production incidents, outages, and escalations
N - Perform Root Cause Analysis (RCA) and implement preventive measures
N - Provide support for 24x7 critical environments
N
NAutomation & Scripting
N - Develop automation scripts using:
No T-SQL, PowerShell (SQL Server)
No MongoDB Shell / Python / Bash
N - Automate routine DBA tasks, monitoring, alerts
N
NSecurity & Compliance
n - MSSQL
No Roles, permissions, TDEencryption, auditing
N - MongoDB:
No Authentication (SCRAM, LDAP), RBAC, encryption
N - Ensure compliance with data security standards
N
NMonitoring & Maintenance
N - Monitor database performance using tools like:
No SQL: SSMS, Extended Events, Redgate, SCOM
No MongoDB: Ops Manager, Atlas Monitorin

📌 Database Administrator (India)
🏢 Atain
📍 India