Jean P. Yangue
Silver Spring MD 20904
Secure an Oracle Database Administration contract position using the latest technologies to stay at the cutting edge of information technology.
Mr. Yangue has extensive Information Technology experience with over 10 years administrating Oracle databases on multiple platforms including Windows servers, HP-UX, AIX-UX, Sun Solaris, and Linux. He is 8/8i/9i/10g/11g OCP Certified DBA with expert knowledge in Oracle 12c,11g, 10g, 9i, 8i, 8.x and 7.x, in the area of logical and physical database design, networking, development and production. Installation, Configuration, migration and support. He has a strong understanding of the various features of Oracle infrastructure and application Servers and Database tiers on Red Hat/Unix and Windows servers. Database knowledge includes, OFA, Space, Memory, and Resource and users’ management, Backup and Recovery Manager, Oracle Enterprise manager (OEM) Cloud Control 12c, EM Express. He is knowledgeable with Oracle Database /RAC/Standby/Golden Gate. He is highly proficient in all phases of Oracle RDBMS and Application support to include resource, user management for multi-user system and database application account and role management. Experienced with tables, indexes, and table-level partition, and Web base Enterprise Applications. He is experienced with Oracle database and Application system configuration, upgrade, enhancement and quarterly CPU Patching. He is familiar with triggers, stored procedures, functions and full life Cycle methodology. Experience with TFS/Source control tool. Excellent analytical and problem solving skills, with the ability to diagnose, troubleshoot, and quickly resolve problems. Mr. Yangue is an effective team player with excellent communication and interpersonal skills.
Database: Oracle 12c, 11g, 10g, iasdb, 9i, 8i, 8.x, 7.x, MS Access
Software: REMS, GTS, PRISM, Esri, EBS,ERP, Oracle 11g, 11i, 10IAS, 9i, 8i, 8x, 7x, Net8, Oracle Net.
Tools: TFS/Source control, Powerbuilder 5.x/6.x/7.x. Toad9.x/10, SQL*Loader, CRM, Data pump Import-Export, DBMS Pkg, Grid control, RMAN, ETL, SQLJ,ODBC, J2EE, Data Guard, Golden Gate, Visio, Oracle Enterprise manager (OEM) Cloud Control 12c/13c
Hardware: Dell, Red Had 4.x, 5.x, HP9000, Sun Sparc E450/6800,PC/Intel Desktops and Servers, PC's (Solaris 8/9/10), Hard Drives, Tape Drives, EMC, VERITAS, RAID, ASM NetBackup, Laptops and Printers.
Operating systems: Windows2008/20, Linux6/7, HP-UX10.2/11.11, Solaris2.6/7/8/9/10/ AIX-UX4.1/4.2,
Apps/Others: REMS, Delphi, Documentum 7.1, Dashboard, Tableau, FAACTS,GTS, PRISM APEX, ERStudio, Oracle OBIEE, Oracle11i,R12, EBS,FIT,CMS, ArcSDE9.2/9.3/9.3.1,ArcGIS9/10, WAM, NORTEX, EBS, Pramavera, PeopleSoft/8.0/8.5/9.0, METIS, CRM,ERP, REMEDY, Visional, Granite, MS Project, OLTP, DSS, Baths processing, Crystal Reports 9/10/11, 10iAS, Portal, Ultra Search. Oracle NetSuite.
3/2012-Present: Sr. Oracle DBA Subsystems Technologies Inc.
Mr. Yangue is the Sr. Oracle DBA currently working for Subsystem Technologies in support to FAA ALO-200, Real Estate Management Contract Support. His responsibility span Linux and Windows Operating support, Oracle Database, REMS Application, Documentum server 7.1, Dashboard, Tableau, FAACTS and Delphi to REMS interface and Report server support. Duties include:
Life Cycle Maintenance Support
Research and provide client with cutting edge Oracle software products. Responsible for Oracle on Linux and Windows Operating system design and capacity planning to host All Oracle Databases and various Applications. Provide Oracle software products installation and configuration in compliance with FAA Standards
Design and built a Development, QA, and UAT servers in support to production system.
Migrate OS and Oracle Database and Application servers from AGL to MMAC data center
Successfully lead Oracle Database migration from 10g to 11g and 12c Install and configured
Install and configured Oracle Enterprise manager (OEM) Cloud Control 13c.
Designed, implemented AVAMAR servers backup and recovery procedure using RMAN.
Fine tune Oracle Production database server to achieve maximum uptime and reliability.
Design and implement AVAMAR backup and recovery strategies using RMAN
Install and establish Network connectivity between Oracle Database and heterogeneous Applications sources.
Install, configure the TFS/Source control server and client layer for team members.
Generate and design directory structure for DBA, developers and programmers, SOP’s…etc.
Maintain Codes change for Database administration, development, web developers and Application developers and processes documentation
Participate in (CC) Change Control meeting, schedule and deploy all Database production
Provide support for ERStudio users group and Oracle OBIEE Report Server.
Assist in designing eDMS and Tableau Applications
Provide technical guidance for Oracle Database and Application Lease process flow.
Work with Documentum engineer and Tableau developers for design and configuration.
Provide Oracle database architecture design to engineer and developers for metadata.
Setup, configure eDMS and Tableau backend and network connectivity and support.
Design and create eDMS and Tableau database objects such as Tablespaces, schema, tables, views, Mviews, triggers and procedures.
Design and create eDMS and Tableau database jobs in support to applications
Design and create daily and weekly backup jobs and generate monthly Reports.
Responsibilities include setting up Golden Gate and providing day to day monitoring and control of Delphi to database transfer, DR and various Application data replicat
Working with Delphi production team and application team to resolve all interface issues to include Dephi system user account and password management.
Set up and configure Oracle database staging and extract process and load.
Monitor loaded process and resolved any error daily to avoid staggering.
Install and configure GoldenGate software in support to standby Reporting/DR and MSDB flatfile server synchronization in integrated or classic mode.
Work with Application owner in planning data replication and implementation.
Support Data Extract and apply process from multiple system to Oracle Database
Create cron job to monitor, notify and backup Goldengate Home Directory
Provide support to development team in designing and creating instances and Database objects, install and configure Oracle client software and establish network connectivity.
Resolve above 95% Database and Application Helpdesk tickets.
Deploy Oracle Database CR (Customer Request) in Production system.
Refresh Development, QA, and UAT environment from Production on demand.
Database Security Support
Search and Download the Oracle quarterly CPU/PSU patches.
Plan for Oracle quarterly CPU/PSU patches implementation for all environments.
Install and configure the Oracle patches in Development, QA, UAT and REMS Production.
Work with Security team to implement FITS (Federal Information Transfer Standard)
Setup Scan user account base on scan Application requirements.
Analyze the monthly Oracle database scan Report
Find solutions to mitigate identified security rick for Oracle database categorized in High Medium and Low.
Dashboard/Tableau Application Support
Providing Dashboard/Tableau maintenance and coding enhancement.
Build and configure Dashboard baseline data at a beginning of each fiscal year.
Provide support for Dashboard and Tableau Development and upgrade
Sr. Oracle DBA/Consultant UMUC Adelphi, MD
Mr. Yangue worked for UMUC (University of Maryland) in the IT department as Sr. Oracle DBA to provide and implement oracle server and application migration from 10g to 11g. Responsibilities included and not limited to installing Sun, Database 10g/11g and Application server software. Design, install, configure database on Sparc x86_64 bit and network connectivity. Install and configure Grid control and management agents on all servers. Support APEX Applications and databases and troubleshooting. Work with Oracle support to install to configure EXADATA v2 and CDC stream implementation. Analyze and provide Capacity planning for database and backup storage and strategies. Install and configure and upgrade recovery catalog to 11g. Develop scripts for RMAN, hot backup and data pump for NetBackup implementation on primary site and DR. Mr Yangue is providing outstanding services in configuring oracle products to meet customer requirements. Client server and web base environment setup and troubleshooting. Perform Patch installation and maintenances in all Development, QA and production standalone and RAC environments. Provide management with oracle database best practice and documentations
Sr. Oracle Apps DBA WSSC Laurel, MD
Mr. Yangue worked with WSSC (Washington Suburban Sanitary Commission) in the SSOD as Sr. Oracle Database Administrator in support to FIS, HRMS, DWH and GIS system at Laurel MD. Responsibilities included 24/7 support and not limited to installing Linux Red Hat AS 5.3 Linux x86_64 bit, Database 10g/11g and Application server software. Design, install, configure database and network connectivity. Support Applications and databases and troubleshooting. Mr Yangue provided outstanding services for all oracle products. Client server and web base environment setup and troubleshooting. He provided database and application security and Application Patch installation and maintenances in all Development, QA and production environments. Responsibility includes:
Mr. Yangue provided support under the direction of systems and Operation Managers and participates in 24x7 on call rotation. Analyze, diagnose and resolve all Oracle developments, QA and production issue according to escalation rules. Work closely with the Application developers and the rest of the technical team to keep all database and application available to users. Design, install and develop databases and application codes, PL/SQL, Performance Tuning, Perform all aspects of required task as directed by managers. Proactively identify potential problems before they occur and notify appropriate managers. Design and implement backup strategy for all WSSC Oracle databases. Proactive databases monitoring to detect any error to include space issue. Maintain security according to best practices. He managed users account and security. Resolve assigned tickets and performs other related duties as assigned.
Build Linux Red Hat AS 5.3 Linux x86_64 bit servers to host Oracle 10g/11g databases servers
Design and implement Development, QA and Production environment.
Design and implementation RMAN NetBackup, hot, cold and Export backup for all databases.
Upgrade all databases from 8.x, 9.x, 10.x to 11g
Install, configure, administer and monitor Databases and Applications
Install and configure 2 nodes 10g RAC on Linux Red Hat AS 5.3 Linux x86_64 bit servers.
Format LUNS and create Disk Groups on SAN shared Disk for voting, ocr and all DB files.
Install and configured database instance using ASM based storage
Configured Grid control for Enterprise servers, Databases and application real time monitoring.
Tuning application using sql trace, TKPROF, PERFSTAT, and OEM (AWR, ASH,ADDM)
Plan and Migrated FIS, HRMS, GIS, MISC to new DMX system.
Managing database storage structure, table fragmentation, tuning and partitioning
Research, download and install required OS, Databases and Application Patches
Provide tech expertise and support to FIS, HRMS, GIS, DWH, MISC developers, test and users group.
Build Development, Test and production environment for ERP databases and applications migration
Install and configure CMS application and database access for WSSC users groups
Clone and patch All WSSC databases and applications as required by business group
Install, configured and upgrade WAM application
Diagnosed problem and Upgrade to resolve NORTEX application issues for FIS users group
Install, configured FIS, HRMS, GIS, DWH and CMS ODBC connectivity for all users groups
Design, Install and configured Spatial Oracle Database for development, QA and production system
Upgrade ArcSDE 9.2 to ArcSDE 9.3 and ArcSDE 9.3.1 for Development, QA and Production system
Design and build multiple Geodatabases on QA and semi-production for ArcGIS application testing
Tuned Geodatabase parameters using GIOMGR utility to maximum performance.
Work with ESRI support to address GIS issue and resolution.
Maintain and support GIS developers and WSSC users groups.
Analyzed system and provide capacity planning for database and application SAN space allocation
Plan and install and configured 11g R2 RAC.
Participate and coordinate POC for Archival system Tools.
Participate in all IT projects rolled out to help design high performance database architecture.
Researching and resolve issues and filing bugs with Oracle Server development team.
Analyze and tune development, test and production database performance issue.
Analyze, diagnosing and tune ERP databases and applications in Development, QA and Production
Work closely with ETL developer to tune and modify application code
Assist ETL developer in creating new instance and database objects as needed.
Clone and troubleshoot all WSSC databases as needed
Refresh database, application schema and tables in support for application development efforts.
Restore and recover database and objects to keep all up and available to users.
Work and resolve outstanding issues through TARS with Oracle Corporation technical support.
Design and implementation RMAN NetBackup and Export backup for all databases
Programming Fire hydrant process codes and testing
Successfully Deployed Fire Hydrant process and implementation to production
Setup and monitoring nightly jobs and troubleshooting
Provide support to all application development team by creating new instances and db objects as needed
Build testing environment for backup to determine worse case scenario recovery time
Assist FIS, HRMS and ERP customer as needed
Participate in project definition and evaluation meeting
Provide input solution for new system implementation.
Provide advice for implementation of Oracle Grid control as adequate Oracle monitoring tool.
Install and configure Oracle Grid Control for WSSC database and SAN storage monitoring
Configured EMC system plug-in with Oracle Grid control.
Migrate from base release (10.2.0.3) to latest release (10.2.0.5)
Download, install and deploy Oracle agent services on monitored EMC DMX Servers
Install and configured Grid control release (10.2.0.3)
Provide presentation to team and managers after completing Grid base product configuration
Upgrading Grid control from release (10.2.0.3) to release (10.2.0.5) in support to SDE, GIS, FIS, ERP, EAM and CRM application hosted by EMC (SAN) server’s for real time performance monitoring,
Install and successfully configured Oracle Enterprise Manager System Monitoring CLARIION plug-in for SAN real time performance monitoring and reporting.
Provide daily status Report to IT system support
Sr. Oracle DBA SAIC on Assignment at NHTSA/DOT Washington DC
Mr. Yangue worked with NHTSA/DOT as Oracle Subject Matter Expert in support to NHTSA CIO Office. Duties include and not limited to configuration, installation Oracle and application software’s, client server environment setup, Database and Application Patch installation, maintain and resolve all Production, Development and Test environments. Ensure availability of all application and provide support to Application Developers and end-user communities. Achievements include:
Build Linux Red Hat AS Linux4.x x86_64 bit servers.
Design and rebuilt NHTSA databases servers to meet industry standards.
Lead DBA Project efforts and mentor other administrators and end users.
Ensuring high customer satisfaction rates.
Implement OFA for all Oracle blade servers ( Windows 2003/ Linux update4)
Successfully completed all NHTSA Oracle Database Migration from Windows 2003 physical servers to Windows 2003 Blade servers.
Providing consultation on SQL Server to development teams.
Installing, configuring, administering and securing clients' production servers.
Design custom-tailored backup/restore and disaster recovery plans for production servers.
Troubleshooting performance issues and fine-tuning queries and stored procedures.
Implementing and administering database replication between SQL Server databases.
Writing code and creating jobs to automate repetitive tasks.
Standardization of all NHTSA SQL server/Oracle servers physical layout.
Lead and implemented all NHTSA Oracle Databases Migration from 9i to 10g.
Provide assistance to Solaris migration to Linux project.
Provide assistance to other NHTSA projects migration efforts.
Recommend implementation of patches when appropriate.
Implemented CPU critical Patches on all NHTSA Oracle servers.
Design and implemented naming convention for new NHTSA Applications.
Design and implement Oracle Linux physical layout standards for NHTSA.
Reconfigure and move Oracle database servers to comply with new standard architecture
Design and implement backup strategies for all Oracle Databases on Windows and Linux OS
Assist in architecture design for all Oracle application and database servers and interact with both the system admin, infrastructure and application teams to successfully carry out the application configuration project plan
Create appropriate databases and database structures based on application usage
Provide guide lines for VERITAS Oracle database server backup setup and configurations.
Work with system administrator to design, implement and troubleshoot VERITAS backups jobs
Ensure application availability by achieving 99.99 % Production Databases Uptime for critical NHTSA Grants and Procurement system.
Configure Oracle Enterprise Management server to be used for Oracle database monitoring enterprise wide. Troubleshoot and resolve all oracle products related issues
Install, configure, upgrade and troubleshoot TOAD for developers and application users.
Install, configure, upgrade and troubleshoot Crystal Report for procurement application users.
Assist in Designing and implementing Disaster Recovery site
Assist in Designing and implementing RAC on Linux.
Provides support to NTHSA Oracle Application users.
Stay informed of Oracle patches for bug fixes and recommended
Constantly keep managers abreast with Oracle Database best practice.
05/05 – 05/06
Oracle DBA Engineer. Intelsat Corporation Washington DC
Mr. Yangue worked with Intelsat as consultant in support to Intelsat and Panamsat IT Database and Application consolidation and migration while maintaining Production, Standby, Development, Test environments. Provided 24/7 Operation support. Install and configuring OEM for Enterprise wide monitoring. Responsibilities include:
On-call rotation Support 24/7
Setup OEM and OMS for all instances, Servers monitoring and data collection
Maintained OEM for Standard Events monitoring and Data collection.
Troubleshoot and resolve all OEM issues
Provide Reports and performance metrics to managers and users for troubled issues.
Proactive local and remote database monitoring and troubleshoot all OEM error notifications
Monitor table spaces to detect those close to their maximum extent.
Check memory and table space for fragmentation.
Manage Schema for multi-user system and database application account and role.
Check the system table space if containing any user objects.
Troubleshoot database and application slow performance. Worked with Oracle Support.
Check Operating file system usage, disk space and take appropriate action.
Move or rename database instance. Rename log files and temporary table spaces if needed.
Monitor nightly jobs and archiving for Standby database.
Packages and procedure in support the development team.
Maintain all databases up and running and available to users.
Coordinate migration Operation with user communities.
Customized all Database and OEM configuration files
Develop pre-migration scripts such as Table space, DB objects info and validation…
Upgraded 102 Databases from Oracle version 8.1.7 to 184.108.40.206 and upgrade to 220.127.116.11.
Apply required and recommended Patches to resolve bugs, security issues and for upgrades
Performed security audit and resolved all risks as published by Oracle “ Voyager Code”
Backup and Recovery:
Implement Hot and Cold backup in production environment.
Work with Unix Sys admin to implement backup process for new Servers.
Clone databases and objects in support to development team.
Maintained standby site Server, activate or switch over if needed using customized scripts.
Setup OEM for all database Events system monitoring and notification
Perform system monitoring using OS tolls such as top, sar, iostat, vmstat…and database
Report and provide proactive input solution to performance improvements.
Support application developer in tuning application code. Troubleshoot ORA-error occurrences
Tune SQL statements. Schedule table and indexes analyze on crontab.
Checking tables and Indexes for fragmentation and reorganize/rebuild indexes in a regular basis.
Planned, ordered and install Oracle 9i and 10G software and third party software.
Use Oracle pre-install script to tune Unix,Linux /Oracle Kernel as pre-install task
Create database as requested by application users
Configure OEM on HP Service Guard for enterprise wide monitoring.
11/04 – 05/05
Sr. Oracle Database Administrator Lockheed Martin Lanham MD
Mr. Yangue is currently working for Lockheed Martin IS as Oracle Database Administrator contractor for HUD project supporting multiple environments 24/7. Project under sub-contract to TechUSA.
Proactive local and remote database monitoring and troubleshooting.
Develop monitoring scripts, run Jobs and troubleshoot failed jobs.
Monitor and update statistics on DBA_TABLES using DBMS_STATS packages.
Monitor table spaces to detect those close to their maximum extent.
Check memory and system table space for fragmentation.
Check Operating file system usage, and take appropriate action.
Monitor nightly jobs and archive directory.
Monitor Oracle Alerts and resolve any Oracle error.
Create database and objects to include tables, indexes, views, sequences, procedure.
Backup and Recovery:
Create and implement multiple backup strategies according to database environment
Monitored Hot and Cold RMAN backup and resolved error if any.
Work with Unix Sys admin to implement SHADOW process to nightly refresh Reporting system.
Develop sequential scripts jobs to be implemented in AUTOSYS.
Clone databases and create objects in support to development team.
Perform system monitoring using OS tolls such as top, sar, iostat, vmstat…
Database statistics gathering using STATSPACK, DBSM_STATS and sql scripts.
Report and provide proactive input solution to performance improvements.
Support application developer in tuning application code.
Troubleshoot ORA-error occurrences to include ORA-1000.
Monitor dba_tables and dba_indexes to ensure that all tables and indexes have been analyzed.
Monitor SGA/PGA: database buffer cache and shared pool (library and dictionary) cache hit ratio
Plan and install multiple Oracle and third party software to include Oracle database server 9i/10g
Installed 10g Grid control to automate system and Oracle database monitoring enterprise wide.
Configure 9i/10g databases. Configure 10g Grid control and monitoring Services.
08/03 – 09/04
Oracle Database Administrator GSA/PBS Washington DC
Mr. Yangue worked for GSA/PBS (General Service Administration) as contract Oracle 9IAS/9i Database Administrator in support to Enterprise Portal Development Project on Sun Solaris and windows XP/2k/NTenvironment. He participated in a full life cycle Enterprise Portal development an e-Business project under contract to 3H Technology, LLC.
Installation/ Configuration/ Capacity Planning:
Installed 9IAS infrastructure, Application Server and 9i Database in the three-tier architecture.
Assisted architect team in 9IAS architecture design.
Configured 9ias infrastructure, 9ias middle-tier and 9i Database tier.
Configured Ultra Search application to work with Portal.
Configured OEM web site and OMS in support to database administration environments.
Configured HTTP Server and Web Cache
Participated in logical and physical Database design.
Performed Entities and Attributes mapping.
Implemented logical Design into physical database design.
Participated in Oracle workflow to determine the optimal objects template and process flow.
Performed capacity plan for storage definition prior to database creation and configuration.
Backup and Recovery:
Designed backup and recovery strategy and documentation.
Implemented backup using scripts, RMAN and Operating system Utilities.
Created and customized backup scripts.
Configured RMAN backup policy.
Recovered database as needed.
Maintained all databases up and running and available to users.
Implemented database security policy, create and manage Database user account and privileges
Created, maintained Ultra Search instances for multiple users.
Performed Schema analysis from external source prior to ETL data in Oracle database.
Performed data load using PL/SQL and 9i MERGE new feature.
Loaded BLOB objects into Object template table in support workflow process.
Applied required and recommended Patches to resolve bugs issues and for upgrades.
Maintained iasdb up and running, create portal Groups and Pages.
URL registration, data source creation, infrastructure and middle-tier components maintenance.
Assisted management in determining the best practice for database environment.
06/2002 – 07/2003
Principal Oracle Database Administrator USPTO Arlington, VA (Crystal City)
Mr. Yangue worked for USPTO (U.S Patent and Trademark Office) in the (DBAD), Data Base Administration Division as a contractor supporting more than 250 Oracle Databases, in the Unix and Windows environment. Project under contract to Trawick & Associates.
Provided on-call support on a 24/7 basis.
Proactively monitored all production, development and test databases within the Network.
Analyze online Error messages to resolve all issues and minimize operation down time.
Providing input solutions to achieve High Availability.
Analyzed and reported on poor databases performance, design or inefficient application code.
Installed and configured latest Oracle software version, patches and tools.
Physical database design and creation using DBCA or scripts
Provided input solution for capacity planning.
Created and maintained hot Database Objects in support to application availability.
Perform monthly Objects maintenance by Exporting; truncating, coalescing fragmented tables.
Check for objects growth to detect those close to their max extent limit and provide input solution.
Monitored primary database, maintain standby database, check and maintain archive destination
Resolved issues relevant to arch process getting stuck due to space or Database hanging.
Performance tuning and monitoring.
System statistic gathering and analysis.
Set up database buffer cache advisory for Database tuning (PGA, SGA)
Maintained and analyzed tables and rebuild indexes for performances and query optimization.
Security on database servers:
Implemented Oracle account password policy in the Network.
Built a chart to gather all Databases characteristics and OS version as source of information.
Upgraded/migrated Databases to latest (version 18.104.22.168/22.214.171.124) download and apply Patches.
Worked with Oracle Support to implement security recommendations.
Resolve any bugs, security patches and updates.
Backup and Recovery:
Analyzed and implemented backup strategy to ensure zero data lost implementation
Monitor logs transport service, backup process to ensure all Databases are backed up.
Monitor Cold, Export and RMAN daily Backup
Report on 180 Servers backups on (UX and NT/2K/XP) hosting more than 250 Databases.
Maintained and modified database and backup scripts to perform scheduled jobs.
Training in database design, structured programming, user interface design, and event-driven programming. (Oracle Architecture/Developer 2000, Forms/ Reports) Oracle University.
BA Business applied IS. University of Cameroon.
OCP Oracle 8/ 8i/9i/10g 11g Certified DBA. Oracle Corporation
Solaris 9 Certification in progress.
OCP Member,Oracle Metalink /MOS/ Oracle TechNet, OTN / OEN /Club Oracle/OLN Member,
OUG Member /Oracle Magazine, Oracle Student, Sun Student Union.
Languages: English and French
References Available Upon Request