SQL DBA - Cloud & AWS Migration Expert

Themesoft Inc.; Hartford (CT); On-site; USD 80,000 - 110,000; Full time

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