I will be postgresql dba to install, optimize, replicate, cluster, backup, pgpooling

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

1. PostgreSQL installation, configuration in any OS.
2. Database User creation, privilege assigning, role segregation.
3. SQL Query writing
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 explalin plan
• DB Parameter Tuning for proper usage of RAM (Less Usage, no Swapping) and DISK (Less I/O)
• Proper Indexing for soft parsing

Advanced Services:

1. PostgreSQL Database replication i.e. 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 DB Support on Monthly Basis - Starts from $80

NOTE: PLEASE DISCUSS on INBOX BEFORE ORDERING CUSTOM REQUIREMENTS.