Position : Database Administration (MSSQL Server & Mongo DB)Location : Gurgaon Shift : Rotational 24*7 Onsite/ Work From Office Database Administration (SQL Server & Mongo DB)• Install, configure, and manage Microsoft SQL Server and Mongo DB Standalone/clusters• Handle database provisioning, upgrades, patching, and migrations• Manage both on-premises and cloud environments (Azure SQL, Mongo DB Atlas)Performance Tuning & Optimization• Optimize SQL queries, indexing, stored procedures• Analyze Mongo DB performance using:o Query profilero Indexing strategieso Aggregation pipeline optimization• Troubleshoot:o Slow querieso High CPU/memory utilizationo Locking/blocking issues (SQL)o Replication lag (Mongo DB)High Availability & Disaster Recovery• SQL Server:o Always On Availability Groupso Failover Clusteringo Log Shipping / Replication• Mongo DB:o Replica Sets configurationo 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:o T-SQL, Power Shell (SQL Server)o Mongo DB Shell / Python / Bash• Automate routine DBA tasks, monitoring, alerts Security & Compliance• MSSQLo Roles, permissions, TDE encryption, auditing• Mongo DB:o Authentication (SCRAM, LDAP), RBAC, encryption• Ensure compliance with data security standards Monitoring & Maintenance• Monitor database performance using tools like:o SQL: SSMS, Extended Events, Redgate, SCOMo Mongo DB: Ops Manager, Atlas Monitoring• Schedule and manage:o Index maintenanceo DB health checkso Capacity planning Collaboration & Documentation• Work with application teams, Dev Ops, and infrastructure teams• Maintain runbooks, SOPs, and architecture document

📌 Database Administrator (Gurugram)
🏢 Atain
📍 Gurugram