SUMMARY:

• To obtain a challenging position in a high quality environment where my skills will add value to the organizational operations and I would put forth the best of my knowledge towards the growth of the organization.
• Seek challenging assignments and responsibilities, with an opportunity for my growth and career advancement.
• 7+ years of experience in databases predominantly in the field of PostgreSQL and MySQL Database administration with extensive experience in handling critical Reporting Applications.
• A comprehensive working experience on operating systems like Linux, IBM AIX, Sun Solaris, and Windows.

STRENGTHS:

• Leadership Skills.
• Self - motivated.
• Positive attitude and enthusiastic in teamwork.
• Ability to work individually and in a team.

TECHNICAL SKILLS:

Databases: Postgre SQL, MySQL, Oracle

Operating System: Linux (OEL), Windows XP/7/8.

Languages: C, Java, Hibernate, STRUTS, springs, Java Script, JSP

Web Technologies: HTML.

IDE: Microsoft Visual Studio.NET 2008

Frameworks: .NET FrameWorks3.5

Programming Language: C#, .net

EXPERIENCE SUMMARY:

Confidential, Framingham, MA

Responsibilities:

• Managing 25 PostgreSQL and 5 MySQL Production Databases and their associated Non - Production Databases.
• Installation and Configuration of PostgreSQL and MySQL Software and Creating Databases.
• Provided production support to critical applications like Confidential Exchange, Service Now (Incident Management) Databases, Sales Databases, Financial Transactional Databases, and Customer Hub Databases.
• Written over 70 Shell Scripts for Health Check automation and proactive maintenance of the Infrastructure including Infrastructure (Server/DB/Storage/Network) availability and bottlenecks such as Blocking/Locking, Fragmentation, Invalid Objects and Unusable Indexes etc.
• Monitoring growth and managing space and estimation and Forecasting.
• Setup and maintenance of disaster recovery/failover solutions and Building the Standby Environments for all the Databases and Monitoring the Synchronization of Standby database with Primary.
• Handled Disasters including failover and loss of databases and storage for PostgreSQL Databases.
• Performed PostgreSQL Database Migrations across different hardware and between different systems (OS Versions and RDBMs).
• Established and Maintain Healthy Backup & Recovery Strategies and Procedures.
• Server tuning by optimizing the memory utilization and monitoring the I/O bottle-necks and IO waits.
• Handled Space Reclaim, Performance Improvement and De-fragmentation of Database Objects using VACUUM FULL and several other options.
• Enabled Logging of Slow Queries and improved performance through several maintenance tasks on PostgreSQL and MySQL Database Tables using OPTIMIZE and Table Rebuilds.
• Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts.
• Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL and MySQL Databases as requested by the Application Teams based on criticality of the Applications.
• Monitor Database Performance, CPU Utilization and Memory Resource Utilization.
• Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.
• Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.
• Managed Backups/Restore of PostgreSQL Databases using pg dump/pg restore and pg basebackup.
• Managed PITR (Point-In-Time-Recovery) during Disasters for PostgreSQL Clusters.

Confidential, Rockville, MD

Responsibilities:

• Creating and designing the Databases as per the requirements and specifics tailored to the project’s needs.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Modified most of the Queries and replaced them with Perfectly Tuned SQL’s which generates Accurate Data.
• Re-written most of Complex SQL’s to ensure best possible Execution Time for the Queries.
• Most of the Reports being generated were run through my Automated Queries for which I was recognized as the Best Analyst of the Quarter.
• Written multiple Shell Scripts that automated Backups/Recovery and Space Reclaim from all the Database Servers.
• Perform maintenance activities in strict downtime.
• Refreshing development / test database from production using pg dump and pg restore.
• Performance monitoring/tuning, space monitoring, tuning of SQL statements for optimum performance.
• Coordinating with application team and advising the development team accordingly to solve technical issues.
• Automation of Database jobs as required by the applications.
• Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.
• Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.

Confidential, Seattle, WA

Responsibilities:

• Managed 20 PostgreSQL Production Databases related to Voice-Call Analytics.
• Installation of Postgres Binaries and created several Clusters on different Ports and Servers and Created several Databases.
• Written Shell Scripts that automatically takes Full Database and Archive Backups and Archive Deletion Confidential regular intervals for all PostgreSQL Databases.
• Involved into L4 Support to resolve all the Performance Issues which cannot be resolved by L1, L2&L3.
• Worked extensively on several performance issues that act as a bottleneck for Application Teams.
• Managed Backups/Restore of PostgreSQL Databases using pg dump/pg restore and pg basebackup.
• Managed PITR (Point-In-Time-Recovery) during Disasters for PostgreSQL Clusters.
• Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts.
• Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL Databases as requested by the Application Teams based on criticality of the Applications.
• Monitor Database Performance, CPU Utilization and Memory Resource Utilization.
• Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.
• Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.
• Handling Database Migrations and Refresh Database or Schemas and Tables as requested by the Application Team.
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Deploy the Database Objects requested by the Application Team.
• Collect the Dumps generated by several reports from PostgreSQL Databases and importing to Archival Databases for Archival and Purging.
• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cronjob periodically in regular intervals.
• Written Complex Shell Scripts that automates the Import of Reports to PostgreSQL and MySQL Databases.
• Write Queries to avoid Duplicate updates and maintain Consistency.
• Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
• Write Complex SQL’s to generate the Data needed and send it to the Team.
• Update the Statistics of All the Database Objects to avoid any Performance Issues.
• Monitoring Daily Health Checks of all my PostgreSQL Databases through my automated Scripts.
• Managing Connection Issues and User Creations, Roles and Privileges of PostgreSQL Databases.
• Handled Database Switchover/Failover for PostgreSQL Databases.