Role: AWS Redshift Administrator Engineer
Location: Boston MA (Onsite)
Type: Contract
Job Duties:
- 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.
Minimum Skills Required:
- 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.