SUMMARY OF QUALIFICATIONS:

• Have over 15 years’ experience in information technology and extensive experience with Oracle’s e - Business Suite applications, Oracle WebLogic Server and Oracle Fusion Middleware Installations, Configurations, and Administrations. Have expanded the knowledge and skill set in the latest Oracle Fusion Middleware and Oracle Applications Technology Integration arena.
• Hands on experience in installations, implementations, upgrades, patching, and advanced configurations such as the F5 load balancing, High availabilities, and the RAC-based infrastructure database, etc.
• Have demonstrated the initiative to learn and adapt to the latest technology quickly.

PROFESSIONAL EXPERIENCE:

Confidential

 Sr. Oracle Apps/FMW DBA

• Designed and implemented TFSMS system with Oracle Identity and Access Management Suite 11g. This includes: Apache HTTP servers, WebGate, Access Managers (OAM), Oracle Internet Directory, Oracle Portal, and Oracle RAC database for FMW metadata.
• Installed/Configured and Clustered Weblogic Servers on 16 Linux machines to create the WLS Domains for IDM, Portal, EBS accessgate, Apex listeners, etc. Configured HA for Admin servers. Configuring Managed WebLogic Servers to use the Custom Keystores to meet the USMC security requirements.
• Tune JVM heap size for WLS Admin Servers.
• Integrated OAM with Oracle Application Express (APEX). This integration was done by registration of APEX instances into OAM, creation of WebGate agent and Application Domain, and customized Authorization Policies of HTTP Headers variable, as well as the deployment of WebGate on the APEX OHS servers and utilization of its web listener Oracle REST Date Services (ORDS).
• Designed and implemented PKI, CA, x.509 certificates, Cryptography for TFSMS system. Successfully implemented End-To-End SSL encryption for the entire Oracle Identity & Access Suite and related applications.
• Applied Oracle quarterly PSU and JDK update against Oracle FMW products and Weblogic Servers.
• Integrated Oracle EBS with Oracle Access Managers (OAM), Apex, OID, and Oracle Portal.
• Migrated the enterprise system into a highly secured data center.
• Provided Post Deployment System Support (PDSS) to meet SLA and resolve performance issues and other software known issues quickly.

Confidential, Mclean, Virginia

Sr. Oracle Apps/FMW DBA

• Identified the detailed tasks involved in planning and coordinating the 11i upgrade, the RAC based AS10g infrastructure database, clustering AS10g, integrating AS10g with 11i, replacing JInitiator with the native Sun Java Runtime Engine (JRE), etc.
• Supported several developments simultaneously, while resolving unexpected demands with limited resources and environmental constraints in creative and effective ways.
• Installed and configured a split-architecture configuration of Oracle 11.5.10.2 Applications using HP Proliant DL380 G4 (RedHat Linux AS 4) as the application server tier and HP rp7410 (HP-UX 11.11) for the database tier.
• Installed, upgraded, clustered, and configured High Availability Oracle Application Server 10g Enterprise Edition, including Identity Management Infrastructure 10.1.4.0.1 and AS10g portal 10.1.4.1.0 using 14 servers.
• Converted user accounts in the form of the traditional application accounts (fnd user) into OID.
• Integrated the Oracle Fusion Middleware component Oracle Application Server 10g Enterprise Edition with Oracle E-business Suite 11i.
• Installed and configured three sets of Oracle Real Application Clusters (RAC) running Oracle Database 10g Release 2 with Automatic Storage Management (ASM).
• Co-developed the upgrade of the TFSMS system from 11.5.9 to 11.5.10 procedures and carried out the execution in multiple iterations.
• Upgraded over 10 databases from different versions to 10.2.0.3.
• Upgraded Oracle Jinitiator from 1.1.8.16 to 1.3.1.25 and later replaced JInitiator with the native Sun Java Runtime Engine (JRE) for Oracle E-business Suite 11i instances.
• Highly effective at collaborating with Oracle to resolve extremely complex problems and bugs.
• Developed clone procedures in refreshing AS10g/11i instances using the copy of production.
• Developed password complexity verification function and automatic password generation scripts and applied them in the TFSMS database password management.
• Managed 8 development and test environments as well as the production environment.
• Served as a mentor and guide to Junior DBAs and SAs on the project.

Confidential

Sr. Database Designer/Administrator

• Developed a complete and efficient design for the ALIASTM database for the Michigan CHR Project.
• Implemented database replication after evaluated various Oracle Replication technologies.
• Loaded, validated, and verified a large-scale data set from the client’s legacy system into Oracle database.
• Coded and unit tested database creation scripts and packaged stored procedures and functions that work with the ALIASTM application codes.
• Performed database installation, configuration, patching, and performance tuning.
• Researched and prepared to implement Oracle9i RAC on Linux.
• Performed ad hoc analysis and query utility coding to generate reports from data warehouse server.
• Supported internal developers and Confidential Staff with their database questions and issues.
• Actively participated in meetings with Confidential staff and 3rd party vendors to address database design and implementation issues.
• Successfully configured the Alias application databases in the customer’s production environment.
• Transferred the knowledge and operational procedures to the client.

Confidential

Primary Production DBA

• Managed the UCCNet mission critical web application databases under High Availability Architect (Veritas Cluster Server Configuration) that meet the SLA.
• Provided troubleshooting for the live production database problems and handled database changes, emergency fixes, and bug fixes across the stage, certification, and production environments in a timely manner.
• Developed and tested database disaster recovery by using Oracle 9i Data Guard in order to minimize data loss.
• Completed the database upgrade from Oracle 8 to 8i and 8i to 9i within a minimum downtime window.
• Tuned the database server, SQL, and PL/SQL that significantly improved database performance.
• Implemented Oracle 8i/9i database new features, which increased the database manageability and efficiency.
• Transferred the knowledge and operational procedures to the client.

Confidential

Lead Development DBA

• Redesigned the UCCnet GlobalPortal data model.
• Created and managed multiple databases for development, bug fixes, functional test, and performance test.
• Responded to requests from the UCCnet project management, business analysts, Helpdesk, operational team, development team, and test team in a timely fashion.
• Created the UCCnet database build procedure and scripts that standardized the repeated tasks.
• Re-configured and Created database Audit Trail reports.
• Drafted the UCCnet database performance recommendations that were accepted by senior management.
• Evaluated and recommended the purchase of the database management tools; recommended the development and test database server memory upgrade to enhance system performance.
• Resolved assigned Bugs by the due date.
• Developed and modified the SQL and PL/SQL programs for the UCCnet project.

Confidential

Production and Development Database Support

• Implemented data mart purge, transfer, and archive process in Unix shell scripts to off-load system overhead.
• Performed the day-to-day, on-line magazine production and physical standby (Oracle 8i) database management activities that well satisfied the customer.

Confidential

Database Architect/Lead DBA

• Performed the full web database development lifecycle including business requirements analysis, conceptual data modeling, and conflict resolution with application object modeling, physical database design, and database build.
• Enforced database object naming convention and SQL coding standards.
• Addressed the loading stress issues for this On-line marketing sales web application.
• Delivered the OnNet Online data model brief, database build procedure, and OnNet Online database performance recommendations documentations.

Confidential, Baltimore, Maryland

Senior Oracle Applications DBA/Developer

• Finalized Oracle Applications Release 11 Network Computing Architecture planning on multiple Sun Enterprise machines.
• Installed and configured Oracle Applications 11.0.3 and 11i with modules AR, AP, GL, FA, and CM. Set up Oracle ADI 6.0.4 on financial users' desktop.
• Applied AR Mini-Pack and other critical patches to fix the problems.
• Reviewed and assigned the custom extensions functional design and technical design for Oracle Applications. These extensions include, but are not limited to, modules such as interfaces, automated data load from web site, reports, forms, and enhancements.
• Created custom schema, objects, and file system structure.
• Migrated custom development from test environment to production environment.

Confidential, Laurel, Maryland

Senior Oracle Database Analyst

• Stepped in to quickly get familiar with Oracle Applications to avoid hiring a specialized DBA from the Oracle consultant services resulting in a significant cost savings.
• Played the lead DBA role in Oracle E-Business Suite Applications GL, HRMS, and PAYROLL implementation.
• Installed and configured Oracle database, Oracle Applications, and Oracle Application Server 4.0.8.1 for Web-enabled Applications.
• Upgraded Oracle Server from 7.3.2.3 to 7.3.4.4 and Applications from 10.7 prod 16 to 16.1.
• Tracked, troubleshot issues, and resolved Oracle TARs; monitored, enhanced, and refined production performance; and provided intensive technical support to both functional-users and application developers.
• Received the General Manager’s reward for contributions to the Financial Information System project.

Confidential, Baltimore, Maryland

Database Manager/Analyst

• Maintained and updated various large-scale databases such as Maryland Unemployment data, Maryland Employer data, Baltimore City Public School data, and Welfare data from different sources in HP-UX, C, SAS and Oracle7 environments.
• Installed and upgraded HP-UX, Oracle7 Server and Oracle application tools on HP9000/700 series workstations.
• Evaluated the hardware of the database server and add devices such as disks and memory to the system.
• Normalized database, managed database storage, and tuned database performance.
• Manipulated, analyzed data and generated reports for government agencies and research associates.