SQL DA

Role & responsibilities

Role: Database Engineer

Experience: 4+ YearsYears ( 4 + years of strong and relevant experience)

Location: Pune, Maharashtra, India

Notice Period: Immediate to 30 Days
Interview Mode : 1st round virtual,2nd round F2F

Skill Set: MSSQL, Database Administration, SQL Server, L2+ Support, Migration, Upgrades

Mandatory Skills: SQL Server Administration, Always On Availability Groups, Performance Tuning, Database Migration, Version Upgrades, L2+ Support

Job Description:

• Manage and maintain MSSQL database environments (SQL Server 2016/2019/2022).
• Perform database installations, upgrades, migrations, and decommissioning activities.
• Configure and maintain database security, backup, restore, and recovery procedures.
• Manage database users, roles, permissions, linked servers, SQL Agent jobs, and maintenance jobs.
• Monitor database availability, storage, performance, and overall health.
• Support SQL Server hosted on cloud platforms such as AWS EC2 and SQL Server on Azure VM.
• Provide L2+ support for database-related incidents and service requests.
• Troubleshoot complex database issues and performance bottlenecks.
• Investigate blocking, deadlocks, connectivity issues, job failures, backup failures, disk space issues, and database corruption alerts.
• Collaborate with application teams, infrastructure teams, cloud teams, and vendors for issue resolution.
• Participate in on-call rotation for critical database support.
• Support DR drills, failover testing, and recovery validation.
• Perform incident analysis, root cause analysis, and provide technical recommendations.
• Conduct database health checks and performance tuning.
• Optimise SQL queries, indexes, execution plans, statistics, and database configurations.
• Analyse wait statistics, Query Store data, expensive queries, I/O latency, CPU usage, memory pressure, and tempdb contention.
• Implement and maintain high availability and disaster recovery solutions.
• Perform capacity planning and resource management.
• Review database growth trends and provide recommendations for archiving, partitioning, storage planning, and scalability.
• Implement and maintain monitoring and alerting for performance, availability, capacity, backup status, and SQL Agent jobs.
• Develop automation using T-SQL, PowerShell, or other scripting tools to improve operational efficiency.
• Maintain database documentation and ensure compliance with security policies and industry standards.
• Support database audits, compliance, vulnerability management, access reviews, and remediation activities.
• Prepare technical reports, health check findings, incident summaries, and recommendations.
• Support change management activities, including risk assessment, implementation planning, validation, and rollback planning.

Essential Requirements:

• 3+ years of strong and relevant experience.
• Hands-on experience with SQL Server Always On Availability Groups (administration and troubleshooting).
• Strong expertise in SQL Server Performance Tuning, including query optimization, execution plan analysis, indexing, and troubleshooting.
• Hands-on experience in SQL Server migration activities, including server/database migrations, version upgrades, and cutover support.
• Experience in MSSQL database administration and L2+ technical support.