profile: Oracle Apps DBA Enterprise Solution Architect

• More than 20 years of expertise guiding large teams of technical contributors in the design and implementation of technical systems and upgrades for multi-million dollar infrastructure projects.
• Superior technical acumen with experience leading the full project lifecycle including presales, licensing, analysis and design, implementation, and continued support of data centers, databases and IT systems.
• Drive continuous process improvement through the delivery of training and documentation for operational and support processes.
• Oversee the growth and development of IT team members through coaching, counseling and mentoring.
• Partner with executive leadership in the incorporation of technology infrastructure solutions that support corporate priorities, maximize efficiencies and position the company for future growth.

technical skills

• Databases: Oracle Applications 10/11i/R12/ Oracle 7/8i/9i/10/11/12, SQL Server 7.0/2000 and DB2, OLAP, OLTP
• Platforms: Windows 95/NT/2000, HP, AIX, Linux, Solaris and SAN Brocade/Cisco Storage. ERP: GL, AP, FA, MFG, Cash Management, HR, AR, 11.5.1 -11.5.8 Siebel, Retek RMS, RDW, SAP and 9iAS Backup and Recovery: RMAN, Veritas, Brbackup, Brarchive, RAC, TSM, EMC Clariion, Celerra, Symmetrix , Shark, Segate, Legato, HACMP, Oracle ASM, OCFS, Data Guard, Oracle RAC, Oracle Grid Control, Oracle Collaboration Suite Performance and Tuning: Statspack, Oracle Performance Tuning Pack, CCMS, SAP DBA, SAP Gui, Explain plan, OEM, utlbstat, utlestat, Toad, SQL Navigator, Erwin, BMC Patrol, Precise, SQLplus, Server Manager, ETL Cognos and Informatica , SQL Loader, RAC, OPS, SQL Bactrack, Developer 2000 and SQL Lab Languages: C/C , Cobol, Java, Visual Basic, JDBC, PL/SQL, UNIX Shell, HTML, Pro-C, Batch scripting, ODBC, OBIEE 10g/11g, Informatica 8/9, SOA 10g/116, Sabrix Misc: Oracle forms server, Workflow, Discoverer, ADI, 6i reports server, Apache, Cognos, PVCS, Replication and Parallel Server, Application Server, TOGAF 8.1/9.1, Salesforce 31.0, VM Ware ESX/Vsphere, Cloud, SaaS, IaaS, EMC, Netapps, Virtualization Project Roles: Lead Oracle Apps DBA, DBA Manager, Principal Consultant, Management Consultant, Solution Architect, IT Project Manager

technical consulting experience

Confidential

Sr Oracle Apps DBA/Solution Architect/Project Manager

• Manage multiple data center consolidation projects
• Manage all IT functions which include deployment, servers, network equipment and other devices
• Completed Oracle implementations following the launch of 2 new healthcare buildings. Directed 12 DBAs and developers on the first 15.3 million Oracle implementation and a team of 16 on the 20.5 million Oracle implementation within the second office.
• Deliver consultative expertise in infrastructure planning and design on behalf of an expanding health care system. Collaborate with internal IT organization to define infrastructure needs, attain appropriate support, set budgetary requirements and communicate the status and delivery of technical projects.
• Responsible for installing, patching, cloning, maintenance and backup of 11i/12 Oracle Application
• Consults within the IT organization to develop appropriate support for IT centric projects from various technology and service departments integrate activities with business units, corporate departments, and IT departments to ensure the successful implementation and support of project efforts.
• Responsible Planning and managing workload of Developers, DBA's and Infrastructure team
• Work with technical architects to approve technical design docs as well finance budget for all IT projects
• Collaborate with stakeholders to map out an IT Project scope and vision
• Steer weekly meeting to gauge the timeline and the scope of the project
• Involved in vital planning for infrastructure setup for the Health Care System
• Responsible for managing DBA's and developer through Oracle Application implementation
• Architect and Design
• Provides input to the development of corporate IT standards and policies to ensure compatibility and integration throughout the company.
• Lead team of people who have responsibility for strategy and development, including systems and application development.

Confidential

Enterprise Solution Architect/Project Management

• In charge of database management and service delivery for 10 simultaneous projects throughout the Western Region. Directed the work of 25 Database Administrators delivering database architecture solutions to top tier corporations.
• Lead Enterprise Solution Architect for SOA Implementation. Directed a large team of SOA developers, technical architects and OBIEE developers on solution design for a global communications company. Led a team of SOA developers, technical architects and OBIEE developers on building solutions for global communication company
• Created Release Management process for IaaS Cloud offering
• Budgeted, architect, scope and completed a scalable infrastructure for an ERP System which includes SAN, Network and Virtualization
• Project managed the SDLC of multiple projects which include procedural manuals operations
• Solution Architect for SOA development for a global pipeline company located in Canada.
• Directed Database Administrators in an Oracle R12 implementation. This includes installing, patching and monitoring all R12 instances. Created best practices documentation for the Oracle R12 implementation as well as Oracle 11i upgrades to Oracle R12.
• Created technical design documents using tools such as EA Sparx and TOS Team
• Led Governance meeting to ensure that rules were enforce as it relates to the reuse of SOA services
• Architect solutions for SOA development for a global pipeline company located in Canada
• Work with technical architects to approve technical design docs as well finance budget for all IT projects
• Created best practices documentation for Oracle R12 implementation as well as Oracle 11i upgrades to Oracle R12. This include modules such as AP, AR, GL, FA and MFG.
• Work with third party vendor to ensure the appropriate hardware was acquire for the right project, thus ensuring that it adhere to the IT budget
• Led a team of DBA in Oracle R12 implementation. This include installing, patching and monitoring all R12 instances.

Confidential

Oracle Apps DBA/Enterprise Solution Archtect

• Completed multiple projects on behalf of Infosys' diverse client base. Contributed to pre-sales through the analysis of current infrastructure and the delivery of technical presentations highlighting proposed solutions to improve performance and productivity. Managed full project lifecycle, leading teams of DBAs, Developers and Business Analyst in 11g SOA implementations and OBIEE with E-Business Suite
• Led a 30million upgrade of Oracle 11.5.10.2 to 12.1.3 and the migration of Oracle applications and databases from HP to Linux and AIX.
• Solution Architect for a 50 million project encompassing the design of an SOA suite for a large Canadian oil and gas company. This resulted in saving the company over 4.2 million year in maintenance for their previous architecture and software.
• Reduce IT expenses by incorporating virtualization servers and streamlining the data center
• Dramatically improve SLAs compliance from below 80 to 98 by incorporating new procedures and processes
• Managed customer requirements for VMware-based solutions to the vCloud Suite to meet functional and business requirements of a range of clients
• Responsible for Installing, Cloning, patching and day-to-day maintenance of Oracle Apps R12 application, SOA and OBIEE. Also responsible

• Lead Solution Architect in SOA Implementation
• Led a team of DBA, Developers and Business Analyst in 11g SOA implementation for pipeline and telecommunication Company.
• Created System and Design documents for building SOA 10/11g Applications using EA Enterprise Architect and Top Team. Upgrade/clone 10g SOA Application to 11g.
• Created solutions for building SOA applications for communication company which includes working with the Business Analyst and developing System and Design requirements.
• Managed the merger of IT applications between newly acquired Business and existing Business. Responsibilities include being Lead Oracle Apps DBA. Lead a team of DBA's as well as developers. Provide assessment of the client to upgrading Oracle 11.5.10.2 to 12. 1.3 as well as Migrating Oracle Applications and databases from HP to Linux and AIX.
• Created best practices for documentation on Performance and Tuning on 11i/12 with a focus on concurrent managers. Integrated OBIEE with E-Business Suite
• Assist functional team with Oracle Modules such as AP, AR, GL and FA. Administer and tune 11i Application using tools such as DB Control, Grid, Oracle Enterprise Manager, AWR, Oracle Diagnostic utility and ADD.
• Consult with managers and users on resolving issues. Architect and design hardware for E-Business Suite Dev, test and Production.
• Architect and design SOA suite. This include the installation of SOA as well as developing technical specs and design.
• Architect and design E-Business Suite and OBIEE on VMware.Report and assist Managers and IT staff regarding projects, assessments, State of Work and technical assignments

Confidential

Sr Oracle Apps DBA/ Enterprise Solution Architect

• Led the strategy and integration for ERP implementations, the installation and administration of 10g Oracle Application Server, and the design of disaster and recovery standards.
• Oversaw up to 8 technical team members in technical project lifecycle on behalf of multiple Fortune 500 clients.
• Delivered a multi-million dollar SOA implementation. Restructured the client order-to-cash system, which included design, testing and integration of the full development lifecycle and management of an offshore technical team. Architected and designed an E-Business Suite and OBIEE on VMware.

• Provide leadership, guidance, and supervision to direct reports, support staff, and other IT department staff regarding projects and/or technical tasks and assignments.
• Collaborate with business unit management, IT peers, and business unit/IT staff to develop, define, and implement process, business, and technical solutions
• Installed, built and upgraded 9i databases to 10g and Oracle Applications 11.5.9 to 11.5.10.
• Lead over eight DBA's and UNIX administrator. Led the strategy and integration for ERP implementation
• Install and Administer 10g Oracle Application Server
• Develop standards for creating Disaster and Recovery
• Provide in debt documentation on best database, performance and tuning and Oracle Application Installation practices
• Delivered multi-million dollar SOA implementation which consist of restructuring the client order-to-cash system which includes design, testing and integration of the full development software lifecycle .
• Utilize EA Enterprise Architecture software to design and build web services such as WSDL, XML, UDDI, J2EE, SOAP, Web Logic and Adapter technology.
• Architect and design SOA suite. This include the installation of SOA as well as developing technical specs and design. Architect and design E-Business Suite and OBIEE on VMware. Lead Technical Architect for SOA implementation which includes creating technical and system design documents as well as leading offshore team thus ensuring a successful implementation.
• Work with business units such as users, managers, supervisors and team leads to understand the challenges and map out and implement a timely solution
• Install, build and upgrade 9i databases to 10g as well as upgrading Oracle Applications 11.5.9 to 11.5.10
• Work with the functional team on modules such as FA, AR, AP, HR and Asset Management

Confidential

Sr Oracle Apps DBA Manager Hands-On

• Supervised a team of 8 database administrators and technical infrastructure team members. Created documentation on best practices for database performance tuning and Oracle application installation practices.
• Revitalized a struggling Oracle upgrade. Directed the upgrade of 9i databases to 10g as well as the upgrade of Oracle Applications 11.5.9 to 11.5.10 on behalf of this large client in the oil and gas industry.

• Team Lead and supervisor over eight DBA and infrastructure team.

• Install and Administer 10g Oracle Application Server
• Develop standards for creating Disaster and Recovery
• Provide in debt documentation on best database, performance and tuning and Oracle Application Installation practices
• Work with business units such as users, managers, supervisors and team leads to understand the challenges and map out and implement a timely solution
• Install, build and upgrade 9i databases to 10g as well as upgrading Oracle Applications 11.5.9 to 11.5.10
• Work with the functional team on modules such as FA, AR, AP, HR and Asset Management
• Provide leadership, guidance, and supervision to direct reports, support staff, and other IT department staff regarding projects and/or technical tasks and assignments.
• Collaborate with business unit management, IT peers, and business unit/IT staff to develop, define, and implement process, business, and technical solutions

Confidential

Sr Oracle Apps DBA/Solution Architect

• Led a team of 3 database administrators in the management of a SAN storage infrastructure. Directed an Oracle upgrade and trained technical contributors in the maintenance and tuning of Oracle modules such as FA, GL, AR and HR. Supervised the migration of several 11i applications from Linux to AIX.
• Completed an in-depth infrastructure assessment within a large healthcare organization for the potential upgrade of 11.5.9 to 11.5.10. Following recommendations, selected to lead the Oracle upgrade.

• Provided contract services which includes Leading a team of three DBA's and SAN storage Infrastructure.
• Provided assessment to client on upgrading from 11.5.9 to 11.5.10
• Created best practice document on performance and tuning of 11i with a focus on concurrent managers.
• Led and assist functional team with Oracle modules such as FA, GL, AR and HR.
• Provide detail documentation on Backup and Recovery of 11i Applications.
• Design backup and recovery strategy for 11i Application
• Administer and tune 11i Application using tools such as DB Control, Grid and Oracle Diagnostic utility.
• Consult with managers and users on resolving issues
• Install, upgrade, patch and clone from11.5.9 to 11.5.10
• Led the effort in migrating several 11i applications from Linux to AIX
• Provided detail timeline of migration and upgrade

Confidential

Oracle Apps DBA

• Managed the Delinea data center while simultaneously directing an Oracle system implementation.
• Technical Lead for the implementation of Oracle 11.5.10. Completed extensive tuning of 11i application and created a standby database for 11i instances.

• Provided contract services which includes Install, upgrade, Clone 9i 11.5.9 Oracle applications to 10g 11.5.10
• Implementation of HR, FA, AP, GL and AR
• Consult as Technical Lead for oracle implementation for 11.5.10
• Provide day to day maintenance such as patch and tuning concurrent managers
• Assist functional team with forms and reports as well as functional setup of FA, AP, GL HR and AP.
• Install and configure Oracle Discoverer and Single Sign On.
• Provide extensive tuning of 11i Application utilizing the Oracle Diagnostic Tool and DB Control.
• Provide documentation for best practices when upgrading from 11.5.9 to 11.5.10
• Created standby database for 11i instances
• Communicate with users and managers on best practices for maintaining 11i instances
• Use Kintana to migrate all code to production

Confidential

Lead Oracle Application Database Administrator/Project Manager

• Directed a team of 13 in the upgrade and implementation of 9i 11.5.9 Oracle applications to 10g 11.5.10. Implemented RAC Real Application Clusters on production and test machine. Designed and tested backup and recovery strategy. Led functional team in the implementation of all modules such as GL, AP, AR, HR and Manufacturing.
• Mentored, trained and provided documentation on best practices for maintaining 11i instances for a team of internal technical contributors with minimal Oracle expertise.

• Led the effort in Install, upgrade, clone 9i 11.5.9 Oracle applications to 10g 11.5.10. which include managing Business Analyst and technical design team during the implementation of E-Business Suite.
• Administer all databases using DB control and Grid
• Consult with management, users and technical leads on procedures and best practices for administering 11i databases
• Optimize concurrent managers by Implementing load balancing on 11i instances
• Implement RAC Real Application Clusters on production and test machine
• Provide day to day maintenance such as patching and sql tuning of all 11i instances
• Provide documentation on best practices of maintaining an 11i instances
• Assist functional team in implementing all modules such as GL, AP, AR, HR and Manufacturing
• Led the effort with SAN architect to ensure optimization of the 11i instances
• Assist functional team in forms and reports using tools such as form builder, discoverer and ADI
• Administer database security and permission of all database users
• Provide proactive growth of the database by using tools such as OEM, Grid and Locally management tablespace
• Implement and test backup and recovery strategy using Legato

Confidential

Sr Oracle Apps DBA Manager Hands-on

• Directed teams of up to 15 nationally dispersed technical contributors in the delivery of 15 database projects on behalf of JP Morgan's premier customers.
• Delivered multiple projects with a focus on ORACLE 8i/9i Enterprise Database/Data Warehouse systems as well as 11i Application Server and Oracle COLLABORATION Suite.

• Project Manager and Technical Lead for the implementation of database best practices, policies and procedures for entire client base.
• Hands on Project Manager for teams of up to 15 people for project specific engagements.
• Performs all roles related to analyzing, designing and implementing ORACLE 8i/9i Enterprise Database/Data Warehouse systems for data mining as well as Implementing 11i Application Server and Oracle COLLABORATION Suite includes Portal Server .
• Responsible for tuning highly transactional database used for high volume trading.
• Develop best practices for measuring capacity Effective project management Technical skills for execution of activities such as estimating, planning, resourcing, communicating, engineering, measuring, tracking, reporting, and documenting.
• Effective Technical skills which includes SAN, performance tunning, installing 11i/8i/9i databases

• Work with Business Users, the Business Systems Analyst, and Project Manager to understand requirements, assisting with the technical solution, design and migration of data warehouse and implementing the solution

Confidential

Sr Oracle Apps DBA

• Lead Database Administrator overseeing a team of technical contributors in the implementation and management of new architecture for the current production system. Installed, upgraded, cloned and migrated Oracle 8i/9i/10g databases and Oracle applications GL, AP, AR and Cash Management .
• Gathered technical requirements for the design, implementation and migration of a data warehouse solution. Architected migration of data warehouse and data marts from HP to AIX. Deliverables included, installing Linux and Windows and migrating Oracle Apps from Windows to Linux, migrating SAP 4.6 from Solaris to AIX environment, providing database capacity planning, designing backup methods and disaster recovery.

• Lead DBA responsible for Installing, upgrading, cloning and migrating Oracle 8i/9i/10g databases, Oracle Applications GL, AP, AR and Cash Management .
• Design and implement backup methods and disaster recovery strategies for Data Warehouse and Data Marts
• Architect and documented migration of data warehouse and datamarts from HP to AIX
• Create test lab for migrations. This includes installing Linux and Windows and migrating Oracle Apps from Windows to Linux.
• Work with Business Users, the Business Systems Analyst, and Project Manager to understand requirements, assisting with the technical solution, design and migration of data warehouse and implementing the solution
• Evaluate hardware and application software using evaluation matrices
• Work with client to understand any production problems and assist in the resolution. This includes new architecture of their current production system to get maximum optimization
• Develop best practices for performance and tuning of 9i/10g databases
• Migrate databases from Tru64 to AIX environment.
• Collaborate with the client and other business groups to gather statistics on the hardware and data
• Migrate SAP 4.6 from Solaris to AIX environment. Provide expertise and leadership in a Oracle Financial and Data Warehouse and OLTP environment
• Mentor Junior DBAs as well as distribute task with go-live timeline
• Monitor database growth and provide database capacity planning for apps expansions
• Design and implement backup methods and disaster recovery strategies
• Migrate database between software versions, platforms and database products
• Install and upgrade RETEK RDM, RMS and RDW

• Develop custom forms using form builder. Create batch jobs in PRO C and C
• Install, clone, migrate and upgrade Oracle 9i/10g on AIX and HP

Confidential

Senior Oracle Database Administrator

• Supervised a team of 3 Database Administrators in the installation, configuration and maintenance of Apache web server and 9iAS and Oracle databases. Developed and implemented maintenance plans for backups, 11i instances and other Oracle databases.
• Install and patch eight 11.5.9 Instances on Solaris platform.
• Work with financial modules such as FA, GL, AP, AR, Cash Management
• Install and configure Apache web server and 9iAS and Oracle databases
• Other duties includes: cloning, configuration, upgrade, backup, tuning, capacity planning, patching and administration of multiple Oracle Financial databases. Installing, configuring supporting Apache web servers, SSL, 9iAS and Oracle databases.
• Perform daily monitoring of 11i Instances using Oracle Application Manager, Oracle Enterprise Manager, adadmin and adpatch.
• Train and mentor other DBA's.
• Trouble shoot Oracle portal and frame work.
• Provide documentation on maintaining 11i instances.
• Work with functional and developer group on FA, GL, AR, Cash Management, HR and AP modules .
• Setup financials third party tools such as ADI, Discoverer and Workflow.
• Create workflow processes and develop 6i reports.
• Performance and Tuning of oracle databases using tools such as Statspack, Perforamnce tuning pack, Tkprof, and SQL trace.
• Assisted developers in tunning their code.
• Implement backup and recovery plan for all Oracle databases.
• Develop and Implement DBA maintenance plan for Backups, 11i instances and other Oracle databases.
• Provide performance tuning of PL/SQL stored procedures.
• Work with Business Users, the Business Systems Analyst, and Project Manager to understand requirements, assisting with the technical solution, design of data warehouse and implementing the solution.

Confidential

Technical Solutions Consultant

• Provided expertise and leadership in a Oracle, SAP Data Warehouse and OLTP environment on behalf of 2 diverse clients, a large grocery store chain and the United States Navy.
• Provide expertise and leadership in a Oracle, SAP Data Warehouse and OLTP environment
• Address Performance and Tuning problems in an HP/AIX/Solaris/NT environment.
• Use Oracle utilities for diagnosising performance problems such as statspack, OEM, utlbstat, utlestat, Oracle Performance Tuning Pack and Quest tools, SAP DBA and CCMS.
• Perform SAP Basis such as the transport system.
• Eliminate tablespace, data block fragmentation as well as utilize partitioning for maximum performance from the database.
• Perform regular maintenance such as tuning rollback segments, redo logs, and adjusting parameters to get the maximum performance from the database and installing SAP instances.
• Support development efforts by working with developers to tune there code. This includes establishing code reviews and documentation as well as using TOAD for debugging.
• Install, upgrade, migrate, support, configure 8i/9i/9iAS databases, SAP and Oracle Financial Applications.
• Administer SAP and Oracle database using SQL PLUS, Enterprise Manager, SAP DBA, OEM and Server manager and CCMS
• Provide backup and recovery using tools such as Brbackup, Veritas, Rman, Brarchive and TSM.
• Ensure the availability of the databases according to SLAs Service Level Agreements .
• Provide documentation on best practices for tuning SQL code and the OLTP and data warehouse database.
• Maintain and operate production, development and test SAP terabyte and data warehouse databases. Create documentation for support desk in case of emergencies as well as mentor and train junior DBA's.
• Create best practices and standards for DBA's and developers to follow as well as test disaster recovery plan.
• Implement security standards within Oracle and the UNIX environment. Backup, restore and recover fully operational databases.
• Create databases and Implement various ERP applications such as Siebel, Retek, SAP and Financials.
• Work with business application developers to define relational entity model by using tools such as ERWIN.
• Normalize and de-normalize the data model to avoid redundancy as well as many complex SQL queries.
• Develop and implement standards to create various database objects and logical database design into physical database objects.
• Capacity planning and Benchmark of Data Warehouse, Data Marts and OLTP databases. Used 8i Transportable tablespace to speedup the movement of the data.
• Proactively identify problems, apply creative thinking and identify short or long-term solutions that need to be implemented, depending upon various constraints.
• Work with Business Users, the Business Systems Analyst, and Project Manager to understand requirements, assisting with the technical solution, design of data warehouse and implementing the solution.
• Tune ETL process COGNOS and INFORMATICA to have a quicker response time.

Confidential

Technical Solutions Consultant

Administered 10 databases on UNIX and AIX platforms on behalf of key client, Apple Inc.

Early career experience as an Oracle Database Consultant with McKesson HBOC Inc. and GeoQuest Inc.