Microsoft SQL Server Database Administrator (DBA) - WFH Delhi

Capital Placement Services Gurgaon; Delhi; Remote; INR 700,000 - 1,100,000; Full time

Job summary

Capital Placement Services Gurgaon is seeking an experienced Microsoft SQL Server Database Administrator (DBA) for a remote role with UK shift timings. The candidate will manage SQL Server databases across staging and production, optimize performance, ensure high availability, and handle AWS RDS for SQL Server.

The role requires 2-5 years hands-on experience, strong troubleshooting skills, and collaboration with development teams to improve database performance and scalability.

Qualifications

• 2-5 years of hands-on experience in administering SQL Server databases.
• Experience in staging and production environments.

Responsibilities

• Install, configure, administer, and maintain Microsoft SQL Server databases.
• Manage SQL Server instances on-premises and AWS RDS.
• Configure backups, restores, DR strategies, and maintenance plans.
• Monitor health, performance, and availability using SQL Server tools.
• Identify and resolve bottlenecks at infra and app/query levels.
• Perform query optimization and execution plan analysis.

Skills

SQL Server DBA

Performance tuning

Backup & recovery

Security & HA

Production support

Troubleshooting

Query optimization

Cross-functional collaboration

Education

Bachelor's degree (CS/IT)

Tools

AWS RDS

SQL Server Management Studio (SSMS)

SQL Profiler

DMVs / Extended Events

Linked Servers

Job description

Job Title: Microsoft SQL Server Database Administrator (DBA)
Work Location: Remote
Work Timings: UK Shift

Job Summary
We are looking for an experienced Microsoft SQL Server Database Administrator (DBA)
with 2-5 years of hands-on experience in administering, monitoring, optimizing, and
troubleshooting SQL Server databases in staging and production environments. The
candidate should have strong expertise in database performance tuning, backup and
recovery, security, high availability, and AWS RDS for SQL Server. He/she should be
capable of independently managing staging and production environments, optimizing
database performance, and supporting business-critical database systems to ensure
high availability, reliability, and scalability.

• Key Responsibilities
  o Install, configure, administer, and maintain Microsoft SQL Server
  databases.
  o Manage SQL Server instances hosted on-premises and AWS RDS.
  o Configure and manage database backups, restores, disaster recovery,
  and maintenance plans.
  o Monitor database health, performance, and availability using SQL Server
  monitoring tools.
  o Identify and resolve database bottlenecks at both the infrastructure and
  application/query levels.
  o Perform query optimization, execution plan analysis, and performance
  tuning.
• 
  o Design, implement, and maintain database objects, including:
  Tables
  Views
  Stored Procedures

Functions
Triggers
Indexes
Constraints
o Configure and manage SQL Server Agent Jobs.
o Configure and troubleshoot Linked Servers.
o Manage TempDB configuration and optimize its performance.
o Monitor blocking, deadlocks, waits, and resource utilization.
o Perform index analysis, maintenance, fragmentation management, and
statistics updates.

o Troubleshoot database issues using:
Extended Events
SQL Profiler
Activity Monitor
Query Store
Dynamic Management Views (DMVs)

• Support database deployments, schema changes, and release activities.
  o Ensure database security by managing users, roles, permissions,
  auditing, compliance and encryption where applicable.
  o Production Incident Handling, Root cause analysis (RCA), performance
  troubleshooting and proactive monitoring.
  o Work closely with development teams to improve database performance
  and application scalability.
  Prepare and maintain database documentation, SOPs, and operational
  runbooks.
• Required Technical Skills
  o SQL Server Administration
  o Microsoft SQL Server 2016/2019/2022
  o Installation and configuration
  o Backup and Restore
  o Database maintenance
  o SQL Server Agent
  o Linked Servers
  o TempDB optimization
  o Database Migrations & Upgrades: Experience upgrading SQL Server
  versions and migrating databases
• AWS
  o AWS RDS for SQL Server
  o Snapshot management
  o Parameter Groups
  o Option Groups
  o Performance Insights
  o CloudWatch monitoring
• Performance Tuning
  o Query optimization
  o Execution Plan analysis
  o Index tuning
  o Statistics management
  o Wait Statistics Analysis: Understanding waits such as `PAGEIOLATCH`,
  `CXPACKET`, `CXSYNC_PORT`, `ASYNC_NETWORK_IO`, etc
  o Blocking and deadlock troubleshooting
  o CPU, Memory, and I/O performance analysis
  o Monitoring & Troubleshooting
  Extended Events
  SQL Profiler
  Query Store
  Activity Monitor
  Dynamic Management Views (DMVs): Strong hands-on experience
  using DMVs for troubleshooting Performance Monitor (PerfMon)

Windows Event Viewer
Resource Monitoring: CPU, memory, disk I/O, and storage
performance analysis.

• Database Development Knowledge
  T-SQL
  Stored Procedures
  Functions
  Triggers
  Constraints
  Indexes
  Views
  CTEs
  Window Functions
• Database Concepts
  OLTP and OLAP
  Database normalization and denormalization
  Database design and data modelling
  Transaction management
  Isolation levels
  Locking and blocking
  Concurrency management
• Good to Have
  High Availability & Disaster Recovery (HA/DR), Always On
  Availability Groups, Log Shipping, Replication, Database Mirroring,
  Failover Clustering
  Automation: PowerShell and SQL scripting for routine DBA tasks
  Experience with CI/CD for database(dacpac) deployments
  Database security and auditing
  Capacity planning
  

Partitioning and compression
Experience with large databases (VLDB)
Familiarity with Azure SQL is an added advantage

• Soft Skills
  Strong analytical and troubleshooting skills
  Excellent problem-solving ability
  Good communication and documentation skills
  Ability to work independently in production support environments
  Experience working with cross-functional teams