Website:
Job details:
🌟 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!
Click on Apply to know more.
