Datavail Infotech

6 days ago

Mumbai, India Datavail Full time

Job Title : PostgreSQL Database Administrator.

Education : Any Graduation.

Experience : 8+years.

Location : Skills :

- PostgreSQL Open Source and EDB PostgreSQL.

- AWS, Microsoft Azure and GCP PostgreSQL.

- Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repack.

Job Description :


- 7+ years of relevant Experience.

- Good knowledge of PostgreSQL Database Architecture.

- Installing, configuring PostgreSQL using source code, RPM, one-click installation on-prem and Cloud Technologies.

- Strong experience in handling Database Logical and Physical Backups.

- Hands on experience on restoration techniques on PostgreSQL like pg_restore and Point in time recovery (PITR).

- Expertise in Applying database patches from lower version to higher version.

- Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg_dump/pg_restore & pg_upgrade).

- Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool.

- Expertise in Streaming Replication (Including Cascading Replication).

- Configuring pgbouncer for connection pooling.

- Configuring pgbadger for generating statistic report on the basis PostgreSQL log file.

- Handling Database corruption issues.

- Have done Oracle to PostgreSQL Migration for multiple clients.

- Strong knowledge on PostgreSQL configuration parameter for tuning the DB health.

- Managed Users and Tablespace on PostgreSQL Servers.

- Configuring Heterogeneous DB connections between Oracle, PostgreSQL.

- Expertise in Shell scripts for performing Online Backup and maintenance activity.

- Strong experience in setting up RDS & Aurora Cluster.

- Strong experience in Query Tuning and performance improvement.

- Tuning parameter group and configuring Aurora cluster for Read Replica.

- Configuring RDS & Aurora PostgreSQL Logs to push to S3 Bucket.

- Experience on Reviewing performance Metrics and query tuning on Aurora PostgreSQL.

- Configured Query Store and Analytics workspace on MS Azure Cloud.


(ref:hirist.tech)

  • Datavail Infotech

    1 week ago

    Mumbai, India Datavail Full time

    About Us : Datavail is a leading provider of data management, application development, analytics, and cloud services, with over 1,000 professionals enabling clients to design, build, and manage applications and data through a world-class tech-enabled delivery platform. With 17+ years of industry expertise, Datavail partners with AWS, Microsoft, Oracle, and...

  • Datavail Infotech

    1 week ago

    Mumbai, India Datavail Full time

    About Us : Datavail is a leading provider of data management, application development, analytics, and cloud services, with over 1,000 professionals delivering innovative technology solutions. As an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), and a partner with Oracle and MySQL, we...

  • Datavail Infotech

    1 week ago

    Mumbai, India Datavail Full time

    About the Role :We are seeking a highly skilled Data Architect with proven expertise in designing, implementing, and optimizing enterprise-scale data solutions leveraging Azure Databricks, Snowflake, and modern data engineering frameworks. The ideal candidate will combine deep technical proficiency with strong architectural vision to drive robust, scalable,...

  • Infotech - Principal Consultant - Oracle Financials

    3 weeks ago

    Mumbai, Maharashtra, India Datavail Full time

    Role Overview : We are seeking an experienced Principal Consultant - Oracle Cloud Financials to lead end-to-end implementations and provide functional expertise across Oracle ERP Cloud Financials modules. This role requires strong business acumen in finance, hands-on Oracle Cloud ERP experience, and the ability to drive successful client engagements through...

  • Infotech - Artificial Intelligence Architect - Machine Learning Models

    3 weeks ago

    Mumbai, Maharashtra, India Datavail Full time

    Job Title : AI Architect. Location : Hyd/Mum/Bang. Exp Level : 15+. Education : Any Dgree. Job Summary :- Scope out, design and oversee the architecture of AI and machine learning solutions across products and platforms for our clients.- Collaborate with team members to translate business requirements into AI-enabled solutions at either a Roadmap, Proof of...

  • Infotech - Oracle Cloud/Essbase Consultant - EPM Solutions

    3 weeks ago

    Mumbai, Maharashtra, India Datavail Full time

    Title : Oracle Cloud EPM ESSBASE Consultant. Location : : 8+ Years. Position Summary : 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...