Redshift administrator Engineer

Job Title: Redshift administrator Engineer

Location: Boston MA (Hybrid)

Type: Contract

Interview Process:

• Technical Zoom Interview (panel)
• In Person Interview with hiring manager
• Final Zoom Interview

Job Description:

• The Redshift Admin Engineer consultant will be responsible and working on various key data systems and services that includes AWS services (EC2 RDS Redshift S3 ELB NLB).
• The consultant will perform Redshift administration and release management activities. This role requires a highly motivated individual with strong capability technical ability data capability excellent communication and collaboration skills including the ability to develop and troubleshoot a diverse range of problems.

Responsibilities:

• Administer and maintain scalable cloud environments and applications for data organization.
• Understanding business objectives of the company and creating cloudbased 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.
• Handson 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 daytoday 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
• Handson 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 backups; 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.

Qualifications:

• Bachelors degree in computer science or engineering
• Minimum of 12 years of experience in System platform and AWS cloud administration
• Minimum of 5 to 8 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 OSlevel scripting environment such as KSH shell. PowerShell
• Experience with version management tools and CICD pipeline
• Indepth 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.