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.
· Partner with data engineers on query design during
projects and while performing analytics, and to analyze, troubleshoot and
optimize application and ad-hoc queries in production.
· 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.