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