• Job Description

  Req#: JPC - 10181427

  Title: AWS Redshift Administrator / Engineer

  Location: Boston, MA / Hartford, CT (onsite)

  Candidate has to go for In-person interview

  Description:

  Job Duties:

  • 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 8+ 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.

  Regards

  Kisshore

• About the company

  United Software Group, Inc. (USG) is a Global Information Technology Consulting Company established in the year 2002 with its Headquarters in Columbus-Ohio, USA. USG is operating a business in 6 countries USA, Mexico, Canada, UK, Ireland and India. USG is a Minority Owned Enterprise (MBE) offering IT consulting, Talent Management and Staff Augmentation Solutions to its Clients. USG is recognized by INC5000 as Americas Fastest-Growing Private Companies and is honored with A+ rating by BBB as a mark of a trustworthy customer-oriented organization. USG’s services are based on requirements specified by operational business users from different industries such as Banking & Financial, Consumer Good and Distribution, Telecommunication, Insurance, Engineering, Healthcare, Life Sciences, Retail, Manufacturing and Automotive.

Notice