VAMON N NGWA

301-***-****

adhn6x@r.postjobfree.com, adhn6x@r.postjobfree.com

PROFESSIONAL SUMMARY

•Over 7+ years of experience as a Oracle DBA (18c,12c,11g, 10g) in IT industry.

•Expertise in Oracle 18c,12c,11g, 10g on various Unix platforms (Linux, HP-UX, Solaris, AIX), windows NT 4.0/2000/2003 in the areas of database creation, refreshing database, user management, RMAN, Export and Import utility.

•Experience Perl and shell scripting and other Oracle tools and utilities like Oracle OEM, SQL Navigator and TOAD.

•Involved in Installation, Performance Tuning, Backup and Recovery, RDBMS Patching, Security, Oracle Enterprise Manager (OEM), Standby Database, Database Upgrade from 9i to 18c, troubleshooting and basic knowledge of networking and security.

•Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK

•Creation of databases, instances, table spaces, data files, rollback segments.

•Creating tables, indexes, synonyms, views, sequences, profiles, constraints, triggers and procedures.

•Design and implementation of Backup & Recovery using RMAN and SQL scripts.

•Proficiency in using Log miner, SQL *Loader and Export/Import utilities.

•Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and backup verifications.

•Setting up Standby Database / Oracle DataGuard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.

•Experience in Migration of Oracle 18c,12c,11g, 10g

•Experience in installation and configuration of Oracle RAC.

•Experience working on PL/SQL programming on different databases like Oracle 10g/ 11g/12c/18c.

•Experience as 24x7 Production DBA as well as application (development) DBA.

•Knowledge on Golden Gate with installation, configuration and troubleshooting various issues.

•Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures

•Scheduling Jobs and Alerting using SQL Server Agent

•Monitoring and managing the use of disk space, memory and connections, Initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user database and transaction log, Creating and using segments.

•Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash.

•Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables

•Proactive and efficient in timely delivery of all assignments, always enthusiast to take up new challenges.

•Motivated team player and an adaptable individual with good analytical and strong interpersonal skills.

•Excellent written and verbal communication skills.

TECHNICAL SKILLS

•Operating System: Solaris, Linux, HP-UX, AIX, 95/98/2000/NT/XP, VMware

•Databases: ORACLE 18c,12c,11g and 10g

•DB Tools: SQL*Plus, SQL*Loader, Export & Import utility, OEM, Database Configuration Assistant, RMAN, Toad, PL/SQL developer, AWR, ADDM, DataGuard

•Languages: SQL, PL/SQL

•Internet: ASP, JSP, XML, HTML/DHTML, VBScript, JavaScript, Flash MX

•GUI Tools: Oracle Enterprise Manager

TECHNICAL EXPERIENCE

Database Administrator

August 2019 APPLE

AUSTIN, TX

Responsibilities:

•Installed, configured and maintained oracle databases on Linux and Solaris environment.

•Created Database as per requirements using DBCA and scripts.

•Startup and Shutdown of individual instance on RAC 2 node environments.

•Implemented and supported two node RAC environments.

•Managed ASM diskgroups via asmcmd and database control.

•Worked on replication technologies such as Shareplex and Dataguard.

•Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment.

•Migrated and upgraded oracle database from 10g to 18c on linux environment.

•Setup jobs and events using Enterprise Manager (OEM) console.

•Implemented dataguard (physical) for high availability/disaster recovery solution.

•Used Import/Export and SQL * Loader utilities to move data and objects Configured and Tested Backups for Oracle Databases by restoration and recovery

•Wrote shell scripts and scheduled them in CRON for monitoring and health checks of database

•Monitoring Database growth and space administration.

•Frequent analysis of objects and schemas.

•Experience in developing, maintaining and debugging procedures, packages and functions using sql developer.

•Export & import at full, schema, tablespace and object level.

•Responsible for Online/Offline database backups and managing Database recovery with RMAN

•Worked on backup and recovery strategies using RMAN.

•Performed database tape backups using netbackup and RMAN.

•Installed, configured and resolved issues on golden gate replication technology.

•Refreshing or cloning databases from production to development using RMAN and OS level scripts

•24X7 support for databases and production operations teams

•Interacted with Functional & Technical experts, system administrators, security analysts and other members of the project team to ensure optimum operation of the database

•Environment : Oracle 9i, 10g, 11g12c and 18c, RMAN, Solaris, Linux, VMware, RMAN, RAC, SQL*Plus, SQL, PL/SQL, Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, replication.

Database Administrator

February 2016 - July 2019

VECTREN

EVANSVILLE, IN

Responsibilities:

•Perform installation, configuration and of Oracle databases on Solaris, Linux, and VMware.

•Determined and implemented best practices for Oracle Setup, Installation, Configuration, Monitoring, Sizing, Capacity Planning, Backup and Recovery strategies

•Created Database objects like Tables, Tablespaces, Rollback Segments, Multiplexing Control files, Data files, Redo log files, Partition tables, Views, Indexes, Clusters, Synonyms, Materialized views. Audited, Implemented scripts/tools to help rollout and manage Oracle in a global distributed environment

•Setup jobs and events using Enterprise Manager(OEM) console, enrolled users and maintained system security by controlling and monitoring user access to the database

•Responsible for developing different databases at various stages of implementation of Projects (Databases for conversion of data, interfaces, training and development)

•Used Import/Export and SQL * Loader utilities to move data and objects

•Monitored and maintained database growth and tablespace utilization

•Devised backup/recovery strategies and implemented it in line with Business requirements (RMAN)

•Configured and Tested Backups for Oracle Databases by restoration and recovery

•Involved in the performance tuning and query optimization

•Experience in Performance Tuning by using tools/utilities by Automated Workload Repository (AWR)

•Installed and Configured Oracle 10g 11g and 12c Real Application Cluster (RAC) Instances with stand by database (DataGuard) using CRS and ASM .

•Upgraded Oracle Database from 10g and 11g and 12c

•Code reviews of host and interface applications to ensure optimum database connections, resource usages, locks, query response times

•Designed and Implemented Oracle Disaster Recovery Solutions for customers

•Applied patches in production and test instances

•Managing Database (User management, Table space management, Performance related issues).

•Knowledge on basic architecture and functioning of Golden Gate technology.

•Strong hands-on partitioning and performance tuning skills

•Strong SQL scripting skills

•24X7 support for databases and production operations teams

•Assisting Developers in writing and tuning their queries

•Environment : Oracle 9i, 10g, 11g and 12c, Solaris, HP-UX, Linux, VMware, RMAN, RAC, SQL*Plus, SQL, AWR, Toad, PL/SQL, UNIX Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, Data Guard, SQL, SQL Server.

Oracle Database Administrator

November 2012 - February 2016

CARESOURCE

DAYTON, OH

Responsibilities:

•Supported more than 40 databases size 1 GB to 1.1 TB.

•Experience in taking Daily and Weekly Physical backups using RMAN

•Involved in writing korn shell scripts for daily RMAN backups, tape backups, Index rebuilding and to generate Multi-Master Replication. Databases are reorganized to improve performance

•Developed and maintained stored procedures, functions, packages, and triggers and used Oracle standard packages. Daily monitoring Alert logs, growth of table spaces, size of the tables, top sessions and top 10 SQLs

•Developed complex queries and PL/SQL procedures on Data Warehousing environment to facilitate strategic plans to higher levels of management. Created Oracle database redo log members and groups managed on-line redo log files. Responsible for Oracle database performance tuning.

•Cloning of production database to the test environment using Recovery Manager (RMAN)

•Database Administration and Planning including logical design, physical design, backup & recovery

•Implemented DataGuard (Standby) for high availability/disaster recovery purpose

•Developing a backup and recovery strategy and tested several recovery scenarios

•Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc

•Database Planning and designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions

•Configured, implemented, supported, and maintained physical and logical databases.

•Data transfers using BCP. Granting roles and permissions to SQL server users, fixing super user permission, granting & removing permissions of all users, providing security administration by creating groups, users with appropriate roles checking the database Consistency.

•Monitoring and managing the use of disk space, memory and connections, Initializing database devices, Disk mirroring for recovery, creating, enlarging and removing user database and transaction log, Creating and using segments.

•Backing up and restoring database, Backup and recovery plan using Dump and Load command, Creating Logical Device names, using backup server for backup and recovery, Step by step recovery of database after crash

•Setting database options, Tuning Queries and Stored Procedures, Monitoring SQL server activity, Setting and resetting the configuration variables.

•Environment: Oracle 12c/11g/10g/9i, Red Hat Linux, AIX, RMAN, RAC, Data Guard, SQL*Plus, SQL, PL/SQL, Shell Scripting, SQL*LOADER, Oracle OEM, Import/Export Datapump, SQL Diagnostic Manager, SQL Compliance Manager.

REFERENCES

Available upon request

Education and Training

2010

UNIVERSITY OF DOUALA

Masters

2008

UNIVERSITY OF DOUALA

Bachelors

Certifications

•ORACLE CERTIFIED ASSOCIATE 12 C

•ORACLE CLOUD INFRASTRUCTURE

•SQL FUNDAMENTALS

•AWS CERTFIED CLOUD PRACTITIONER

•AWS SOLUTION ARCHITECT

Contact this candidate