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.

PostgreSQL and MySQL Database Administration – Hands-on experience to installing/configuring the Database servers, its replication, streaming replication etc in Linux and Windows platforms.Backup & Recover PostgreSQL and MySQL databases.Performance Tuning & Optimizing queries in Postgres & MySQL. Experience to analyze database structures, indexes, views, partitioning and data rollup strategies and stored procedures.Maintaining custom vacuum strategies for high volume databases.Monitoring and Manging various databases components (logical & physical) like tablespaces and segments.Monitoring and troubleshooting with performance related issues in databases servers.Worked in designing and managing PostgreSQL database schema's.Experience with Hot Standby (PostgreSQL (9.x and greater).Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.Troubleshoot performance problems, fine-tuning of databases and index Analysis.Linux Kernel Compilation from source and its customization for various requirements like Linux ClustersInternal backup administration of all main Linux servers.System Administration – including managing the trouble ticket queue, responding to proactive monitoring alerts, executing change controls, routine maintenance, shell scripting, performance, tuning and system diagnostics. RAID technologies for data redundancy and maintaining system uptime.Handled more than 40 servers including web and databases, vicidial, Nagios, Qmail, DMS.PostgreSQL database administration including Streaming Replication.JBoss configuration and cluster server administration.Handling the server administration including Application JBoss, Web-server (Apache, IIS).

Leading ISP providing datacenter Solutions, Server co-location, Web hosting, and Health Care IT Service provider industry for operations in United States and India.Manage Webservers like Apache, Nginx and Tomcat.Handled more than 40 servers including web and databases, vicidial,nagios,qmail,DMS.Various RAID technologies for data redundancy and maintaining system uptime.Manage mail servers like Exim , Qmail, Sendmail, Postfix.Manage DNS, FTP (vsftpd,pure/pro ftp).MySQL and Postgres Server administration – configure and monitoring the Database server replication,streaming replication etc in Linux and Windows platforms.Planning and upgrading of major and complex application and database upgrades.Co-ordination with programming divison for the application modification and bug fixing.Security management by auditing and maintaining roles,privileges, and user profiles.Worked on linux flavours like centos, redhat and also on debian servers.Worked on security tools like ClamAV, Spamassassin, Mod_security and control panel based security features.