Redshift Database Administrator

3 weeks ago

Pune, Maharashtra, India WorkiFicient Full time

Must-haves :

- Overall exp. Of 7 to 10 yrs.

- Redshift administration (key role,5 years experience with redshift)

- Data Migration / Sync specifically DATA UNLOAD, COPY

- Deployments

- Tuning / Optimization

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 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

(ref:hirist.tech)

  • Highly Skilled Redshift Expert Wanted

    17 hours ago

    Pune, Maharashtra, India beBeeRedshiftEngineer Full time ₹ 1,00,00,000 - ₹ 1,50,00,000

    Senior Redshift Engineer OpportunityLocation: Remote (Within India)Contract Duration: 6 months (extendable)At a leading provider of top-tier talent, we specialize in delivering specialized professionals across enterprise platforms. We are looking for a highly skilled Senior Redshift Engineer to support our clients in architecting, optimizing, and scaling AWS...

  • Senior Database administration

    2 weeks ago

    Pune, Maharashtra, India Aera Technology Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Aera Technology is the Decision Intelligence company. We deliver innovation and services that enable enterprises to operate sustainably, intelligently, and efficiently. Our platform, Aera Decision Cloud, integrates with your existing systems to digitize, augment, and automate decisions in real time. Aera helps enterprises around the world transform decision...

  • Oracle Database Professional

    18 hours ago

    Pune, Maharashtra, India beBeeDatabase Full time ₹ 9,00,000 - ₹ 12,00,000

    Job Title: Oracle Database Administrator with AWS ExperienceThis is a unique opportunity to work as a skilled Oracle Database Administrator with experience in AWS. We are looking for a highly motivated and experienced professional to join our team.Job DescriptionWe are seeking an Oracle Database Administrator to support the development and implementation of...

  • Database Administrator Position

    1 day ago

    Pune, Maharashtra, India beBeeDatabase Full time ₹ 9,00,000 - ₹ 12,00,000

    Database Administrator OpportunityWe are seeking a skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for the day-to-day administration of our database systems.Responsibilities:Administer and maintain various databases, ensuring optimal performance and reliability.Develop and implement scripts to...

  • Database Administrator

    1 day ago

    Pune, Maharashtra, India beBeeDatabase Full time

    Job Title: Database SpecialistTeamware Solutions is seeking a skilled professional for the IT IS_AMS_Database_MS SQL Server role. This position is crucial for ensuring the stability, performance, and availability of our Microsoft SQL Server databases within an Application Management Services (AMS) environment.You'll work with relevant technologies, ensuring...

  • System Database Administrator

    3 days ago

    Pune, Maharashtra, India beBeeDatabaseAdministrator Full time ₹ 8,00,000 - ₹ 12,00,000

    Job Title: System Database AdministratorWe are seeking a skilled and experienced System Database Administrator to join our team. The ideal candidate will have a strong background in database administration, including experience with Windows NLB and clustering.Database AdministrationWindows NLB and ClusteringAntivirus Management ToolsScripting...

  • Database Administrator

    20 hours ago

    Pune, Maharashtra, India beBeeDatabase Full time ₹ 20,00,000 - ₹ 30,00,000

    About the Job">Looking for a skilled professional to manage and safeguard our databases. We require a highly skilled PostgreSQL Database Administrator who can ensure performance, security, and integrity of our databases.">The ideal candidate will be responsible for database design, implementation, and maintenance, as well as planning and development of the...

  • Database Administrator

    2 weeks ago

    Pune, Maharashtra, India Pratiti Technologies Full time

    Job DescriptionWe are seeking a proactive and experienced Database Administrator to manage our database infrastructure. In this role, you will be responsible for the day-to-day operations of our database systems, with a strong focus on performance optimization, troubleshooting, and strategic migration projects. The ideal candidate has deep expertise in SQL...

  • Greenplum Database Administrator

    3 weeks ago

    Pune, Maharashtra, India TESTQ Technologies Limited Full time

    Role : Greenplum Database AdministratorLocation : Pune, Maharashtra, IndiaPosition Type : Fixed Term Contract (FTC)Experience Level : 5+ YearsAbout the Role : We are hiring a Greenplum Database Administrator to manage and optimize Greenplum clusters. You will handle maintenance, backups, performance tuning, and ensure the stability of production...

  • Database Administrator

    1 week ago

    Pune, Maharashtra, India Global Payments Inc. Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Every day, Global Payments makes it possible for millions of people to move money between buyers and sellers using our payments solutions for credit, debit, prepaid and merchant services.  Our worldwide team helps over 3 million companies, more than 1,300 financial institutions and over 600 million cardholders grow with confidence and achieve amazing...