Experienced in administering and maintaining medium enterprise database servers on Linux servers.Participating in daily meetings to discuss about the new database design, modeling and creation.Installing and Configuring PostgreSQL from source or packages on Linux machines.Experience designing database structures, indexes, views, partitioning.Implementing backup and recovery (Logical and Online).Setup and maintenance of postgres master-slave clusters utilizing streaming replicationCross-datacenter disaster recovery and backup architecturePerforming schema management, database sizing, maintaining privileges.Data migration while upgrading database versions.Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater).Performance monitoring and optimizationInstalling and configuring Object level replication like Slony etc.Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.Configuring log analyzation tools like pgfouine and pgbadger etc.Removing the Index bloat Concurrently to improve the performance.Scheduled maintenance activities to vacuum, analyze to improve the query response time.Maintaining custom vacuum strategies at table and db level.
Listed skills include Database Management System, Postgresql, Microsoft Sql Server, Open Database Connectivity, and 5 others.