What are the responsibilities and job description for the AWS Redshift administrator Engineer position at Intellicept Inc?
AWS Redshift administrator Engineer
Boston, MA (OR) Hartford, CT. This position requires (Hybrid 3 days onsite)
C2C
NOTE: In-person Interview Required.
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 & Regards
Pinki Kumari
Talent Advisor
Email: pinki@intellicept.com
Cell: - (848) 999-4581
Intellicept Corporation