AWS Redshift Administrator Engineer

Job Title: AWS Redshift administrator Engineer Location: Boston, MA (OR) Hartford, CT. This position requires (Hybrid 3 days onsite) Type: [Contract] 6+ months Interview: In-person after L1 interview. Rate: ALAP Job Responsibilities • Administer and maintain scalable cloud environments and applications for data organization. • Understanding business objectives of the company and creating cloud-based solutions to facilitate those objectives. • Implement Infrastructure as Code and deploy code using Terraform, Gitlab • Install and maintain software, services, and application by identifying system requirements. • Hands-on AWS Services and DB and Server troubleshooting experience. • Extensive database experience with RDS, AWS Redshift, MySQL • Maintains environment by identifying system requirements, installing upgrades and monitoring system performance. • Knowledge of day-to-day database operations, deployments, and development • Experienced in Snowflake • Knowledge of SQL and Performance tuning • Knowledge of Linux Shell Scripting or Python • Migrate system from one AWS cloud to another AWS account • Hands-on DB and Server troubleshooting experience • Maintains system performance by performing system monitoring and analysis and performance tuning. • Troubleshooting system hardware, software, and operating and system management systems. • Secures web system by developing system access, monitoring, control, and evaluation. • Testing disaster recovery policies and procedures; completing back-ups; and maintaining documentation. • Upgrades system and services and developing, testing, evaluating, and installing enhancements and new software. • Communicating with internal teams, like EIMO, Operations, and Cloud Architect • Communicate with stakeholders and build applications to meet project needs. Minimum Required Skills • Bachelor's degree in computer science or engineering • Minimum of 7 years of experience in System, platform, and AWS cloud administration • Minimum of 5 to 7 years of Database administration and AWS experience using latest AWS technologies AWS EC2, Redshift, VPC, S3, AWS RDS • Experience with Java, Python, Redshift, MySQL, or equivalent database tools • Experience with Agile software development using JIRA • Experience in multiple OS platforms with strong emphasis on Linux and Windows systems • Experience with OS-level scripting environment such as KSH shell., PowerShell • Experience with version management tools and CICD pipeline • In-depth knowledge of the TCP / IP protocol suite, security architecture, securing and hardening Operating Systems, Networks, Databases and Applications. • Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) , query performance tuning. • Experience supporting and optimizing data pipelines and data sets. • Knowledge of the Incident Response life cycle • AWS solution architect certifications. • Strong written and verbal communication skills.