Microsoft SQL Server Database Administrator

🌟 We're Hiring: Microsoft SQL Server Database Administrator! 🌟
We are looking for a skilled and proactive Microsoft SQL Server Database Administrator with at least 5 years of experience to join our team. If you are passionate about database management, optimization, and security, this is your chance to make an impact in a dynamic environment.
📍 Location: Gurugram, India
⏰ Work Mode: Work from anywhere
💼 Role: Microsoft SQL Server Database Administrator
What You'll Do:
SQL Development & Database Design
Develop and maintain complex T-SQL queries, Stored Procedures, Views, Functions, and database objects.
Design and modify tables, indexes, constraints, and other database objects.
Write efficient and maintainable SQL for large-volume transactional systems.
Understand SQL Server query processing and logical execution order of SQL statements.
Use CTEs, subqueries, window functions, APPLY, temporary tables, table variables, and other appropriate SQL techniques.
Review existing SQL code and identify opportunities for performance and maintainability improvements.
Work closely with developers to improve application/database interaction and scalability.
SQL Performance Tuning
Analyse and optimize slow-running queries and Stored Procedures.
Analyse execution plans and identify scans, lookups, joins, spills, excessive memory grants, and other performance issues.
Perform index analysis and recommend appropriate indexes.
Troubleshoot blocking, deadlocks, waits, CPU, memory, and I/O-related issues.
Analyse SQL Server wait statistics, including waits such as PAGEIOLATCH, CXPACKET, CXSYNC_PORT, ASYNC_NETWORK_IO, etc.
Use Query Store, DMVs, Extended Events, and SQL Server monitoring tools for performance investigation.
Identify whether performance issues originate from SQL, database design, application behaviour, or infrastructure.
SQL Server Administration
Manage SQL Server databases in staging and production environments.
Manage database users, logins, roles, permissions, and security.
Configure and troubleshoot SQL Server Agent Jobs.
Configure and troubleshoot Linked Servers.
Manage database-level configuration and troubleshoot SQL Server configuration issues.
Perform database backup, restore, migration, and recovery activities when required.
Monitor database health, storage, capacity, and performance.
Manage indexes and statistics where appropriate.
Troubleshoot production database incidents and participate in RCA activities.
AWS RDS for SQL Server
Strong practical experience with AWS RDS for SQL Server.
Understand RDS architecture, supported features, and limitations compared with traditional SQL Server.
Work with:
RDS Parameter Groups
Option Groups
Snapshots
CloudWatch
Performance Insights
Storage and IOPS
Instance sizing
Monitor and troubleshoot database performance using AWS and SQL Server monitoring tools.
Understand how SQL Server workloads behave within a managed RDS environment.
Troubleshoot issues involving CPU, memory, storage, I/O, connections, waits, and database performance.
Understand which DBA activities are handled by AWS and which activities remain the responsibility of the database/application team.
Production Support
Investigate and resolve database-related production incidents.
Analyse blocking, deadlocks, long-running queries, resource contention, and application/database performance issues.
Perform root cause analysis and recommend permanent solutions.
Support database deployments, schema changes, and release activities.
Work closely with application developers and DevOps teams during production issues and releases.
If you're ready for your next challenge in database administration, apply now! 🚀

Work arrangement
Yes