Aws Redshift Dba

**About Us**

“Quess IT Staffing is India’s largest IT staffing company with over 20 years of experience in staffing IT professionals in 300+ companies across levels and skillsets. Our 10,000+ associates deployed in 80+ cities and towns are proficient in over 500 technological skills. Our associates help enable cutting edge solutions some of the biggest names across industried. Quess IT Staffing is a division of Quess Corp Limited, India’s leading business services provider and largest domestic private sector employer. Quess Corp Limited is - ‘A Great Place to Work’ certified - a testament to our excellent culture, people, and processes.”

**About Company**

**Roles and Responsibility**

Job Title: AWS Redshift DBA

Experience: 5 to 6 years

Notice period: Immediate to 15 days

Location: Bangalore

JD:
Primary Responsibilities Include
- Own the architecture for the AWS Redshift clusters across all environments.
- Own the database administration of the Enterprise Data Warehouse on AWS Redshift.
- Own the architecture for our Enterprise Data Warehouse on AWS Redshift including cluster and node topology, configuration, and sizing.
- Automate provisioning, operation, monitoring and troubleshooting of the database and data lake infrastructure.
- Determine, enforce and document database policies, procedures and standards.
- Keep up to date with emerging cloud technology trends on AWS Redshift.
- Define design standards for AWS Redshift for use by development and support teams. Partner with the Data Architect to define data modelling standards.
- Provide operational management for our Enterprise Data Warehouse (EDW) in AWS Redshift across all environments, including configuration, maintenance, code migration, and incident response.
- Identify and execute cost, performance, and uptime optimizations.
- Partner with the Analysts and Business Partners on data extracts as needed.

Technical Essentials
- Expertise in Redshift Administration for managing databases, user tables, indexes, statistics, managing permissions addressing the user issues.
- Excellent and proven knowledge of AWS Redshift and SQL demonstrated through 4+ years in a Redshift DBA role.
- Excellent knowledge of related AWS technologies included Aurora, Redshift Spectrum, S3, EMR, DynamoDB and Athena.
- AWS Certification is preferred.
- Experience with generating various DB health statistics, utilization and right sizing.
- Automating the repeated DBA tasks.
- An interest and ability to learn new technologies.

Business / Soft Skills:

- Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
- Ability to communicate effectively, both verbal and written, excellent presentation skills.
- Ability to effectively move forward on tasks even with ambiguous or changing requirements.
- Ability to work in a team-oriented, collaborative environment in a global context.
- Willingness and ability to train and teach others.
- Ability to facilitate meetings and follow up with resulting action items.
- Ability to self-manage, prioritize and execute tasks in a high-pressure environment.
- Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills.
- The desire for growth and innovation, to bring rapid solutions to business challenges/opportunities.
- Strong consultancy orientation and experience, with the ability to form collaborative, productive working relationships across diverse teams and cultures is a must.
- The ability to work in a centralized/decentralized operating model, with varying implementation partners and implementation owners.