SUMMARY

• 20 years of experience in information technology.
• Specializes in Oracle Database Administration and in Oracle Applications including installations and upgrades from various versions through 12c Releases and R12 eBusiness.
• Experience in Oracle EBS Cloud migration and provisioning under OCI (IAAS, PAAS, DBAAS and SAAS)
• In addition, expert in excels in database, development and application tuning.
• Experience includes Oracle DBA, Oracle Applications DBA and Oracle WebLogic/FMW Administration, Oracle SSO using OAM/OID/Access Gate/AD/WNA for EBS and non - EBS applications, MarkView and applicable SSO implementations. Hadoop (BigData) with various eco-systems, Replications using Data Guard and/or Golden Gate and Endeca, AWS, EBS migration to AWS - AMI.
• An accomplished and results oriented team lead with proven track record of performance in technology, infrastructure and with operations team. Philip has been a member of IT Leadership and IT Core Teams for multiple implementation/upgrades including Oracle E-business suite 11i, R12, R12.2, DB Upgrade Specialist 11i, 12c etc, Oracle SSO (OIM, OAM, OID, AD, WNA, Access Gate/WebGate) and SSL, AWS migrations (iCloud provisioning), implementation and upgrades. Possesses strong interpersonal skills and collaborate effectively with customers, technical staff, management, and vendors while delivering quality projects on time and on budget.
• Served as an Oracle Applications DBA Confidential over 20 different clients since May 1997. Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, DB/SQL statement tuning, backup/recovery, general troubleshooting, firefighting, developer/integrator relations, script development, documentation and DBA mentoring and training for junior DBAs. SSO OAM/OID (v 11.1.2.3/1.1.1.9 ) integration with iPlanet and e-business and SSL configuration; Create, and configure WebLogic domains, SOA projects, OBIEE (BI, BIAPPS and ORI) applications and ODI Confidential .
• Re-plat formed Oracle DB and Applications from Solaris to Linux on several occasions - adhoc projects.
• Implemented, installed new R12 and upgraded several 11i eBusiness Confidential . The versions range from to 11i, R12 12.1.3 and 12.2.x
• Oracle Fusion Applications (Customer Relationship Management, Financials, Human Capital Management & Supply Chain Management)
• Designed and implemented Oracle Financials E-Business Suite Release 12.1 on Oracle 11g R2 RAC on Exadata with multiple modules of Oracle E-Business R12 environments.
• Performed numerous Oracle Database and Tools upgrades from RDBMS version 9 through 12c.
• Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third-party systems including Endeca (Oracle Commerce) Rel 3.1scripts -Formally ATG.
• On various occasions, minimized development downtime and resource time by automating Oracle Applications maintenance through cloning, patching and migration procedures via shell scripts and enabling developers with complex development tasks i.e. RICE components.
• As a well-versed Principal Oracle DBA and Apps DBA, with extensive knowledge and experience, have the technical and communication skills to be a great addition to an organization.
• Extremely versed with Oracle EBS 11i to R12, upgrades, migration and support/maintenance including architectures, ETLs and SSO/SSL associated with EBS infrastructure.
• Deep expertise and hands on experience on installation, deployment, administration of Hadoop on large scale cluster implementations.
• Implemented Hadoop eco systems such as HBase, HDFS, Map-Reduce, Pig, Hive and others.
• Deep expertise in building big data platforms, such as Hadoop, on cloud infrastructure, such as AWS, OpenStack.
• Oracle Fusion Apps - Governance, Risk and Compliance.
• Developed various operational scripts for monitoring Databases, EBS Tech Stacks, WebLogic Admin and managed Services and logs in WLST, Unix Scripts and SQL.
• Developed operational scripts to argument DIP/ODSM synchronization and provisioning profiles for AD/OID/EBS.
• Developed operational scripts to manage OID users and EBS using ldap, oidprovtool, SQL and Unix. Most scripts are often scheduled for critical business operations.
• Developed strategic scripts for EBS migration to Amazon Web Services (AWS) Cloud platform and Oracle Cloud migration for WebLogic Services, Databases and EBS.
• Experienced File Based Data Import (FBDI) and Spreadsheet Uploads via delivered/custom templates (ADFdi) and spreadsheet loader templates for Empl load, Role assignments and category and Manager and email updates.
• Experienced in various cloud modules including CX, CPQ, WMS, OTM, Marketing and EPM.

TECHNICAL SKILLS

Database & ERP Core Skills: Oracle DBA (Core, Oracle Apps) Development Unix, RICE Functional Configuration (HRMS, OTL, OTM, OAB and Payroll) Oracle E-Business Suite Release R12.x.x, 11i, 11.5.10, 11.5.8, 11.0.3 Financials (GL, AP, AR, FA) Procurement (OE, Inventory, iStore, Configuration) HRMS (HR, Payroll, OTL, SSHR, OAB, OTA), SunGuard

Database: Oracle 8x, 9i, 10g, 11g, SQL SERVER 2000/2005, 12c (AWS iCloud), Cloudera & Horton works (Hadoop)

Fusion Apps: Oracle Fusion Applications - Financials, Procurement,Supply Chain Management.

Operating Systems: HP-UX 11.0, AIX 6.0, Solaris 10.6, RH EL 4.0 to 7.0, Windows NT 4.0 and Windows 2000 and Window Server 2007 to latest.

Performance Tuning: OEM (adviser), Explain Plan, TKPROF, AWR ADDR, DBStats, FNDStats etc.

DBA, SOA & Dev. Tools: Oracle Enterprise Manager (OEM), Grid Control, RMAN, RAC, SQL, SQL*Loader, Forms, Reports, SSO OAM/OID(v 11.1.2.3/1.1.1.9 ), SSL, TOAD, Sql Navigator, Reports & Forms 4.5, 6i, 9i & OC4J, JSP, OBIEE, PL/SQL, UNIX Scripts, Oracle Discoverer, Fusion Middleware (FMW - WebLogic, B2B, OBIEE and Identity Manager -OAM), JDeveloper, Eclipse, Java. Oracle SOA/DB 10g to 11g.

Productivity, Change Management Software & Methodologies: MS Office Suite, MS Project, Visio, PowerPoint Change Management CVS, GDD, VSS Test Director, Pantagon, Kintana, Changeman Methodologies AIM, SOX, Security, On Demand; Oracle Best Practices. Grid Control and OEM.

Hardware: Sun Sparc, HP-RP74xx, Sun -Ultra series, EMC storage, IBM RS6000, DELL.

HA/MA Technology: Data Guard, RAC, F5 HD Load Balancing, Web Farm, Concurrent Manager and PCP.

SOA: BPEL, OBIEE, B2B, Web methods, WebLogic 10g FMW 10g/11R2g FORMS REPORTS, OAM, OIM, ODS, IDM etc and SCA Components build, deployment, configuration and Installation. SOA upgrades from 10g to 11g, Oracle ebusiness Admin Support for Order to Cash implementation supporting Functional team and developers.

Backup & Recovery: RMAN, Third Party tools ConVault, BCV, Omni back, data protector

Security: Integrated Oracle EBS with OAM/OID (v 11.1.2.3/1.1.1.9 ); Integrated FORMS/REPORTS/DISCOVERER with SSO using OIM/OAM/OID (ldap servers). Implemented Role Based Access Control (RBAC) including functions, grants and hierarchies in Oracle EBS.

Oracle Identity Management: Oracle Identity Manager 9.0.1 - 11.1.1.5/9 , Oracle Identity Analytics 11g, Oracle Access Manager 10g - 11g, Oracle Virtual Directory, Oracle Role Manager; WebGate and Access Gate including AD and WNA (Window Network Authentication).

Identity Management Technologies: DXML, SAML, SASL, Kerberos, PKI, XACML, DCE, Biometrics, general cryptography, and federated identity management; SSO - OAM, WNA, OIM OVD, OIF, OID integration with iPlanet and e-business, Apex Systems, SSL configuration, certificates and Key creations using keytools for CSR and KeyStores generation and application. Assisted Wintel Team on KeyTab creation and validations

Directories: Active Directory, Sun Java Directory Server, Open LDAP, Oracle Internet Directory; savvy LDAP scripter - integrated with Unix scripts for ADand OID user maintenance.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Oracle EBS Applications DBA/ Oracle Cloud Fusion

Responsibilities:

• Managed Identity and Access Management in Oracle fusion applications, including PAAS and SAAS role designs and controls across Oracle Cloud ecosystems.
• Implemented Function and Data Security Controls including Authorization Policies Manager (APM) and Oracle Identity Management (OIM).
• Created Rest API(s) and BoT for automated gap implementation. Developed and implemented BI consumer reports for security management. Scheduled various process to run Confidential specific frequencies for User/Role synchronizations.
• Managed duty roles, data role templates, and data security policies, in addition to User and role provisioning tasks monitoring. Maintained OTBI Data Models/Reports; created adhoc reports on User, Role and Security contexts (BUs, FA books and Data Access (DAS))
• Worked in compliance with Oracle Application Access Control Governor (AACG) in Governance, Risk, and Compliance Controls (GRCC). Created custom VBA for SOD rules and entitlements verifications.
• Responsible for supporting Oracle E-business suite on-premise and Fusion Financials Security applications.
• Assisted and built various Oracle Cloud Integrations with SaaS and PaaS using MFT, connection points, leveraging stored credentials in PaaS. Leveraged SFTPs and architected the entire integration frameworks.
• Enabled File Based Data Import (FBDI) and Spreadsheet Uploads via delivered/custom templates (ADFdi)
• Performed Integrations using Oracle Integration Cloud (OIC) and other home-grown web services lower tech file transfers and loads.

Confidential, Chicago, IL

Sr. IT Oracle E-Business Applications DBA/ OAM/SAS Developments

Responsibilities:

• Responsible for supporting Oracle E-business suite 12i instances and other mission-critical Oracle systems including SSO, and SAS applications.
• Researching and troubleshooting application and database issues for the Oracle Applications teams including SCM, ASCP, Finance, HRMS and Order-to-Cash. Including support for boundary systems such as WebLogic, OBIEE, OAM/OID, Demantra, Discoverer and Informatica.
• Responsible for EBS Cloud Migration and provisioning for a Proof of Concept (POV) on IAAS, SAAS, DBAAS including IOTAS.
• Partners with technical and business groups to ensure that database performance standards adhere to enterprise service level agreements.
• Assisting in all facets of infrastructure lifecycle management, including administrative activities such as cloning, backup/restore, and patching and while ensuring quality control and auditing of databasesisaccurate.
• Configure, administer and maintain Oracle Fusion Middleware MAA (maximum availability architecture 12c WebLogic - this includes HA and DR config) infrastructure components, including and not limited to: WebLogic Suite (WLS, Coherence, and Java SE), SOA Suite 11g/12c (Adapters, BPEL, BAM, Business Rules, OSB, and OWSM), Installs, patches, upgrades, configures, tunes and maintains the Oracle E-business Suite 12i and 11g/12c Oracle databases.
• Collaborates with system and network administrators, installs system enhancements and assists in hardware, software and data utilization analysis to ensure maximum efficiency.
• Participates in the design, implementation and testing of the disaster recover procedures.
• Provides DBA support for custom application development efforts.
• Provides level 2 support (24x7) for the Production environment, which includes high-volume business critical applications.
• Analyse performance issues in the application, concurrent manager, and database tiers of E-Business Suite installations.
• Assist developers with performance tuning.
• Responsible for capacity planning, database space management.
• Responsible for overall architecture, design, development, and support of all Oracle Application Technology Stack components including but not limited to Oracle 11g/12cRAC (multiple instances), core Oracle Database, Oracle E-Business Suite 12i, OID/OAM, OBIEE, Demantra, Discoverer, Middleware (WebLogic) 11G/12C, SOA 11G
• Implementing and supporting Oracle ERP Applications.
• Ability to analyse and resolve difficult technical issues quickly in a high-pressure environment.
• Support 3rd party applications like Informatica, Vertex, Noetix, iScramble etc.
• Write UNIX shell scripts for various Operational tasks including start-ups, monitoring, checklists and statuses.
• Clones 12i environments including boundary applications Establishes and maintains Oracle ASM/RAC databases in various Linux and Unix Nodes.
• Tunes the Oracle E-business 12i application, the Oracle databases and PL/SQL code.
• Proactively identifies and corrects 12i performance problems and monitors space usage.
• Ensures the 12i system is appropriately secured and periodically audits the security of the 12i system.
• Documents DBA processes and Prepares documentation for new and modified systems, environments, hardware, software or databases.
• Participate in on-call rotation providing 24X7 support and perform other tasks and functions as requested by USG.
• Support Business Analysts and Developers on implementation of OTC and Supply modules including iSupply. Providing complex queries modification, custom objects and user objects creation including DDLs. provided scripts API for Code and configuration migration of OTC from non-Prod instances to PROD. A

Confidential, Groton, CT

Sr. Oracle Applications DBA/OAM/OID

Responsibilities:

• Responsible for Installing, supporting and maintaining the Electric Boat (EB) Oracle eBusiness (EBS) and IAM (OAM/OID) including upgrades, integration and configurations of same on DEV, STAGE (UAT) and Production Instances. All integrated with SSO (OID/OAM/Webgate/AccessGate) and GRC Applications. Responsible for Administering Oracle DB on Exadata platform Confidential CSC.
• Co- Designed, Installed and created Operations manuals for IAM implementations and integration with EBS including the overall architecture - improving earlier designs.
• Administered Oracle eBusiness Applications providing developer, UAT and Production support 24/7.
• Created, and configured WebLogic domains v. 10.36/12c, SOA11g, OBIEE applications (BIAPPS and ORI) and ODI including the servers
• Supported and maintained all Oracle DBA activities associated with managing the entire software stack/footprint for clients.
• Experienced administering and supporting Oracle database on Exadata platform.
• Assisted functional and Development teams in troubleshooting issues including SR management and providing requested logs and report output for Oracle Support.
• Proactively monitor SR (Metalink) activities and footprints to ensure all outstanding SARS are resolved, closed and/or activated.
• Ran CPU patch checklist to ensure CPU patches are up-to date; worked with OS team to also ensure all Security patches are applied and tested per requirement on EBS, GRC, IAM and WebLogic based instances.
• Reviewed, designed strategiesandupgraded outdated DBs and FMW/WebLogic from 10g/ 11g to 12c while reviewing PSU/CPU patches in the mix for post patch applications after each upgrade.
• Upgraded 11G stacks to 12C, this included WebLogic, SOA/FMW 11g and 12c, EBS 12.1.3-12.2. X Reviewed, designed strategiesand scripts for migration of EBS customizations and in-house applications.
• Developed various operational scripts for code migrations, start-up and shutdowns, checklists, monitoring and critical application licensing reports. Mostly scheduled to minimize tedious and time-consuming tasks for EBS management - over 100 scripts well documented for KTs and other required documentations.
• Developed various wlst, ldap, oidprovtool (DIP command line Management) and Unix scripts for managing DIP throughputs and WebLogic Server Admin and managed server operations such as password rules, SSL Certs creation, loggings and debugging, Bootstraps and provisioning; leveraging both internal profiles and ldap Bulk loads to maintain user consistencies from AD (Active Directory); Created and maintained security implementation for password generation during SSO outages; Created scripts to monitor and maintain critical component outages such as DIP, OPMN, access gate and CM (Concurrent Managers) and URL pings are part of daily Check Lists..
• Oracle 11g/12c SOA, WebLogic, RAC.
• Provided EBS Apps Admin support on various modules including Supply Chain and OTC - “Order to Cash”

Confidential, NJ

Sr. Oracle Applications DBA/WebLogic Administrator/OAM

Responsibilities:

• Responsible for supporting and maintaining the Confidential Oracle eBusiness (EBS) and Mark View Applications including upgrades and configurations of DEV, STAGE and Production Instances and incorporating SSO (OID/OAM/Webgate/AccessGate) and MarKView Applications - Platform used is Exadata.
• Administered Oracle eBusiness Applications providing developer and Production support 24/7
• Managed offshore teams while providing technical leadership in various capacities through routine training, KT (Knowledge Transfer), interviews and developing operational strategies/documentation. Literally holding hands while getting them smoothly acclimated to our environment.
• Supported and maintained all Oracle DBA activities associated with managing the entire software stack/footprint for clients.
• Configured and Maintained load balancing, backup/recovery, sizing and space management for various eBusiness instances including DEV, QA and Production.
• Assisted functional and Development teams in troubleshooting issues including SR management and providing requested logs and report output for Oracle Support.
• Proactively monitor SR (Metalink) activities and footprints to ensure all outstanding SARS are resolved, closed and/or activated.
• Ran CPU patch checklist to ensure CPU patches are up-to date; worked with OS team to also ensure all Security patches are applied and tested per requirement.
• Extensively used Exadata platform for implementing Oracle database and applications.
• Reviewed, designed strategiesandupgraded outdated DBs and FMW/WebLogicfrom 10g/ 11g to 12c while reviewing PSU/CPU patches in the mix for post patch applications after each upgrade.
• Reviewed, designed strategiesand scripts for migration EBS and in-house applications to Amazon Web Services (AWS).
• Successfully migrated requested in-house applications such EBS to iCloud (AWS). Used AWS in provisioning additional capacities as needed.
• Run AWR reports routinely to monitor user codes and risks associated with DB events for example -dictating ‘commit impacts’ in a code block.
• Developed various operations scripts for code migrations, start-up and shutdowns, checklists, monitoring and critical application licensing reports. Mostly scheduled to minimize tedious and time-consuming tasks.
• Developed various wlst, ldap, UNIX scripts for managing DIP throughputs and WebLogic Server Administration operations such as code migration, loggings, debugging and SSL validations.
• Oracle 11G/12C WebLogic, SOA on RAC based database 11g and 12c DB

Confidential

Sr. Oracle Applications DBA

Responsibilities:

• Responsible for supporting and maintaining the Motorola Oracle eBusiness Application Including installations of DEV, TEST QA and Production Servers and incorporating SSO and WebLogic FMW Applications such as Discoverer and Oracle Learning Module. Managed Oracle DB on Exadata including performance, integrity and security
• Administered Oracle eBusiness Application s providing developer and Production support 24/7
• Supported and maintained all Oracle DBA activities associated with managing the entire software stack/footprint for clients.
• Configured and Maintained load balancing, backup/recovery, sizing and space management for various eBusiness instances including DEV, QA and Production.
• Assisted functional and Development teams in troubleshooting issues including SR management and providing requested logs and report output for Oracle Support.
• Oracle Exadata performance integrity and security.
• Proactively monitor SR (Metalink) activities and footprints to ensure all outstanding SARS are resolved, closed and/or activated.
• Ran CPU patch checklist to ensure CPU patches are up-to date; worked with OS team to also ensure all Security patches are applied and tested per requirement.
• Reviewed, designed strategiesandupgraded outdated DBs and FMW/WebLogicfrom 10g/ 11g to 12c while reviewing PSU/CPU patches in the mix for post patch applications after each upgrade.
• Run AWR reports routinely to monitor user codes and risks associated with DB events for example -dictating ‘commit impacts’ in a code block.
• Oracle 11g/12c WebLogic, SOA and RAC
• Assisted in the implementation of OTC (Order to Cash) from design, implementation to go-live.

Confidential

Sr. Oracle WebLogic/MiddlewareAdministrator and eBusiness Admin

Responsibilities:

• Responsible for supporting and maintaining the Confidential .gov Middleware infrastructure (WebLogic, SOA, OSD, WebCenter/Portal and EBS; including installations of DEV, TEST QA and Production Servers and in corporation multi-languages.
• Designed, implemented and supported Oracle Financials E-Business Suite Release 12.1 on Oracle 11g R2 non-RAC and RAC on Exadata with multiple modules of Oracle E-Business R12 environments.
• Applied Oracle CPU patches and upgradesfor 12.1.3, SSO, including non-eBusiness db Upgradessuch as 11.2.0.3, 11.2.0.4, and 12c.
• Applied pre-upgrade patches for R12 and upgrade 12.1.3 to R12.2.4
• Upgrade and applied WL, OAM, OID and AccessGate patches for SSO issue resolutions.
• Configured and Maintained Oracle RAC, Oracle ASM, and Oracle Dataguard for the eBusiness and non-eBusiness DB/applications.
• Maintained various application utilities (OBIEE, SSO and FMW/SOA/ETL for Analytics, Security and ETL respectively).
• WebLogic, SSO (OAM, OID, and OIM) Discovery, Forms and Reports Installation on a Windows OS including associated Applications DB and Metadata/Repository DB. supported projects and maintenance of R12 Oracle E-business Suite (12.2, 12.1.3), 10g AS SSO/OID, Discoverer, 10g/11g OBIEE, OWB, 12c OEM, 11g WebLogic (10.3.5)/11g OracleAccess Manager/11g OID, APEX, 11g ASM/RAC, Platform migration (HP-UX to Linux), E-business databases migration from HP-UX to Linux and various other third-party and supporting applications databases from versions 9i to 11g (11.2.0.4).
• Implemented big data using Cassandra/Hortonworks on AWS servers. (For an HP POC project)

Confidential, Georgia, North Carolina

Sr. Oracle DBA/Technical Architecture Team Lead

Responsibilities:

• Responsible for support and design of State’s Benefits Application (UILINK) which is a critical business system used to provide State of Nevada, South Carolina, North Carolina and Georgia benefits package to individuals and State employees.
• Responsible for ensuring availability and performance of the databases
• Responsible for implementation and release of database changes as submitted by the development team
• Interacted with development teams, business owners, and various levels of management
• Ensured high availability and performance (requiring 24x7 pager support on a rotational basis) including weekends on planned outages.
• Worked alsoas part of a team that delivers a high availability service-- with the architecture team
• Installed and configured Oracle OEM grid control and Oracle Data Guard for use on the project.
• Pro-actively monitor database systems to ensure secure services with minimum downtime; wrote several in-house scripts that generates alerts via emails; capture/review developer codes for compliance.
• Hands on Oracle Exadata performance migration from non - Exadata to Exadata environment.
• Responsible for improvement and maintenance of the databases to include application DDL rollout and upgrades
• Provided Data Modelling via Ca Erwin, created Data flow to explain conversion strategies. Assisted developers with Conversion - writing standard scripts for them to leverage while maintaining development Standards.
• Responsible for performing tuning of codes and identifying code bottlenecks; assist developers in code re-writes and changes.
• Developed and trained developers in Data Masking utility (Leveraging Oracle Tool) to ensure PII information are secured.
• Provided ongoing training and knowledge transfer to permanent staff
• Provided in depth training on Oracle Identity Manager 11g deployment, configuration, and custom connector development for Oracle Web Applications and eBusiness
• Provided on demand support, architectural advice, and development
• Provided ongoing support and enhancements to existing OIM 11g environment
• Oracle 11G, SOA, WebLogic, non-RAC

Confidential, Chicago, IL

Sr. Oracle Application DBA/Technical Architecture Team Lead

Responsibilities:

• Responsible for support and development of FTD’s Oracle EBS critical business systems Including databases and application middleware that are used to provide FTD’s HR, expense, and time reporting processes, Clarity and Longview applications.
• Install, configure, and support an FTD Oracle eBusiness Suite (EBS) release 12 instance, including the installation of the application and database software, which implements HRMS, iExpense, Time & Labor, and Payroll modules.
• Support data separation and migration of existing FTD EBS data from an existing EBS R11 instance into the new FTD R12 instance
• Experienced performing Data guard implementation and administration on Exadata environment.
• Work with internal application support team and external application integrators to install, configure, and troubleshoot FTD EBS R12 instance.
• Cross train experienced Oracle database administrators in skills required to support and maintain the FTD EBS R12 environment
• Document FTD EBS R12 environment, maintenance procedures, and operational processes
• Automate EBS related maintenance processes (shutdown/start-up, backups, monitoring)
• Administer and maintain Oracle database instances supporting production applications.
• Monitor and tune system to ensure maximum system efficiency and required system availability. Resolve any problems that arise with the database.
• Participate as a member of a project team to design new products or enhancements to existing products.
• Create policies and enforced based upon attributes, including SQL category, time of day, application, user, and IP address for Database Firewall eventsalongside audit data.
• Advise on product architecture and database interface. Should have the aptitude to understand the business requirements and convert such requirements into an efficient database implementation.
• Meet established schedules and resolve technical or operational problems.
• Execute assigned tasks to achieve maximum levels of productivity.
• Make recommendations for technical and process improvements as they relate to our databases.
• Suggest new methods, products, procedures, and innovations that will improve corporate profitability.
• Assist in the presentation and demonstration regarding database issues on behalf of the company.
• Ensure business and technical issues in areas of responsibility are communicated appropriately to the appropriate person(s) or level(s) of the organization.
• Effectively follow the policies and procedures established by the team and department.
• Interact and work with other IT departments and departments external to IT to ensure that database products are developed and put into production according to planned schedules and expectations.
• Protect interests of employees and the company in accordance with company policies and governmental laws and regulations.
• Protect the data from hazards and unauthorized access.
• Perform any other duties as assigned
• Re-platformed, Implemented and upgraded from REl 10.1 tonew ATG (Endeca) 11 and Endeca Commerce Experience Manager Applications Rel3. For an eBusiness integration. -Configured properties and dimensions.
• Oracle llG, SOA, WebLogic, RAC

Confidential, Des Moines, IA

Sr. Oracle Application/WebLogic DBA/Technical Team Lead

Responsibilities:

• Maintained and Supported Oracle EBS Development, QA andProduction on a multi-tier environment including istores on DMZs;
• Implemented RAC/ASM for POC and later moved same to PROD.
• Developed complex ETL and conversion programs in PLSQL, SQLLOADER, and Unix Script to argument development resource. The development was part of the legacy conversion for employees, GL Interface and Vendor conversion while assisting developers and functional team with complex development/technical issues.
• Created ad-hoc in-house scripts in UNIX and Sql for monitoring and maintaining Web logic servers, databases and applications.
• Experienced installing and configuring OEM with Exadata.
• Enabled and monitor alerts for Database Firewall; customized security alerts and reporting’s; also set business thresholds for applicable SOX monitoring such as audit; unauthorized login reports.
• Wrote various application management strategies and standard documents including Development, Installation, and Monitoring and Troubleshooting standards leveraging AIMs Methodologies for RICE Implementation.
• Designed and implemented Database capacity planning as we migrated legacy data from a new company acquisition.
• Installed and managed Oracle Fusion middleware and configured the tech stack for OBIEE, ESSBASE, Identity Management, Single sign-on, Windows authentication, and configuring Oracle Portal administration.
• Managed and administered SOA components such as BPEL, B2B and BAAM - other managed services.
• Created and provided the required schema repositories for OBIEE/ESSBASE reporting.
• Oracle 11G SOA, WebLogic, RAC

Confidential, Lexington, KY

Sr. Oracle Application DBA/DBA Team Lead

Responsibilities:

• Maintained and Supported Oracle EBS Production on a multi-tier environment including istores on DMZs
• Installed and upgraded 10g/9i database to latest Oracle DB 11g including configuration of same on Oracle EBS and Grid Controls.
• Created ad-hoc in-house scripts in UNIX and Sql for monitoring and maintaining Web logic servers, databases and applications.
• Implemented robust load process for monthly Vertex and Shop Visible (postal Codes) uploads.
• Implemented automated post and pre-clone checklists/validation for Cyber source/ipayment in eBusiness including iStore configurations.
• Implemented in-house Oracle 10g/11g/9i RMAN, Netback up and Tape backup management integration with RMAN and created robust scripts for I/O, disk and performance monitoring including automatic db restores to ensure backup validities and planned black-outs/drills.
• Configured Oracle Data Guard 11g/10g/9i and created documentation for planning, configuration, maintenance & troubleshooting using the tool.
• Configured and created documentation for in-house DBAs to troubleshoot RAC10g/11g/9i - Real Application Clusters as well as planning, designing, maintaining, installation and troubleshooting procedures.
• Configure and created documentation forOracle11g/10g Grid Control/Oracle Enterprise Manager, Management Agent setup, Oracle Enterprise Manager Grid Console Management Console configuration; same standard was adopted by client for other internal installations.
• Monitored Database Console, Application Server Console, Grid Control Plugins and beacons while showcasing the capacities to team.
• Designed and implemented Database capacity planning as we added new servers and memory and CPUs during our 10g to 11g upgrade and server additions admin tiers to relief performance bottlenecks on the architecture.
• Installed and managed Oracle Fusion middleware and configured the tech stack for Identity Management, Single sign-on, Windows authentication, and configuring Oracle Portal administration.

Confidential, OH

SR. SOA 11g Middleware Administrator

Responsibilities:

• Analysed, tested, and implemented physical database design supporting various business applications including base definition, structure, documentation, long-range requirements, and operational guidelines.
• Supported B2B(OSB) component of Oracle e-Business in relation to trouble-shooting, performance tuning, instance stabilization through optimizing queries, and memory, command line optimization and executions.
• Ensured data recovery, maintenance, data integrity, and space requirements for physical database are met through formulations and monitoring of policies, procedures, and standards relating to database management.
• Audited the current environments, providing capacity planning and best practices for the future production/development/test environments, including establishing new standards and procedures.
• Planned, scheduled and supervised the work of internal DBA & Offshore staff.
• Led, reviewed and participated in development of quality entity relationship diagrams, data flow diagrams, database normalization schemas, logical to physical database mapping, data table parameters, etc.•
• Reviewed the physical model created from the logical model, ensuring data structures and databases comply with standards, guidelines, and procedures. •
• Monitored file system space, database allocation, and data integrity, verifies efficient use of disk storage, reclaims dead space, optimizes space allocation and avoids out-of-space conditions.
• Developed and maintained a backup and recovery strategy for all databases. Performs regular random drills to test disaster recovery scenarios.
• Provided daily Oracle Applications 11i / Oracle 10g DBA technical administration and support, including change management requests, monitoring, performance tuning, backup and recovery.
• Installed and managed SOA Middleware components for Dev, Stage and Production instances
• Applied Middleware Patches to patch level the instances
• Upgraded SOA 11.1.1.3 to 11.1.1.5 including schema & components upgrades using RCU, Patch Upgrade assistance, etc.
• Migrated SOA queues and artifacts to Stage and PROD for developers
• Configured Data Sources, JMS Adapters and JMS Modules connection pool, factory and Partitions as part of SOA Project CM
• Monitored BPEL alert logs proactively fixing issues to avoid user outages. Worked with DBA team to resolve database issues.

Confidential, Schaumburg, IL

Sr. Oracle Apps DBA

Responsibilities:

• Designed and configured EBS Infrastructure/Capacity & Planning for PFT Implementation on a multi-node architecture. Upgraded RDBMS and application to latest CPU, JDK/JRE patch levels.
• Installed and configured new R12 on 11g database for new Financial and CRM --DMZ for iStore implementation.
• Configured and implemented Oracle OEM Data Grid for efficient maintenance of the instances.
• Configured RMAN for hot clones, backup and recovery set up customization tops; routinely cloned and applied SR recommended patches.
• Wrote several proactive monitoring scripts for both Database and Application Server Tiers. Wrote several instance management documents such as development standards for developers, patch and cloning documentation; issues and patch logs;
• Mentored client staff on how to administer all the above.
• Improved Connect: Direct for business-critical data migrations and ETL by developing UNIX scripts that are scheduled to perform routine business operations.
• Developed OBIEE Repositories for various reporting layers (Presentation, Physical and Business models) including applying interactive dashboards and drill down capabilities using global filters with security setups.
• Evaluated, designed, build up, applied, and supported Business Intelligence technical solutions using Oracle Business Intelligence Enterprise Edition (OBIEE) / Siebel Analytics.
• Generated and planned executive level dashboards, complex reporting, and metadata modelling.
• Carried to the project during the Vision and Strategy, Architecture, and Development phases.
• Analysed business problems and design proper solutions utilizing Oracle BI Enterprise Edition (OBIEE)
• Worked as lead technical architecture as both AppsDBA and developer in the design and development of dashboards and reports.
• Other Assignments Include:
• Provided production support and Phase II implementations for Grants and iStore. Provided mentoring, Instance Management strategies and schedules and performance tuning and monitoring.
• Designed and configured EBS Infrastructure/Capacity & Planning for Financials - Supply Chain Modules Implementation on multi-node architecture - 4 Node RAC and several middle tiers load balanced across mid-Tier farms and proxies. Upgraded RDBMS and application to latest CPU patch levels; Created strategies to mitigate performance bottlenecks and optimized the architecture and custom Sql queries. Developed several in-house scripts for proactive monitoring of critical business processes.
• Designed cloning strategies for ten different environments and provided grid monitoring for the environments.
• Configured and maintained SOA, SSO/OID -OIM for R12 and OBIEE integration.
• Configured and maintained 10g R3 Oracle WebLogic for portal, server and integration components.
• Researched and documented upgrade path for WebLogic 10g R3 to 11g; Client wanted to apply task in the next phase.
• Resolved start-up script issues with startWebLogic.sh and startManagedWeblogic.sh; created scripts to monitor WebLogic logs for contention issues related to port and service integrations.
• Migrated 11i instance from Windows to Linux platform and patched up existing techstacks with customer patches; upgraded to auto configuration while using Oracle recommended best practices for platform migration.
• Performed several re-implementations of fresh installations of e-Business Suite for efficient use of Technology stacks and file systems. Configured Shared ApplTop to minimize instance downtime during patching and overall configuration maintenance.
• Configured High Availability with Data guard and setup RMAN for backups and hot clones. Provided client with Security Best practices for 11i/10g instance, including securing access to default accounts, securing the network using encryption, using Single Sign on (SSO), and enabling SSL.
• Documented all security practices and create daily management reports.

Confidential, Cleveland, OH

Principal Database Administrator (Apps DBA)

Responsibilities:

• Created and administered Sarbanes-Oxley (SOX) compliance in relation to Security (Segregation of Duties, User Management), auditing (Application Auditing), and change management (Object Migration, Application Configuration, Application Patches).
• Converted table character set into utf8 to accommodate Portuguese language during data import & export.
• Completed full life cycle implementation of Oracle Financials with Multi-Language (MLS) and Multi-Currency (MRC) with UTF8 Character Set.
• Provided technical architecture and DBA support on SASC/FSC eBusiness Consolidation project. SASC/FSC system runs on Oracle eBusiness suite 11.5.10.2 with Oracle database 9i / 10g RAC environment.
• Performed 11i to R12 upgrade in QA instance as part of parallel implementation for Client Stage II role out.
• Worked with the UNIX team to stage all the R12 DVDs for installation.
• Applied all the consolidated help patches for R12 including functional patches for AP, INV and HRMS modules as part of the R12 post upgrade.
• Assembled a test team to perform end-to-end testing of the R12 upgrade.
• Worked with business areas to validate and identify customizations as pre-R12 upgrade.
• Verified application module patch levels and updated the latest ATG RUP &AD patches to proceed with R12 upgrade.
• Reviewed customization and applied best practice tuning approaches to resolve performance bottlenecks.
• Administered Oracle Applications, configuration and migration of Latin eBusiness application into multi-language with application localizations; including managing and resolving OID, SSO and portals.
• Installed and maintained OracleAccess Manager (OAM) as a solution for both centralized identity management and access control and provided an integrated standards-based solution that delivers authentication, web single sign-on, access policy creation and enforcement, user self-service, delegating administration, reporting, and auditing.
• Implemented OID, SSO infrastructure and integrated it with Oracle E-Business Suite and Active Directory architecture.
• Experienced with Fusion Middleware working knowledge
• Applied multi language patches including SPED patches for Brazil localization; imported bolt-on applications such Colfax, Synchro and MarkView.
• Proactively monitored production and 14 other instances made up of DEV, UAT, QA and other parallel implementationswith the bolt-on application
• Upgraded and configured database application software. Monitored capacity and performance, and proactively resolve a wide range of issues.
• Assisted management in defining standards and strategies for security, SOX (separation of duties via responsibilities and menu setup) database objects, and backup/recovery. Managed Oracle backups through RMAN and CommVault.
• Assisted Functional and Development teams in creating a comprehensive data model for their application requirements.
• Provided lead role in technical architecture of the environment while supporting different module AOL setup as system administrator utilizing BR100 documents for profiles, responsibilities, and lookups. Flex fields, value sets, data/request groups and cm and application registrations.