AWS Redshift administrator Engineer |Boston, MA (OR) Hartford, CT

Location: Boston, MA (OR) Hartford, CT

Client: NTT Data 

Please mention visa status while sharing the profile

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.

Thanks,

Manoj