Description

You will manage database systems across cloud and on-premises environments, focusing on design, implementation, and performance optimization.

Responsibilities

• Design, configure, and manage database systems on AWS (Redshift, EMR) and on-premises hardware like IBM Netezza or Greenplum.
• Perform core administration tasks including backup, recovery, performance tuning, and SQL optimization.
• Develop shell scripts for data loading, unloading, and routine maintenance activities.
• Implement workload management for resource allocation and manage data replication, encryption, and archiving.
• Provide 24/7/365 support via an on-call rotation to resolve issues across application, database, and network tiers.

Required Skills

• 5+ years of experience in general database administration.
• 3+ years of experience managing technologies such as IBM Netezza, Teradata, Pivotal Greenplum, or Actian ParAccel.
• 1+ years of experience with cloud database services including AWS Redshift or AWS EMR.
• Strong knowledge of the Hadoop ecosystem (YARN, MapReduce, HDFS, HBase, ZooKeeper, Hive).
• Deep understanding of Data Warehousing and MPP architecture.
• Ability to write, analyze, and optimize complex SQL queries using query plans and database statistics.
• Proficiency in Unix/Linux and shell scripting.
• Experience with SDLC, Change Management, and troubleshooting methodologies.

Education and Experience

• B.S. in Computer Science, BTECH, or equivalent work experience.

Key Skills

Education

BTECH