Job Title: Senior Associate Database Administrator
Education: BE\B.Tech or equivalent
Experience: 5+ Years
Location: Mumbai
Key Skills: AWS Admin, SQL, PLSQL/TSQL, DBT
Required Skills:
Configure & Manage Redshift cluster in production and non-production environments.
Managing the users access for Prod and Non-Prod environments.
Creating Snapshot for backup and recovery.
Monitoring the query workload.
Managing cloud watch for alarm monitoring.
Load and unload data to S3 Bucket and database as per user requirement. (Data refresh activity).
Create and manage Redshift Data-shares for secure data distribution across accounts and clusters.
Build and maintain external schemas using AWS Glue/Athena, including external tables.
Managing AWS MDC task (QA, STAGE& PROD).
Participate in Production deployment.
Working on Confluent Kafka & AWS Managed Streaming for Apache Kafka (MSK).
Deploy, configure, and operate Confluent Kafka clusters (on-prem).
Monitoring Kafka services on Dev,stage,& Prod environments.
Troubleshooting the error with the help of support team.
Upgrading the confluent Kafka & troubleshooting the error post upgrade.
Support for Reltio as per user requirement.
Work extensively on Linux environments for system administration, troubleshooting, and operations.
Create and maintain Shell scripts.
Build automated jobs using cron.
