Chia Paul Ngum

Address: prior lake, ***** Minnesota

Email: adll4e@r.postjobfree.com Tel: 763-***-****

LinkedIn Profile: https://www.linkedin.com/in/chia-paul-ngum-940b28137/

SUMMARY

An accomplished and seasoned Senior Oracle Database Administrator (SDBA) with over 7+ years of experience with extensive knowledge in Oracle database administration. Oracle Certified Associate SQL (OCA) in Oracle Database12c Administrator, proficient in Oracle 10g,11g, 12c, 18c and 19c on Windows, and Red Hat Linux. Expertise knowledge in database configurations and installations, Database Design, and development (SDLC), Monitoring, Tuning, Migration, Upgrades, Backup & Recovery and Security Implementations. Enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail with strong organization, verbal, and written communication skills in English and French able to multitask successfully and thrive in a dynamic fast paced and versatile work environment.

Experience in data encryption using Oracle TDE to protect the organization’s critical information and exceeding the industry standard.

In-depth understanding of security and backup procedures to ensure database integrity.

Experience with various tools, such as SQL*Loader, SQL, SQL Developer, RMAN, PuTTY, Mobaxterm, WinSCP, PL/SQL and Oracle Enterprise Manager (OEM) 12c and 13c.

User Management, creation, monitoring, and management of database users. Altering passwords and granting/revoking access to system/object privileges, roles, and auditing user actions.

Monitoring & Reorganizing Tablespaces/Tables/Indexes.

Databases Performance Tuning / Maintenance.

TECHNICAL EXPERTISE

Operating Systems: Unix, Linux- Red Hat Linux 5.4, Red Hat Linux 6, Windows 2000 Server, Solaris, AIX

RDBMS: Oracle 10g, 11g, 12c, 18c and 19c.

Tools/Utilities: RMAN, OEM Oracle Management Server, SQL*Plus, Export/Import, Data Pump, RMAN, AWS, ADDM.

Utilities: RMAN, ADRCI, SQL*Plus, RDA-HCVE

High Availability Solutions: RAC, Data Guard, and ASM

PROFESSIONAL EXPERIENCE

Thompson Reuters, Eagan, MN

Oracle Database Administrator October 2016 – Present

Worked collaboratively with other DBAs to ensure optimal performance of the database.

·Used Oracle Enterprise Manager (OEM) for database monitoring and performance tuning.

·Installed Oracle databases on Linux OS and analyzed SQL statements, reorganize database objects and designed indexes.

·Performed day to day database administration tasks like database creation as well as working on projects such as upgrades and patching.

·Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption (TDE).

·Experience with applying Patches such as CPU/PSU patches, One-Off Patches, Interim patches as per the oracle recommendations. Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance.

·Monitoring and reporting daily backup with RMAN, configuring, and managing backups (full and incremental). Performed Installation, security and patch upgrades over successive Oracle generations using the OUI and DBCA.

·Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle Instances.

Created database objects such as tables, views, synonyms, sequences, and triggers. Created user accounts and assigned appropriate privileges.

Database Security monitoring and security compliance auditing.

Monitors and resolves Data guard problems, maintains flashback capability, troubleshoots database problems including performance issues and resolves them with the AWR, Performance views and SQL Tuning advisor.

Implemented a backup and recovery policy and uses RMAN.

Responsible for monitoring and troubleshooting the database environment. Table space monitoring, Performance monitoring and tuning for performance improvement.

Implemented database security using Oracle’s Transparent Data Encryption (TDE) to protect the organization’s critical information and exceeding the industry standard.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) reports and automatic session history.

Administered tablespaces (data file) on space management and adjusted for future needs.

Installed and configured Oracle OEM 12C on Dev and test environments.

Planned and performed Backup/Recovery using RMAN base on SLAs, test backup for corruption, Work with Flash Recovery Area as well.

Expertise in implementing data refreshes using RMAN utility, Transportable Tablespace (TTS) feature, Data pump and conventional Export/Import of Oracle 11g, 12c.

Part of team which provides 24X7 on call support for production and development databases.

Used OEM extensively to monitor the general health and troubleshoot/diagnose problems in the - Strong skills in applying CPU, PSU and One-off Patches using "run Installer" and Perl based utility "Opatch" as part of the maintenance activity.

Cloned production databases as needed for testing, development using RMAN and Grid Control.

Oracle High Availability involving Oracle RAC.

Applied Oracle quarterly patches of the current PSU version to non-RAC and RAC configured databases.

Fairview Health Services, Edina, MN

Oracle Database Administrator June 2013 – January 2016

Implemented proactive database monitoring using SQL Trace. Mr. Performed database design and maintenance using Oracle partition technologies.

Implemented backup and recovery procedures using RMAN and Data Pump utility for Oracle databases and test regularly in conjunction with Operations. Maintained 24*7 Availability by implementing standard processes and troubleshooting live issues.

Monitored and optimized database performance, troubleshooting performance issues using OEM and AWR.

Performed SQL Tuning and provided consultation such as creating Materialized views, table partitions, adding indexes, dropping unnecessary indexes.

Managed database security by creating and assigning privileges to users depending on the user’s activity, auditing, and performing other security related tasks including Transparent Data Encryption and acknowledged HIPAA laws.

Monitored bugs from the alert log and trace files and used DDL statements to CREATE and ALTER within a dynamic SQL script, created schemas, synonyms, and roles.

Used RMAN for database refresh with hot backups, incremental backups and validated to ensure the backups were secured and usable for recovery.

Participated as part of a teamwork effort for SDLC principles and the development of documentation for new procedures and processes for technical projects.

Managed users by creating them, assigning roles, managing passwords and privileges including other security related tasks.

Managed Automatic Storage Management (ASM) and Non-ASM database file systems.

Used Oracle Enterprise Manager (OEM) for database monitoring and performance tuning.

Installed Oracle databases on Linux OS and analyzed SQL statements, reorganize database objects and designed indexes.

Performed day to day database administration tasks like database creation as well as working on projects such as upgrades (from 9i, 10, 11g to 12c) and patching.

Database upgrades, resource capacity planning, platform migrations, application consolidations and data center rationalization.

Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption (TDE).

Experience with applying Patches such as CPU/PSU patches, One-Off Patches, Interim patches as per the oracle recommendations.

Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

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

Maintained the data integrity and security using integrity constraints and database triggers.

Implemented database security using Oracle’s Transparent Data Encryption (TDE) to protect the organization’s critical information and exceeding the industry standard.

Analysis on SQL and Services with high CPU, Memory usage, AWR analysis, ADDM (Automatic Database diagnostic Monitor report), Active Session History (ASH).

Monitoring production database and provide detailed analysis on Long running, Resource consuming SQLs, Wait events, Locks and Alert log file.

EDUCATION/CERTIFICATIONS

B.Sc. in Computer Science

Metropolitan State University, Saint Paul, Minnesota

Oracle Database SQL Certified Associate

Oracle University

Oracle Database 12c Administration Certified Associate (OCA)

Oracle University

Oracle Cloud Infrastructure Foundation Certified Associate

Oracle University

Professional Scrum Master 1 (PSM)

Scrum

Pursuing Oracle Certified Professional Exams,

Contact this candidate