We provide IT Staff Augmentation Services!

Data Warehouse Lead Resume Profile

PA

Summary

I have 30 years of experience in all phases of design, development, and implementation of computer applications. I have worked for clients within the manufacturing, banking, healthcare, education and services industries as well as the U.S. Federal Government. His areas of expertise include Exadata, Core Database Technologies, Oracle RAC, PL/SQL programming and Oracle Application system support. I am adept at providing technical solutions to sophisticated and complex technical problems in production support and development roles while delivering end-user training, documentation, creating and maintaining project schedules, and preparing and presenting project briefings to executives. I have technical leadership, DBA and application development experience.

Professional Experience

Confidential

  • Data Warehouse Lead:
  • Successfully worked with Best of Breed Oracle Customers as part of the Engineered Systems Services Group, in conjunction with other elite internal Oracle Support Teams, to bring real world success to customer Exadata Migrations from inception to post-production support. Accomplishments included providing custom alignment to Exadata MAA Best Practices as well as ensuring best use of the Exadata investment by utilizing product features as part of custom migrations.

Confidential

  • Windows Server 64-bit Design, Implementation, And Tuning: Successfully designed and built a highly performing and scalable 4-node 11g RAC/ASM infrastructure used for worldwide deployment of critical Naval applications. Worked with NRL and other government agencies, Microsoft Management and Engineers, as well as Oracle RAC Assurance Management and engineers to achieve performance benchmarks not previously achieved by Microsoft Platforms. Resolved complex node eviction issues and assisted with Oracle Spatial application changes to make best use of RAC. Designed and developed a Streams N-Way prototype using Extended Data Type Support.
  • 11g RAC: HP-UX Itanium Design, Implementation, And Tuning: Successfully supported multiple Oracle 11.1.0.7 RAC/ASM environments operating under HP-UX Itanium 11.31 nodes attached to a multi terabyte sized HP XP-24000 San. Assisted with DataProtector interface to RMAN for backup, recovery and duplication strategies. Worked with IT managers, data center staff and application developers to ensure the database integrity, high availability and security. Participated in platform migration and planning from a 5 terabyte AIX platform to HP-UX and simultaneous upgrade from 8i to 11g for a custom Powerbuilder/Tuxedo front-end application supporting 4,000 statewide users.
Confidential
  • 10g RAC: Tuning: Successfully performed diagnostics and troubleshooting for a 2 node Linux IA64 RAC/ASM cluster supporting a critical 911 system and its external interfaces for a large US City.
Confidential
  • 10g RAC: Installation: Successfully implemented a test and production 2-node AIX 5.3 RAC/ASM environment using IBM DS4700 San supporting both a platform Migration and Peoplesoft upgrade.
Confidential
  • 10g: HP-UX Performance Tuning, ASM, RAC Planning: Successfully assisted large international pharmaceutical company in transitioning from outsourced to in-house database support team. Mentored staff of 15 DBA's in identifying root causes and resolving performance related issues post 10g upgrade in an 11Terabyte production DW. Identified known bugs, requested, escalated and assisted in one-off patches. Used latest support tools to assist in diagnostics of optimizer abnormalities and behavioral changes. Diagnosed parallel query and materialized view performance issues. Assisted with design and planning for DW transition to Linux RAC/ASM on EMC DMX San. Diagnosed AIX 5.3 memory performance issues for 10.2.0.4 database.
  • 10g Architecture MAA/HA/RAC on Windows: Design, Implementation, And Tuning: Successfully assisted large school district with 350 schools and 14,000 users in an Oracle conversion by implementing an Oracle 10.2.0.4 RAC/ASM environment operating under Windows 2003 R2 nodes attached to a multi terabyte sized IBM 8300 San. Design included Dataguard and Fast Start failover to a colo RAC. Utilized RMAN for backup, recovery and duplication strategies. Installed, configured, documented and trained Grid Control and additional management agents for over 100 targets. Worked with IT managers and application developers to ensure the database integrity through Flashback technology. Participated in database software design and development, standards development, and support the development, QA and IT operations groups. Assisted development groups with growth design of large tables and RAC based development considerations. Assisted with query performance and SQL Access Advisor recommendations on hot objects. Recent on-hands training in RAC 11g.
Confidential
  • 10g: Upgrade, MigrationRMAN, EM GRID: Successfully upgrade and migrated 8i and 9i databases cross platform from Solaris 64-bit to Linux RHEL 5 32-bit and by moving from EMC raw files to EMC ASM. Also migrated from SE to EE. Assisted client in presenting and provisioning 8-100g EMC LUN's using Powerpath. Successfully installed ASMlib and created ASM instances. Successfully installed 10gr2, installed the latest 10.2.0.3 patchsets, installed latest oPatch and successfully migrated 4 8i and 9i databases. Successfully installed and configured EM Grid Control 10.2.0.3 with secured OMS and agents. Successfully designed, installed, configured and tested a backup strategy with RMAN and Legato Networker. Successfully designed, installed, configured and tested a High Availability, Disaster Recovery solution using Dataguards Physical Standby/Maximum Availability/Dataguard Broker architecture via EM. Reviewed installation and trained client on the use of asmcmd, EM Grid control navigation, RMAN and Data Guard Broker.
Confidential
  • 10g RAC: Design, Implementation, And Tuning: Successfully managed 3 separate Oracle 10.2.0.3 RAC/ASM environments operating under Red Hat Linux AS4 nodes attached to a multi terabyte sized HP EVA San. Successfully implemented current one off patches and patch sets to levels up to 10.2.0.3 including CPU July 2007. Utilized RMAN for backup, recovery and duplication strategies using Symantec's Veritas Net Backup products. Installed, configured and managed Grid Control and additional management agents. Created and installed various shell scripts to monitor and report on various database activities. Worked with IT managers and application developers to ensure the database integrity, high availability and security. Participated in database software design and development, standards development, and support the development, QA and IT operations groups. Assisted development groups with growth design of large tables and RAC based development considerations. Assisted with query performance and SQL Access Advisor recommendations on hot objects.
Confidential
  • Oracle Architecture and Administration: Worked with DBA staff to support 120 8i, 9i and 10g databases running on Solaris. Databases included Peoplesoft, Power Plant, Data Warehouse and Service Desk Applications. Implemented current patch levels to 10.2.0.3 with CPU April 2007. Managed snapshots using Network Appliance Filer, used BMC's SQLBacktrack for management and archival of logs. Technical tools used included Embarcadero's DBArtisan, HP's Service Desk and 10G Grid Control to support database tuning.
Confidential
  • Oracle Architecture, Warehouse and Administration: Supported online credit card and payment interface systems using Cybersource. Installed, configured and supported Business Objects XI Crystal Reports. Created data warehouse for back office in-house financial applications. Upgraded 8i and 9i databases to 10g. Supported online newspaper content via xml feeds.
Confidential
  • Oracle Architecture, Development and Administration: Provided DBA and development support for product enhancements, migrations and data center consolidations. Daily responsibilities included the installation, configuration, backup, tuning, capacity planning administration of Oracle 9.2.0.5 10g databases while providing database consultancy to internal groups in support of various applications. Ongoing activities include advanced PL/SQL programming with emphasis on SQL performance tuning. Interacted with Oracle 8i/9i/10g/ databases on Sun's Solaris 5.9 , Clustered HP Tru64 5.1.b, Linux RH9 and Windows 2003 while successfully implementing a 10g upgrade and 10g Grid Control. Maintained RMAN repository, writing scripts and interfacing to a custom monitoring database. Integrated RMAN scripts to Legato including daily backup, full backup and incremental backup on databases. Supported ongoing system statistics gathering and performance monitoring. Install and support Oracle Designer 9i repository. Supported development, test production database software pushes. Created and maintained korn borne shell scripts to support various data source interfaces.
Confidential
  • Oracle Architecture, Conversion, Development and Administration: Served as the DBA Team Lead for a major Oracle development project supporting legacy system conversion efforts to 3 tier architecture. Daily responsibilities included the installation, configuration, backup, tuning, capacity planning administration of 24 Oracle 9i 10g databases while providing database consultancy to internal groups in support of various applications. Ongoing activities include advanced PL/SQL programming with emphasis on SQL performance tuning, Object Types and Collections, XML, Oracle JAVA Stored Procedures via JVM/JDBC thin driver, Oracle Reports, 9iAS, 10gAS and Oracle 9i Designer and Data Modeling. Supported business operation on a 24x7 basis. Activities consistently include monitoring databases, backup recovery, and tuning the databases to meet contractual agreements Interacted with Oracle 8i/9i/9iAS/10g/10gAS databases on Sun's Solaris 5.9 , IBM's Aix 5.2 and Windows 2000 Advanced Server systems. Implemented recommendations for Oracle MAA for RAC Data Guard for HA under Sun Cluster. Successfully implemented 10g Grid Control along with 10g agent interfaces to 9i databases. Successfully upgraded Oracle databases from 9.2.0.1 to 9.2.0.5. Successfully tuned 9iAS 10gAS Reports Server engines. Created and maintained RMAN repository, writing scripts and interfacing to OEM. Integrated RMAN scripts to Veritas Net backup 4.5 including daily backup, full backup and incremental backup on databases over 100 GB. Set up Advance Replication in support of a Hybrid Master Materialized View site configuration. Made recommendations for developers on Oracle's Virtual private Database for Label security. Supported ongoing system statistics and performance using Quest Spotlight, other Quest Central Tools and STATSPACK. Supported Oracle Designer 9i repository and upgrades. Responsible for coordination of production test database software pushes with middle tier. Coded Korn shell scripts to support various data source interfaces. Maintain Partitioned tables, Global Domain Indexes and Oracle Text. Administered Connx Datapump/Datasync JDBC interface to provide real-time SQL queries from Oracle to VMS/RMS.
Confidential
  • Oracle Architecture Administration: Responsibilities included database administration for 18 Oracle 8i 9i databases coupled with a variety of n-tier COTS packages some of which included FileNet, Livelink, Microstrategy, Lawson and Maximo running on Windows 2000 Advanced server. Daily responsibilities include backup recovery, OEM event and job monitoring, performance tuning, and development support. Informatica ETL support. Support utilizing Quest products. Designed and implemented Advanced Replication through firewalls to Edwards Air Force Base via Oracles Connection Manger.

Skills Summary

Oracle Platform and Architecture
  • Oracle 11gR2, 10g, 9i, 8i, 7
  • ASM
  • RAC, including IPMP setup
  • Streams, Golden Gate
  • RMAN
  • Business Intelligence
  • Oracle High Availability
  • Performance Tuning
  • Data Guard
  • Exadata
  • Grid Control 12c, 11g
  • Application Server
Non-Oracle Databases
  • DB2 OS390
  • Sybase
  • IMS
  • SQL Server 6, 7, 2000, 2005
  • MS Access
  • IDMS
Hardware Operating Systems
  • Dell Poweredge Servers
  • HP DL380 Servers
  • EMC CX3, CX4, Symmetrix SAN
  • Hitachi 9990 SAN
  • HP EVA Storage Array
  • VMS
  • Dell/EMC CX700/CX500/CX300 SAN
  • IBM Mainframe, RS/6000
  • SUN E4500/6000/10K, SUN Fire V240, SUN Fire T1000, SUN Fire X4200, Sun SPARC Enterprise M8000 Server, Super Cluster T4
  • HP 9000, Proliant ML
  • Brocade Fabric Channel Switch
  • Emulex HBA's
  • Qlogic HBA's
  • Red Hat Linux 2,3,4,5, truss
  • Solaris 8, 9,10, Solaris Containers, truss, strace
  • HP-UX 11.31, Itanium
  • AIX 4.3, 5.1, 5.2, 5.3
  • Tru64
  • VMWare/ESX Server
  • Oracle VM
  • MVS/OS 390
  • Novell Netware
  • Windows NT
  • Windows Server 2000/2003
  • Windows 3.1/95/98/2000/XP
  • DOS
  • IBM OS/2
  • EMC Navisphere/Navicli configuration

Programming Languages and 3rd Party Applications

  • PL/SQL
  • EMC Navisphere SAN Management Software
  • WinRunner, LoadRunner, Quest SQL-Navigator, Apache, Hammerora, PowerDesigner 8, EasyER, EasyCASE, Erwin 3.5.2
  • OSWatcher
  • Swingbench
  • Orion
  • Unix Shell Scripting
  • COBOL, 360 Assesmbler, IBM Series 1 EDX/EDL, C, Fortran, PL1, Basic, CICS Systems Programmer, BMC DB/2 Utilities, ISPF Dialog Manager, Omegamon for DB/2/CICS/VTAM,, NCP, FileAid, FileAid for DB/2, Intertest, Netspy, MS Office, Lotus Notes, Connex, Business Objects, Crystal Reports, Cybersource

Engagement Experience

  • Applications Development
  • ETL/Data Conversion
  • Testing
  • Installation
  • Troubleshooting an assortment of problems, ranging from poorly tuned OS kernels to diagnosing defective fiber optic cables connecting the database server to the SAN and everything in between.
  • End User Training
  • Conversion
  • Configuration
  • Project Management
  • Backup and Recovery Optimization
  • Disaster Recovery Implementation and testing
  • Performing various traces within the database and at the operating system to identify and correct performance issues.

Hire Now