Senior Oracle Database Consultant Resume
Overland Park, KS
OBJECTIVE:
- To obtain a position that will enable me to utilize my business, technical and management skills, while offering a challenging and rewarding career in the fields surrounding Oracle Database and Application consulting, Project Architecture / Engineering, Oracle Identity Management implementation / integration, Maximum Availability Architecture (MAA) and Disaster Recovery (DR) architecture / implementation surrounding Oracle published best practices.
SUMMARY:
- I have over 18 years experience in database configuration for high availability surrounding eBus 11 / 12OVERVIEWPeopleSoft 8 / 9, OBIEE, and several others). Proven competency surrounding Oracle database architecture design and administration for both OLTP and Data Warehouse projects, and specialized in Oracle Exadata implementation
- Oracle Identity Management, database migration and ldap / OID integration. I hold many industry s, including Oracle Exadata 11g Implementation Certified Specialist and Oracle Database 11g Performance Tuning Certified Expert, foreign systems integration, Maximum Availability Architecture (MAA), database fail over and disaster recovery system architecture, full lifecycle development support, senior project engineering, principal project architecting, principal database / Identity management security architect, integration delivery and performance tuning.
TECHNICAL SKILLS:
Programming/Administration: configuration Oracle applications Linux and Windows (HR, Finance, ERP, Supply Chain, Analytics, and several other modules), OBIEE Installation / Configuration / Administration in Linux and Windows, Oracle database 11g/10g, Oracle Apps 11 & 12, Oracle Fusion Middleware, Oracle Spatial, Oracle Identity Management 11g/10g, Microsoft Active Directory & LDAP Integration with Oracle Internet Direct, Oracle Exadata V1 / V2 (11.1.0.7 R1 & 11.2.0.3 R2) including advanced clustering, SCAN utilization, ASM, RAC surrounding eBus DR and fail over (automatic application, middleware, database, service failover), Oracle ETL programming, Oracle RAC, Oracle Data Guard 11g/10g, CICS, SQL, PLSQL, CCL (Ext SQL)
Operating Systems: Sun Sparc Solaris, Sun x86 - 64, HP-UX PAR RISC64, RedHat Linux 4.2-5, Sun Solaris, Unix (various), VM-Ware Virtual Server and Virtual Workstation, SCO, NT Server, Open VMS, Windows 2000 Pro, Windows XP Server, Windows XP Pro, Windows 2003 Server, Windows Vista, Citrix Server and Presentation server client install and integration, Exchange Server
PROFESSIONAL EXPERIENCE:
Confidential, Overland Park, KS
Senior Oracle Database Consultant
Responsibilities:
- Installation of Oracle R12.1.1 multi node with 11g Database
- Implement Oracle DataGuard, Streams, 2-8 node Clustering, ASM, and DR / MAA.
- Installing of HRMS Localizations (global and Canada) using hrglobal driver.
- Installation, Configuration, and Upgrading of Oracle APPS from R12.1.1 to R12.1.3
- OBIEE Installation, Configuration, and Administration
- Oracle Apps (Several Modules) Installation, Configuration, and Administration
- Implementing MLS Lite to enable multiple Languages
- Performed Daily Checks of database and applications.
- Implemented RMAN Backups surrounding various disaster recovery requirements
- Configuring of Printers and Troubleshooting the Alignment issues.
- Configuring the Notification Mailer to send emails to the users.
- Maintenance of R12.1.1 and 11.5.10.2 instances.
- Performing Daily checks.
- Prepared Daily Reports for Oracle Apps status and Database growth
- Deployed daily checks script to monitor the instance
- Installation of ORACLE R12 with 10g Database
- Monitoring and troubleshooting the Oracle database and Application issues
- Cloning of E-biz applications single node to single node.
- Management of tablespaces, datafiles in the database
- Performed daily checks of the database and applications
- Applied OPatches on the database
- Upgraded Oracle Clusterware and databases from 10.2.0.2 to 10.2.0.4
- Upgraded Oracle databases (including Exadata) from 11.1.0.7 to 11.2.0.4
- Implemented the RAC on EBS environment on ASM
- Implemented the backup and recovery strategy with RMAN
- Creation of users and assigning privileges and roles
- Installed and configured several Oracle products including, but not limited to, Oracle Enterprise Database 11gr2, 11gr1, 10g (all releases), Oracle Exadata V1 / V2, RAC, ASM, OCS, and APEX.
- Provided long term technical needs analysis of hardware, software, and business workflows in an effort to reduce administrative costs while improving overall internal and external Oracle Applications administration / development resource allocations
- Provided management with high level technical and financial implications in an effort to reduce the number of resources for administration and development, while maintaining support for business growth and improving scalability, functionality, and performance.
- Provided technical direction for several senior level Oracle DBA’s, Middleware architects and Developers surrounding organizational needs and SOX compliance utilizing Oracle Identity Management integration with current databases, Sun ldap, MSAD, Oracle Applications, and web applications. Also managed projects which included long term proactive management, centralization of administration, and centralization of disaster recovery practices, centralization of Microsoft Active Directory / LDAP / Oracle Internet Directory, Oracle Names Server, and Enterprise User Security
- Provided long term technical needs analysis of hardware, software, and business workflows in an effort to reduce administrative costs while improving overall internal and external Oracle Applications administration / development resource allocations.
- Provided management with high level technical and financial implications in an effort to reduce the number of resources for administration and development, while maintaining support for business growth and improving scalability, functionality, and performance.
- Oracle Internet Directory 10g / 11g integration with oracle Microsoft Internet Directory
- Install and configure Oracle Business Intelligence Enterprise Edition 10 and 11 components.
- Oracle HTTP Server 11g (11.1.1.3)
- WebLogic Server 11g (10.3.3)
- Oracle Business Intelligence Enterprise Edition (11.1.1.3)
- Oracle Identity Management 11g (11.1.1.3)
- Built Oracle Business Intelligence Metadata Repository.
- Setup and configured connections to various data sources.
- Built the OBIEE physical layers, business models, and mapping layers.
- Utilized multiuser development environment including mapping logical SQL .
- Installed, managed, and administered OBIEE processes and components.
- Migrated OBIEE to and from Linux and Windows servers.
- Administered OBIEE Publisher including
- Security
- Data Source Connections
- Integration with other Oracle products
- Report delivery options
- Runtime configuration settings
- Scheduler settings
- System maintenance options
Confidential
Senior Oracle DBA and Oracle Apps DBA / Technical Manager
Responsibilities:
- Provided business to business technical team management of 14 senior level DBA’s and 5 Application DBA’s consisting of onshore and offshore resources. Assessed business needs analysis and coordinated resource allocations based on project requirements. Provided functional coordination and database administration on Oracle databases including load balancing of raid arrays, database installations and cloning efforts, Develop security policies and profiles, manage and support various development efforts, install, patch, upgrade, tune, troubleshoot and various other DBA functions surrounding Oracle’s Database technologies and eBusiness suite.
- Installed, migrated, and upgraded Oracle 9i, 10g, and 11g r2. Migrated / upgraded multiple db’s ranging from .5tb to 8tb.
- Provided database administration including RAC and Data Guard, backup and recovery functions using Oracle Recovery Manager, shell scripting, cron jobs (for reporting, job execution, and backups.
- Provided database administration for Sql Server 2005 and 2000 database engines using Server Management Studio for creating and managing databases, transaction logs and database snapshots. Provided security management (login, database, and permissions), backup and recovery management, and automating tasks with jobs and alerts.
- Provided project mgmt on a several development projects ranging from legacy system re-devel to web application development.
- Provided build, support, and analysis of multiple Data Warehouse installations utilizing plsql, oracle forms, and oracle reports.
- Provided business needs analysis for multiple groups within the organizations.
- Worked with a number of contractors to satisfy projects requirements.
- Allocated resources for multiple projects.
- Provided support for 90+ databases including 10+ eBusiness installations in various operating systems, hardware, and environments including development, test, pre-production and production installations.
- Developed system, network, and database design standards and documentation.
Confidential, Dallas/Houston, TX
Senior Oracle Applications and Database Consultant
Responsibilities:
- Develop project plans, foreign systems integration plans, and resource allocation management
- Analyze systems, database, and sqlnet performance statistics.
- Analyze SQL calls to the production and development environments to support development staff.
- Develop and implement Oracle disaster recovery plan
- Maintain security profiles and Roles accessing the RDBMS
- Perform database builds from system architecture through schema generation and data migration
- Execute database schema migrations on all dev, test, cert and production environments.
Confidential, Kansas City, MO
IT Director, Functional Oracle DBA / Apps DBA / Project Manager
Responsibilities:
- Provided Oracle Database Administration and project management and resource allocation for database and network infrastructure related projects on UNIX and NT Platforms.
- Managed development teams surrounding ERP, EBS, and EDI
- Managed integration of all networking, telecommunication, server, and client hardware.
- Installed, managed and supported all ERP systems and related industrial manufacturing process integration, process improvement, and work flow analysis.
- Developed system rollout strategies, network topology strategies, disaster recovery strategies.
- Managed enterprise server construction, systems integration, and database builds.
- Coordinated support efforts in a client server environment for all critical business applications.
Confidential, Kansas City, MO
Manager of Infrastructure and Database Integration
Responsibilities:
- Supported production,, test, and demo databases for 14 hospitals, 9 labs, and multiple physician offices.
- Maintained security, Oracle upgrades, and schema refreshes.
- Developed and implemented backup and recovery strategies.
- Optimized system performance at the OS and Oracle levels.
- Worked with application developers on SQL tuning.
Confidential, Kansas City, MO
Sql Server / Oracle / Microsoft Access Database Administrator
Responsibilities:
- Built tables and migrated data from various foreign systems and databases including SQL Server, Access, DB2, Mumps, and COBOL flat file tables and arrays.
- Aided with development of real-time foreign systems interfaces.
- Planned and developed enterprise level backup and recovery strategies.
- Allocated system storage, planned future storage requirements, and maintained system security.
- Monitored performance and user access to the Oracle and SQL Server RDBMS.