Job Description

Role: AWS Redshift Database Administrator

Location: Boston, MA (Hybrid (2-3 days in office /week)



• Redshift Database Administrator responsible for and working on various key data systems and services that includes AWS services (Redshift, RDS, S3, ELB, NLB).
• Perform Redshift administration and release management activities. Data strategies to meet the demands of business requirements
• 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
• The person will be working for a major Insurance client.
• Minimum of 8 to 10 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 in insurance is preferred but not mandatory.

Key Responsibilities & Skillsets:

• Install and maintain software, services, and applications 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
• 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

Candidate Profile:

• Bachelor's degree in computer science or engineering
• Minimum of 8 to 10 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 in Snowflake
• 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 preferred
• Strong written and verbal communication skills