SUMMARY

• Senior database administrator with over 5 years of involvement with building, provisioning, and supporting next - generation RDBMS solutions.
• I worked on PostgreSQL and Oracle databases, but also MySQL and SQL Server databases. I have hands-on experience in Installation, Configuration, Upgrades and Patch, Migration, Database Refresh, Backup and Recovery, Cloning, Replication, Database Security, Data guard, Memory Management, Data Modeling, and Performance Tuning.
• Excellent analytical and problem-solving skills.
• A dedicated team player who can effectively collaborate with diverse teams across the organization.

TECHNICAL SKILLS

INSTALLATIONS/DESIGN/PATCHING: Hands on in Design, Upgrade, Patch management, Migration, Database Refresh, Cloning Configurations in OLTP as well as OLAP environments

BACKUP AND RECOVERY: Pg dump, Pg dumpall, Backup and Recovery plan with RMAN for VLDB Oracle Databases and Applications. Installed Oracle Data Guard database and RAC on Amazon cloud and Oracle on Demand as part of the DR Strategy. Worked extensively on Cloning /Duplicate of databases using RMAN.

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

RDBMS: PostgreSQL from 9.6, 10, 11 Oracle 10g, 11g, 12c, Microsoft SQL Server

Languages: Shell scripting, PL/PGSQL, python, java

Tools: Pg/PLSQL, SQL*Plus, PGADMIN4, PGBADGER, PGBOUNCER, PGHERO, PGPASS PGBACKREST, BART, EFM DBCA, PEM, Toad, OEM Grid, RMAN, MTK, Orapg2, SQL*Loader, Exp/Imp/Data Pump, Log miner, Stats pack/AWR, DBCA, DBUA, ADDM, TOAD 9.6+, AWS DMS, AWS SCT. JIRA, CRONTAB, SHELL, BASH SCRIPTING

PROFESSIONAL EXPERIENCE

PostgreSQL DBA

Confidential, Columbus, OH

Responsibilities:

• Install and configure servers for PostgreSQL versions 9.7,10.7 and 11.4 on both Windows and UNIX platforms
• Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.
• Experience with EDB and community PostgreSQL
• Configure REPLICATION between MASTER and SLAVE, and monitor replication daily.
• Exposed to cross platform migrations Oracle to PostgreSQL where I documented and assisted during migration from ORACLE Databases to PostgreSQL database in AWS Cloud.
• Configured PgBouncer for connection pooling and PgBadger for generating statistical reports.
• Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg basebackup and Pg backrest and Pg dumpall and Pg dump for logical backups
• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.
• Support daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on UNIX/Linux and AWS Console (Database sizes range 50GB to 25TB)
• Implement table and index partitioning to improve query speed.
• Monitor CPU utilization, memory, Database Connections and storage space daily using pg stat activity, PEM, Pg view and AWS CloudWatch alarms. Also use custom shell scripts deployed on crontab to monitor performance and resources.
• Clone databases for development/testing environments.
• Backup databases using pg dump cluster Backup as well as.
• Experience in installation, and creating Hot streaming replication.
• Experience and maintained standby database switch over/Failover
• Daily logs revision for unusual events and performance issues and took appropriate action according to company policies and incident reports.
• Experience reorganization of tables and indexes within databases when needed
• Perform PL/PGSQL errors fixes for application issues.
• Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
• Participate in capacity planning meetings to meet the demands of the dynamic aspects of storage and memory for the databases
• Perform Database Refreshes from production environments
• Pgbench for PostgreSQL performance test
• Perform patching and upgrades of Databases using AWS minor versions upgrades, pg upgrade, pg dumpall and logical replication
• Provided Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Migrated database from Solaris to Linux with Data Pump and Golden Gate. Migrated from SQL Server / DB2 to Oracle and Oracle to SQL Server unidirectional and bidirectional using Golden Gate 11 g and 12c.

Oracle Database Administrator

Confidential, Philadelphia, PA

Responsibilities:

• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and Perl based utility “opatch”.
• Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).
• Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.
• Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a job scheduled (Cronjob).
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.
• Monitored the Applications and database using OEM.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Maintain 4 node RAC 11gr2 Standby database and DG Broker, Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Used Oracle Enterprise Manager (OEM) 11gGrid Control for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implementing Data Pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.