IDC Technologies: Redshift Administrator

Monday, 24 April 2023

Redshift Administrator | AWS cloud @ Chicago, IL

NOTE: NO OPT, CPT VISA'S

Hello,

My name is Anusha 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: Chicago, IL

Client: Impetus

Contract duration: 06+ Months

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: 6+ Years

Certifications Needed: No

Warm regards,

Anusha S

Technical Recruiter

Office: 310-929-1616 EXT: 112