Job Description
Job 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.