SUMMARY:

Oracle Certified Professional (OCP) with over 20 years of professional experience in the Information Technology industry, I have gained knowledge in all phases of software development life cycle. During my years of experience, I have been involved in the design, development, migration, and implementation of software solutions utilizing my proficiencies in Oracle Database Engineering and Administration (Application DBA and Operation DBA), Data Modeling, and Data Warehousing. I have a strong understanding of both relational and dimensional modeling and experience with working on multi - terabyte database systems.

TECHNICAL SKILLS:

• Oracle8i/9/i10g/11g/12c
• Oracle 11g Real Application Cluster (RAC)
• Oracle Exadata
• Oracle Data Guard 11g
• Oracle VLDB
• Recovery Manager (RMAN)
• Oracle Automatic Storage Management (ASM)
• Automatic Workload Repository (AWR)
• Enterprise Manager Cloud Control 12c (OEM)
• WebLogic 11g
• Oracle E-Business Suite 12.1.1
• Oracle GoldenGate 11g
• UNIX/LINUX Shell Scripting
• PL/SQL
• SQL
• SQL Loader
• Oracle Data Pump
• Erwin
• Oracle Warehouse Builder (OWB)
• Informatica PowerCenter 8.6
• SQL Developer
• TOAD
• MYSQL
• MS Access
• Visual Basic
• ASP
• HTML
• JavaScript.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA/WebLogic Admin

Confidential, Herndon, VA

Responsibilities:

• Sr. Oracle DBA consultant providing both Oracle DBA (Application and System/Core) and WebLogic support for Confidential Disaster Credit Management System (DCMS). DCMS is a 24x7 environment that provides low-interest rate loans to survivors of natural disasters.
• Responsible for providing Database Engineering and Administration support for all environments (production, non-production, and COOP/standby), which consists of 26 Oracle Database servers and 14 WebLogic Application servers on Solaris 11 and ZFS storage.
• Installed, configured, and maintained Oracle 11g/12c RDBMS and Enterprise Manager 13c, upgraded Oracle 11g environments to Oracle 12c, developed backup and monitoring scripts.
• Decommissioned and registered target environments, created incident rules and notifications/alarms in Oracle Enterprise Manager 13c, and Configured OEM and all target agents to use third party SSL.
• Maintain, troubleshoot, and configure weblogic, and harden weblogic ports and settings to comply with SBA’s security standards.
• Performance tune all environments and resolve all database related issues, generate and analyze AWR/ASH reports, install quarterly CPU patch for Oracle database and WebLogic, backup database, refresh staging environment with production data using RMAN restore, and support WebLogic deployment builds.
• Resolve Nessus and Tripwire security vulnerability scan, and implement SBA’s security baseline (hardening) standards to meet STIG compliance standards.
• Work with storage engineer to optimize ZFS storage to maximize throughput for Oracle database.

Sr. Oracle DBA/Exadata Admin

Confidential, Washington DC

Responsibilities:

• Sr. Oracle Database Architect/DBA providing both Application and System DBA support for Confidential Enterprise Data Warehouse (EDW). EDW is a 4 Terabyte system that runs on Oracle Exadata half rack, which consists of 4 Oracle RAC nodes and 7 storage nodes with ASM/Exadata/Linux platform configured with a physical standby database using Data Guard.
• Responsible for performance tuning, monitoring database and storage servers/cell nodes, reviewing code migration, maintaining schema objects and privileges, and managing all environments for EDW (development, test, production, and COOP/standby).
• Developed monitoring and maintenance scripts in support of EDW, generated AWR and AWR SQL reports to analyze performance, significantly reduced nightly jobs from 4 hours to 15 minutes, and improve overall stabilization of EDW system.
• Database Lead for re-platforming current Exadata environment onto Amazon Web Services (AWS) Elastic Compute Cloud (EC2) and Relational Database Service (RDS) environment, which entails recommending database architectural design, installing and configuring Oracle 12c, and restoring production data from Exadata environment onto AWS.
• Resolved multiple failed drives and replaced Infiniti band adapter on Exadata cell nodes for production and non-production environments, restored Exadata environment after an entire storage node crashed, and manually created cell disks, grid disks, and asm disks.

Sr. Oracle Database Architect/DBA

Confidential, Washington DC

Responsibilities:

• Responsible for providing all aspects of Database Engineering and Administration support for multiple environments (development, test, and production).
• Recommend and implement Oracle Database partitioning and indexing strategy, perform capacity planning, monitor database usage, configure and manage ASM disks, identify and resolve performance issues, address defragmented objects, and enable resumable space allocation to facilitate batch loads.
• Installed and configured Oracle 11gR2 Grid Infrastructure/Real Application Cluster (RAC), Oracle 11gR2 and Oracle 12c RDBMS, Enterprise Manager 12c, and GoldenGate 11g.
• Configure and monitor physical standby database and performed fail over database switchover drills from primary to standby to ensure archived logs are successfully transported, and leverage Oracle Flashback Technologies to facilitate testing.
• Installed and configured E-Business Suite R12 (EBS) application on 2 nodes Linux platform, performance tune (EBS) application, performed maintenance on system, applied patches, and monitored EBS jobs.
• Scale-up existing Oracle RAC environment by extending Oracle Clusterware and RAC Database onto new node.

Sr. Oracle Database Architect/DBA

Confidential, Vienna, VA

Responsibilities:

• Responsible for providing Oracle engineering and Database Administration support, maintaining both the logical and physical data model, recommending data warehouse best practices for fast data loads, database design, and database configuration.
• Implement partitioning, indexing, parallelism, and database backup strategies for all environments (cold backups and RMAN).
• Maintain data model using ERWIN and ensure both logical and physical data model conforms to FINCEN’s naming standards.
• Clone database onto different environments with different ASM configuration using RMAN, transfer Oracle datafiles from file system storage to ASM storage, migrate Oracle managed files from with 32k blocksize to an environment with different 8k blocksize using transportable tablespace, and create restore points to flashback database.
• Installed and configured physical standby database and monitored DR environment using Oracle11g Data Guard.
• Developed and automated a migration script using Unix Shell and PL/SQL to ensure all database objects are synchronized in each environment, reviewed, corrected, and performance tuned developer’s scripts (SQL, PL/SQL), and managed all migration efforts while following the CM process.
• Create and maintain Oracle objects and thresholds, generate AWR snapshots and ADDM reports, and resolve database performance issues using Oracle Grid Control.

Solution Architect/Oracle DBA

Confidential, Mclean, VA

Responsibilities:

• Solution Architect/DBA for the Single Family Credit Data Mart ( Confidential ) project for Confidential . The Confidential data mart is on a LINUX / Oracle 11g RAC with Automatic Storage Management (ASM) architecture platform with 5 terabytes of data.
• Provide Oracle Database Engineering and Administrative support, data modeling, and data warehouse expertise to improve the overall design and performance of Confidential .
• Significantly improve the performance for Confidential by recommending best indexing and partitioning strategies, utilizing parallelism, creating materialized views, and formulating solutions for fast data refresh and data loads.
• Interact with business users, developers, performance, and production team to provide solutions to resolve performance related issues.

Sr. Oracle DBA/Data Architect

Confidential, Fairfax, VA

Responsibilities:

• Responsible for the overall design, development, and maintenance of both physical and logical model for both CRMIS (Case Review Management Information System) and MIS (Management Information System) Data Warehouse System for CMS (Center for Medicare and Medicaid) using dimensional modeling, recommend data warehouse best practices and data load strategies, provide Oracle Database Administration support, and produce project documents (database design document, system design document, and operation and maintenance manual documentation).
• Responsible for installing, configuring, performance tuning, and maintaining Oracle 10.2 Database on Solaris 10 for the development, test, and production environment.
• Develop and implement database backup strategies for both Confidential and CMS’s environment using RMAN.
• Ensure both LDM and PDM conforms to CMS’s data architectural guidelines.

Business Intelligence Specialist

Confidential, Mclean, VA

Responsibilities:

• Designed developed, and implemented an Enterprise Data Warehouse System for the EMDS (Enterprise Management Decision Support) project for Deputy Under Secretary of the Army Business Transformation (DUSA-BT).
• Provide database administrative support to Avanco projects. i.e. Install, configure, performance tune, restore and recover database, and upgrade Oracle products (Oracle 10g database, Oracle Warehouse Builder 10g, Oracle Application Server 10g, Oracle Portal, and Oracle Business Intelligence Enterprise Edition).
• Responsible for the design, development, maintenance of both physical and logical data model for EMDS using dimensional modeling, analyze both business requirements and Army data to translate into technical design, develop and performance tune ETL mappings, develop refresh strategies, and develop PL/SQL procedures/functions and dimensional objects utilizing the OLAP catalogue.
• Defined methodologies and business rules, established performance and technical standards, and interact with customer and team to formulate system architect.

Data Systems Engineer

Confidential, Vienna, VA

Responsibilities:

• Designed and developed Confidential Data Warehouse System using Erwin Data modeling tool, Oracle Warehouse Builder 10g (OWB), PL/SQL, and Oracle 10g database.
• Analyzed Confidential KEYVIEW Data warehouse for restructuring and modernizing into a dimensional data warehouse.
• Responsible for developing and maintaining Oracle 10g objects on Sun Solaris platform, formulating ETL strategies from source to target database, developing OWB mappings and PL/SQL scripts, and maintaining both logical and physical design.
• Responsible for all database administrative tasks. i.e. Install and configure Oracle 10.1 database, perform database backups, create and manage oracle objects (DDL, sequence, indexes, and tablespaces), and performance tuned both database and ETL mappings.
• Lead and mentored development team to design and develop efficient ETL mappings and data warehouse process.
• Provided data migration support and recommended data load strategies for Total Force Data Warehouse (TFDW) on LINUX/Oracle9i platform system for the United States Marine Corp using Oracle Warehouse Builder 9.2.

Information System Technologist

Confidential, Mclean, VA

Responsibilities:

• Developed and maintained Enterprise Data Warehouse on Sun Solaris 7.0 UNIX/Oracle 9i platform system for the Department of Treasury.
• Extract, transform, and load data (ETL) from PeopleSoft Database System and National Finance Center (NFC) Mainframes (flat files) using Oracle Warehouse Builder (OWB) 9.2, UNIX script, and PL/SQL.
• Supported Business Objects developers by resolving all data issues related to data warehouse.
• Designed, developed, and implemented Customer Relationship Management (CRM) application on HP-UNIX/Oracle 8.0.6 platform system for British Telecommunication Public Safety Radio Communication Project (PSRCP) using Clarify eFrontOffice, Oracle8i, and PL/SQL.
• Interacted with clients and analyzed requirements to formulate system architecture and produced documents (system design, test, transition, and installation procedures in support of British Telecommunication.

Technical Consultant

Confidential, Reston, VA

Responsibilities:

• Customized Clarify CRM application (eFrontOffice v8.5) for 360networks project on Unix/Oracle 8.0.6 platform.
• Installed and configured Clarify Web Application (Clear Express) on NT Server, developed PL/SQL scripts, modified web site for Nortel’s Sales department using ASP and JavaScripts, and converted Clarify baseline Actuate Reports into Crystal Reports.

Application Lead

Confidential, Washington, DC

Responsibilities:

• Developed, implemented, and maintained database system using Clarify CRM software package and Oracle 8.
• Responsible for developing and maintaining forms using ClearBasic, designing data model via Data Dictionary Editor, developing reports using Crystal Reports 7.0, and performing database maintenance.

Visual Basic Developer

Confidential, Arlington, VA

Responsibilities:

• Designed, developed, and implemented Orphan Products Development (OPD) for the FDA using Visual Basic 6.0 and Oracle 7.0.
• Responsible for researching client requirements and formulating design alternatives, developing GUI interface and Oracle objects, installing and configuring the development environment, and developing both test and user documentation.
• Developed and maintained EMSARS database system using VB 6.0, Crystal Report 7.0, and Access 97.

Programmer

Confidential, Arlington, VA

Responsibilities:

• Designed and developed Out Year Planning System (OYPS) for Advance System and Technology Office (ASTO) using Visual Basic 6.0, MS Access, and Erwin.
• Translate business requirements into technical design document.

Programmer

Confidential, Arlington, VA

Responsibilities:

• Maintained TIEMS database system using Visual Basic for Application and Access (VBA).
• Involved in adding enhancements to website using HTML and Active Server Page (ASP).