SQL DBA

RAPSYS TECHNOLOGIES PTE LTD; New Delhi; On-site; INR 700,000 - 1,300,000; Full time

Job summary

RAPSYS TECHNOLOGIES PTE LTD is seeking an experienced SQL Database Administrator to manage and optimize SQL Server databases in an Indian delivery center. The role covers installation, configuration, and ongoing maintenance to ensure data integrity and availability.

You will monitor performance, administer backups, and implement security controls. Collaboration with development teams will optimize queries and ensure scalable, reliable database operations across on‑premises and cloud environments.

Qualifications

• Strong knowledge of SQL Server architecture and administration.
• Experience with backups, restores, and disaster recovery planning.
• Proficiency in performance tuning, indexing, and query optimization.

Responsibilities

• Install, configure, and maintain Microsoft SQL Server databases.
• Manage SQL Server instances on‑premises and AWS RDS.
• Monitor health and performance; troubleshoot bottlenecks and failures.

Skills

SQL Server Administration

Performance Tuning

Backup & Recovery

AWS RDS

Security

DMVs

Tools

SQL Server Management Studio

Extended Events

SQL Profiler

DMVs

Job description

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.

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 and application/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
  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.
  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
• Locking and blocking
• Concurrency management