Senior Data Engineer aws redshift

RedShift Database Administrator

JOB-TYPE: FULL TIME

LOCATION: CANADA(Remote)

Job Responsibilities

  • Seeking 8 years experience in designing setting up and administrating Amazon Redshift Data modelling physical and logical Best practices Redshift workload management data partitioning sorting security data security backup auditing key management and encryption Document and implement best practices 
  •  Redshift workload management data partitioning sorting security data security backup auditing key management and encryption
  •  Working knowledge of AWS Lake formation Experience in data replication application scalability and high availability architecture Query optimization and database tuning skills Working knowledge of one of scripting languages Python etc x
  •   UNIX shell scripting PL SQL and SQL skills Knowledge and experience with AWS offerings Aurora PostgreSQL OpenSearch EC2 S3 etc 
  •   Experience with NOSQL database MongoDB or DynamoDB AWS Data Analytics Specialty certification a plus Working knowledge of AWS Lake formation
  •    Experience in designing and implementation of Data replication application scalability and high availability architecture
  •   Experienced in Query optimization and database tuning skills Lead and implemented Backup and Disaster Recovery DR strategy for AWS and other databases with planning and execution based on RPO RTO objectives and SLAs 
  •   Working knowledge of one of scripting languages Python etc Experienced in UNIX shell scripting PL SQL and SQL skills
  •  Knowledge and experience with related AWS data offerings Aurora PostgreSQL OpenSearch EC2 S3 etc 
  •   Working Knowledge of related AWS real time streaming offerings like Kinesis or similar technology 
  • Experience with NOSQL database MongoDB or DynamoDB is a big plus AWS Data Analytics Specialty certification a plus Provide AWS Cloud Database Administration and expand utilization of Cloud based tools including Amazon Relational Database Service RDS Aurora Redshift Dynamo DB etc 
  • Automate provisioning operation monitoring and troubleshooting of the database and data lake infrastructure Automation experience leveraging solutions like Terraform Ansible 
  •  Provide consistent database maintenance optimization and best practices inputs to existing Redshift and SQL databases data lake SQL engines and applications
  • Set up operate and scale databases in the Cloud Utilize knowledge of Data Migration Data Warehouse Data Lake ETL ELT Database design implementation data provisioning scalability availability performance 
  • Collaborate with Architects and provide guidance on designing AWS
  • Cloud database solutions Deploy and Administer Data Warehouse Data Lake solutions using Amazon Web Services 
  • Capacity planning and analysis of growth patterns of data to plan for future storage requirements Develop data migration plans to migrate legacy on premises databases into AWS data stores Use knowledge of EDW Data Lake ETL ELT Relational Non Relational Databases
  • Postgres SQL etc Guide database related activities and develop strategies to improve utilization and performance Work with Data Engineering
  • Master Data Management Data Governance Machine Learning Provide guidance on Data provisioning Develop automation for repeatable processes across teams 
  • Work with cross functional teams to ensure successful delivery of features and improvements Monitor identify and resolve performance issues within AWS database technologies Lead and implement Backup and Disaster Recovery DR strategy for AWS and other databases 
  • Configure test and implement database applications Upgrade database software and apply patches Participate in DevOps activities Primary Skills Redshift Database Secondary Skills AWS

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Click the following link for more information on your rights as an Applicant - http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

Applicants for employment in the US must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in the US by Capgemini.

 

Ref:

1366538

Posted on:

May 19, 2022

Experience level:

Experienced (non-manager)

Contract type:

Permanent

Location:

Toronto

Business units:

FS

Department:

Financial Services

cookies.

By continuing to navigate on this website, you accept the use of cookies.

For more information and to change the setting of cookies on your computer, please read our Privacy Policy.

Close

Close cookie information