SQL Developer

Key Responsibilities

· Manage and maintain Microsoft SQL Server databases (2016 and later) across development, UAT, and production environments.

· Monitor and improve database performance using Query Store, Extended Events, and Dynamic Management Views (DMVs).

· Design and maintain indexes, partitioning strategies, and statistics to ensure optimal performance.

· Develop and maintain T-SQL scripts, views, stored procedures, and triggers.

· Implement robust backup and recovery solutions using native SQL Server tools and third-party backup tools (if applicable).

· Ensure business continuity through high-availability configurations such as Always On Availability Groups, Log Shipping, or Failover Clustering.

· Perform database capacity planning and forecast growth requirements.

· Ensure SQL Server security by managing logins, roles, permissions, and encryption features like TDE.

· Collaborate with application developers for schema design, indexing strategies, and performance optimization.

· Handle deployments, patching, and version upgrades in a controlled and documented manner.

· Maintain clear documentation of database processes, configurations, and security policies.

Required Skills & Qualifications

· Bachelor’s degree in Computer Science, Engineering, or related field.

· 3–5 years of solid experience with Microsoft SQL Server (2016 or later).

· Strong command of T-SQL including query optimization, joins, CTEs, window functions, and error handling.

· Proficient in interpreting execution plans, optimizing long-running queries, and using indexing effectively.

· Understanding of SQL Server internals such as page allocation, buffer pool, and lock escalation.

· Hands-on experience with backup/restore strategies and consistency checks (DBCC CHECKDB).

· Experience with SQL Server Agent Jobs, alerts, and automation scripts (PowerShell or T-SQL).

· Ability to configure and manage SQL Server high-availability features.

· Exposure to tools like Redgate SQL Monitor, SolarWinds DPA, or similar is a plus.

Nice to Have

· Exposure to Azure SQL Database or cloud-hosted SQL Server infrastructure.

· Basic understanding of ETL workflows using SSIS.

· Microsoft Certification: MCSA / Azure Database Administrator Associate or equivalent.

· Experience with database deployments in CI/CD pipelines.

Job Types: Full-time, Permanent

Pay: ₹500,000.00 - ₹700,000.00 per year

Benefits:

• Provident Fund

Education:

• Bachelor's (Preferred)

Experience:

• Microsoft SQL Server: 3 years (Required)

Location:

• Gurugram, Haryana (Required)

Work Location: In person