With over 7+ years of experience in field of data administration and development. I have great working experience in Postgres and Oracle.
Profile Summary:
Having Knowledge of PGPSQL, Triggers, Functions, Indexes, Query Writing
Query Optimization, Performance tuning
Experience in setup H.A.
Experience in setup PG POOL.
Experience in database initialization and installation and configuration setup, replication setup
Backup and Recovery Process using Pg_dump and Pg_restore, tool
Experienced in Creating Portioned Tables and Managing Partitions.
Experience on creating Linux Shell scripting.
Proficient in structured query language (SQL).
Migration from Oracle to Postgresql
User Management
My Skills:
Postgresql, Pg Pool, Oracle, Pl/SQL, PgSQL, Ora2PG, Barman Backup and Recovery, Oracle FDW