Nathalie E Mechela N

Oracle / PostgreSQL Database Administrator

240-***-****

adq5j4@r.postjobfree.com

SKILL SUMMARY

I have over 6+ years of hands-on experience as Database Administrator. I have extensively worked on Installing, Patching and configuring Oracle 19c, 12c and 11g and PostgreSQL 10, 11, 12, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security and Capacity Planning. Managed databases on Linux, UNIX and Windows environments. I have experience in configuring and managing Data Guard, GoldenGate and streaming replication for High Availability and disaster recovery . I Have the ability to work both as an individual contributor and as a member of a team.

● Experience in Database Administration in large-scale production environments across multiple platforms.

● Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery

● Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.

● Ability to set up a disaster recovery environment using streaming replication.

● Experience with Oracle GoldenGate maintenance and troubleshooting for High Availability and disaster recovery.

● Experience in performing Backups/Recovery using RMAN, Datapump, pg_dump,pg_dumpAll, pg_basebackup, pg_Backrest, and Flashback Technologies.

● Experience in SQL Tuning using tools like Explain Plan, AWR, ADDM, TKPROF, OEM, pg_stat_activity, pg_stat_users_tables, pg_top, pgAdmin.

● Configure pgBadger, pgAnalyse, for logs analytics.

● Experience in Database capacity planning, monitoring object growth and Storage Management.

● Experience in performing Cloning and Refreshing using RMAN, Datapump, pg_dump, pg_dumpAll.

● Experience in Partitioning Tables, Rebuilding of Indexes, Function, Rule, Materialized Views.

● Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo Segments, creation of database objects.

● Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.

● Experience in Shell Scripting for configuring monitoring alerts and automation.

● Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone

● Experience in Upgrading PostgreSQL databases using Logical Replication and pg_Upgrade.

● Experience with PostgreSQL Streaming and Logical Replication using RepMGR, maintenance and troubleshooting for High Availability.

● Experience in performing Backup schedules using Crontab.

● Experience with Oracle Migration on premise to PostgreSQL in AWS RDS using SCT and DMS.

● Experience with Oracle Database migration from EC2 to AWS RDS.

● Experience with database Migration from Oracle on premise to Azure database for PostgreSQL using ora2pg.

WORK EXPERIENCE

CTBC Bank -Edison, NJ

August 2019 – March 2022

PostgreSQL/Oracle Database Administrator

● Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.

● Fixing the memory issues and suggesting the best practices.

● Configure, monitor, and improve PostgreSQL database.

● Implemented Streaming and Logical Replication using RepMGR, maintenance and troubleshooting for High Availabily

● Performed Upgrad PostgreSQL databases using Logical Replication and pg_Upgrade.

● Responsible for monitoring environments using monitoring tools like OEM, pg_analyse, pgAdmin, pg_Badger and datadog.

● Working with data guard physical/logical standby databases.

● Performed incremental and differential backups using Recovery Manager

(RMAN).

● Created recovery catalog, performed complete and incomplete recovery using RMAN.

● Performed logicals backups and recovery using pg_dump and pg_dumpall.

● Performed physical backup using pg_basebackup and pgbackrest.

● Streamlined backup procedures using pg_dump, pg_dumpall.

● Used Data Pump for export and import. Edited scripts for Backup of databases, maintenance of archive logs for databases.

● Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.

● Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.

● Performance tuning of the database – SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM.

● Performed Migrations from oracle on premise to PostgreSQL in AWS RDS PostgreSQL using SCT and DMS.

● Performing schema management, database sizing, maintaining privileges.

● Installing and configuring connection pooling tools like Pgbouncer.

● Performed numerous ORACLE software upgrades from 11g to 12c by managing the whole process.

● Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application turning.

● Troubleshoot and maintain ORACLE Data guard environment where TBs of log shipping and application happen every day.

● Monitor Production Databases using various internal tools and custom scripts.

● Installed the Oracle software using silent features and also created databases.

● Supported & maintained the Production/Development databases on various servers

● Extensively worked on setting up auditing in many databases we supported.

● Managing Database Structure, StorageAllocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

● Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 19c Grid Control.

● Provided 24X7 support for all the production and development databases. Humana Inc - Louisville, KY

August 2016 – July 2019

Oracle / PostgreSQL Database Administrator

● Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11g..

● Configuring and fixing the Issues with Pgadmin-III client application.

● Responsible for monitoring environments using monitoring tools such as pgAnalyse, Datadog and pgBadger.

● 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.

● Configuring third client software pgadmin-III.

● Performing PITR.

● Patch, Upgrade and keep the PostgreSQL DBs current.

● Ensured that oracle database systems operate securely and efficiently.

● Managing databases from planning and testing stages through implementation and support.

● Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application turning.

● Partitioned tables Maintenance.

● Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

Involved in SQL Query tuning and provided tuning recommendations to Application jobs.

● Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.

● Implemented recovery strategies whenever required and successfully recovered databases in case database crashes, by using RMAN and pg_restore.

● Scheduling the Physical backups (hot & cold) in Crontab using RMAN utility and monitoring the scheduled jobs.

● Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and granting necessary privileges to the relevant groups.

● Used TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

● Maintained the data integrity and security using integrity constraints and database triggers for all the production and development databases.

● Implemented Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 12c, 11g) allowing users to quickly move a user Tablespace across Oracle databases.

● Implemented data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 12c, 11g.

● Upgraded the databases from 11g to non CDB 12c.

● Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

● Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

● Performed space management, capacity planning, disaster recovery and overall maintenance of the databas.

● performed Failover and Switchover using Data Guard Broker and manually as and when required.

● Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

● Applied patches 11g/12c.

● Performed replication with two standby and one primary.

● Successfully performed physical and logical backup using pg_dump, pg_dumpall, pg_basebackup

● Provided 24X7support for all the production and development databases. EDUCATION

● UNIVERSITY OF BUEA, CAMEROON : BACHELOR’S DEGREE COMPUTER SCIENCE

● CompTIA SECURITY+

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS: Red Hat Linux, Oracle Linux, UNIX, AIX, HP-UX, and all Windows,

RDBMS: Oracle 9i, 10g, 11g, 12c and 19c,

LANGUAGES: SQL, PL/SQL, Shell Scripting, Ksh, bash, PostgreSQL 9.x, 10.x,11.x, & 12.x, AWS RDS

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), 11g OEM Grid Control OEM 12c, OEM 13c, Oracle Data Guard, Oracle Management Service

(OMS), Real Application Clusters (RAC), ASM, Sql

Navigator, Data Pump (expdp, impdp), TOAD, SRVCTL, SQL*Plus, SQL Developer, Apex, ETL, SQL Loader, Oracle Streams, golden gate, pgAdmin, psql, pgDash, pgHero, pgBadger, PgBouncer, Pgpool, pg_activity, Vacuum, Vacuum full, EDB Migration Toolkit (MTK), Ora2pg, AWS Data Migration Service (DMS) & Schema Conversion Tool (SCT), EDB Failover Manager (EFM), SQL Server Management

studio (SSMS),

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, and ADDM, ASH, pg_stat_activity, PGTune, pg_stat_statement,

pg_stat_user_tables, pgstattuple, MS SQL Server Profiler, SQL Developer, …etc

WEB TOOLS: HTML, XML

Contact this candidate