SUMMARY

• I am a well organised, proactive, and highly motivated professional Database Administrator with extensive experience. I am a fast learner, good at disseminating information and documentations. I am a team player and culturally versed hence interacting professionally with others is easy. I am Bilingual in French and English.
• 7 years of experience in Oracle Installation, configuration, maintenance and administration.
• 7 years of experience in managing large - scale OLTP and OLAP databases in HA and DR setup.
• 7 years’ Experience configuring and administering DATA GUARD for disaster recovery. Configured both physical and logical standby databases.
• 7 years’ Experience in migration/consolidation of databases using Oracle 12c multitenant.
• 2 years ‘experience with all aspects of designing/implementing Exadata solutions.
• 2 years ‘experience on migrating existing Oracle databases into Exadata Knowledge of different Oracle database migration paths into Exadata.
• I have experience in migrating large Oracle databases (OLTP and Data Warehouse) into Exadata.
• I have experience in Software and firmware maintenance of Exadata Storage Cells, including upgrades and patching Software and firmware maintenance of InfiniBand switches, including upgrades and patching.
• I have experience in providing and implementing performance tuning recommendations of all components in the Database Machines.
• 4 years’ Experience in PostgreSQL, AWS, SQL Server, and Exadata.
• 4 year’ Experience in PostgreSQL replication, Streaming Replication, Logical Replication, log shipping.
• 4 years’ Experience in Migrating Oracle Environment to PostgreSQL Enviroment
• 7 years of experience on Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• 6 years Expertise in implementing and maintaining Database Security such as auditing and TDE.
• 6 years of experience in Performance monitoring/tuning/troubleshooting using tools such as ASH, Explain Plan, STATSPACK (perfstat), SQL Trace, TKPROF, AWR and ADDM reports.
• 6 years’ Experience in Installation, managing and administering 3 nodes RAC on 11gR2 using ASM storage
• 6 years of experience implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• 6 years’ Experience using RMAN for backups, recovery and cloning.
• 6 years’ Experience MIGRATING from similar to different operating system such as Linux Red Hat, AIX, Solaris, Windows using DATAPUMP, GOLDENGATE, TRANSPORTABLE TABLESPACE, and many other strategies.
• 5 years’ Experience writing UNIX SHELL SCRIPTING & debugging PL /SQL PACKAGE.
• 6 years’ Experience configuring Oracle GOLDENGATE both unidirectional and Bidirectional.

TECHNICAL SKILLS

• Oracle 10G (10.2.0.5), Oracle 11G (11.2.0.2, 11.2.0.3, and 11.2.0.4) and Oracle 12C (12.1.0.2 and 12.2.0.1)
• HP-UX, Sun Solaris OS (5.1, 5.2, 5.3, 5.9, 5,10, 6.1), Redhat Enterprise Linux, Oracle Enterprise Linux and Windows 2008 and 2012 R2, Exadata X5-8, Microsoft Azure Cloud
• Oracle E-Business Suit 11.5.10.2, 12.0.6, 12.1.1, 12.1.3, 12.2.2, 12.2.4 and 12.2.5
• AD Utilities, OIM, OAM, OBIEE, OID, ODI, FNDLOAD, FNDCPASS
• OEM 12c & OEM 13c Cloud Control, Exp/Imp, Data Pump, DBCA. DBUA, OUI, RMAN, Goldengate Monitor, DGMGRL, GGSCI
• Putty, Toad, SQL Developer, SQL*Plus, SQL*Loader, WinScp and Filezilla
• Sql, Pl/Sql and Unix Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Lakeland, FL

Oracle Database Administrator

Responsibilities:

• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Tuned PL/SQL, SQL with Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)
• Performed Database health checks and used the notification tool to send the alerts in OEM Grid Control.
• Supported and managed Oracle Real Application Clusters (RAC) environment on Red Hat Linux.
• Applied Database software fixes/patches.
• Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
• Identified database bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, INDEXES, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implement policies to maintain database to make sure that the databases integrity and maximum availability.
• Performance issue tracking and solution making using Statspack analyze the report and find the root cause of the issue and provide best solution. Explain plan used to diagnose the long running queries, tuning applied if it required.
• Virtual database setup to limit the user to access table columns only by the admin not the application users. Oracle Advanced Security features like TDE (Transparent Data Encryption), Data Vault and Audit Vault.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD and DBARTISAN for database management.

Confidential - Plano, TX

PostgreSQL Database Administrator

Responsibilities:

• Installed/configured PostgreSQL (9.5, 9.6. and recently worked with PostgreSQL VERSION 10).
• Used pg Hero for Performance TUNING mostly, SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY.
• Tuned autovacuum parameters to ensure up-to-date table stats and reclaim space consumed by dead tuples.
• Used Pg Bouncer for connection pooling, pg Badge for generating statistic reports.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recovery.
• Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.
• Experienced in cross platform migrations preferably oracle to PostgreSQL.
• Documented and assisted as an oracle dba data migration from oracle databases to PostgreSQL database in AWS cloud.
• Proactively managed standby replication and hot standby for disaster recovery.
• Managed and monitored these databases using pgAdmin and psql.
• Created roles, granting privileges, creating tables, use of indexes, and primary & foreign key constraints as required.
• Performed maintenance activities like vacuum, vacuum full, analyze; Checking the auto vacuum jobs, customized vacuum on certain tables and columns.
• Experienced in tuning PostgreSQL database settings & Troubleshooting performance issues, Managing Users and Tablespace on PostgreSQL Servers.
• Working knowledge of pgAdmin and psql tools.
• Familiar backups (pg basebackup, pg backrest, pg dump,) and restore, compressed (gzip) backups, database or schema refreshes.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports
• Involved with OLTP relational databases system analysis, design, implementation and management
• Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms
• Administered 11g RAC environments, adding and removing nodes to the cluster and handled performance tuning using AWR
• Supported off-hour on call support for database related issues
• Documented many of the Standard Processes for peers to follow

Environment: Oracle Databases 11g& 12c, Goldengate 12c, OEM 12c, RHEL, OEL, Exadata X5, HP-UX and Windows 2008R2 & 2012

Confidential - Germantown, MD

Oracle Database Administrator

Responsibilities:

• Successfully installed and configured Oracle 11.2.0.3, Oracle 12.1.0.1 databases on AIX platforms
• Performed Database upgrade from Oracle 10g to Oracle 11g (11.2.0.4) RAC database
• Refreshed/ cloned databases using RMAN utility
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Detect corrupted blocks by using DBVERIFY utility
• Successful in in applying RDBMS patches, security patches for improving the security and functionality of the databases
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) and 12c cloud Control
• Extensively used AWR, ADDM and explain plan for periodic performance tuning
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments.
• Implemented proactive monitoring using Tuning Pack with Diagnostics Pack, and STATSPACK, SQL Trace, TKPROF, and EXPLAIN PLAN
• Implemented Flashback technology of the Oracle 12c, 11g and 10g along with Recyclebin for a faster recovery of the databases and database objects
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
• Implemented Security through Virtual Private Database and Fine-grained Auditing
• Perform production system problem analysis and recommend corrective measures in a timely manner

Environment: - Oracle Apps 11.5.10.2 & 12.2.2, Oracle Database 11g & 12c, Goldengate 11g, OEM 12c