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.