Paul B. Nga

adg142@r.postjobfree.com Mobile: 224-***-****

Database professional with over 7 years’ experience, in Oracle and SQL Server. Expertise providing technical support in all aspects of database administration, problem solver with an elevated level of attention to detail and a confident and capable communicator with the ability to develop positive rapport with diverse stakeholders as required. Committed to the support, shaping and subsequent delivery of major projects, parallel to maintaining ongoing support. I am highly motivated to join and support your organization with the performance, integrity, and security of the database.

EDUCATION AND TRAINING

Montgomery College: Associate Degree in Computer Science, Rockville. 2012

National Advanced School of Posts and Telecommunications (SUP’PTIC): BSc. Eq. Telecommunications and Networking, Yaounde, Cameroon. 2009

Certifications:

CompTIA Security Current

Oracle Cloud Infrastructure Architect Associate 2019

AWS Certified Solution Architect- Associate 2020

Oracle Certified Associate on Oracle 10, 11g, 12c 2019

AWS Certified Solution Architect- Professional 2020

SQL Fundamentals Certified Oracle 11g, 12c 2018

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, 12c, Â Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

RDBMS: Oracle 11g, 12c, Microsoft SQL, MySQL, Unix SQL

Tuning tools: TKPROF, AWR, ADDM, EXPLAIN PLAN, and STATSPACK.

Environment: Oracle 12.2.0.2,12.1.0.2.0, 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Strong skills in applying security patches (Patch Set, Critical Patch Updates (CPU)/Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Configuration of ASM for RAC and NON-RAC environments.

Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.

Expertise in PL/SQL, SQL and UNIX Shell Scripting.

Proficiency in the use of 11g features such as Data Pump, Flashback Recovery, ASM, AWR, and ADDM.

Performance tuning of Queries by maintaining Aggregates, Compression, Partition and Indexing.

Database operation, maintenance, security, provisioning, administration, replication, automation, disc I/O/space management.

PROFESSIONAL CREDENTIALS

Modest Technologies Solutions LLC, Laurel, MD 2015-Present

Oracle Database Administrator (DBA)

Key Duties

Install, configure, and maintain Oracle 10g and 11gR2 on Linux. Upgrade from Oracle 10g to 11g.

Extensively implement Data Pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Perform tuning on the database – SQL Tuning, used Tuning utilities such as STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

Configure Repository and clients for GRID Control and implement DB Control for some databases.

Utilize Oracle streams to capture, propagate and apply the transfer of data, transactions, and events within managed databases.

Test backups periodically to ensure minimal recoverability time to meet business objectives.

Perform patching on Oracle Database Server 10g and 11g using Opatch utility.

Use AWR, ADDM and STATSPACK reports for troubleshooting performance issues and capacity planning. Extensively use EXPLAIN PLAN, TKPROF and SQL Trace.

Use GRID Control and set up rules for alert notification and schedule RMAN backups with Failure notification.

Design, install & maintain OCR, 11g RAC and Data Guard components of Oracle.

Support & maintain the Production/Development databases on various servers.

Manage Database structure, storage allocation, table/Index segments, rollback segments, undo segments, and constraints.

Install ASM environment and migrate databases from NON-ASM to ASM.

Monitor different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.

Perform EXPLIAN PLAN analysis for Query Optimization and SQL Tuning.

Test Oracle 18c for migration of data. Use tools (SQL Loader, SQL Tuning Advisor, EXPLAIN PLAN.)

Achievements

Perform conversion Non RAC single instance to RAC database instances.

Use Oracle Data Pump utility making faster exports/imports on large databases resulting in significant timesaving.

Implement Data Guard, Physical Standby database in 10g and 11g RAC environment for the production databases for active and passive cluster.

Implement UNIX Scripts using CRON JOB for Day-to-Day activities and Windows Task Scheduler

Write Shel Scripts for the system and database for effective functionality and report generation.

I/O Spaces, MD 2011-2014

Oracle Database Administrator (DBA)

Key Duties

Implemented Grid based monitoring solution for large databases and installation of clusterware, configuring public, private and VIP.

Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled job (Cron Job).

Configured Oracle Streams on 11g, 10g databases for data replication and monitored using Grid Control.

Performed tuning and diagnosing DBMS and individual production databases, organized various migration review meetings with application team to discuss the migration strategy.

Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.

Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 RAC database for high availability, scalability, and performance by determining the best cluster architecture, choosing the best hardware configuration for Oracle RAC.

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.

Used import/export utilities for cloning/migration of small sized databases and Data Pump import/export to move data between 9i and 10g/11g environments.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Achievements

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Implemented Data Pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Responsible for creating RMAN catalog database and registering the databases in catalog database and Cloned production RAC instances to development and QA systems using RMAN duplication.

Involved in defragmenting data blocks of table spaces for optimization. Partitioned tables to increase performance. Evaluated Oracle 11gR2 Goldengate to reduce the complexity involved in Oracle Streams.

Extensively worked in various areas of Data Guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.

Implemented and configured 11g grid control on RHEL.

Contact this candidate