PostgreSQL

Role - PL / SQL Developer

Location -

Experience - 4 to 10 yrs

Postgres SQL performance tuning expert.

1. Should know the PostgreSQL database and working experience as well.

2. Managed and supported a large PostgreSQL database with over 10 TB of data, including backups, restores, monitoring, and performance tuning.

3. In Performance tuning -Constraints creations, Indexes creation & analysis, VACUUM, AUTOVCUUM parameter setup & enabling, explain plan analysis, Server-side parameter setup, SQL query re-writing, bloating monitoring.

4. It is good to have GCP basic understanding and Cloud SQL knowledge.

5. Should have basic understanding of Oracle PL / SQL databases like TABLES,VIEWS,PROCEDURES, FUNCTIONS,PACKAGES, INDEXES,TRIGGERS, MV's.

6. Should work independently if required.

7. Eager to learn new concepts, functionalities in PostgreSQL and able to resolve issue independently.