SUMMARY

• Over 6 years of extensive experience as an Oracle/PostgreSQL database administrator in Production and Project support.
• me have knowledge and hands - on experience in database Design, Migration, Upgrades, Database Security, Backup and Recovery, Cloning, Replication, PITR, Monitoring and Tuning.
• A team player wif excellent communication skills and problem solver who can successfully manage multiple priorities while performing well under pressure.
• me is a proven leader wif motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c, 18c,19c.

PostgreSQL 9.6,10, 11,12.:

Database Tools: PGADMIN4, PGBOUNCER, PGBACKREST, REPMGR, PGBADGER, OEM Grid, RMAN, SQL*Plus, SQL*Loader, DBCA, DBUA, AWS DMS, AWS SCT.

Operating Systems: LINUX, SUN SOLARIS, CENTOS, UNIX, WINDOWS .

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Oracle/Postgre SQL Database Administrator

Responsibilities:

• Involved in Installing/configuring PostgreSQL VERSIONS 9.6 to 12.
• Championed database migration from Oracle on premises to AWS using DMS and SCT.
• Manage and monitor PostgreSQL databases using pgAdmin .
• Backup PostgreSQL databases using tools like pg BackRest for physical backup as well as pg dump and pg dumpall for logical backups and Refreshes.
• Monitor clients connectivity using PG HBA.CONF files, Postgresql.conf, and pgpass files.
• Performed Routine PostgresSQL database and cluster wide maintenance activities like autovaccum, vacuum/vacuum full and Analyze.
• Configured PgBouncer for connection pooling.
• Configured pgBadger for generating statistical reports.
• Configured Repmgr (Replication Manager) for managing replication and failover of PostgreSQL clusters.
• Configured streaming replication (including cascading replication). Configured a REPLICATION between MASTER and SLAVE, and monitored On-Going REPLICATION.
• Monitoring teh bloat report on every table and performing maintenance wif minimal downtime.
• Performing basic tasks such as objects creation; creating roles, creating users, creating tables and granting privileges.
• Implementing teh use of indexes, primary and foreign key constraints as required.
• Assisted in defining and implementing maintenance plan for teh database systems.
• Experienced in tuning PostgreSQL server and Troubleshooting performance issues.
• Managing Users and Tablespaces on PostgreSQL Servers.
• Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Used restoration Techniques like pg restore and pg BackRest for (PITR) Point In Time Recovery.
• Upgrading database versions using pg dump/pg restore and pg upgrade.
• Managing Users and Tablespaces on Oracle databases.
• Managed Oracle 12c Grid Control (OEM) for monitoring Production.
• Providing production support based on a ticketing system.
• 24X7 production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Confidential - Monroe, LA

Oracle/PostgrSQL Database Administrator

Responsibilities:

• Installed, configured, and managed PostgreSQL Version 9, 10 and 11 Enterprise edition.
• Participated and assisted in data migration from Oracle databases on premise to PostgreSQL databases in AWS Cloud using SCT and DMS.
• Configured pgadmin4 to access teh PostgreSQL server.
• Ran maintenance jobs like Auto vacuum and customized Vacuum on certain tables.
• Setup logical Replication on a PostgreSQL Cluster to replicate specific tables and schemas, using publication and subscription.
• Backup PostgreSQL databases using tools like pg basebackup, for physical backups and as well as pg dump and pg dumpall for logical backups.
• Extensive knowledge on tools like pg Badger, and pg bouncer.
• Monitor clients connectivity using PG HBA.CONF files, Postgresql.conf, and pgpass files.
• Experienced tuning PostgreSQL servers setting & troubleshooting performance issues.
• Configured Steaming Replication between teh master and teh slave and monitored teh process.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning teh users to groups and grant necessary privileges to teh relevant groups.
• Resolved locking issues, inconsistencies and assisted in batch processes.
• Setup auditing/oracle transparent data encryption (TDE) for security management.
• Scheduling Physical backups (hot/cold) in CRON tab using RMAN utility and monitoring teh scheduled jobs.
• Experience in initializing and creating PostgreSQL databases.
• Installed and configured Oracle 10g, 11g and 12c, 18c servers and created databases in Linux environments.
• Patched and Upgraded Oracle 10/11g and 12c, 18c to support internal production and test environments.
• Established and implemented backup/recovery and patch scheduling as well as exported and imported databases frequently into teh development and test environments and for archiving purposes.
• Installed and configured OEM 13c to monitor teh entire environment, from teh application servers to teh database servers.
• Configured Dataguard for high availability and disaster recovery.
• Extensive knowledge on datapump and Rman.
• Used EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Providing 24X7 production support based on a ticketing system.