? We're Hiring: SQL DBA! ?

We are looking for an experienced SQL Database Administrator (DBA) to manage and optimize our database systems. The ideal candidate will have a solid understanding of SQL databases, performance tuning, backup strategies, and security protocols to ensure data integrity and availability.

? Location: Recent Delhi, India

⏰ Work Mode: Work from anywhere

? Role: SQL DBA

What You'll Do:

- Install, configure, administer, and maintain Microsoft SQL Server databases.
- Manage SQL Server instances hosted on-premises and AWS RDS.
- Configure and manage database backups, restores, disaster recovery,and maintenance plans.
- Monitor database health, performance, and availability using SQL Server monitoring tools.
- Identify and resolve database bottlenecks at both the infrastructure andapplication/query levels.
- Perform query optimization, execution plan analysis, and performance tuning.
- Design, implement, and maintain database objects, including:
- Tables
- Views
- Stored Procedures
- Functions
- Triggers
- Indexes
- Constraints
- Configure and manage SQL Server Agent Jobs.
- Configure and troubleshoot Linked Servers.
- Manage TempDB configuration and optimize its performance.
- Monitor blocking, deadlocks, waits, and resource utilization.
- Perform index analysis, maintenance, fragmentation management, and statistics updates.
- Troubleshoot database issues using:

Extended Events

SQL Profiler

Activity Monitor

Query Store

Dynamic Management Views (DMVs)

- Support database deployments, schema changes, and release activities.
- 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

- SQL Server Administration
- Microsoft SQL Server 2016/2019/2022 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 Statistics management Wait Statistics Analysis: Understanding waits such as PAGEIOLATCH`,`CXPACKET`, `CXSYNC_PORT`, `ASYNC_NETWORK_IO`, etc
- Blocking and deadlock troubleshooting
- CPU, Memory, and I/O performance analysis
- Monitoring & Troubleshooting

Extended Events

SQL Profiler

Query Store

Activity Monitor

Energetic 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.

o Database Development Knowledge

T-SQL

Stored Procedures

Functions

Triggers

Constraints

Indexes

Views

CTEs

Window Functions|

Database Concepts

- LTP and OLAP
- Database normalization and denormalization
- Database design and data modelling
- Transaction management
- Isolation levels
- Locking and blocking
- Concurrency management

Ready to take your career to the next level? ? Apply now and let's build a brighter future together!

📌 SQL DBA (New Delhi)
🏢 RAPSYS TECHNOLOGIES PTE
📍 New Delhi