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 |
No comments:
Post a Comment