Database Administration

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.