Experience in CRUD operation, security management, Replication, and shared cluster on Mongodb.

Experience in XDB Replication from oracle to Mysql to PostgreSQL.

Role & Responsibility :
• Proficiency and expertise in Postgresql Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Up-gradation of database from 9.4 to 9.5 and 9.5 to 9.6.
• Install & configure development PostgreSQL 8.1.1 and 9.0 databases on Red-Hat Linux servers/Fedora.
• Worked on Replication and Log shipping for Postgresql Server High Availability
• Coding of new tables, views and modifications as well as SQL Stored Procedures, Data Types, Triggers and Constraints
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Monitoring tools and create partition to manage data’s separate.
• Knowledge in Application Performance Tuning and Database Design(ERVIN).
• Handling Memory configurations for database servers.
• Backup and Point in time recovery in PostgreSQL.
• Creating child partitions tables for every month in PostgreSQL
• EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
• Monitoring the production PostgreSQL alert logs for database errors.
• Check Log errors and make necessary actions to rectify them.
• Prepare weekly and monthly reports on database health check and growth.
• Creating Database Links from Testing to Production databases.
• Monitoring the database for Index, partitioning Memory and I/O utilization

Experience in XDB Replication from oracle to Mysql to PostgreSQL.
• Installation and Configuration of multiple PostgreSQL servers using source code or using third party tools.
• Configuration of pg-badger tool to analyze the log-file and generate the html report.
• Configuration of rep-manager tool to automate the DR configuration.
• Perform the switchover/switch back using the rep-manager tool.
• Taking physical backup using the pg_basebackup tool.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Cross-Platform Migration from windows to linux and sun-os to Mac.
• Install and Configure Backup and Recovery Tool (BART) and configure Prod and Testing Server.
• Experience in VACUUM and REINDEX in Production Database for Maintenance Activities.
• Exposure in Backup and Recovery Methods in Postgresql Server using Tools and Scripts.
• Configure and Manage Pg-pool to Load-balancing and Automatic Failover in community Version’s
• Monitor the Disk space and Database growth more than 10 Servers.
• Creating index and monitoring index using Explain Plan to make better Performance of Queries
• Exposure in EDB tool like bart,Pem,Pg-agent,pg-cleint,PPAS-10,pg_cluu,PEM-AGENT,PG-Bench.
• Monitor and manage Replication lag in Slave Environment.
• Patch Upgrade from 9.2.3 to 9.2.4 in production and Testing Environment
• 24 X 7 Production Database on Call Support.