Senior L2 SQL DBA

This is a fully remote position, open to applicants in India.

📋 Description

• Oversee SQL Server database environments utilizing monitoring tools such as PRTG, Azure Monitor, and various database monitoring platforms.

• Analyze system alerts, acknowledge incidents, and conduct initial triage and resolution following established SOPs and runbooks.

• Supervise database instances, SQL Agent jobs, backups, and performance metrics to guarantee optimal functionality.

• Implement database deployments using tools like Azure DevOps, Redgate, DB Maestro, or other approved deployment methods.

• Carry out routine database maintenance tasks, including integrity checks, index management, and backup validation.

• Confirm deployment results and ensure the successful completion of maintenance tasks.

• Monitor and manage the health of Azure VMs and the associated database infrastructure components.

• Execute database refreshes in lower environments according to established procedures.

• Escalate complex issues related to database performance, availability, or failures to L3 DBAs or client teams.

• Assist with service requests, incident tickets, and operational tasks while adhering to SLA timelines.

• Engage in continuous improvement initiatives, backlog items, and automation possibilities within the database platform.

• Take part in database-related projects as assigned.

⛳️ Requirements

• 8+ years of experience in SQL Server database administration or support.

• Proficient understanding of SQL Server architecture, database health monitoring, and performance fundamentals.

• Experience with monitoring tools such as PRTG, Azure Monitor, or similar alternatives.

• Knowledge of database backup strategies, job monitoring, and maintenance plans.

• Familiarity with deployment tools like Azure DevOps, Redgate, DB Maestro, or equivalent.

• Capability to execute tasks based on SOPs and troubleshoot common database issues.

• Strong analytical and problem-solving abilities with a keen attention to detail.

• Effective communication skills and the ability to work in a shift-based support environment.

• Exposure to Azure-based SQL environments (Azure SQL, Managed Instances, or SQL on Azure VM) (Preferred Qualification).

• Basic scripting knowledge (T-SQL, PowerShell) (Preferred Qualification).

• Experience in ITIL-based support environments (Preferred Qualification).

• Previous experience in production support or managed services roles (Preferred Qualification).

🏝️ Benefits

• Competitive salary and comprehensive benefits package.

• Opportunities for professional development and career advancement.

• Flexible working hours and a supportive work environment.