Oracle Manager
Resume:
BOBBY KIMBLE
Houston, Texas *7025
************@*****.***
PROFESSIONAL SUMMARY An Oracle DBA Master that was part of the original team that put together the original Oracle DBA certification examination versions 7.0.Oracle 10g Database Administrator Certified ProfessionalDependable, conscientious, professional with extensive experience as an Oracle Database Administrator delivering 99% system uptime. A strong commitment to quality and excellence in responding to the needs of the user community. Proactive and detail-oriented team leader with effective communication and organizational skills.
TECHNICAL SUMMARY OpenLink ENDUR version 9.1 Rel 2Oracle Application version 12.0.4, R12.3Oracle Applications version 11.5.10 CU2, Oracle Database version 9.2.0.7 Oracle Database 10.2.04, Oracle Hyperion Planning, Oracle EPBOracle Business Intelligence Enterprise Edition version 10.1.3 Oracle Transportation Management 6.1.1Designed, developed and implemented an OLTP, ODS and Data Warehouse on an Oracle 9.2 database. Upgrade database from 10gR1 and 10gR2 to 11R1 and 11gR2. Oracle RAC Real Application Clustering on UNIX/Linux, Automatic Storage Management (ASM) Oracle Streams version 10 and 11g.Managed SQL Server 6.5, 7.0, 2000, 2005 and 2008 clustered environments Developed Backup and recovery strategies Security Strategies and SOX Compliance Data Transformation Services and SSIS (SQL Server Information Services) SQL Clustering (Active-Active and Active-Passive) 2-3 Nodes Performance tuning with SQL Queries and Indexing Security (Windows and SQL Standard) Upgrades from SQL Server 6.5, 7.0, 2000, 2005 and 2008 (In place and new installations) DR Strategies (Snapshots, Replication, Log Shipping and Mirroring) Install/Maintain/Upgrade Oracle 10G/11GR1/11GR2 software stack.Hands-On experience with Oracle ASM, CRS and RAC. Implemented RAC from scratch on large scale mission-critical environments.
Configure, implement and maintain multiple Oracle Instances with multi-node RAC in UNIX. Experience with No-Data-Loss replication using Oracle Dataguard.
Thorough knowledge of Oracle RMAN. Experience establishing and maintaining backup and recovery procedures using Oracle RMAN. Install, configure and maintain database monitoring procedures using BMC Patrol for Oracle Monitor and tune performance of Oracle Databases with GRID control. Experience with Oracle GRID infrastructure.Proficient with Oracle Datapump. Experience writing Oracle Datapump export and import procedures based on the requirements.Partition large tables and provide data modeling support to development groups Upgrade database from 10gR1 and 10gR2 to 11R1 and 11gR2. Develop key automation tools for streamlining workflow and database management
Configuration:Oracle Applications InterConnect (OAI) installation and configurationCitrix MetaFrame deployment of 11i experienceOracle iAS implementation and supportOracle Financial Analyzer (OFA) installationOracle Applications technical architecture design and sizing for 11iOracle Portal 3.0 with Oracle Applications 11i installation and Single-Sign-On (SSO)
CAREER EXPERIENCE
Teksystems Inc, Houston, Texas
Maricopa
Sr. Oracle Application DBA(contractor) Jan 2012 to Present
Environment : Oracle E-Business Suite 11i, R12 Oracle 10g, SOLARIS 9 & 10, ADI,
ORACLE 11gr2 RAC, RMAN, OAM, OEM, ORACLE AS10G
(Soa, Portal, Discoverer, oid, sso)
As an Oracle Apps DBA, responsible for installation, upgrades, maintenance, security and
implementation of Oracle ERP applications and Oracle databases. Planned and performed
major 11i upgrade of Oracle ERP applications on Schedule.
Responsibilities:Responsible for both creation and manage Production, Development, Unit and Test instances of Oracle Version 9.2.0.6,10g,11g & Oracle Applications 11.5.10.2, R12.Oracle applications 11i and R12 Rapid Installation, administration and patching.Successfully Upgraded Oracle Applications 11.5.10.2 to 12.0.4 and database 9.2.0.8 to 11gInstalled and configured oracle 9iAS, 10giAS, OID, Discoverer, idiscoverer via the Application Server Portal.Used Oracle Application maintenance utilities like adadmin, adpatch, admerge adctrl and adrelink etc.Created test environment through cloning production environment for developers to test on live data.Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands.Experience on various modules such as Financials, MFG, CRM, AR, AP, GL, PO, INV, FA, OM, HRMS, iExpense, iSupplier, etc.Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.Creating Application Users, Profiles, Responsibilities, Menus and Functions for the user and monitoring oracle applications using Oracle Applications Manager.Created new Concurrent managers, Purged concurrent requests table and Implemented parallel concurrent processing.Implementation, customization and personalization of Oracle iProcurement.Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.Configuration of Workflow Notification Mailer, OAM, OEM10g.Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack).Oracle Applications Systems Administration. Used RMAN in scheduled recovery, hot and cold backup of Oracle10G database.Installed and configured Single-Sign On and Implemented SSL Security.Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users. Setup a crontab to receive alerts related to TS issues, OS level space issues, locking issues, Database down, CM down issues etc. Periodically purged log files, trace files, concurrent request log and out filesOracle 11g Database Implementation/Upgrade/Support.Oracle 10g Application Server Implementation/Upgrade/Support.Oracle OID Implementation and Support.Development of automated RMAN scripts for both backups and cloning of Oracle Databases.iSupplier Portal ImplementationConfigured R12 EBS for DMZ deploymentCreate DMZ External Firewall between Internet and Load Balancer (open port 443)Create Data Firewall between External Load Balancer and EBS Web Servers (open port 8000)Deploy Internal Load Balancer within internal network for Internal usersDeploy External Load Balancer in DMZ to access EBS Web ServersConfigure 2 network interfaces (NIC) on EBS Web TierConfigure NIC to resolve to two different hostnames in the DNS (one internal and one external)Configure EBS Web Tier Servers for External and Internal access
Teksystems Inc, Houston, Texas
Shell Oil Trading
Large Oil Trading Company
Senior Oracle DBA (contractor) Nov 2010 to Jan 2012Responsible for managing 35+ Oracle Servers environments.Supporting the OpenLink/ENDUR development environments.Worked on the ENDUR BluePrint project – the largest implementation of ENDUR 9.1 Rel2 in North AmericanResponsible for all database functions including installations, migrations, monitoring, cloning environments, developing scripts, backup & recovery, tuning, after hours support, resolving complex customer related problems.Analyze all database components (e.g. PL/SQL store procedures, etc.) running in the existing Oracle 9i environment on UNIX 11i to assess the impact of upgrading it to Oracle 10g running on LINUX 5.4/5.5.Upgrade database from 10gR1 and 10gR2 to 11R1 and 11gR2. Perform hands-on Oracle migration per the detail plans.Provide hands-on database support to the ENDUR Application Developers and Tech leaders who would be migrating ENDUR version 9.1 Rel2 applications to 10x.
Teksystems Inc, Houston, Texas
HCCS
Local Jr. College
Senior Oracle & SQL Server Production DBA (contractor) Nov 2009 to Nov 2010Responsible for managing 25+ SQL Servers environments.Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of sales force automation and product routing. Implemented Quest Spotlight software to monitor SQL Server, enabling company to keep more than 75 SQL databases instances.Responsible for installation and configuration of SQL server 2005 & 2008 database on Dell Servers.Involved in data modeling for the application and created ER diagram using ERWin.Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for this project.Implemented database standards and naming convention for the database objects.Developed DTS packages to extract, transform and load into the Campaign database from OLTP database.Created and configured an OLTP replication database for disaster recovery purpose.Worked with developers to tune the SQL queries using SQL Profiler.Administer Oracle 9i and 10g databasesPerform all forms of database maintenance and administrative activitiesInstall, configure, patch, and upgrade Oracle server software, applications and related productsProvide Oracle backup and recovery using RMAN and other backup tools
Automate routine maintenance tasks as appropriate utilizing OEM, shell scripting and other techniquesResearch and resolve complex technical issues, communicating clearly and effectively with customers and other technical resources as necessaryIdentify opportunities for effectively satisfying business needs through automation, benchmarking and utilization of available technologies, use experience and analysis to develop creative and innovative solutionsTune SQL queries using standard Oracle toolsApply Oracle technology performance tuning techniques to optimize application performanceResearch and evaluate new Oracle features and third party tools and techniquesProvide 24x7 on call support
Physician Capital Group, Houston, Texas
$ 5 Million Medical Technology Startup Company
Senior Oracle Application DBA May 2009 to Oct 2009Created and implemented an upgrade from strategy from Oracle EBS 11.5.7 to R12.0.4. Redesign their architecture; put together all technical documentation, mentor dba's during the upgrade process. Implemented Data Guard for standby migrated existing 9.2. Databases to 10g Real Application Clusters. Implement a shared application top for both techstack and appl_top. Customers run AIX, HP-UX, Linux and Solaris. Utilized Quest Stat for managing Oracle E-Business patches and version control. Migration of Ebusiness Suite from HP-UX Itanium to Linux x-64 -- database and application tier -- Shared application tier -- Migrated Database from Oracle 10g to 11gr2 RAC. Installed and Configured Oracle 11.5.10 and R12 on Redhat Linux. Implemented Oracle R12 E-Business suite PIM Data Hub R12.1.3 Implemented Oracle BPEL 10.1.2.0 Implement Grid based monitoring solution. Client had over 40 databases running Oracle 8 through 11g. Setup RMAN solutions for all Oracle Databases -- created RMAN repository, wrote scripts for backup, integrated RMAN with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery. Provide Performance tuning and performance analysis for their Oracle 11i, R12 -- database and application tiers. Recommend best practices for partitioning, scalability and monitoring. Integrated Identity Manager, Oracle Single-On (SSO), Oracle Internet Directory (OID) and Oracle Application Server with Oracle EBS application. Ensured proper load balancing of the middle tier/concurrent managers across multiple nodes RAC database cluster. Work with other team members to ensure quick resolution of customer problems.
Stanford Financial Group, Houston, Texas
$ 50 Billion Financial and Investment Company
Oracle Application DBA Lead Jun 2005 to Mar 2009Created and implemented efficient database environments, which included procedures and checklist to ensure that implementation of new development, flowed smoothly from Development through QA and UAT, into Production. Managed over 40 Oracle instances hosted on Solaris. Performed and documented cloning tasks utilizing RMAN Duplicate. Responsible for Administering, maintaining, supporting, optimizing, and monitoring production database environments along with multiple QA, development, and disaster recovery environments on Windows and UNIX (Solaris) platforms. Responsible for planning and implementing database software upgrades including but not limited to new installations, critical patch upgrades, maintenance releases, and version upgrades. Developed custom PL/SQL stored procedures,Unix shell scripts to automate various daily DBA operations. Staff, train and manage team of Database Administrators.Schedule and process Work Orders for specific areas of responsibility.Ensure that published timelines are managed and met.Develop and monitor metrics to measure performance and availability and make necessary recommendations for improvements.Defining and implementing highly scalable database architectures utilizing Oracle Technology Ongoing production support meeting rapid turnaround requirements from customers to retrieve, modify, or add data and produce reports.Database administration, system tuning and monitoring.Implemented database changes as submitted by the development team and in accordance with the IT Change Management Policy. Investigated and resolved difficult and advanced database application problems and performance issues, working individually and in coordination with the UNIX team and application support teams. Managed high availability database infrastructure including RMAN and Oracle Standby Database environments. Administered, maintained, and implement policies and procedures for ensuring the availability, security, and integrity of the databases in accordance with IT Security and Sarbanes-Oxley adherence policies. Mentored Junior DBAs and application support team membersImplemented Oracle Streams version 10g.Supported several Trading and Risk Management applicationsPerformed DBA services on a 7x24 Financials and Human Resources worldwide installation. Performed over 2 dozen restores and time-based recoveries. Concurrently managed 7 financial instances, 5 Oracle HR/Payroll custom instances.Performed Database upgrade from 9.2.0.7 to 10.2.0.4Supported Hyperion Budget and Planning software.Performed numerous Oracle Database and Tools upgrades from RDBMS version 6 through 11.1.0.4.Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systemsImplemented and tested RMAN backup and recovery procedures.Installed Grid Control and RMAN repository on Red Hat LinuxWrote UNIX K-shell scripts to support the Oracle database environment.Resolved issues for functional analysts and developers with a focus on service.
VIRTUO GROUP, Houston, Texas
$5 million ASP/ Consultant Company Feb-2005 to Jun-2005
Lead Oracle Application DBA – ContractorManaged and supported 20 remote Peoplesoft Application clients and 80 database instances.In charge of the Oracle and Peoplesoft Hosting Application and database delivery practice. Supported the implementation of PeopleSoft environment for HRMS version 8.9, Finance version 8.4, CRM version 8.9, EPM version 8.9, Ascential 7.5, Business Objects, Supply Chain Management version 8.4, eProcurement 8.4 and Peopletools 8.46 using WebLogic 8.1.Designed setup, configured and customized SPRO module. Applied upgrade patches to the Oracle system. Implemented and tested RMAN backup and recovery procedures. Tuning and monitoring databases to achieve optimum performance level. Developed unique load-balancing and fail-over techniques for Application Server to provide for higher reliability and performance management. Resolved issues for the functional analysts and developers. Developed methodology for supporting production clients in a 24 x 7 environment. These methodologies lead to a reduction in the amount of outages for ERP clients and increase profit by $25,000.00 dollars.
WASTE MANAGEMENT INC., Houston, Texas 2001-20
$25 billion Waste Collector Mar - 2001 to Feb - 2005
Oracle & PeopleSoft Application Database Practice Manager In charge of the Oracle and PeopleSoft Database Administration practice. Supported the installation and upgrades of all databases and applications software components. Troubleshoot and correct common problems with the applications and databases environments. Ensure that application system design and database design supported the business owner performance criteria. Tutored application developers and database administrators in performance design criteria. Plan and conduct unit, system, acceptance, integration, and performance testing. Supported the ETL DataExchange using Informatica/PowerCenter. Performed ETL performance tuning in the Oracle environment.Lead cross-functional teams in resolution of performance problems.Responsible for Database monitoring, security policy and performance tuning.Responsible for Database backup and recovery using RMAN – Database operations monitoring using scripts and OEM. Led the team that implemented and managed more than 170 local and remote servers, and 400+ Oracle database environments supporting a wide range of applications. Most of the high-end production databases were configured to utilize a Multi-Layered Standby database methodology to ensure database recovery in case of total
Enterprise Data Warehouse Consultant
Developed an Executive Information System and Data Ware for the Waste Industry based on Oracle7 database technology
$8 million Data Warehousing/Business Intelligence projectSupported both the on-going development in the corporate data warehouse and new data warehouse projects. This initiative included ETL, reporting, project planning, documentation, and coordinating tasks between multiple IT units. Manage the ongoing development and support of the client specific data marts used for reporting and ad-hoc query capabilities. Managed the data warehousing project 28 Oracle databases with over 8 Terabytes data, each on an Oracle 9.2.0.4.0 database engines.Designed and developed OLAP database and data cubes to support sales force utilizing Oracle databases and loading data using Infomatica Power Analyzer.Supported both Business Objects and Crystal reports developmentAssisted in the physical translation of logical models into an ODS (Operational Data Store) and Star Schema design for data marts as required by client defined Data Warehousing standards. Worked with the UNIX administration staff to help facilitate response-time requirements and Backup/Recovery and Disaster recovery methods for new and existing database.
VERTICALNET INC, Houston, Texas Jan - 2000 to Mar - 2001
$50 million B2B Internet content Provider
Manager of Database Administration and Data Content Maintained and upgraded Oracle Financial, Manufacting and HR/Payroll Applications in a three-tier architecture that included a database server, an Oracle Application Server, and a J-Initiator or Applet viewer.Managed a team Application and System database administrations. Installed the first Oracle 8i database utilizing file systems – this effort reduced maintenance time and cost by several hundred man-hours per month and simplified normal database maintenance tremendously.Configured and implemented Oracle’s Inter-Media Data product to capture and feed news feeds from several on-line news services.Supported Oracle Applications 10.7 for GL, AP, AR, FA, HR, PAY modulesMigrated from 7.x database to 8i (8.1.6)Applied and troubleshoot patches as necessary Configured WorkFlow for use by Oracle ApplicationsResolved issues with the installation and upgrade process as they appeared
BMC SOFTWARE INC, Houston, Texas Jan - 1994 to Mar - 2000
$4 billion Enterprise Software Solution Provider
Oracle ConsultantInstrumental in the development and expansion of PATROL, which is BMC’s end-to-end enterprise management solution? Work on the PATROL team included: determining new database technologies for integration into the product line and managing the implementation of these technologies; investigating new opportunities and markets for the solution; as well as determining, along with other senior R&D architects, the future direction of the Oracle product line. Mentored our customers Oracle and SAP teams to drive ideas for new features in subsequent releases of the Knowledge Module for Oracle and SAP. Acted as a key evangelist of BMC’s products to the outside world. Performed Executive updates and new products briefing.
Software ConsultantResponsibilities included: ensuring the technical success of BMC Patrol Oracle and SAP suite of products within 4 strategic accounts. Leveraged BMC’s R&D resources to address customer issues. Lead the full life cycle implementation of the Patrol into key customers Oracle Financial environments. Increase adoption of and proactively update and advise the customer on how to best utilize BMC products. Understanding the customers’ technical issues and worked to resolve them. Managed the customers issue escalation and monitored deployments to ensure that the customer’s vision of the solution was implemented properly. Provided technical support to BMC’s Patrol customers who were using Patrol to monitor their Oracle and SAP database. Helped customers with any technical issues installing, configuring and using Patrol’s Oracle and SAP suite of products. Performed customers’ demos of the Patrol suite of products as well as Executive briefing. Present at trade shows, seminars and other events. Helped key SAP customers install and configure the Patrol Knowledge Module for SAP in their environments.Assist with high-level pre-sales and post-sales support.
AMERICAN GENERAL LIFE, Houston, Texas Jan - 1993 to Jan - 1994
$ 8 Billion insurance company
Oracle Consultant/DBALead a project team of approximately 3 DBA and 2 Business analysts in planning, development and implementation of the insurance agent’s new business on-line tracking system. Created procedures for measuring and improving the clients Oracle database performance.Provided Oracle database administration support for a large, non-standard financial database using Oracle 7.2 and 7.3.Responsible for all aspects of Database Administration including, database creation, performance tuning and backup and recovery.Utilized IBM RS600/Oracle, AIX version 4.x and IBM’s SSA disk-drive technology in a Raid-5 environment.
BSG CONSULTING, Houston, Texas Feb - 1991 to Jan -1993
$10 million staff augmentation consulting company
Lead Technical Consultant - Oracle PracticeLead Stage 1 of ShipNet system implementation across fleet, involving enhancements of ship’s property management system, development of new data file transfer (ship-to-shore) scripts, and development of simple Oracle applications.Managed several medium sized Oracle 7.3.x databases from inception to production release. Setup Automated Database fail over and event management, which included Altra GMS, Tibco and Web-based applications using Sun’s High Availability Cluster and Sun E-10K servers.Designed and implemented project tracking system and DBA utilities for tracking database file growth and scheduled reorganizations channel I/O activity using Power Builder.
EDUCATION, CERTIFICATIONS & AWARDSTexas Southern University, School of Technology, B.S. TechnologyNominated by The Chauncey Group International to chair the Creation of the Oracle Database Administrator Certification Examination Version 7Quest Oracle Consultant PartnerMicrosoft 64 Bit Beta testerOracle Certified Oracle Database Administrator, V7, 1996Oracle DBA Master - Database Administrator, 1992Oracle Certified Oracle Database Administrator, 10g, 2008Rice University Jones School of Business, Project Management Certificate, 2000
Contact this candidate