Descrizione offerta

Gruppo Zenit India Pvt Ltd subsidiary of Gruppo Zenit Srl, Italy with more than 30 years of proven success and industry experience, specializes in delivering cutting-edge Software Solutions and IT Services to a predominantly European client base.

We at Gruppo Zenit accompany organizations on their Digital Transformation journey, offering required technical expertise and delivering customized solutions that foster sustainable growth through technological innovation.

At Gruppo Zenit, we collaborate closely with our clients to generate measurable results through digital and infrastructure transformation. Our expertise covers the design and development of web and mobile applications, ERP integration solutions and IT infrastructure management. We ensure seamless project execution and provide continuous support throughout the entire application life cycle, including corrective and evolutionary maintenance services.

Job requirement

-  Level 2 support on Incident and problem management.
-  PostgreSQL DB/SQL Performance Analysis and Tuning.
-  Managing PostgreSQL Database Security Audit violations & resolving them.
-  PostgreSQL Database Installation and Configuration, Database Backup and Recovery, SQL Tuning, User maintenance, Tablespace management, Hot Standby and Replication.
-  PostgreSQL Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards.
-  Patch management and highlight teams regarding future enhancements & releases.

Expertise

-  Minimum 5 years of DBA (IT) experience.

Activities in scope

-  Installation and Configuration, Perform maintenance activity in database.
-  PostgreSQL Database upgradations and migration.
-  PostgreSQL Database reconciliation mechanisms.
-  PostgreSQL Database Migration, Upgrades to be compliant with organization standards.
-  Monitoring and optimizing the performance of the PostgreSQL database.
-  Backup and Recovery, Hot Standby and Replication, PITR and Upgradation.
-  SQL Tuning, User maintenance, Tablespace management.
-  Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy.
-  Experience in Installation and creating Hot Streaming Replication (Master and Slave).
-  Problem solving and good analytical skills. Communication, teamwork, and negotiation skills.

Preferred Skills

-   Cluster configuration, Master-Slave.
-   Backup configuration using Veeam and/or by Barman.
-   PgDump/PgDumpall and PgRestore.
-   DR Replica, by Barman or other.
-   Physical streaming replication and Logical replication.
-   Data masking and encryption.

On subject Line “Please mention the Post you are applying with Experience / Current Location.