Redshift Admin

2 months ago


Noida Sector, India Wipro Digital Operations and Platforms Full time

Exp 5 to 8 yrsLocation Noida, Gurgaon, Mumbai, ChennaiNotice Immediate to 30 daysJob Details: Expertise in DB admin activities on AWS services like Redshift, RDS.Responsible for the maintenance, configuration, and operation of AWS Redshift/RDS databases. This includes monitoring database performance, implementing changes, maintaining data security and integrity.Excellent working knowledge of version control system like GitHub and branching strategies. Expertise in CICD process of Redshift deployment of schemas.Monitor database performance, implement changes, and apply new patches and versions.Perform and manage backup, recovery, and migration tasks.Work in close coordination with data engineers/developers to optimize their queries, data loads, suggest best practices.Prepare and maintain documentation and standards related to database administration.Excellent troubleshooting and problem-solving skills with query editor v2, authentication & authorization, application connectivity, query monitoring, query performance, Redshift maintenance tasks, backup and restore, database issues, perform tuning and performance monitoring.User, Roles, Schemas Provisioning through CICD for RDS.Automation of AD user access to RDS using bash scripts.Communicate effectively and concisely with multiple stakeholders.Self-motivated, can work in high pace environment with little to zero guidance.Well versed with security and compliance aspects in Cloud.Good to have AWS Certified Database Specialty certification.