Description
Skill - Postgress-L1
Location- Mumbai - BKC
6 days, Support time - 24
Notice period – Immediate joiner.
Skills Required for Postgres L1
Installation of PostgreSQL on Linux-based systems using RPM, APT, or source (versions 9.6, 10 ,11, 12 etc.)
Perform initial configuration (e.g., postgresql.conf, pg_hba.conf) based on environment requirements.
Creation of databases and configuration of rules in PG hba.conf file.
Creation of users and assigning roles & permissions to the users.
Performed Database Cloning and refresh on to Test environment using pg_dump and cold backup methods.
Regularly Monitoring Alert log
Monitoring and maintaining DB's for their Optimal Performance and ensuring availability of the DB's.
Analyze the logs daily and fix any Postgres issues reported in the logs
Performing backups using SQL dump Utilities ( PG Dump) and PG Base backup utilities.
Experience in taking regular Backups.
Knowledge on Restore / Recover of cluster databases.
Experience on upgrade of Postgres databases.
Experience in setting up Streaming replication.
Experience to configure PG Badger
Note- Male candidates are preferred.
Skills Required
Backup Recovery, Performance Tuning, Database Security, Data Modeling, Query Analysis, Monitoring Tools, Shell Scripting, Postgres Sql
Dba • Navi Mumbai, Mumbai City, Mumbai