DBA Resume

Title
DBA

Primary Skills
Oracle DBA

Location
US-MD-DC and Baltiomore

Posted
Apr-03-09


QUALIFICATION OVERVIEW
Mr. Mokom has over ten years of experience in the industry of data processing and management. As an Oracle Database Administrator, he has vast experience in Oracle 7.x,8.0.4,8.0.5, 8i,9i and 10g servers, in the areas of physical and logical database design and creation, installation, upgrade, migration, performance tuning, backup and recovery (RMAN), SQL*NET, Oracle Net, space-management, replication, Data Guard, Grid Control, etc . Mr. Mokom can troubleshoot on Windows NT/2000 and various UNIX platforms including Sun Solaris 2x, Linux, HP-UX, and AIX. He also monitors and maintains database security. He has worked and provided support to COHESION Discovery, INFRA CMDB, OMNIVISION, NETIQ, SIEBEL, ETMS, and PREMYSIS Applications and he has also managed Oracle databases on 3PAR Storage and Veritas Systems. Mr. Mokom supported the Lawson Financial and Maximo Payroll Applications. He is experienced in full life cycle development for mission-critical applications in Client /Server OLTP environment (from development, testing to production).


CERTIFICATIONS
Oracle 7 OCP Oracle Corp)
Oracle 8i OCP Oracle Corp)
Oracle 9i OCP Oracle Corp)
Oracle10g Trained
Oracle11i Ongoing training

EDUCATION
Bachelor of Science in Geography/Economics from University of Yaounde, CAMEROON


SUMMARY OF SKILLS

• Operating System configuration
• System Installation
• Database creation
• Migration and Upgrade (7.x, 8.1.6, 8.1.7,9i,10g, 11i)
• Performance Tuning
• Backup and Recovery (RMAN configuration and management)
• Space /object Management
• Trouble Shooting
• Database design
• ORACLE NET
• Oracle Data Guard/Standby Database.
• Replication
• Data Warehousing, Decision Support Systems
• OLTP systems
• Multi-instance Management



PROFESSIONAL EXPERIENCE
Verizon, Inc. 2/2005 to Present
Oracle Database Administrator

As an Oracle Support Service personnel onsite at Verizon Inc. (Beltsville MD), Mr. Mokom is responsible for providing onsite support to the Product Development, Engineering, and Database Administration Departments. He also supports internal and external customers. Mr. Mokom is responsible for providing support on Oracle best practices on operating system/server configuration, installation, security practices, monitoring, patch deployment, upgrades on 24/7 systems, backup strategies, Data Guard, etc. He also troubleshoots and provides DBA technical support on a day-to-day basis to various departments. In addition, he has provided support to COHESION Discovery, INFRA CMDB, OMNIVISION, NETIQ, SIEBEL, ETMS, and PREMYSIS applications.


DCWASA (District of Columbia Waste & Sewage Management Authority) 2/2001 to 2/2005
Oracle Database Administrator

Mr. Mokom was responsible for the data warehouse creation and administration assistance including database and application performance tuning for 8i and 9i; recovery, hot/cold backups in a 24X7 environment; modified database schemas, imported and exported; developed scripts/cron scripts that backup database; installed and configured Oracle software and SQL*NET and net8; created replication and tested Oracle databases and Replication Manager Setup Wizard; provided the overall management and data integrity of the Oracle database application, SQL, indexes, tables, and/or database physical design to meet performance objectives; and provided ongoing support for production and test databases to include:
Appling all patches and updates to the database
Installation and configuration of Oracle software and SQL*NET, net8
Upgrade over 20 database instances (both Low and High Volume) from PS 7.5 to 8
Experience in using Oracle9i Metadata for SQL DDL and XML
Experience in using Oracle9i Flashback query and Logminer
Installing ,designing and configuring 9ii and 8ii databases
Performance tuning for 20 databases on four Unix servers and on NT servers
Multi-master replication creations groups and objects using Replication Manager Setup and scripts
Created database operations manual for the documentations
Identify all affected systems and processes before the change is implemented in order to mitigate or eliminate any adverse effects.
Automatic database recovery on Unix environment
Configured and implemented Recovery Manager (RMAN) as a backup and recovery strategy
Database design, creation, duplication and trouble shooting, reverse/forward engineering with triggers and packages

EGLOBE, Inc. 2/2000 to 2/2001
Oracle Database Administrator
Mr. Mokom provided and configured database administration assistance including database and application performance tuning for Oracle 7.3.2,8 and 8i; he modified database schemas, import and export; developed scripts that backup, restore and recover database; created and tested Oracle databases, tuned application SQL, indexes, tables, and/or database physical design to meet performance objectives; and provided ongoing support for production database to include:
Maintain a server environment that optimizes the efficient integration of a variety of servers, including Application Servers, Web Logic Servers, Report Servers, and Web-based Training Servers
Monitor the Process Scheduler for efficient queuing and processing of jobs; manage the regular clean up of logs, tables, and reports associated with the Scheduler
Provide assistance to Development staff for issues relating to performance tuning and SQL creation
Migrate the data between multiple database environments
Maintain a working knowledge of the point in time recovery process for a database in Archive Log mode
Tune SQL statements found in the reporting utilities SQRs, queries, and nVision
Installation and configuration of Oracle software, SQL*NET, and net8
Installation and configuration of Oracle Enterprise Manager (OEM) with Oracle Diagnostics & Tuning Packs on Windows NT platform
Identify all affected systems and processes before the change is implemented in order to mitigate or eliminate any adverse effects.
Database design and creation and duplication using ERWIN forward engineering and reverse engineering with triggers and relationships
Installation and configuration of Oracle software and SQL*NET, net8 and Oracle Financial
Installation and configuration of Oracle Enterprise Manager (OEM) with Oracle Diagnostics & Tuning Packs on Windows NT platform
Create database and database objects using OFA and supported the development and production environments
Monitor/manage database space utilization and growth, tablespace usage and extents, to include allocating and planning disc storage, modifying database structure
Reorganizing and restructuring the database to meet the OFA standards and for optimizing the performance. Resizing tablespaces, tables, indexes and rollback segments
Analyzing tables, indexes and clusters against chained and migrated rows and providing solutions
Capacity planning of the database tables, indexes, tablespaces and database
Manage/modify database security and database schema. Creating users, granting privileges roles and profiles as needed
Establishment backup and recovery procedures using SQL and maintenance including hot and cold backups to support point-in-time recovery of the database on data tapes or drives
Use the database import/export and load utilities for various maintenance and backup and recovery procedures
Data migration using Import/Export, FTP, Database Links and SQL*Loader
Provide performance-tuning activities to improve 1performance of the Oracle database. Tune database through initialization parameter, SQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention
Trouble shooting, restructuring, tuning, and tracking database load, fragmentation, contention, and overall performance for optimal performance of the existing database
Conduct load balancing procedures to reduce I/O and contention


PRIOR WORK HISTORY (DETAILS AVAILABLE UPON REQUEST.)

Census Bureau, Suitland, MD 12/1999 to 6/2000
Oracle Database Administrator

Verisign, Inc. 12/1997 to 11/1999
Oracle Database Administrator

Sallie Mae 12/1995 to 12/1997
Database Administrator


TECHNICAL COMPETENCIES
Proficiency in Oracle 7.x ,8.x and 9x, 10G, Cohesion Discovery, Infra CMDB, Ominivision, Netiq, ETMS, Premysis, Siebel, Lawson Financials, Maximo Payroll System, DBCA, Oracle Net, Autotrace Traceonly Explain, Oracle Enterprise Manager(OEM)/performance pack, DBA STUDIO, SQL*NET, NET8, SQLLDR, Export/Import, Oracle Data Pump, Flask Back, ASM, MViews, PL/SQL,SQL*PLUS, Tkprof, UTLBSTAT/ UTLESTAT, PERFSTAT, AWR, ADDM, DATA MANAGER, Backup Manager, Data Guard, Grid Control, EBU, STANDBY DB, Patrol DB-Reorg for Oracle, RMAN, SQL NAVIGATOR, TOAD,SPOTLIGHT, REPLICATION, 3PAR Storage, Veritas etc.

OPERATING SYSTEM:
SunSolaris 2.x, Linux, AIX, Windows, P9000

Certifications
Oracle 7 OCP Oracle Corporation
Oracle 8i OCP Oracle Corporation
Oracle 9i OCP Oracle Corporation
Oracle10g Trained
Oracle11g Ongoing training


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in DC and Baltiomore, MD | Resumes in Maryland

View other DBA resumes, Database Administrator resumes