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