We provide IT Staff Augmentation Services!

Lead Consultant - Infrastructure Oracle Operations. Resume

3.00/5 (Submit Your Rating)

SUMMARY

  • Over 16 years of Oracle database administration experience including 12 years of managing Oracle eBusiness suite and 5 years of Agile PLM and BI.
  • Manage Oracle application installations for large to small size business - provide full stack oversight to achieve & maintain high service availability in support of business operations.
  • Deliver greenfield implementation of enterprise applications - can go solo or as team lead for the complete lifecycle - software/system selections, proof of concepts, dress rehearsals to go-live and maintenance phase setup and routines.
  • Lead exploration and suitable adoption of emerging technologies.
  • Orchestrate in-use Oracle products/installation through needed upgrades or migrations with careful accounting for dependencies, risks and new requirements.
  • Resolve the daily streams of Oracle system incidents, problems and changes proactively and in a wholesome manner, to ensure stable environment and predictable performance for user community.
  • Utilize business imperatives and operations as the guiding light for systems management (especially relating to internal controls, regulatory compliance, security) and work in tandem with various business functions.
  • Provide system advisories & multiple path forward based on cost benefit analysis and risk assessments to management/stakeholders.
  • Lead diverse and distributed teams for service delivery management and project outcomes - Provide work plans, schedules, critical paths, staging phases & milestones, change release process along with timely and appropriate communication to IT & business teams, partners, vendors and user base.

TECHNICAL SKILLS

Core Applications: eBusiness Suite, Agile PLM, SOA, OBIEE, UPK, Marian.

Core Areas: Project management, Oracle Applications - Management & Implementation

PROFESSIONAL EXPERIENCE

Confidential

Lead Consultant - Infrastructure Oracle Operations.

Responsibilities:

  • Found business operations losing some or all parts of Oracle run application services on any given day.
  • With rigorous analysis, remediated the issues with configuration changes and process redefinitions at server, database and application levels resulting in stable and predictable performances 24x7 basis (except planned maintenance windows)
  • Provided lead on selection of storage for running Oracle systems as well as the actual migrations to the new hyper- converged Nutanix solution.
  • Led the effort on migrating backup solutions for Oracle systems - Moved from an old unplanned setup with Backup Exec to IBM TS 3200 LTO3 drives to a logically planned robust new set of solutions put in place via CommVault.
  • Worked on integrating Oracle systems with new applications, third-party like Quintiq, Insight and custom.
  • Work involved supporting direct business operations support in addition to working with IT technical resources within the company as well as external vendors/consultants.
  • Led issues to resolution with cross-functional teams.
  • Managed quick turn around deployments and cost effective daily operations by leading and sourcing DBA teams from an external managed services company.
  • IT landscape - R12 eBiz includes OPM, SCP & Demantra, SOA, BI

Confidential

DB Engineers

Responsibilities:

  • Implementation - Agile PLM 9.3.1.1. database Setup, including Standby solution to guarantee complete Disaster Recovery solution.
  • Maintenance support for Oracle eBusiness Suite operational issues.
  • Set up included multi-node application servers, authentication by OID, direct integration with Markview, Vertex, several custom systems for HR, Hyperion etc
  • Database upgrade from 11.2.0.1 to 11.2.0.3 - eBusiness suite, Vertex along with 3 other custom databases
  • Planning for consolidating and migrating tablespaces into Oracle Applications Tablespace Model. Reduce from 400 to 12 tablespaces in 1.2 TB. Database.
  • Complimentary to OATM, devising a plan to partition, purge and archive selected huge row count tables.

Confidential

Solo Applications DBA Consultant

Responsibilities:

  • Phase I - Set up a new Agile ecosystem involving Agile PLM 9.3 implementation with Product Data Quality, EDAConnect to OrCAD with CIS. User Productivity Kit. Included support for data migration from Omnify - a small business PLM system. Tasks included procurement specifications for hardware, project planning, collaboration with software vendors and business/technical consultants, alignment with internal Core and Extended Teams for the project and positioning all applications within Confidential ’s security umbrella.
  • Phase II - Grid Control implementation for monitoring/management of all Agile related systems and Data Guard Configuration.
  • System scoping and Implementation of BI for Agile Analytics with ODI.
  • Pro/ENGINEER/Agile integration via EC.
  • Providing IT insights for requirement analysis for Supply Chain Analytics software/vendor selection to manage contract manufactures and N-Tier suppliers.
  • OS: Largely Linux with some Windows, Databases - Oracle 11G, SQL Server, Web servers - WebLogic, Tomcat, Apache, IIS - with SSL and integration with LDAP.

Confidential

Applications DBA Consultant

Responsibilities:

  • First DBA with the distinction of working on all major system implementation from the word Go.
  • Served the company from a small startup phase with less than 150 employees to 1000 + employees.
  • Sole DBA for Business applications - implemented a host of oracle products - eBusiness Suite (11.5.10 on first 9.2.0.6 Database & then to 9.2.0.8), Agile PLM (9.2.2 on 10G Database with Agile Viewer, SCMNet), Discoverer, OBIEE (with Informatica ETL and custom datawarehouse) , MicroWest AMMS, EquityEdge, ADP eTime.. New modules, features & integrations (SalesForce portal using Boomi, Accuimage, ADP) were added and rapid architectural transformations were needed to move on to new Netapp storage devices and custom built data centers.
  • Participated in the initial design of custom Factory Information System.
  • Installed Eyelit MES application.
  • In 2008, supported migration of 3 TB of MES production database - upgrade from 32bit 10G Database to 64bit Oracle 11G database, Tablespace reorganization with partitioning.
  • Support Shareplex replication environment.
  • Implementing backup solution using NetBackup and RMAN for Oracle databases and later Netapp snaps.

Confidential

Applications DBA Consultant

Responsibilities:

  • Involved in upgrade of Oracle Financials system from 11.5.9 to 11.5.10 including OATM. W interfaces to MarkView 170 systems, Sunflower Assets and Purchasing Card.
  • Implementing separate OC4J instances for custom J2EE applications Purchase Card and iOU.
  • Supporting Hyperion Planning/Analyzer/Reports running on Windows 2003 servers

Confidential

Applications DBA Consultant

Responsibilities:

  • Issues handled are Severity 1, Priority 1 or 2
  • Support included several hundred customer applications hosted within Oracle network or at the customer site.
  • All Oracle products in any architecture.

Confidential

Applications DBA Consultant

Responsibilities:

  • Upgrade/Maintenance of enterprise applications - eBusiness Suite (11.5.8, 11.5.9), Marian (5.5.3), Project Controls and a host of custom applications on range of Oracle databases - 8.x to 10.x.
  • New install:Business Intelligence, Oracle Streams, DBI 6.0.5 module & Oracle Warehouse Builder.

We'd love your feedback!