Database Administrator – Redshift (Gurugram)

August 23, 2024
25000 - 30000 / month
Apply Now

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.