Redshift Administrator Engineer

4 weeks ago


Boston, Massachusetts, United States Inabia Software & Consulting Inc. Full time
Job Title: Redshift Administrator Engineer

Location: Boston, MA (Hybrid – 3 days in office)

Duration: 12+ months

Skills: AWS, Redshift, Java, Python

Need 10 plus years candidate

This role is based out of Boston Office

Model : Hybrid : 3 Days in Office.

Job Description:

The Redshift Admin Engineer consultant will be responsible and working on various key data systems and services that includes AWS services (EC2, RDS, Redshift, S3, ELB, NLB). The consultant will perform Redshift administration and release management activities. This role requires a highly motivated individual with strong capability, technical ability, data capability, excellent communication, and collaboration skills including the ability to develop and troubleshoot a diverse range of problems.

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.
Qualifications:
  • 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.


  • Boston, Massachusetts, United States Syntricate Technologies Full time

    Key Responsibilities:As a Sybase Database Administrator at Syntricate Technologies, you will be responsible for managing and maintaining our Sybase database infrastructure. This includes experience in Sybase DB Engineering/Administrator, migration experience, and proficiency in AWS Cloud.Required Skills: Experience in Sybase DB Engineering/Administrator...


  • Boston, Massachusetts, United States Mondo Full time

    Job Title: Database AdministratorAre you a skilled database professional looking for a new challenge? We have an exciting opportunity for a Database Administrator to join our team at Mondo.Job Summary:We are seeking a highly motivated and experienced Database Administrator to manage our Redshift clusters, support our dev team with telemetry, and work on...


  • Boston, Massachusetts, United States JobRialto Full time

    Job Summary:We are seeking an experienced AWS Redshift Administrator Engineer to manage and maintain scalable cloud environments and applications. This role requires a deep understanding of AWS services, database administration, and cloud architecture, focusing on performance optimization, troubleshooting, and system management.Key...


  • Boston, Massachusetts, United States WillowTree Full time

    Job Title: Senior Cloud Data EngineerWe are seeking a highly skilled Senior Cloud Data Engineer to join our team at WillowTree. As a Senior Cloud Data Engineer, you will be responsible for designing, implementing, and maintaining large-scale data platforms on cloud-based infrastructure.Key Responsibilities:Design and implement data pipelines using...

  • Data Engineer

    1 month ago


    Boston, Massachusetts, United States Amazon Full time

    Job SummaryWe are seeking a highly skilled Data Engineer to join our AGI team at Amazon. As a Data Engineer, you will be responsible for designing, implementing, and supporting a platform that provides ad hoc access to large datasets. This is a unique opportunity to work with cutting-edge technology and make a significant impact on the development of AI...


  • Boston, Massachusetts, United States Amazon Full time

    We are seeking a highly skilled Business Intelligence Engineer to join our team at Amazon. As a Business Intelligence Engineer, you will be responsible for designing, implementing, and maintaining large-scale data solutions for our Alexa analytics product suite.Key Responsibilities:Participate in bi-weekly sprints, executing a mix of tickets focused on...

  • Office Administrator

    4 weeks ago


    Boston, Massachusetts, United States HJ Russell and Company Full time

    Job SummaryWe are seeking a highly skilled and organized Office Engineer/Office Manager to join our team at HJ Russell and Company. This role will be responsible for providing administrative support to our project teams, ensuring the smooth operation of our office, and maintaining compliance with company policies and procedures.Key ResponsibilitiesProvide...

  • Cloud Data Engineer

    4 weeks ago


    Boston, Massachusetts, United States Arrowstreet Capital Full time

    Job OverviewThe Investment Process Engineer at Arrowstreet Capital is responsible for ensuring the fidelity of our Data-Driven Investment Process. This involves building visibility and recovery mechanisms for our modern distributed investment process. The daily investment process includes processing external vendor data and the data flow through pre trade,...


  • Boston, Massachusetts, United States Jobs for Humanity Full time

    About the RoleWe are seeking a highly skilled Database Administrator to join our team at Jobs for Humanity. As a key member of our database operations team, you will be responsible for ensuring the smooth operation of our eCommerce databases in production, QA, and DR environments.Key ResponsibilitiesInstall, configure, and tune database software, including...


  • Boston, Massachusetts, United States PA Consulting Full time

    Job OverviewWe are seeking a highly organized and proactive Administrative Coordinator to provide administrative coordination support to our Design, Engineering & Science team and our Boston and Concord offices.The ideal candidate will possess a high level of commitment to providing quality service, producing quality outputs, and meeting tight...


  • Boston, Massachusetts, United States Mass Inc Full time

    About the Role:The Building and Engineering Coordinator (Program Coordinator III) is responsible for leading and managing a team responsible for providing administrative and programmatic support within the Division of Occupational Licensure's Office of Public Safety and Inspections' Building and Engineering Division. The Building and Engineering Division...


  • Boston, Massachusetts, United States HexaQuEST Global, Inc. Full time

    Job SummaryThe Storage Systems Administrator will assist the senior storage engineer in managing and maintaining our storage and backup environments, both on-premise and in the cloud. This role involves helping to ensure the efficient operation, functionality, and stability of our storage and backup systems.Key Responsibilities Assist in setting up backup...


  • Boston, Massachusetts, United States Business And Technology Solutions, LLC Full time

    **Job Summary**We are seeking a highly skilled Civil Engineer to join our team at Business And Technology Solutions, LLC. The successful candidate will be responsible for developing project technical requirements, working with Project Managers, and coordinating with engineers and administrative personnel.**Key Responsibilities**Develop and implement project...


  • Boston, Massachusetts, United States Boston University Full time

    Job Title: Senior CRM AdministratorJob Summary:Boston University Information Services & Technology (IS&T) is seeking a Senior CRM Administrator to join our team. The successful candidate will be responsible for designing, configuring, and leading the release engineering and support of CRM/Salesforce applications.Key Responsibilities:Design and configure...


  • Boston, Massachusetts, United States Jones Lang LaSalle IP, Inc. Full time

    Job Summary:Jones Lang LaSalle IP, Inc. is seeking an experienced Global Real Estate Program Leader to support our client, Amazon Global Real Estate & Facilities, in Arlington, VA, and Boston, MA. As an Engineering Program Manager, you will be responsible for managing and performing administrative tasks related to engineering program support within assigned...

  • Data Architect

    4 weeks ago


    Boston, Massachusetts, United States Wasabi Full time

    Role Overview:At Wasabi, we're a team of pioneers, visionaries, and disruptors who challenge the norm and deliver the unexpected. As a Data Engineer, you'll play a crucial role in designing, developing, and maintaining our data architecture, ensuring our data is accessible, reliable, and ready for analysis.Key Responsibilities: Design, build, and maintain...


  • Boston, Massachusetts, United States Simpson Gumpertz and Heger Inc Full time

    Job SummaryWe are seeking a highly skilled Structural Engineer to join our team at Simpson Gumpertz and Heger Inc. The ideal candidate will have a strong background in structural analysis, investigation, and design of concrete, steel, masonry, and wood-frame structures.The successful candidate will be responsible for working on a wide range of structural...


  • Boston, Massachusetts, United States Toole Design Full time

    Job Summary: Toole Design Group in Boston, MA is seeking an experienced Principal Civil Engineer to join their team. The ideal candidate will have a strong background in civil engineering with final roadway/corridor design experience and a passion for creating quality construction documents and safe streets for all.Key Responsibilities:Manage projects and...


  • Boston, Massachusetts, United States Liberty Personnel Services, Inc Full time

    Job OverviewLiberty Personnel Services, Inc is seeking a Senior Electrical Engineer to join our team. As a key member of our electrical design team, you will be responsible for delivering high-quality electrical designs for commercial, mission-critical, healthcare, science, technology, government, and specialty markets.ResponsibilitiesElectrical Design:...


  • Boston, Massachusetts, United States Builder Full time

    About usWe're a rapidly growing company that's changing the way people build apps. Our mission is to make app building easy for everyone, regardless of their background or tech knowledge.We've already helped thousands of entrepreneurs, small businesses, and global brands achieve their software goals. Our team has grown to over 800 people across the world,...