AWS Redshift administrator Engineer ,Onsite in Boston, MA OR NYC (downtown Manhattan) ONLY LOCAL

VISA – NO H1B, CPT, OPT

Hi,

Hope you are doing Good!!!

Please find the attached Job Description. If you feel comfortable then please send me your updated resume or call me back on 512-898-7112.

Position: AWS Redshift Administrator Engineer

Location: Onsite in Boston, MA OR NYC (downtown Manhattan)

Duration: 12 months Contract

Interview Process: 1 opening – 2 interview rounds (1st NTT, 2nd with client)

Job Description:

• 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 Skills Required:
• Bachelor’s 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 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.