Senior SQL Server DBA

Published date Posted on Indeed on Oct 07, 2021 (9 d ago)

The SQL Server DBA needs to automate the deployment, migration and other SQL Server administration tasks using IaC (Infrastructure as Code) and CaC (Configuration as Code).

Primary Responsibilities

  • Convert on-premise SQL Server environment to IaC (Infrastructure as Code), and Configuration as Code (CaC) and deploy them to Azure IaaS environment

  • Maintain parity between different production and non production environment as defined

  • Accelerate delivery of SQL server infrastructure and environment with minimal effort in an automated fashion

  • Maintain detailed log of changes using IaC and CaC to report drift from base configuration

  • Automate database administration tasks using IaC and CaC tools

Secondary Responsibilities

  • Provision SQL Server instances and databases in multiple environments (Dev, QA, Production, etc.) primarily on Azure cloud IaaS environment

  • Configure high availability and disaster recovery

  • Apply ongoing patches and collaborate with other DBAs to perform major upgrades

  • Tune SQL performance and system-level performance

  • Use various tools to monitor database health (heartbeats, capacity utilization, blocked queries, transaction logs, indexes, etc.)

  • Manage backups, restore

  • Provide access

Experience & Skills

  • 5+ experience as SQL Server DBA

  • 2+ years of experience in managing and automating SQL Server environments using IaC (Infrastructure as Code) and CaC (Configuration as Code) using tools like Terraform, Packer, Azure DevOps, PowerShell, etc

  • 2+ years of experience on managing SQL Server on Azure environment

  • Must be able to work on multiple tasks

  • Must be a self-starter and willing to learn

  • Must be hands-on

  • Must be client-facing

  • Must have strong verbal and written communication skills

  • Relevant certifications on Azure or SQL Server preferred

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Error on reporting

Related jobs

Piper Companies Piper Companies |
2 d ago

Piper Companies is looking for a Database Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Database Architect include:You will be responsible for providing leaders

BuildingLink BuildingLink |
7 d ago

Who We AreBuildingLink simplifies and elevates modern working and living in residential communities with inspired solutions, pioneering technology, and dedicated service. We are a rapidly growing SaaS company, providing an incredibly robust, cross-platform suite of products, serv

LOAN IQ DEVELOPER_______________________________________________________________________________________LOCATION: Remote in USHIRE TYPE: Full-timeVERTICAL: Financial Markets_______________________________________________________________________________________Role SummaryeClerx i

Orange Kiwi Solutions Orange Kiwi Solutions |

About UsOrange Kiwi Solutions provides affordable & responsive Prophet 21 expert support to distributors across North America.As a IT Support Technician for Orange Kiwi Solutions, you are responsible for solving complex advanced challenges related to Prophet 21 implementations an

Tradesmax Group Tradesmax Group |

TradesMax is an innovative Fintech company based in Los Angeles, offering U.S. fundamental equity research, real-time financial big data and news. We empower individuals to take control of their financial futures by providing the data tools and services they need to meet their ne

More jobs by this company

The TIBCO Platform Integration Professional/Sr. BW Developer will be a part of a dynamic and fun environment where you will be responsible for migrating from BW5 to BW6 along with new development. You will be part of a dynamic culture, where teamwork and collaboration are encoura