Senior Associate Database Administrator at Datavail Career Site

Mumbai, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

24 Jun, 26

Salary

0.0

Posted On

26 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Aws Admin, Sql, Plsql/Tsql, Dbt, Redshift Cluster Management, User Access Management, Snapshot Creation, Query Workload Monitoring, Cloudwatch Monitoring, Data Loading/Unloading, Redshift Data-shares, Aws Glue/Athena, Aws Mdc Task Management, Confluent Kafka, Aws Msk, Linux Administration

Industry

IT Services and IT Consulting

Description

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. Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner.

Responsibilities

The role involves configuring and managing Redshift clusters, handling data loading/unloading to S3, and creating/managing Redshift Data-shares for secure data distribution. Responsibilities also include deploying, configuring, and monitoring Confluent Kafka clusters and performing system administration tasks in Linux environments.