SUMMARY:

• I have over 6+ years experience in Database Administration, I have worked on very large production databases, performing various DBA roles across a multiple platform (LINUX, Solaris, UNIX, and Windows) in production, development and testing environments. I am a good team player, good in analytical problem - solving and the ability to work in versatile environments.
• Experienced in PostgreSQL Enterprise Edition version 10, 11, 12, Oracle 10g, 11g, 12c, 18c, 19c Multi-tenancy, Data Guard, Golden gate, RAC databases, OEM, Oracle installation, CPU patches, database Upgrades, Migration, Backup, Recovery, troubleshooting, security, Streaming Replication, Logical Replication. In PostgreSQL I have involved in configuring pgbouncer, pgbadger, pgbackRest and repMgr and I have done migration from oracle to PostgreSQL using Ora2pg and DMS/SCT.

WORK EXPERIENCE:

Confidential - Phoenix, AZ

PostgreSQL DBA

Responsibilities:

• Backup PostgreSQL databases using tools like pg dump and pg dumpall for logical backups and Refreshes, pg basebackup for physical backup, pgbackrest and restore.
• Involved in a 4 months Migration project from Oracle to PostgreSQL on premise and in AWS cloud using tools MTK, Ora2pg, AWS DMS & SCT to Migrate data/databases.
• Experience in Backup and recovery, point in time recovery (PITR), configuring the backup jobs on customer system.
• Used Ansible tool for automation.
• Checking the AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Configuring streaming replication (including cascading replication), configured a REPLICATION between MASTER and SLAVE, and monitored On-Going REPLICATION.
• Experience managing PostgreSQL in a cloud services such as AWS or Azure shell scripting for repetitive tasks and for scheduling jobs on crontab.
• Providing PRODUCTION SUPPORT based on a ticketing system.
• Performed Routine Postgres database and cluster wide maintenance activities like vacuum/vacuum full, Analyze, reindexing.
• Configured PgBouncer and pgpool for connection pooling.
• Monitored CPU utilization, memory, Database Connections and storage space daily using pg stat activity, PEM, Pg view and AWS Cloud Watch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
• Installed and configured EnterpriseDB Failover Manager (EFM) to monitor the Streaming replication.
• Setup logical Replication on a PostgreSQL Cluster to replicate specific tables and schemas, using publication and subscription.
• Used Postgres tools like pg activity, pg top, top command to monitor and tune the database.
• Installed and configured a log analyzer (Pgbadger) to generate reports for database matrices like wait event, locks, CPU consumption, error messages, database connections, idle transaction, and idle connection.
• Used EXPLAIN and EXPLAIN ANALYZE to identify and fine-tune sql queries for performance improvements.
• Extensive experience on ETL and Database Warehouse.
• Involve in 24x7 on-call support for production databases.
• Patch, Upgrade and keep the PostgreSQL DBs current using pg dump, pg restore and pg upgrade.
• Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
• Refreshing Dev and Test schema with data from Production on a regular basis.
• In security I have created security IAM user, policy, role and security groups to control access into AWS resources.
• I have managed databases running on PostgreSQL RDS, Aurora and EC2 instance
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11g to 12c.
• Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ADDM and AWR reports.
• Installation and configuration and administration of Oracle Golden Gate
• Involved in table refreshes and schema refreshes using Datapump, RMAN Duplicate.
• 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.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
• Applied critical patches to Oracle databases and application servers.
• Provided valuable inputs for various performance tuning issues. Explored 12c features by doing POC, including multi-tenant features.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprisewide targets.
• Responsible for capacity planning, database security, recovery planning and applying quaterly patches.
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g and 12c R2.
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Has experience with ansible playbook.

Confidential - Dallas, TX

PostgreSQL/Oracle DBA

Responsibilities:

• Created and maintained Databases and their objects like tables, indexes, materialized view.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like pgAdmin.
• Experience Migrating data from Oracle to PostgreSQL on premises in AWS using DMS, SCT and Ora2pg.
• Backup PostgreSQL databases using tools like pg dump and pg dumpall for logical backups and Refreshes, pg basebackup for physical backup, pgBackrest in incremental and differential backups.
• Monitor space utilization on pg wal/pg xlog, archive location and mount points.
• Implement, configure, and troubleshoot database instances, replication, backup, partitions,storage, and access. Set user privileges within and outside the database environment.
• Setup streaming replication for disaster recovery and high availability solution using repMgr.
• Experience in Backup and recovery, point in time recovery (PITR), configuring the backup jobs on customer system.
• Used Opatch utility for applying CPU and patch set Upgrade (PSU).
• Installed and implemented GoldenGate to replicate table data between databases.
• Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple enviroment.
• Oracle performance tuning support Statspack, AWR, ASH, ADDM, RMAN, Oracle Universal Installer, OPatch and Patchset.
• Supporting data-guard (10, 11 and 12c Active dataguard) for customer data service.
• Migration of database from one server to another server with zero downtime using Oracle Golden Gate.
• Implemented Data guard, creating physical standby databases in 11gRAC environment for production database.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• Implementing Datapump, conventional export/import utility of Oracle 10g, 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.
• Hands on database monitoring/maintenance, replication process and performance tuning which are done using OEM (Oracle Enterprise Manager).
• Configured Dataguard broker between the primary and standby databases, perform Switchover/Failover and monitor the Dataguard status via DGMGRL and GUI.
• Experience working with database security tools TDE, DB Vault / VPD.
• Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.