Paul B. Nga
email@example.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
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
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 184.108.40.206,220.127.116.11.0, 18.104.22.168, 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.
Modest Technologies Solutions LLC, Laurel, MD 2015-Present
Oracle Database Administrator (DBA)
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.)
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)
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 22.214.171.124 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 126.96.36.199 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.
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.