SUMMARY:

• 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, fire fighting, 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 various clients.
• 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 various clients. 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 Confidential 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.1 scripts -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.
• Tasked with POC on Hadoop to enable HUD Data processing. Created and configured HDFS Servers and associated HDFS scripts and API for maintaining various data types in Hadoop. Hadoop tools used are Cloudera, Horton works, and Cassandra and Ambari on AWS cloud servers .
• 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.

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.Expertise in all major versions of technology stack including Database, iAS, Forms, Reports, PL/SQL, Java, Enterprise Manager, SOA, Weblogic and JVM with SSO and non-SSO integrations. Knowledge of Oracle maintenance/patching mechanics and R12 EBS 12.1.3 and 12.2.architecture. and Oracle Business Intelligence (OBIEE) 11g and 12c. BIAPPS, ORI and ODI.

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.

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 AD and OID user maintenance.

PROFESSIONAL EXPERIENCE:

Confidential,Chicago, IL

Sr. IT Oracle E-Business Applications DBA/ OAM

• 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.
• Analyze 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 Confidential /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 analyze 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 startups, 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.

Confidential,Groton, CT

Sr. Oracle Applications DBA/OAM

• 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 strategies and upgraded outdated DBs and FMW/WebLogicfrom 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 strategies and scripts for migration of EBS customizations and in-house applications.
• Developed various operational scripts for code migrations, startup 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..
• Confidential /12c SOA, Weblogic, RAC.

Confidential,NJ

Sr. Oracle Applications DBA/Weblogic Administrator/OAM

• 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 strategies and upgraded 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.
• Reviewed, designed strategies and 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, startup and shutdowns, checklists, monitoring and critical application licensing reports. Mostly scheduled to minimize tedious and time-consuming tasks.
• Developed various wlst, ldap, unix scriptsfor managing DIP throughputs and Weblogic Server Administration operations such as code migration, loggings, debugging and SSL validations.
• Confidential /12C Weblogic, SOA on RAC based database 11g and 12c DB

Confidential

Sr. Oracle Applications DBA

• 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 strategies and upgraded 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.
• Run AWR reports routinely to monitor user codes and risks associated with DB events for example -dictating ‘commit impacts’ in a code block.

Confidential

Sr. Oracle Weblogic/Middleware Administrator and eBusiness Admin

• Designed, implemented and supported Oracle Financials E-Business Suite Release 12.1 on Confidential R2 non-RAC and RAC on Exadata with multiple modules of Oracle E-Business R12 environments.
• Applied Oracle CPU patches and upgrades for 12.1.3, SSO, including non-eBusiness db Upgrades such as 11.2.0.3, 11.2.0.4, 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 utililies (OBIEE, SSO and FMW/SOA/ETL for Analytics, Security and ETL respectively).
• Weblogic, SSO (OAM, OID, 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)
• Responsible for Installing, configuring and administering Oracle Fusion Middleware Applications - including, but not limited to Oracle WebLogic Server (11g), Oracle WebCenter (11g), and Oracle Service Bus (11g)
• Worked with the UNIX and DB teams for provisioning Servers with necessary ports allocations and DB access for Weblogic/Component configurations.
• Worked with UNIX team to provide proper user access for developers such as sudo access for oracle/weblogic accounts.
• Created baseline matrix for Server provisioning (Admin Guides) for everything from server components, log locations, Domains, certs generation to data Source (DB) locations to ports and managed servers running on each instance.
• Followed in-house build guidelines from the administrators already onsite to; maintain Oracle Fusion Middleware Applications - Including future and existing Oracle Fusion Middleware applications.
• Responsible for configuring Site Minders and/or ldap for user authentications.
• Created startup scripts and alert monitoring for our maintenance.
• Installed and configure OMS - Oracle Enterprise manager (Grid Control 11g) and Agents for monitoring DB sources, middleware alerts etc.; deployed cross-server type agents for Solaris, HP and Linux servers while discovering various services.
• Applied patches on a regular basis to keep the Quarterly patches in-sync and for fixing bugs, adding new functionality and features, and installing of maintenance releases.
• Supported of Application Deployments - working with Java development teams and carrying out code package deployments to the environment.
• Participated in design and staff meetings - attending scheduled morning SCRUM/SPRINT for team planning, task assignments and Statuses.
• Implemented and maintained Oracle eBusiness SSO using AccessGate - OAM and OID user store allowing SSO authentication flow within the Identity component of OAM - AccessGate while applying respective Best-Practices. Used the synchronization adhoc query to populate users in OID USER tables; also implemented scripts to enable SSO on cloned instance (DEV and TEST)
• Provided significant enhancements and box fixes to OIM 11g environmentDeveloped several new custom provisioning/reconciliation connectors for access HUD system, directory, and SaaS file storage system
• 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
• Confidential, SOA, Weblogic, RAC

Confidential

Sr. Oracle DBA/Technical Architecture Team Lead.

• 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 also as 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 a number of 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 OracleIdentity 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
• Confidential, SOA, Weblogic, non-RAC

Confidential,Chicago, IL

Sr. Oracle Application DBA/Technical Architecture Team Lead.

• Install, configure, and support a FTD OracleeBusiness 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/startup, 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 events alongside 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 in order 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 to new ATG (Endeca) 11 and Endeca Commerce Experience Manager Applications Rel 3. For an eBusiness integration. -Configured properties and dimensions.
• Oracle llG, SOA, Weblogic, RAC

Confidential,Des Moines,LA

Sr. Oracle Application/WebLogic DBA/Technical Team Lead

• Maintained and Supported Oracle EBS Development, QA and Production 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.
• Confidential SOA, Weblogic, RAC

Confidential, KY

Sr. Oracle Application DBA/DBA Team Lead

• 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 forCyber 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 for Oracle11g/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

• Analyzed, 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

• 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 of 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.
• Analyzed 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 OracleWeblogic 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 startup 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)

• 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 implementations with 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.