Datavail Infotech

7 days ago

Hyderabad, India Datavail Full time

About the Role :


We are seeking an experienced Senior Associate Database Administrator with deep expertise in PostgreSQL (Open Source & EDB) and hands-on experience across multi-cloud environments (AWS, Azure, GCP). The ideal candidate will have a proven track record of managing mission-critical databases, architecting high-availability solutions, executing performance tuning, and delivering robust backup and recovery strategies. You will be part of Datavails Global PostgreSQL Practice, working with diverse clients, complex architectures, and cutting-edge cloud technologies.

Key Responsibilities Administration & Architecture :


- Administer, configure, and maintain PostgreSQL databases (Open Source and EDB PostgreSQL) across on-premises and cloud (AWS RDS & Aurora, Microsoft Azure Database for PostgreSQL, GCP).

- Perform database installation using source code, RPM packages, and one-click deployment methods.

- Architect and implement high availability and disaster recovery strategies, including replication (streaming, cascading), failover, and DR servers.

- Configure and manage load balancing using pgpool.

Backup, Recovery & Upgrades :


- Design and execute logical and physical backup strategies using BARMAN, pgbackrest, and native PostgreSQL tools.

- Implement and test Point-in-Time Recovery (PITR) and restore strategies (pg_restore, pg_dump, pg_upgrade).

- Manage version upgrades (major & minor) with zero or minimal downtime.

- Apply database patches and security updates in a controlled, documented manner.

Performance Monitoring & Tuning :


- Monitor database health using pgAdmin, pgbadger, pgbouncer, and custom scripts.

- Optimize database parameters for maximum performance and stability.

- Investigate and resolve performance bottlenecks, query tuning, and resource utilization issues.

- Configure query analytics in Azure Query Store and set up performance dashboards.

Cloud & Cross-Platform Integration :


- Provision and manage AWS Aurora PostgreSQL clusters, configure read replicas, and tune parameter groups.


- Integrate PostgreSQL logs with AWS S3 and Azure Log Analytics for centralized monitoring.

- Configure heterogeneous database connections between Oracle and PostgreSQL.

- Execute and lead Oracle-to-PostgreSQL migrations using migration tools and custom scripts.

Automation & Scripting :


- Develop shell scripts for automated backups, maintenance tasks, and monitoring alerts.

- Automate routine DBA operations to improve efficiency and reliability.

- Implement proactive monitoring and self-healing scripts for database & Security :


- Diagnose and resolve database corruption issues and unexpected failures.

- Implement and enforce security best practices, including user access control, tablespace management, and encryption.

- Maintain compliance with organizational and industry security standards.

Required Skills & Tools :


- PostgreSQL Core & EDB PostgreSQL Architecture, replication, backup & recovery.

- Monitoring & Administration Tools pgAdmin, pgbadger, pgbouncer, pg_repack, repmgr.

- Backup & DR Tools BARMAN, pgbackrest.

- Cloud Platforms AWS (RDS, Aurora), Azure (PostgreSQL, Query Store), GCP (PostgreSQL).

- Performance & Tuning Query optimization, parameter tuning, connection pooling.

- Scripting Strong in Linux shell scripting for automation.

- Migration Expertise Oracle-to-PostgreSQL migration strategies and execution.


(ref:hirist.tech)

  • Datavail Infotech

    5 days ago

    Hyderabad, India Datavail Full time

    Job Description :Title : Oracle Cloud HCM Functional ConsultantLocation : HYD/MUM/BANGEducation : Any DegreeExp Level : 5 - 8+ YearsRoles and Responsibilities :- 5+ years in HCM Cloud functional support experience- Support experience in handling tickets / issues related to Core HR, Payroll and at least couple of other HCM modules- Excellent business...

  • Datavail Infotech

    1 week ago

    Hyderabad, India Datavail Full time

    Title : Principal Consultant Oracle Cloud HCM Technical Consultant. Location : Hyderabad/Mumbai/Bangalore. Education : Any Degree.Responsibilities : - Deliver the technical components related to implementation, upgrade, and maintenance of the Oracle HCM Cloud systems. - Develop HCM Extracts for reporting, analysis and integration with other systems. -...

  • Datavail Infotech

    14 hours ago

    Hyderabad, India Datavail Full time

    Job Description : : Oracle Cloud PPM Functional Location : HYD/MUM/BANG Exp Level : 10+ Years Roles and Responsibilities : - Lead the day-to-day activities of PPM cloud modules including process design, implementation lifecycle support, and project reviews. - Implementation experience with Project Accounting, Project Billing, Project Costing, Grants. -...

  • Datavail Infotech

    1 week ago

    Hyderabad, India Datavail Full time

    Job Description : Principal Consultant Oracle Cloud HCM Technical ConsultantLocation : : Any DegreeResponsibilities :- Deliver the technical components related to implementation, upgrade, and maintenance of the Oracle HCM Cloud systems.- Develop HCM Extracts for reporting, analysis and integration with other systems.- Develop Reports using BI...

  • Datavail Infotech

    5 days ago

    Hyderabad, India Datavail Full time

    JOB DESCRIPTION : We are looking for an experienced Oracle Hyperion Infra + Functional Techno-Admin who can manage Hyperion infrastructure while also having functional/technical & Migration knowledge of Hyperion applications. The role combines environment administration, performance tuning, upgrades, and integrations with functional support for Planning,...

  • Datavail Infotech

    14 hours ago

    Hyderabad, India Datavail Full time

    About Us :Datavail is a global leader in data management, application development, analytics, and cloud services. With over 1,000 professionals worldwide, we empower organizations to innovate, optimize, and scale through technology. As an AWS Advanced Tier Consulting Partner, Microsoft Solutions Partner, Oracle Partner, and MySQL Partner, we bring deep...

  • Datavail Infotech

    7 days ago

    Hyderabad, India Datavail Full time

    About the Role : We are seeking an experienced Principal Consultant specializing in Oracle E-Business Suite (EBS) Upgrade Testing and Oracle Cloud Supply Chain Management (SCM) Testing. The ideal candidate will have a proven track record in end-to-end functional testing across multiple implementation projects, with a deep understanding of SCM business...

  • Infotech - Principal Consultant - Oracle HCM Module

    3 weeks ago

    Hyderabad, Telangana, India Datavail Full time

    Job Description : Principal Consultant Oracle Cloud HCM Technical ConsultantLocation : : Any DegreeResponsibilities :- Deliver the technical components related to implementation, upgrade, and maintenance of the Oracle HCM Cloud systems.- Develop HCM Extracts for reporting, analysis and integration with other systems.- Develop Reports using BI...

  • Datavail Infotech

    16 hours ago

    Hyderabad, India Datavail Full time

    About the Role :We are seeking an experienced Oracle Cloud SCM Functional Support Consultant with strong expertise in Supply Chain Management processes and hands-on support experience in Oracle SCM Cloud applications. This role will be part of our Enterprise Applications Cloud ERP practice at Datavail, providing mission-critical functional support for global...

  • Datavail Infotech

    5 days ago

    Hyderabad, India Datavail Full time

    Role Overview : The Service Desk Manager will lead the IT Service Desk function, ensuring operational excellence, continuous improvement, and superior end-user support. This role will oversee all Level 1 and Level 2 support teams, manage ServiceNow ITSM modules, and act as the key owner of incident management, request fulfillment, knowledge management, and...