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.