Support Engineer (MS SQL Server DBA) with AzureDevops

Support Engineer (MS SQL Server DBA) with AzureDevops

Remote

Long Term

Note : Need independent consultants with 10+ years experience

Job Description :

This position uses a blend of DBA, DevOps, CI / CD, and scripting skills. The production support specialist must have experience in software maintenance, support, and operations and will ensure the functionality and usability of internal software applications while diagnosing and resolving application issues.

The production support specialist must have a solid understanding of MS SQL Server technologies , and the ability to write queries against the databases and develop scripts using Python / PowerShell that Extract, Transform and Load data.

The production support specialist will be responsible for performing daily, weekly, monthly, quarterly, and yearly operation tasks required for ongoing functionality of software applications.

The production support specialist will troubleshoot errors and production problems via help desk tickets, and initiate corrective actions, along with preventive techniques where appropriate.

The position is responsible for creating operational run books and other documents related to production control work as needed.

This is a contract position and is on a rotational on-call schedule.

Responsibilities :

• Deploy and operate many MS SQL Server databases on on-premise infrastructure.
• Perform DBA operations such as backup, migration, tuning, disaster recovery, provisioning of accounts and permissions etc.
• Develop and maintain disaster recovery plans, backup strategies, and ensure data integrity and availability in case of failures.
• Write and maintain T-SQL scripts / procedures.
• Develop, maintain, and optimize continuous integration and continuous deployment (CI / CD) pipelines to automate software build, test, and deployment processes on Azure DevOps.
• Deploy, maintain and troubleshoot .NET applications and servies on Windows servers
• Work closely with development, QA, and operations teams to ensure seamless integration and delivery of software solutions.
• Automate repetitive tasks and processes using scripting languages (e.g., Python, PowerShell) to enhance efficiency and reduce manual intervention.
• Create and maintain comprehensive documentation for infrastructure, processes, and configurations to ensure knowledge sharing and continuity.
• Provide advanced technical support and troubleshooting for complex issues, acting as an escalation point for junior engineers and ensuring swift resolution.
• Lead the resolution of high-priority incidents, coordinating with internal teams to minimize impact and restore normal operations promptly.
• Maintain professional and clear communication with business, ensuring they are informed about progress, resolution steps, and preventive measures.
• Conduct thorough root cause analyses for recurring issues and implement robust solutions to prevent future occurrences.
• Monitor system performance and reliability, proactively identifying potential issues and implementing preventive measures.
• Develop and maintain internal tools and scripts to automate common support tasks and improve efficiency.

Requirements : :

• Bachelor's degree in computer science, Engineering, or related field.
• A minimum of 8 year of experience in Microsoft SQL Servers with proven experience as an SQL Database Administrator, Database Engineer, or in a similar role.

Having a good level of understanding on database high availability and disaster strategies is required.

• Minimum of 10 years of experience in DevOps Engineer or in a similar technical support role.
• Proficiency in deploying web applications, WCF services, REST API using Microsoft .Net framework.
• Experience with Azure cloud platform is required, focus is on Microsoft Entra ID, App Proxy, Cloud networking, security etc.
• Proficiency with CI / CD tools such as Azure DevOps.
• Experience in Agile / Scrum methodologies.
• Candidate must have effective verbal, non-verbal and written communication skills and ability to communicate across different levels of the organization
• Ability to analyze, resolve and document problems and resolutions
• Ability to work as part of a cross-cultural teams, excellent inter-personal skills in areas such as teamwork, facilitation and negotiation.

Ability to work independently or part of a team.