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.
We are looking for experienced individuals who would like to join a dynamic team of IT service providers.
Currently we are looking for experienced candidates in providing L2 support in incident management and problem management.
 

Job Description

• Level 2 support on Incident and problem management
• PostgreSQL DB/SQL Performance Analysis and Tuning
• Managing PostgreSQL Database Security Audit violations & resolving them
• User maintenance, Tablespace management
• Monitoring and optimizing the performance of the PostgreSQL database.
• Expertise in configuring load Balancing using HAProxy, PGPool
• Patch management and highlight teams regarding future enhancements & releases
• pg_dump/pg_dumpallandpg_restore

Expertise (3- 5 years of DBA IT experience)

• Installation and Configuration, perform maintenance activity in database
• Database upgradations and migration
• Database reconciliation mechanisms
• Database Migration, Upgrades to be compliant with organization standards
• Monitoring and optimizing the performance of the PostgreSQL database.
• Database Installation and Configuration, Database Backup and Recovery
• Backup and Recovery, Hot Standby and Replication, PITR and Upgradation
• Experience in Installation and creating Hot Streaming Replication (Master and Slave)
• Problem solving and good analytical skills. Communication, teamwork, and negotiation skills
• Cluster configuration, Master-Slave
• Load Balancing using HAProxy, PGPool
• Backup configuration using Veeam and/or by Barman
• DR Replica, by Barman or other
• Physical streaming replication and Logical replication
• Data masking and encryption
• Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy
• SQL Tuning
• Hot Standby and Replication
• PostgreSQL Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards
• Strong knowledge in working on Linux environments.
• Proficiency in scripting languages such as Bash.