100% Remote - MS SQL Server DBA

Overview

Remote
Depends on Experience
Full Time

Skills

SQL Server DBA
Azure DevOps
CI/CD
AWS is a plus
SSRS/SSIS/SSAS
PowerShell
Bash
DMVs
Profiler
DACPACs

Job Details

This is Narendra from Prodware Solutions LLC. We have a role which closely matches your skill set. Please go through the job description below and let me know if you or anyone who is looking for a good opportunity. You can reach me on .
Job title: MS SQL Server DBA
Duration: Full Time Permanent/ Long Term Contract
Location: 100% Remote
About the Role
  • We are seeking a highly skilled and motivated Microsoft SQL Server DBA administration and troubleshooting along Microsoft Azure and any CI/CD and automation is most relevant to manage, optimize and automate SQL Server environments for our client (a leading US based P & C insurer). You ll ensure database integrity, performance and security while leveraging Azure DevOps CI/CD pipelines and scripting to support global development, test and production environments.
Key Responsibilities
  • Administer and automate SQL Server instances (installation, configuration, upgrades, performance tuning, backup & restore).
  • Automate repeatable tasks via Azure DevOps Pipelines (e.g. build/release, backups, restores, environment refreshes).
  • Maintain performance and system integrity; optimize queries and server configurations.
  • Enforce database security and access controls; manage permissions via self-service group structures.
  • Define, enforce and document database standards and architectures.
  • Review software changes for compliance with standards.
  • Create and keep up-to-date architectural documentation and system design.
  • Support global environments (development, test, production) and provide on-call troubleshooting as needed.
  • Recommend and implement new database technologies, tools and best practices.
  • Build reports, dashboards and visualizations using SQL Server reporting tools.
  • Where applicable, step up to mentor colleagues and promote a continuous learning culture within the team.
Experience & Qualifications
  • Required (Minimum) 12 yrs :
  • 5+ years of hands-on experience in Microsoft SQL Server administration including backups, restores, performance tuning, SSRS/SSIS/SSAS and scripting (PowerShell, Bash).
  • Experience with Azure DevOps Pipelines and CI/CD processes for database automation and deployment.
  • Familiarity with both Windows/Linux server environments.
  • Exposure to cloud environments (Microsoft Azure; exposure to AWS is a plus).
  • Knowledge of data warehousing concepts and working with large, complex data sets.
Technical Skills & Tools needed:
  • Experience with Microsoft SQL Server (2012 2019+)
  • Experience with SSRS, SSIS, SSAS
  • Experience with Scripting: PowerShell, Bash
  • Azure DevOps, Azure SQL/VM
  • Performance monitoring tools (DMVs, Profiler)
  • CI/CD deployment tools (DACPACs, SQL Server database projects)
  • Basic Linux and Windows server administration
Soft Skills
  • Strong problem-solving and analytical abilities
  • Good communication and documentation capabilities
  • Team-oriented mindset with a commitment to continuous improvement
  • Ability to collaborate across global teams and time zones
  • On-call support may be required as needed
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.