SUMMARY

• 7+ years senior DBA having knowledge and ability to perform all the basic database management skills of data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.
• 5+ Years of experience in PostgreSQLRDBMS with knowledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, pgbouncer, Stado and ora2pg.
• Configuring PostgreSQL Streaming Replication and Pgpool for load balancing.
• Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment.
• Managing the servers, Web Servers, Load Balancing, and Keepalived, distcache, Apache Configurations, PHP configurations and deployment of accounts.
• Extensively worked on Mmapv1&Wiredtiger storage engine. Experience in handling CRUD operations in MONGODB.
• Extensive experience in developing Map - Reduce programs and aggregation frameworks using JavaScript's.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM-AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases.
• Expert level experience in Oracle RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
• Configured Automatic Storage Management (ASM) to fulfil storage needs. Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning.
• Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
• Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals.
• Write Complex Shell Scripts that automate the Import of Reports to PostgreSQL and MySQL Databases.

PROFESSIONAL EXPERIENCE

PostgreSQL DBA

Confidential - Chicago, IL

Responsibilities:

• Working as Sr. PostgreSQL DBA and handling various duty of postgres DBA part of remote services group providing support to consulting clients for various projects for ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR activities
• Configuring and fixing the Issues with Pgadmin-III client application.
• Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
• Installing and configuring new servers as per customer's request.
• Cloning the Development, test and UAT environments with production data as per customer's request.
• Design and implement disaster recovery for the PostgreSQL Database.
• Configuring third client software pgadmin-III, phppgadmin to access the database server.
• Configuring the backup jobs on customer system. Experienced in performing PITR.
• Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.
• Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability.
• Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
• Identifying and resolving incidents and address to user problems/concerns. Trouble shooting database issues.
• Support developers for efficient SQL query and Identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup.
• Coordinating of Service Request (SR) with business team and providing them SQL queries.
• Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
• Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
• Active participant in discussions related to Backup Strategy, DC/DR architecture. Maintained, patched, and upgraded servers as required.
• Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.
• PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.
• Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
• Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.
• Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and developmentdatabases.

Environment: SOA, Mulesoft, Java, SOAP, Core Java, J2EE, Struts, JSP, jQuery, SOAP, JMS, Eclipse, JUnit, PL/SQL, HTML, SVN, CVS, JIRA (defect-tracking tool), BMC Remedy Tool, JavaScript, Servlets, Windows XP.

PostgreSQL DBA

Confidential - Lowell, AR

Responsibilities:

• Ability to proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
• Technical mentor and helping technically to internally Greenplum Global support team.
• Worked on end to end application level performance tuning re designing data models, Choosing proper distribution keys rewrite Greenplum function code.
• Interacting with development, Testing, and release teams, providing recommendations, driving standards for effective Greenplum production operations.
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore.
• Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
• Ability to thrive in a fast-paced, deadline-sensitive environment.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
• Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Experience in code migration, database change management through various stages of development life cycle.
• Providing response for all system / database issues on 24 x 7 Schedule responding to critical events and situations outside normal work hours.
• Work with development and operations teams to tune production queries for optimal performance.
• Implement and monitor replication for high availability and disaster recovery scenarios.Review new database schema changes.
• Monitor and manage database indexes for optimal performance.Automate the configuration management of database and Big Data systems.
• Performing schema management, database sizing, maintaining privileges.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
• Daily log analysis using pgbadger tool and query tuning.
• Maintaining custom vacuum strategies at table and db level.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
• Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.

ENVIRONMENT: Oracle 11g, 10g, Linux, Solaris, Shell scripting, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA

PostgreSQL DBA

Confidential - Seattle, WA

Responsibilities:

• 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)
• Controlling migrations of programs, data base changes, reference data changes and menu changes through the development life cycle.
• Setup and maintenance of Postgres master-slave clusters utilizing streaming replication. Cross-datacenter disaster recovery and backup architecture
• Performing schema management, database sizing, maintaining privileges.Data migration while upgrading database versions ranging from 8.2 to 9.5.
• Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
• Installing pivotal-support packages to monitor performance like (gpsupport and mem watcher.. etc)
• Fixing the memory issues and suggesting the best practices.
• Responsible for monitoring environments using monitoring tool viz. Nagios, Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
• Installing and configuring new servers as per customer's request.Performance monitoring and optimization
• Installing 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.
• Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Maintaining custom vacuum strategies at table and DB level.
• Query optimization and troubleshooting.
• Troubleshoots with problems regarding the databases, applications and development tools.
• Close collaboration with engineering on schema additions and updates utilizing Liquibase

ENVIRONMENT: Oracle 11g, 10g, Golden Gate, Linux, Solaris, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, ADDM, RAC, Expdp and Impdp, IPMon, JIRA.

Linux Administrator

Confidential

Responsibilities:

• 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)
• Controlling migrations of programs, data base changes, reference data changes and menu changes through the development life cycle.
• Setup and maintenance of Postgres master-slave clusters utilizing streaming replication
• Cross-datacenter disaster recovery and backup architecture
• Performing schema management, database sizing, maintaining privileges.
• Data migration while upgrading database versions ranging from 8.2 to 9.5.
• Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
• Installing 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.
• Single Point of Contact for technical support, application support, users and help desk personnel of all applications.
• Expertise in writing Shell Scripts.Conducted Linux administration activities and managed test databases.
• Evaluated database performance and executed table maintenance processes. Maintaining documentation and standards for Database.
• Support developers for efficient SQL query and Identifying long running queries and optimizing.
• Setup/Maintenance of Test/Development/UAT Servers setup
• Coordinating of Service Request (SR) with business team and providing them SQL queries.
• Query optimization and troubleshooting.
• Troubleshoots with problems regarding the databases, applications and development tools.

ENVIRONMENT: Oracle 8i, 9i and 10g, Sybase, Sun Solaris, HP-UX, Windows 2003, SQL Server, Sybase, RMAN, Dataguard, SQL/PL-SQL, HTML, STATSPACK, Erwin

Linux Admin

Confidential

Responsibilities:

• Administered, maintained Red Hat 3.0, 4.0, 5.0, 6.0 AS, ES, Troubleshooting Hardware, Operating System Application & Network problems and performance issues; Deployed latest patches for, Linux and Application servers, Performed Red Hat Linux Kernel Tuning.
• Involved in troubleshooting of Red Hat Linux server issues and hardware issues and replacements.
• Applying patches on Linux machines and package management using RPM and YUM.
• Maintained the Bash Shell and Python scripts for the automation purposes.
• User and Group administration, maintain User & File System quota on Red Hat Linux.
• Responsibilities include installation, configuration and management of PostgreSQL and MySQL database servers.
• Installed and configured Nagios monitoring tool to manage infrastructure.
• Worked on Applying patches, installed monitoring tools, and upgraded BIOS on HPC Clusters.
• Building & configuring Red Hat Linux systems over the network, implementing automated tasks through Crontab, resolving tickets according to the priority basis using JIRA