SQL DBA - Cloud & AWS Migration Expert

Themesoft Inc.

Hartford (CT)

On-site

USD 80,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Join a forward-thinking company as a SQL DBA specializing in cloud and AWS migrations. In this role, you will be pivotal in building AWS EC2 servers, configuring Always ON solutions, and ensuring seamless database migrations. Your expertise in SQL Server and cloud technologies will drive performance and reliability while mentoring peers in best practices. This is an exciting opportunity to work in a dynamic environment where your contributions will significantly impact the success of IT services and consulting projects. If you're passionate about database management and cloud solutions, this role is perfect for you.

Qualifications

  • Strong experience with SQL 2022 and SQL Server migrations.
  • Proficient in AWS cloud solutions and Always ON configurations.

Responsibilities

  • Build AWS EC2 servers and configure Always ON for high availability.
  • Automate tasks and provide technical mentorship to peers.

Skills

SQL 2022
SQL Server Migration
Always ON Configuration
Backups and Recovery Models
High Availability and Disaster Recovery
SSRS/SSIS/SSAS Migration
Performance Tuning and Optimization
Powershell Scripting
Troubleshooting Database Issues
AWS EC2 and S3

Tools

Terraform
Jenkins
Dynatrace
Foglight

Job description

Direct message the job poster from Themesoft Inc.

Talent Acquisition - Strategic Recruitment Manager

Position: SQL DBA - Cloud & AWS Migration Expert

Location: Hartford, CT

We are looking for a SQL DBA who will be responsible for building AWS EC2 servers, configuring Always ON and migrating SQL databases to On-premise and cloud environment (AWS) and ensuring their security, stability, reliability, and performance. He would help to solve all migration related issues and ensure end to end smooth migration.

Responsibilities

  • The ability to assist in finalizing a Microsoft SQL Server migration design in which to migrate Microsoft SQL server machines into a right-sized Virtual Machine (VM) for On-premise and AWS EC2 residing within the customer’s environment.
  • Building AWS EC2 servers using terraform and Jenkins pipelines.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Implement Always On Availability Group as a High Availability solution.
  • Automate repetitive tasks performed on a day-to-day basis.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Prepare documentation and specifications.

Skills and Qualifications

  • Strong proficiency with SQL 2022 and its variation among popular databases
  • Strong proficiency in SQL Server side by side migration
  • Strong experience in Always ON setup, configurations, and setup
  • Experience with backups, restores, and recovery models
  • Strong knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Experience in SSRS/SSIS/SSAS migration
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience of Cloud solutions.
  • Strong proficiency in Powershell scripting on SQL and Windows servers.
  • Capable of troubleshooting common database issues.
  • Knowledge on AWS EC2, S3 Bucket, Security, and other IaaS/PaaS services.
  • Knowledge on monitoring solutions in Dynatrace, Foglight etc.

Seniority level: Associate

Employment type: Contract

Job function: Information Technology

Industries: IT Services and IT Consulting

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Server Database SME on AWS/Azure
SQL Server Database SME on AWS/Azure

Eliassen Group • Washington

On-site
USD 76,000 - 90,000
Medical insurance
Dental insurance
Vision insurance
+2
SQL DBA (Infrastructure Focused) (JOB ID 002769)
SQL DBA (Infrastructure Focused) (JOB ID 002769)

Innovien Solutions • Atlanta (GA)

On-site
USD 120,000 - 180,000
Medical insurance
Vision insurance
401(k)
Senior SQL DBA | AlwaysOn & Migration Expert
Senior SQL DBA | AlwaysOn & Migration Expert

Mindlance, Inc. • Chicago (IL)

On-site
USD 90,000 - 120,000
Senior SQL Data Architect & Cloud Migration Lead
Senior SQL Data Architect & Cloud Migration Lead

Pyramid Consulting • Los Angeles (CA)

On-site
USD 90,000 - 130,000
Senior SQL Server DBA & Cloud Migration Lead (AWS/Azure)
Senior SQL Server DBA & Cloud Migration Lead (AWS/Azure)

Eliassen Group • Washington

On-site
USD 76,000 - 90,000
Medical insurance
Dental insurance
Vision insurance
+2
SQL DBA
SQL DBA

Highbrow LLC • Berkeley Heights (NJ), Alpharetta (GA)

On-site
USD 110,000 - 140,000
SQL DBA (Infrastructure Focused) (JOB ID 002769)
SQL DBA (Infrastructure Focused) (JOB ID 002769)

Innovien Solutions • Livonia (MI)

On-site
USD 100,000 - 130,000
AWS SQL Server Architect & Migration Engineer
AWS SQL Server Architect & Migration Engineer

Slalom • City of White Plains (NY)

On-site
USD 138,000 - 158,000
401(k) match
Health/dental/vision coverage
Parental leave
+1
AWS SQL Server Architect & DBA Engineer
AWS SQL Server Architect & DBA Engineer

Slalom • Harrisburg

On-site
USD 138,000 - 158,000
AWS Data Migration Specialist
AWS Data Migration Specialist

TechDigital Group • Torrance (CA)

On-site
USD 130,000 - 160,000