Thursday, 13 April 2023

Redshift Administrator | AWS cloud @ West Chicago, Illinois (DAY 1 ONSITE)

VISA TYPE: NO OPT & CPT VISA'S

 

Hello,

My name is Matt Adams and I am a Staffing Specialist at Veda Info Inc. I am reaching out to you on an exciting job opportunity with one of our clients.

 

Please find the JD below and kindly respond with the below details if interested:

 

Work authorization:

Expected pay-rate (or) employer details:

 

Job Title: Redshift Administrator | AWS cloud

Work Location: West Chicago, Illinois (DAY 1 ONSITE)

Client: Impetus

Contract duration: 06 Months + Extendable Possible

 

Does this position require Visa independent candidates only? No

 

Job Details:

·        Experience in database administration and implementation of DB related scripts/jobs.

·        Experience with SQL analysis, troubleshooting activities, including Redshift data warehouse & Aurora PostgreSQL RDS, analytical applications support.

·        Experience in working on AWS technologies, AWS services, AWS CLI & S3 storage understanding.

·        Strong knowledge on multiple cloud technologies including VPC, IAM, Security Group, EC2, S3, Amazon API Gateway, DynamoDB, Athena, AWS Route 53, Glue.

·        Good understanding of Redshift architecture, hands on experience in setting up Redshift cluster from the scratch and snapshot creation.

·        Hands on experience in cluster security like, data proration, identify and access management (IAM) & infrastructure security.

·        Hands on experience in loading data, running complex queries, performance tuning.

·        Hands on experience in configuring monitoring of AWS Redshift clusters, automated reporting of alerts, auditing & logging.

·        Conducting daily maintenance and support for both production and development databases using CloudWatch and CloudTrail.

·        Experience in CloudFormation

·        Experience of working in Linux/Unix environments.

·        Good understanding of snapshot creation and Disaster recovery.

·        General operational expertise such as good troubleshooting skills, understanding of system’s capacity, bottlenecks, basics of memory, CPU, OS, storage, and networks.

·        Expertise in debugging and analytical skills with solid grasp of system development methodologies, techniques, and tool.

·        Partnering with Data Integration Engineers to migrate data from a variety of source platforms - including SQL Server, DB2. The target for these platforms is AWS Redshift, using AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)

·        Proven experience in crafting and implementation of security and auditing standards for large databases. And running DR Environments (Standby, ADG).

·        Solid understanding of Database, Performance tuning in AWS

·        Experience in Oracle/Teradata is a plus.

·        Familiarity with Big Data (Hadoop) systems is an added advantage.

·        Strong verbal & written communication and excellent analytical & problem-solving skills are mandatory

 

Interview Process (Is face to face required?): No

Minimum years of experience: 08+ Years

Certifications Needed: No

 

If this job/position is not suitable to you, please refer a candidate and earn a referral bonus. Vedainfo Referral Program is one of the best in the industry! Contact us for more details. 

  

Thanks, 

Matt Adams 

Technical Recruiter 

VEDAINFO INC. 

Office: 310-929-1190 EXT: 156 

Direct: -+1 310-929-1190 

E-Mail: Matt@us.vedainfo.com

California 

3868 W Carson Street, 

Suite 204, Torrance, CA 90503

Company Name | Website
Facebook  Twitter  Pinterest  

No comments:

Post a Comment