Database Admin - Amazon Redshift

Tek-analytix

7 - 10 years

10 - 14 Lacs

Pune

Posted:2 days ago| Platform:

Apply

Skills Required

Performance tuning Automation Linux Database design Debugging Database administration Windows Resource management SQL Python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Key Result Areas and Activities:

Design and Development: Design, implement, and manage Redshift clusters for high availability, performance, and security.
Performance Optimization: Monitor and optimize database performance, including query tuning and resource management.
Backup and Recovery: Develop and maintain database backup and recovery strategies.
Security Enforcement: Implement and enforce database security policies and procedures.
Cost-Performance Balance: Ensure an optimal balance between cost and performance.
Collaboration with Development Teams: Work with development teams to design and optimize database schemas and queries.
Perform database migrations, upgrades, and patching.
Issue Resolution: Troubleshoot and resolve database-related issues, providing support to development and operations teams.
Automate routine database tasks using scripting languages and tools.

Must-Have:

Strong understanding of database design, performance tuning, and optimization techniques
Proficiency in SQL and experience with database scripting languages (e.g., Python, Shell)
Experience with database backup and recovery, security, and high availability solutions
Familiarity with AWS services and tools, including S3, EC2, IAM, and CloudWatch
Operating System - Any flavor of Linux, Windows
Core Redshift Administration Skills -Cluster Management, Performance Optimization, workload management (WLM), vacuuming/analyzing tables for optimal performance, IAM policies, role[1]based access control, Backup & Recovery, automated backups, and restoration strategies.
SQL Query Optimization, distribution keys, sort keys, and compression encoding
Knowledge of COPY and UNLOAD commands, S3 integration, and best practices for bulk data loading
Scripting & Automation for automating routine DBA tasks
Expertise in debugging slow queries, troubleshooting system tables

More Jobs at Tek-analytix

Sr. Business Analyst - Automation Specialist

Nagpur

6 - 11 yrs

INR 9 - 14 Lacs

Full Stack Engineer

Pune

6 - 9 yrs

INR 9 - 13 Lacs

Azure Synapse Data Engineer

Pune

3.0 - 8.0 yrs

INR 8 - 12 Lacs

Sr. Data Engineer - Azure Synapse

Pune

7.0 - 12.0 yrs

INR 10 - 15 Lacs

Agile Coach

Pune

10.0 - 14.0 yrs

INR 14 - 19 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.