Objective: Seek a challenging position on an Oracle-based data warehousing or large system project where I can contribute/design/integrate/configure/code/tune/support all aspects of the system components.

PROFESSIONAL EXPERIENCE

Confidential

Provided IT consulting services to the USDA - NFC National Finance Center's Enterprise Reporting Project, INSIGHT an enterprise-wide data warehousing project with advanced business intelligence capabilities.

• Worked with ETL team to assist in development of some back-end database packages to be called from Oracle Data Integrator ODI packages. Provided ODI administration supports such as backup/recovery, security patching, users management, topology configuration management, master/work repository refreshes, code migration. Tuned inefficient codes regularly. Upgraded ODI to 11.1.1.7.
• Provided infrastructure administration support for Oracle database, Oracle Data Integrator, WebLogic. Provided back-end support for OBIEE application. Collaborated and worked closely with Data Modeling, ETL, BI, Testing, Business teams to convert business requirements/data into business soft tools/reports/information. Participated in all life-cycle phases of data integration.
• Installed and configured enterprise reporting infrastructures for development and training teams. Installed and configured databases, WebLogic servers, ODI Agents/Studios, OBIEE suite, APEX, HTTP Web servers. Worked with System Admin team to allocate and to plan out servers worked with network/security teams to resolve port, SSL certificate, firewall, F5 issues configured ETL processes applied security patches.

Platforms Tools: Solaris10, Oracle 11g, Weblogic10.3.6, Oracle Data Integrator 11.1.1.7, OBIEE 11.1.1.7, Oracle HTTP Server 11.1.1.7, APEX 4.2.2.00.11

Confidential

Senior Oracle Database Administrator

• Provided Oracle database and Fusion Middleware support to the CBER eMRP pilot program at the FDA. Troubleshoot SOA BPM workspace/composer/BAM issue where login screen rendered blank pages. Decoupled Oracle OAM SSO from Weblogic server to narrow down the issue. Replicated the CBER eMRP pilot system on a different server from scratch to identify the cause of the issue. Installed and configured WebLogic 10.3.3.6, Oracle database repository 11.2.0.3, SOA 11.1.1.6, OSB 11.1.1.6, JDeveloper 11.1.1.6. Configured SOA domain and datasources. Tune JVM runtime memory.
• Analyzed and provided inventory of RMAN backups for FDA ORA division databases. Recommended a different and a more precise method for reporting daily backup report. Setup new RMAN backups for new databases.
• Provided Oracle database administration and Oracle Fusion Middleware support to FDA MARCS 2.0 Inspection project. Worked closely with application developers to assist them on issues relating to database and WebLogic.
• Wrote UNIX script to automate the sequence order for starting FMW product related managed servers that interdependent of each other.

Platforms Tools: Solaris10, Linux5, Oracle RAC10g 11g, Weblogic10.3.6, SOA11.1.1.6, OSB11.1.1.6, JDevloper11.1.1.6.

Confidential

Senior Oracle Database Administrator

• contributions in support of the 2010 Census Fingerprinting Program.
• Feeder systems to web technology.
• contribution to the success of the CBS Reauthorization project.
• Provided all database administration support for the data warehousing project in development/ test/ production environments at the Administrative and Management Systems Division AMSD of the Census Bureau. Assigned as the primary DBA for the data warehousing project.
• Configured, administered and tuned the data warehouse extract, transform, and load ETL process. The ETL process received data source from the bureau wide Census Business System CBS . Monitored nightly data refresh flowing into different data marts and materialized views. Reconciled data discrepancies. Maintained partitioned tables. Administered all data flow interfaces to and from the data warehouse database. Attended regular meetings with different groups to gather data warehouse requirements and interfaces with other projects.
• Provided administration support for the middleware layer of data warehouse system. Installed, configured and administered WebLogic server. Tuned JVM HotSpot and Jrockit. Resolved stuck threads issue. Setup Machine and Node Manager. Administered LDAP/OID user accounts and RADs using Oracle Directory Service Manager ODSM and PL/SQL DBMS LDAP package. Administered WebLogic Forms service. Assisted developers with forms compilation, migration and deployment to Oracle11g Fusion Middleware platform.
• Worked with development team to build a web-based application CBS Reauthorization to reauthorize all Single Sign On accounts of all the applications AMSD managed. Involved in all software development life cycle. Analyzed, designed and implemented most of PL/SQL backend packages and APIs to front-end codes.
• Provided support for other AMSD databases and systems as needed. Supports varied from administration to data backup to tuning to programming to monitoring SOA applications.

Platforms Tools: Solaris10, Linux5, Oracle RAC10g 11g, Weblogic10.3.4, ODSM11.1.1.5, Oracle Fusion Middleware11g, Grid Control11g, OWB10g, TOAD, Physical Standby database.

Latest Oracle Trainings: WebLogic Administration, WebLogic Tuning, WebLogic Troubleshooting, WebLogic Forms Service, Identity Management, Oracle SOA Suite Administration, Oracle Service Bus Administration

Confidential

Senior Oracle Database Administrator

Installed and configured an Oracle10G R2 Real Applications Cluster RAC environment on Linux platform this environment COHORT is used to store replicated medical data collected at various military bases around the world. Set up COHORT User Acceptance and Development environments. Upgraded RAC 10.2.0.1 to 10.2.0.3. Upgraded RMS production database from Oracle 9iR2 to 10gR2 RMS database is used to store copies of Referral Faxes originated from various military sites. Migrated and loaded data into RAC environments. Set up RMAN repository and scripts for backup/recovery. Converted large tables into partitioned tables and performed maintenance work on existing partitioned tables. Converted regular heap table structures into index-organized structures. Performed Mitigation and applied critical patches against production databases. Set up schedulers to alert and report system's health via email notifications. Researched and presented Oracle Advance Queuing and Change Data Capture CDC technologies to developers. Implemented shell scripts to monitor disk space, check alert logs, cleanup OS directories, and automate export/import process. Assisted developers with PLSQL and typical database issues on daily basis. Administered and performed troubleshoot RAC database-related issues. Monitored systems performance.

Platforms Tools: Oracle10G R2, Toad, OEM, SQLPlus, Linux 4x, Windows, UNIX Shell, RMAN, PL/SQL

Confidential

Senior Oracle Database Administrator

Provided infrastructure systems support to the Military Operations Program at the Federal Aviation Administration Command Center. Performed a tuning process for the existing production data load. Installed and configured Oracle database 10g for test environment. Set up and configured the RMAN repository. Performed backup and recovery on development and test environment per request. Monitored and managed the entire development environment daily using Enterprise Manager Grid Control. Cloned and Refreshed development environment with production. Assisted in applications upgrade. Installed and configured Oracle10g Applications Server. Installed and configured ARCSDE 9 and ARCGIS ARCMAP and ARCVIEW. Performed export/import of Oracle Spatial data.

Platforms Tools: Oracle10g, Oracle10gAS, Solaris 9, UNIX Shell, Enterprise Manager Grid Control, ARCSDE 9, ARCGIS 9

Confidential

Senior Oracle Database Administrator

Provided 24x7 on-call support to the Bureau of the Consular Affairs at the Department of State. Monitored, maintained and troubleshot replicated data and system issues that often generate in multi-terabyte environment part of the team that managed all the US overseas embassy's databases and their consolidated domestic databases in the US. Managed and monitored IDENT dataflow process. IDENT dataflow is a process that sends fingerprint and biometric information of VISA and NON-VISA applicants to the Department of Homeland Security DHS for scanning against terrorist watch list. Activated standby databases when there was a failover. Set up Oracle9i database for a development project and provided development support. Developed PL/SQL packages to retrieve replicated data spanning in multiple servers. Provided applications upgrades.

Platforms Tools: Oracle 8i 9i, Win2000, Replication Manager, PL/SQL, NETIQ

Confidential

Oracle Database Administrator

Recognition: One of the Key Contributors to Group's Successes

Analyzed, redesigned, implemented and unit tested a system integration process that allowed DELPHI - a brand new accounting system implemented for the Department of Transportation - to share and reconcile data with IFACTS. IFACTS is a web-based funding and allocating system that is currently utilized by the Federal Aviation Administration, AFZ801.

Platforms Tools: Oracle 8.1.7, UNIX Solaris 2.6, PL/SQL

Analyzed and redesigned the data feed process that allows an in-house system, ESIS, to properly and efficiently receive and process data from a data center. ESIS is an energy and facility tracking system that is utilized by the Federal Aviation Administration, AFZ801.

Platforms Tools: UNIX Shell script, PL/SQL

Installed, configured and partitioned additional disk devices and file systems on SUN Solaris server. Managed local spaces and performed file retrieval from backup. Set up mirrors for hardware devices to speed up backup and recovery effort.

Platforms Tools: UNIX Solaris 2.6

Provided routine administrative, backup Recovery, and tuning support for ESIS and IFACTS systems. Implemented shell scripts to monitor and automate Oracle process and system's space usage.

Platforms Tools: UNIX Solaris 2.6, Windows 2000, Oracle 8.1.7, OEM

Confidential

Oracle Database Administrator

Provided 24x7 on-called supports for Remedy, Financial, billing, data warehouse and Legacy production database systems. Installed and configured Oracle 7.x.x 8.x.x on UNIX Solaris and HP-UNIX platforms. Designed, configured, implemented, administered and performed disaster/recovery on production and development databases. Cloned and refreshed development and test environments using hot and cold backups from production. Monitored system performance. Set up cold hot backup and monitoring shell scripts on new databases. Configured SQL Net and Net8 for both clients and servers. Performed different tuning aspects of production environments. Applied patches to Oracle 7.3.4 servers. Migrated development and production remedy and financial database servers from version 7.3.4.5 to 8.1.7.0

Platforms Tools: Oracle 7.x.x 8.x.x, UNIX Solaris 2.8, HP-UNIX 11, Shell Scripts

Worked with application developers to create and to debug various PL/SQL packages, database triggers, SQL Loader and shell scripts. Assisted production support personnel with front/back-end troubleshooting legacy and web-based applications systems. Provided analysis/data-modeling assistance to application developers. Collaborated with the remedy team in upgrading remedy applications from version 4.0.2 to 4.5.1.

Platforms Tools: Oracle 7.x.x 8.x.x, designer 2000, UNIX Solaris 2.8, HP-UNIX 11, PL/SQL

Designed and developed application program interface that automated the population of telecommunication invoice data into Circuit Billing Reconciliation CBR . CBR was a legacy system that reconciled telecommunication invoices with PSINet circuit usage. This automated process produced paperless accounting.

Platforms Tools: Oracle 7.x.x, Forms 4.5, PL/SQL, SQL Loader, UNIX cron job, designer 2000

Worked with a consulting team to integrate PSINet's acquired companies' data into PSINet's databases. This project impacted various databases and applications. Responsibilities included designing and creating interface tables, triggers, and packages to validate data. Migrated and loaded data into PSINet's system such as Account Circuit Tracking system. ACT system was used to track all customer-centric activities starting from entering the contract until the last circuit was set up.

Platforms Tools: Oracle 7.x.x, PL/SQL, Designer 2000, SQL Loader

Provided production support for homegrown legacy systems. Duties ranged from correcting applications and systems problems to designing and upgrading existing systems. Ensured users' satisfaction and on-time deliveries of software patches.

Platforms Tools: Oracle 6 7.x.x, Designer 2000, Developer 2000, PL/SQL, SHELL scripts, UNIX cron jobs

Designed and developed Business Object universes for a data warehouse project. These universes served as repositories of object data allowing end-users to create and customize their own reports.

Platforms Tools: Oracle 6 7.x.x, Designer 2000, Business Objects 4.0