SME - PostgreSQL (JIO)

B.E./ in Computer Science

-Must have 8 years relevant experience in PostgreSQL Core DBA Role and Responsibility

Mandatory Skills/Knowledge

Knowledge of Postgresql Architecture of versionand 15 all version

issues related to Backup and Recovery with commands. -Migration tool from Oracle to Postgresql setup.

performance troubleshooting using pgadmin commands tools like pgpool repmgr oswatcher etc

issues related Database upgrades and migrations. -Install configure and troubleshooting replication tools

issues involving Unix storage or network problem

on VCS Cluster -Knowledge on Grafana kibana will be an added advantage

and provide suggestions to applications and development teams for better design of application

database solutions and advise architecture for the database system

engaged with other infra teams to bridge the technical gaps to build consistent infra systems

10.-Advance Level cluster concepts. -Xtrabackup failure for database backup concepts

and team builder. Reliable hardworking self-motivated able to work independently or as a team member with the ability to meet deadlines. Adoption attitude based of situation.

4

Preferred Skills/Knowledge

Level knowledge of database administration and architecture.

Design Knowledge and hands on experience..

analysis and component design including detailed design and resolving design issues.

as a participant to project and application management teams to promote standards and best practices provide estimates and plan and manage database activities on deliverables.

Level knowledge in OS / Network / Storage Concepts