Database Administrator

Gruppozenit; Thiruvananthapuram; On-site; INR 600,000 - 800,000; Full time

Job summary

A leading tech firm in Thiruvananthapuram is seeking experienced professionals for Level 2 support in incident and problem management. Candidates should have expertise in PostgreSQL database performance optimization, installation, and configuration. This role requires at least 3-5 years of DBA IT experience. The ideal candidate will demonstrate strong analytical skills and teamwork abilities, ensuring the smooth execution and maintenance of database operations.

Qualifications

• 3-5 years of DBA IT experience required.
• Strong analytical skills and problem-solving abilities.
• Experience with database migration and upgrades.

Responsibilities

• Provide L2 support on incident and problem management.
• Optimize performance of PostgreSQL database.
• Conduct PostgreSQL database security audits.

Skills

Incident management

Problem management

PostgreSQL DB tuning

Database security management

Linux environments

Scripting in Bash

Communication and teamwork

Job description

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

Expertise (3- 5 years of DBA IT experience)

• Installation and Configuration, perform maintenance activity in database
• Database upgradations and migration
• 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
• 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.

Candidati