SQL DBA

🌟 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: New 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 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

• 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!