EXECUTIVE SUMMARY:

OCP - Certified Oracle DBA with 20+ years IT experiences, specialize in Oracle Database Server administration, commands solid Oracle core technology skills, strong organisational skills, has strong interest in a Sr. Oracle DBA position in the Greater Washington DC area.

TECHNICAL SKILLS:

Technical Track: O/S Environment Database Server Software/Tools

Hardware: racle RDBMS Server and Oracle Applications Database Administration Sun Solaris; HP-UX, IBM-AIX, RH Linux, Windows Oracle RDBMS 7.x, 8.x, 8i, 9i, 10g, 11g, 12c Oracle Applications 11.0.3 AD utilities like adctrl, adaimgr, adadmin, adpatch, adunload, adrelink; Oracle Enterprise Manager with Performance Tuning and Diagnostic Pack, RMAN, SQL*Loader, SQL Trace & TKPROF, SQL*Net, Oracle Agent, Oracle SQL Developer, SQL*Plus, Oracle OEM Fusion Middleware Control, Oracle WebLogic Manager, Oracle HTTP Server, Quest SharePlex real time replication, Quest Central for Oracle, SQLab Vision, TOAD, Spotlight on Oracle, CA AllFusion Model Manager (ModelMart), ERwin, Siebel Call Center, OpenText Exceed X-windows, WRM Reflection X. HP 9000, Sun ES 10000/6500/5500/4500/ Sunfire880, IBM RS/6000/P650, HP SureStore E Disk Array XP256, EMC Symmetrix 8000/5000/3000 Enterprise Storage System

PROFESSIONAL EXPERIENCES:

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• Perform software installation and configuration of Oracle enterprise databases migrations on multiple platforms from Solaris to AIX to Linux, and database major release upgrades from 8.x to 9i to 10g to 11g to 12c over past 14 years.
• Install, configure and maintain Oracle Internet Directory system (Oracle LDAP), and Oracle Enterprise Manager system (Oracle Grid Control), including latest Oracle Fusion middleware control and oracle WebLogic Server installation and administration.
• Develop and formulate standards of procedures (SOP) and naming conventions for various Oracle database administration tasks.
• Develop, standardize and implement database availability monitoring, backup jobs and other troubleshooting utilities in various extensive shell scripting tasks.
• Evaluated and perform database and instance wide performance tuning, data growth monitoring and capacity planning.
• Design, plan and perform Oracle database various patching activities, including patching strategy for databases in RAC environment.
• Design, implement Oracle database security encryption solution via Oracle Wallets.
• Participate in planning and implementing database disaster recovery (DR) solution via scheduled load-shifting activities among data centers.
• Design, test and implementation of database RMAN online backup and recovery strategy; and logical data export or import (including Datapump) plans, database cloning or duplication procedures.
• Review new database setup requirements from user groups. Design and propose system requirements and specifications to meet the user groups business needs.
• Provide database user access management to user groups and application developers.
• Develop and implement Oracle database security auditing procedures and setup.
• Evaluate and collect requirements for database annual auditing event from internal and external auditors. Provide evidence to meet auditors requests.
• Design, plan, install and manage Oracle 11g RAC databases to support mission critical application in high availability mode.
• Design, plan, install and manage Oracle 11g Data Guard to provide high level’s data protection and off load reporting solution.
• Perform extensive in-depth research for trouble-shooting and debugging various database issues in Oracle Support website (Metalink).
• File proper Oracle Support tickets and work closely with Oracle Support for various in-depth troubleshooting tasks.
• Conduct testing and concept proofing of various Oracle latest technologies, like recent Oracle 12c cloud computing in AWS RDS environment.

Confidential, Annapolis, MD

Sr. Oracle DBA

Responsibilities:

• The major tasks include production database backup and recovery, database real-time monitoring, trouble shooting through proprietary monitoring software, performance monitoring/tuning, change request implementations, database migrations/upgrades from 8.0.x to 8i and 9i.
• Provided night shift operational support for 300+ Oracle databases which versions are ranging from 8.0.4 to 8i and 9i. Most of the databases are clustered on Sun or HP boxes implementing Veritas failover solution for high availability purpose and Quest Software’s SharePlex for real time replication purpose. Backup solution is implemented with Veritas NetBackup throughout all platforms.

Confidential, Reston, VA

Sr. Oracle DBA

Responsibilities:

• Maintained 13 Oracle Applications (Financials) 11.0.3 databases on HP-UX platform and configured environment specifically for production migration, acceptance test, integration test, application development , patch test, and training activities. Maintained close interaction with Sr. IT management with regards to database architecture design and presentations, resources and capacity planning, database application development.
• Maintained Oracle Financials databases by controlling space and memory usage, debugging and applied customised objects, implementing backups, recovery and data migration, creating database links between different databases for data checking and updating, applied user/security management policy, debugging SQL1Net problems and fixed database connection problems.
• Migrated Oracle Financials development database servers from 8.0.5 to 8.0.6 and provided migration path for production; Wrote shell scripts for DBA routing activities like alert log checking, data refresh, export/import and backup processes; Conducted data refresh from production instance to development instances;
• Maintained Oracle Applications (Financials) environment by installing and managing Oracle Application Server , applying new releases, managing concurrent programs, implementing requests/reports purge(cleaning), setting up printing mechanism in Unix, configuring report view format (PDF, text, html), and applying patches. Automated startup and shutdown of all application services.
• Restructured Oracle Applications (Financials) 11.0.3 environment by implementing server partitioning , which allows Oracle Applications Release 11.0.3 to use Oracle 8i Enterprise Edition Release 8.1.7 to store database objects and data while the Oracle Applications file system is still using Oracle8 Enterprise Edition Release 8.0.6 technology stack.
• Provided ad hoc technical support to Financials Application users and development team in following fields: Troubleshoot data or script errors during custom configuration; Installed Application tools (ADI, Workflow, Tickmark, RingMaster); Set up client Oracle environment so as to enable users use oracle tools; Set up Unix environment for developers to use form/report GUI tools in Unix; Tuned SQL, PL/SQL scripts for custom objects and data conversion.
• Provided software installation of Oracle 9iAS and Oracle Discoverer (Version 4.1, both Administration and User Edition) and database support for Confidential Financial Data Warehousing team.
• Installed and configured Oracle Enterprise Manager (OEM) 9i version in a multi-tiered Oracle server environment. Installed Oracle 9i database server software and created an Oracle 9i database hosting the OEM repository. Configured Oracle Diagnostics Pack and Tuning Pack for better monitoring, diagnosing, capacity planning and tuning the Oracle databases.
• Participated and supported other 2 OLAP/DSS data warehousing projects: Regulatory Finance Information System, Revenue Projection Management System. Installed and configured Oracle Server 8.1.6 / 8.1.7 software; Created and maintained 6 instances for development, integration and QA testing purpose; Conducted both logical and physical database designs with a complex data / index partition scheme; Proposed and customised OFA-compliant database file system.
• Prepared database backup and recovery strategy; Prepared DBA utilities scripts; Created the model for projecting data growth and provided database sizing support in capacity planning. Conducted performance-tuning support for application developers, which focus on SQL tuning, system disk I/O tuning and other system memory/resource tuning .

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• Participated in the development and support of a cutting-edge E-commerce financial system , which offers real time credit approval and notification, loan origination, funding, settlement, fulfilment, transaction reporting and customer care - all on the Internet base. The system runs Oracle 8i in 24x7 hot standby mode on Sun Solaris 2.7 platform.
• Installed and configured Oracle Server 8.1.6 software; Created and maintained 6 database instances for development, integration, QA testing, demo and production environment;
• Conducted both logical and physical database designs ; Prepared database backup and recovery strategy; Prepared export/import and sql loader scripts; Deployed Oracle Advanced Network Option and set up database access control mechanism.
• Involved in database sizing activities in capacity planning; Created the model for projecting data growth ; Proposed and customized OFA-compliant file structure.
• Maintained SuperSolution’s proprietary Daybreak Financials Application; Coded daily job shell scripts for batch job and ACH file generation; Applied Daybreak patches to meet changing customisation needs.

Confidential, Washington, DC

Sr. Oracle DBA

Responsibilities:

• Performed Oracle services focusing on backend database administration, performance tuning, system migration, application conversion and migration, and web based Oracle Application Server (OAS) administration . Conducted both logical and physical database designs including data normalisation, ER modelling, object sizing, disk i/o distribution and database access control.
• Prepared, deployed and consistently tested backup and recovery strategies in support of Confidential global operations in mission critical 24x7 environment . Proactively monitored, researched and installed Oracle patches for both RDBMS servers and application development tools based on new technical requirement.
• Built and deployed Confidential multi-tier and multi-platform database application architecture . Web-enabled Oracle Forms and Reports applications within headquarters intranet through installing and configuring Oracle Application Server (OAS), Developer Forms Server and Reports Server. Monitored and tuned Oracle Application Server (OAS) for optimal performance. Examined and configured OAS web security schema and multi-node load-balancing schema .
• Created and documented the pilot program for migrating existing forms from Oracle Forms 4.5 Mac version to Oracle Forms 6.0 NT version, and existing reports from Oracle Reports 2.5 Mac version to Oracle Reports 6.0 NT version.
• Co-ordinated the collection of technical requirement information on various application development and conversion projects by working closely with team application developers, technical writers and functional group managers. Identified procedures and techniques to improve performance of application code.