We provide IT Staff Augmentation Services!

Tech Lead/oracle Applications/dba Resume

Reston, VA

ORACLE SOFTWARE:

  • 9i - 18c RDBMS
  • 10g -18c RAC/Grid
  • Automatic Storage Management (ASM)
  • Recovery Manager (RMAN)
  • Enterprise Manager (OEM) & 12c Grid Control
  • E-Business Suite EBS (12.1 & 12.2)
  • Oracle WebLogic 10g-12c
  • Discoverer 11.1.1.7
  • 11g OAM/OID (Single Sign-On)
  • Application Express (APEX)
  • Data Guard
  • Fusion Middleware (FMW) versions 11g,12c
  • Service-Oriented Architecture (SOA) Suite
  • Oracle Service Bus (OSB)
  • BPEL Process Manager
  • Windows HP-Unix Solaris Linux IBM-AIX

PROFESSIONAL EXPERIENCE:

Tech Lead/Oracle Applications/DBA

Confidential, Reston, VA

Responsibilities:

  • Technical Lead for a 12 Member team supporting Production/Sustainment of DMHRSi (Defense Medical Human Resource System Internet)
  • Panned and Installed Oracle WebLogic 12c multi-tenant Platform across seven node Cluster. Each tenant utilizes Fusion Middleware to utilize its own Domain Partition.
  • Implemented DISA WebLogic Server 12c STIG across all environments going through an ATO (Authority to Operate) and multiple Annual Reviews.
  • Worked with PMO to help create WebLogic application on-boarding Documentation.
  • Supported integration of multiple applications into a WebLogic PaaS (Platform as a Service) platform. This was the first implantation of this kind for these applications.
  • Supports 8 node Oracle Fusion Middleware 11.1.1.7 Discoverer with WebLogic 10.3.6
  • Created custom WebLogic Monitoring scripts (using WLST) for all WebLogic environments. Scripts sends automatic email alerts when detecting issues.
  • Integrated WebLogic 12c with ForgeRock J2EE policy agent for Single Sign on.
  • Utilized Oracle Fusion Middleware Control 12c for maintaining, monitoring, and troubleshooting.
  • Review DISA STIGs (Security Technical Implementation Guides) to make sure Production systems are in compliance.
  • Worked on annual reviews using Systems Scan Matrix, addressing all DISA STIGs.
  • Worked with ISSO to address Web Inspect and AppDetective findings.
  • Responded all to IAVM (Information assurance vulnerability alerts) for the project.
  • Supports 8 node Oracle 12.1.x EBS system with OAM/OID (Identity Management)
  • Working with customer to plan the 12.2.x EBS upgrade analysis with 19c Database
  • Reviewed program documentation of the system and kept them up to date.
  • Oracle EBS installation, upgrade, and maintenance support.
  • Setup Oracle Data Guard (Disaster Recovery/DR) for 7+TB system.
  • Keeps DR in sync at all times, troubleshoots issues
  • Reduced Audit Storage space down by 40% by purging old data.
  • Provides guidance in performance tuning of Oracle Databases
  • Support Informatica 10.2 troubleshooting.
  • Writes Standard Operating Procedure (SOP), Product Insertion Guides, and Configuration Recommendation white papers
  • Create processes, templates, and tools to ensure consistent application, evaluation, and use of architecture best practices
  • Trouble-shoots production systems and able to perform/write up Root Cause Analysis of complex issues
  • Work in coordination with other Engineers to lead the Production support of applications in an ITIL-centric environment
  • Monitors application to ensure systems are meeting ongoing business needs
  • Identifies and consults with internal technical resources to produce strategic designs

Oracle Apps DBA/Software Engineer

Confidential, Fairborn, OH

Responsibilities:

  • Five plus years supporting National Air and Space Intelligence Center ATEP I & II contracts.
  • Installed, upgraded, and patched Oracle 11gR2 (RAC) Grid database systems.
  • Installed and patched high available, multi-node, Oracle FMW (Fusion Middleware systems including OSB, SOA Suite, and WebLogic.
  • Utilized Fusion Middleware Enterprise Manager console to monitor status of system.
  • Created scripts using WLST (WebLogic Scripting Tool) for startup and WebLogic Monitoring.
  • Developed, maintained, and patched Oracle Application Express (APEX).
  • Managed storage and backups using ASM, shell scripts, and Oracle Grid Control 12c.
  • Experienced in Oracle Spatial indexing and partitioning.
  • Led Cross-Platform Migration of Multi-Terabyte RAC systems using Transportable Tablespaces.
  • Worked on development team to convert Legacy-System into a Micro-Service Architecture, using Docker, Cassandra, and Mesosphere DC/OS.
  • Experience working Agile software development environment.
  • Upgraded Oracle FMW from versions 11.1.1.5 to 11.1.1.6 and 11.1.1.6 to 12.1.2.0
  • Developed, deployed, tested, and maintained BPEL processes in SOA to support ingestion of files.
  • Used SQL Developer to create/fix SOA BPEL processes.
  • Sustained all application Oracle PL/SQL code.
  • Designed, Developed and Implemented Oracle APEX Nomination Tool and Dashboard monitoring application.
  • Installed, configured, engineered, scripted and documented PostgreSQL database servers with Replication and Hot Standby capability.
  • Worked sustainment bugs and enhancements through multiple environments to support a healthy configuration change management of the production system.
  • Created SQL, shell scripts, Python scripts, and PL/SQL to help automate processes.
  • Converted various scripts (Shell and Python scripts) from Solaris to Linux compatible.
  • Works with Oracle Support to help resolve Oracle Bugs and issues.
  • Created installation guides and Standard Operating Procedures (SOP) for Production maintainers.

Database Administrator

Confidential. Fairborn, OH

Responsibilities:

  • Conducted environment builds and development of the release packages.
  • Supported the developers in design and build, to architect an efficient database structure.
  • Maintained the Software Version Description, Operator Manual, Deployment Production Architect, and Readme for each release.
  • Executed security scans (SRR Scans) in compliance with DISA standard procedures.
  • Provided support for Client application development and deployment support.
  • Conducted and Analyzed SRR Scans/STIG Fixes to Oracle 11i environments.
  • Supported the installation of release packages into all environments.
  • Developed and tested RAC databases and Oracle Applications.
  • Designed, implemented, and maintained new databases, backup/ recovery and configuration management.
  • Upgraded Oracle Single instance to Oracle RAC Configuration.
  • Installed database management system (DBMS) related software tools.
  • Performed Rapid Clones of 11i EBS to redeploy environments on new hardware.
  • Installed and setup the Cognos 8 application.
  • Submitted input for modification used for problem resolution and daily maintenance.
  • Monitored software database license process.
  • Managed technical action reports to resolve bugs/issues with DBMS software.
  • Routinely worked on troubleshooting of 11i EBS issues.
  • Developed/maintained/participated in disaster recovery plans.
  • Supported capacity planning.
  • Participated in implementing database strategies and solutions.

Database Administrator

Confidential, Clarksburg, WV

Responsibilities:

  • Worked on 9i and 10g RAC databases on Solaris.
  • Upgraded Oracle 10g 10.2.0.x databases to 10.2.0.4
  • Applied Patch Set Update/Critical Patch Update patches to the Oracle databases.
  • Used Automatic Storage Management (ASM) for management of storage on disk groups.
  • Put into practice and tested RMAN repository for 10g RAC databases.
  • Performed the refreshing and recreation of non-production databases from production.
  • Monitored daily operations (disk usages, backups, retention, etc).
  • Created Shell Scripting and PL/SQL to do various tasks.
  • Developed, monitored, and carried out nightly backups and exports of databases.
  • Created Service Requests with Oracle, to solve database issues and errors.
  • Rolled back and forward Nonoperational databases for testing.
  • Reviewed and worked system 9i to 10g upgrade.
  • Archived users and groups from databases when needed.
  • Created/edited schemas and objects for databases.
  • Edited and created cookbooks and standard operating procedure (SOP) documentation.

Hire Now