SUMMARY

• I am a highly motivated prof essional Postgres/Oracle D a tabase Ad ministra to r with 6 y ears of exte nsi ve kno wledge and proficienc y.
• I hav e w orked on ver y larg e produc tion databas es, perfor ming v ari ous DBA r ol es acr oss a multitud e of pla tfor ms ( LIN UX, Solaris, UN I X, AIX and Wind o ws) in p roduc tion, de vel o p ment and testing envir on ments.
• I had good exposure on cross platform migrations from Oracle to PostgreSQL .
• Proficient in database support, research, process automation, documentation, patching and upgrades, database performance tuning, backup/recovery, data migration and database security.
• I have hands on experience in HA technologies like Streaming Replication, RAC(ASM), Goldengate and, Data Guard. I a m an enthu siastic, go getter, proa ctiv e te a m pla yer wh o is fas t a t pickin g up new te chn ol ogy w i th gr eat att ention to de tail.

TECHNICAL SKILLS

• DB Migration Oracle to Postgres using MTK,ora2pg and DMS
• Experience in PostgreSQL cascading/multiple replication on PostgreSQL 10 pgbackrest,BART,pg basebackups
• Automatic/manual failover with repmgrd
• Good knowledge in PostgreSQL database architecture and Primary components.
• Upgrade from 9.3 to 9.4, 9.6,10 and changing environment server to server.
• Creating new cluster and upgrade to cluster to another postgres sever. pgbouncer
• DB Migration Oracle to AWS
• Backup and rec o ver y us i ng RMAN.
• T ranspa rent Databas e Encr ypt i on (TDE)
• ORAPKI, OWM (Oracle Wallet Manager).
• D atabas e se cur i ty.
• RMAN with Catalog/Non - Catalog
• Ex po r t/i mpo r t and Data Pu mp(EXPDP/IMPDP).
• Cross Platform Migration.
• Orac l e Data Guard /s tandb y datab ases.
• BROKER (DGMGRL).
• Oracle Database upgrades single and RAC instances (OPatch utility).
• Real Application Clusters (RAC)
• CRSCTL, SVRCTL, CLUVFY,CVU.
• Auto mat i c S to rag e M anag e ment A SM.
• D atabas e Re sourc e Manag em ent.
• Golden Gate (logdump, GGSCI).
• Orac l e Databas e r efresh (RMAN CLONING and EXPDP)
• Orac l e Databas e Chang e M an ag emen t.
• AWR rep ort ana l ys i s, ADDM, Expl a i n P l a i n, ASH, TKPROF.
• Multitenant Database.
• Database Migration with EXPDP, TTS, DATAGUARD, AND RMAN.
• SQL De vel oper.
• OEM12C AND 13C.
• SQL*Loader
• Remedy.
• SQL TUNING ADVISOR.
• SQL Ser ver.
• DBVERIFY-block corruption.
• Data Modeling ( ERstudio, DBartisan, Oracle SQL Developer Data Modeler)

PROFESSIONAL EXPERIENCE

Confidential, Pleasanton- CA

Sr Postgres DBA/ Database Engineer

Responsibilities:

• Creating and dropping schemas and users in PostgreSQL.
• Killing an unwanted and specific session in PostgreSQL.
• Logical and physical backup and recovery of all databases in PostgreSQL.
• Configured and Database installation creating tables, schemas, roles.
• Backup and Point in time recovery in PostgreSQL.
• Switch the Database from Production to Testing and Testing to Production.
• Creating Database Links from Testing to Production databases.
• Monitoring the database for Index, partitioning Memory and I/O utilization.
• EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
• Monitoring the production PostgreSQL alert logs for database errors.
• Check Alert Log errors and make necessary actions to rectify them.
• Limiting the memory space and granting the necessary roles.
• Monitor the client connectivity using pg hba.conf files.

Confidential, Buffalo - NY

Oracle/Postgres Database Administrator

Responsibilities:

• I have supported over 180 postgres servers for production, development, test and staging purposes on Linux/Unix environments.
• I’ve migrated On-Premises postgres Databases to azure with minimum downtime using DMS.
• I have installed and configured postgres servers from 9.x,10.x and 11.x
• I have moved databases, schemas, tables, globals from one server to another using pg dump .
• I have tuned the performance using top command, pg stat activity,netstat.
• I have performed DBA tasks such as database security which includes creating users,granting and revoking privileges based on the principle of least privilege.
• I have configured pgbouncer for connection pooling.
• I have created pgcrypto extensions for encryption.
• I have performed Backup and recovery using tools like pgbackrest,BART,pg basebackups.
• I have Automated tasks like backups and vacuuming using crontab.
• I can write shell scripts for dba basic tasks.
• I have Configured the file system alerts using crontab and PEM(postgres enterprise manager)
• I have configured streaming replication between a master and slave for HA.
• I have migrated data from oracle to postgres using MTK,ora2pg and DMS as well as SCT.

Confidential, WA

Oracle Support Database Administrator

Responsibilities:

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.
• Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Worked on Standardization of 12c/11g Clusterware build and DB build by preparation response files.
• Implemented Oracle Physical Standby Dataguard on multiple oracle 11g / 12c databases.
• Configured DG Broker for easy Failover/Switchover during outages and Convert to Snapshot standby during DR test every 6 months.
• Troubleshooting and fixing DG Broker configuration.
• Troubleshooting and Fixing out of sync Oracle Physical Standby Dataguard using RMAN incremental backup.
• Successfully upgraded oracle 10g(10.2) to oracle 11g(11.2), 11.3 to 12c.
• I’ve applied PSU patch quarterly.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Configure Oracle Advanced Security on 11g and 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Refreshed/cloned databases using RMAN utility.
• Performed Database upgrade from Oracle 11g and to Oracle 12c RAC database.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Involved in converting a single instance database to Oracle 11g, 12c RAC databases.