Logo
ThemeSoft

SQL DBA - Cloud & AWS Migration Expert

ThemeSoft, Hartford, Connecticut, us, 06112

Save Job

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 customers 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 #J-18808-Ljbffr