I will postgresql dba to install, optimize, replicate, migration, backup, pgpooling

In this GIG I will provide PostgreSQL Database Administration services with extensive 9+ years industry experience: 

1. PostgreSQL database installation, configuration in any OS.
2. Database User creation, privilege assigning, role segregation.
3. SQL Query writing & existing Query tuning
4. PgSQL Database health check and Overall database server Performance tuning
5. Connection pooling (session, transaction, statement) issue resolution using pgBouncer and or pgPool for Bulk incoming connection and bulk data loading optimization.
6. Slower PostgreSQL queries performance tuning with:

• SQL Query Optimization and Re Writing with explain plan
• DB Parameter Tuning for proper usage of memory(RAM) (Less Usage, no Swapping) and DISK (Less I/O uses)
• Accurate Indexing for soft parsing

Advanced Services:

1. PostgreSQL Database replication (Uni-Directional): Master-Slave, MASTER-MASTER-SLAVE using pglookout, repmgr, pglogical 
2. Clustering: repmgr, pgCluster, Patroni
3. Unlocking and Unblocking locked and blocked sessions, transactions
4. Configuring shell/batch script for daily Database backup automation with pgdump, psql, crontab

PostgreSQL database Support on Monthly Basis - Starts from $90