About the job Redshift Administrator
Role: AWS Redshift Database AdministratorLocation: Boston, MA (Hybrid (2-3 days in office /week)Role Overview: - 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