Lead Administrator
Installed, upgraded, configured and tuned MySQL, PostgreSQL, Oracle and Cassandra database systems and all associated middle-ware applications in LINUX and Windows environmentsAdministered, supported and monitored databases by proactively resolving database issues and maintaining serversPlanned and implemented security measures to safeguard vital business dataManaged systems and infrastructures by defining hardware requirements and planning storage capacity for PostgreSQL, MySQL and Oracle databasesExpertise in monitoring and analyzing memory, CPU utilization, disk utilization, locks, deadlocks, queries execution time and its optimization, also familiar to analyze the database queries and indexingCreated and implemented database designs and data modelsDatabase Log shipping and Replication configuration and managementIdentified new ideas, products and/or features that improved customer satisfaction, reduced costs and kept product line in forefront of industryEnhanced availability of infrastructure through enterprise-wide planning, thorough testing, efficient implementation and comprehensive supportOptimized system security and performance with proactive changes such as server hardening and up-gradations and patch deployment.Troubleshoot performance problems, fine-tuning of databases and index Analysis. PostgreSQL database administration including Streaming Replication and Log Replication.Knowledge in handling HP Monitoring Tools (HP Sitescope, HP NNMI). Administrating Disaster Recovery Management BCP Suite IBM Sanovi DRM tool and periodic drill executions were carried out.Handling HPE Data Protector Backup administration and restoration.Managed HPE 3par Storeserv 10800 Storage Administration.