Search for AWS Redshift Administrator Engineer roles in Hartford, CT, with 7+ years of experience, specifically in cloud administration, using AWS technologies, involving SQL and Python skills.

Okay, I've searched for AWS Redshift Administrator Engineer roles in Hartford, CT, requiring 7+ years of experience, focusing on cloud administration with AWS technologies, and involving skills in SQL and Python. I have found 45 positions for you to explore.

AWS Redshift Administrator Engineer

Hartford, CT

7 years + Experience

AWS

Python

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The AWS Redshift Administrator Engineer role at NTT DATA is fundamentally about ensuring the integrity, performance, and scalability of cloud-based data environments. This position demands a deep understanding of both cloud technology and database management, with primary responsibilities revolving around administering AWS environments, particularly the Redshift data warehouse. The candidate will be expected to translate business objectives into effective cloud solutions, which requires not only technical expertise but also a strategic mindset. Key responsibilities include implementing Infrastructure as Code with Terraform, troubleshooting issues, and maintaining time-sensitive system performance and upgrades, all while working closely with cross-functional teams. This collaborative aspect underlines the need for strong communication skills, as they will liaise with various stakeholders to align technical capabilities with business needs. Success in this role will likely be defined by the stability of the data systems, efficiency in deployments, and the ability to anticipate and resolve potential issues before they impact users or operations.

Company Analysis:

NTT DATA occupies a significant position as a global innovator in business and technology services, renowned for its R&D investments aimed at fostering sustainable digital transformation. As a company servicing 75% of the Fortune Global 100, NTT DATA emphasizes adaptability, inclusion, and forward-thinking, creating an environment that is likely fast-paced and innovation-driven. Such cultural dynamics suggest that the AWS Redshift Administrator Engineer will not only be required to manage technical deliverables but also to be a proactive contributor to the team’s overarching goals of client success and innovation. In terms of organizational context, this role seems to be positioned within a collaborative tech team, likely reporting to upper management or cloud architecture leads, giving it strategic visibility. The role’s alignment with NTT DATA’s mission to enhance operational capabilities through cloud solutions makes it essential in meeting client demands and advancing the company's technological expertise in the competitive digital landscape.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Tell me about a time when you had to resolve a major cloud infrastructure issue. What steps did you take?
Describe an instance where you implemented Infrastructure as Code. What challenges did you face, and how did you overcome them?
Can you discuss a situation where you had to communicate complicated technical information to non-technical stakeholders?
What has been your experience with performance tuning in a database environment? Can you provide a specific example?
How do you approach troubleshooting issues within AWS environments, especially in critical moments?
What strategies do you use to ensure that database security is maintained during migrations or upgrades?
Imagine you are faced with a sudden drop in performance metrics for a Redshift database. How would you troubleshoot and identify the root cause?
Suppose you are tasked with migrating a database from one AWS account to another. What steps would you take to ensure minimal downtime and data integrity?
Why are you interested in working at NTT DATA specifically, and how do you see your skills contributing to our mission?
How do your personal values align with our focus on innovation and client success?
What do you believe is the number one challenge facing cloud service providers today, and how would you address it?
Can you describe your familiarity with Agile methodologies? How have you integrated them into your work processes?
What questions do you have about the team you'll be working with or the projects you're expected to contribute to?
How do you stay current with the latest developments in AWS technologies and cloud solutions?
What do you consider as successful outcomes in the first 6 months of this role?

Job Details

Overview Company

AWS Redshift Administrator Engineer

NTT DATA North America

3 days ago

Highlight

OnsiteFull-time7+ yearsSenior

Summary

NTT DATA North America is seeking an AWS Redshift Administrator Engineer to join their team in Hartford, CT. The role involves administering and maintaining scalable cloud environments and applications for data organization.

About the Role

As an AWS Redshift Administrator Engineer, you will be responsible for administering and maintaining scalable cloud environments, implementing Infrastructure as Code, and deploying code using Terraform and Gitlab. You will handle AWS services and database troubleshooting, manage database operations, and ensure system performance. The role also involves migrating systems between AWS accounts, securing web systems, and communicating with internal teams and stakeholders to meet project needs.

About You

Required:

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.
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 environments such as KSH shell and PowerShell.
Experience with version management tools and CICD pipeline.
In-depth knowledge of the TCP/IP protocol suite, security architecture, and securing and hardening operating systems, networks, databases, and applications.
Advanced SQL knowledge and experience working with relational databases, query authoring, and 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.

Preferred:

Experience with Snowflake.
Knowledge of SQL and performance tuning.
Knowledge of Linux Shell Scripting or Python.

NTT DATA North America

NTT DATA, Inc. is a trusted global innovator of business and technology services. We're committed to helping clients innovate, optimize and transform for long-term success. Our R&D investments help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure, and connectivity.

Hartford, CT