AWS Administrator

Job Description

This is a strong technology and support service delivery & operations role, accountable for installation, configuration and administration of the AWS REDSHIFT PLATFORM DBA, user management tickets and all other 24 x 7 support and maintenance operations L1 / L2 / L3 activities.

As a database administrator, you will work with diverse data analytics technologies on the cloud. Technical Responsibilities include deploying, managing, and operating scalable, highly available, and fault-tolerant databases on AWS. Strong verbal and written communication skills with ability to articulate results and issues to internal and client teams. Proven ability to work creatively and analytically in a problem-solving environment.

Responsibilities
• 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 modeling 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.

Required Skills
• Bachelors or/and Master degree in computer science or related discipline
• Strong analytical skills and enjoys solving complex technical problems.
• 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.

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.

Qualification
• B.E/B. Tech/Masters in Computer Science, Electronics, relevant technical certification