Manager Oracle

Michael A. Foster

408-***-**** cell ****@*************.***

Consultant Senior DBA / Manager / Architect / DB Developer and Mentor, Linux+ Certified Administrator, Oracle Certified Professional OCP DBA six times over ( 11g, 10g, 9i, 8i, 8.0 and 7.3 ).

Thirty-years of experience as an Oracle based Architect, Developer / Development DBA; extensive experience as a Production Oracle DBA; significant experience as a hands-on Technical Project Lead / Manager. Many years OLTP & Data Warehousing DBA, Analyst and OLTP & DW Developer experience. Focused on building, and the continuous improvement of, simplistic, appealing, and intuitive designs to robustly and effectively address intent.

Significant exposure to Government, Web/E-Commerce, Oil, Public Utility, Inventory, Order Mgmt., MRP, Manufacturing Execution, Scientific, Engineering, Retail, Power, Support Systems, and Financial industries.

Recent and considerable experience designing, developing, tuning, and administrating Oracle based large scale OLTP databases, & Data Warehouses. Strong understanding of relational design, and star schema design (fact and dimension entities) from both a logical and physical perspective. Many years of experience with very large transactional databases, heterogeneous feeds / ETL / ODS / Client facing Data Mart design and hands on implementations.

More than twenty-five years of experience provisioning, installing, upgrading, patching, production administration / DBA, tuning Oracle databases (6.0 thru 12c), application servers (12c, 11g, 10g AS, 9iAS, WebLogic) and related products (Apex, Forms, Reports, Discoverer, Oracle Enterprise Manager / OEM).

Twenty-five years of experience – spread across career – as a Developer of Oracle based solutions for mission critical requirements – using standards based development tools – using Agile like methodologies (OLTP, DW, VLDB, & High User Concurrency).

Strong Client facing communication skills at all levels.

Focused on Enterprise - RDBMS based - full project life cycle implementations, including proposal, requirement definition, design, development, test and production administration stages.

Extensive experience architecting, and implementing infrastructure, including performing capacity planning, and performance analysis for compute, SANs, Storage Appliances, and networking components to support large ERP based systems (both OLTP and DSS/Data Warehouses).

More than twenty-five years of day to day administrative and development practice with each of the following Operating Systems: UNIX, Redhat Linux, Solaris, HPUX, AIX, Windows NT/2000/2003/XP/2008/Win 7, and VMS.

Ability to work in many different capacities to accomplish goals (e.g. Team Member, Administrator, Developer, Project Manager / Lead, Architect, QA, Presenter, Mentor etc.). My knowledge is your knowledge.

Considerable Project Management, and Scheduling experience with a thorough understanding of the steps necessary to complete a large complex Oracle Applications (e.g. Financials 11i etc.) migration, installation, or custom Oracle development project.

Sizable technical experience (more than five projects) with installation, tuning, upgrades, data migrations and development of system interfaces, extracts, Oracle Forms and SQL based report customizations on Oracle Apps ( e-Business Suite / EBS ) R12, and 11i. Heavy hands on experience with Apps. admin tools like adop, adpatch, autoconfig, adadmin. Significant SAP DBA support experience as well as an Oracle DBA.

Thorough knowledge and experience with several Oracle Backup and Recovery architectures to insure database data integrity, backups and recoverability within budget and time frames - using many different technologies to fit Clients requirements RMAN, split mirrored hots, expdp / impdp, Data Guard etc. Experience with several failover and clustered architectures / technologies (OS and Oracle RAC based clustering) and Oracle Streams replication.

Strong knowledge of security mechanisms available at the networking, operating system, database and application levels, assure guarantee safekeeping of proprietary information, along with single on applications.

Recent Skills and Tools Summary

Operating Systems Administration

HP UX / AIX / Solaris / Linux (Redhat RHEL 2,3,4,5,6, CentOS, Oracle Enterprise Linux) / Windows Server / Mac OS / VMS / VMWare / vSphere, Sun, HP, IBM, Compaq, Dell, EMC, Hitachi, Dell

Applications Administration And Development

Vertical Market Experience - Finance, Claims, Order Management, Inventory, Shipping, Engineering, Power Grid Management, Banking, Document Management, Retail

SAP DBA, Oracle Applications e-Business Suite (EBS) Releases 10.x, 11.0, 11i, R12.1 & R12.2, OBIEE, Discoverer, Business Objects, Extreme Volume OLTP, Terabyte Warehousing, ETL

Oracle Application. Server 3, 4, 9i, 10g R2, 11g, WebLogic, Apache

Database and Application Server Administration and Development

Oracle Enterprise Database Server Versions 2,3,4,5,6,7,8,8i,9i, 10g, 11g R2, 12c, Oracle RAC 9i, 10g, 11g & 12c

Oracle Enterprise Manager (OEM), Grid, ASM, ADDM, AWR, ASH, Oracle Tuning Advisors, SQL Profile

Oracle Application Server 3, 4, 9i, AS 10g, AS 11g, WebLogic

Oracle Developer, Oracle Designer, BI Publisher, Work Flow

APEX, Toad, SQL Developer, SQL, PL/SQL, Oracle Forms, Oracle Reports, Pro*C, MySQL

Oracle Related Tuning

Infrastructure - Host Server Provisioning / Tuning, Networking Design, Storage Array Design

Application Tuning - Algorithm Design / Re-design, Workflow Design Refactoring

SQL / View Tuning - Optimal Index Definition, w/AWR, SQL Profiling, Explain Plan,

Schema Tuning - Oracle Statistics Optimization, Partitioning,

Database Tuning - Memory Optimization (PGA, SGA), Optimizing IO Patterns and RAID Strategies for Desired Load

Oracle Support Tools, Installs, Migrations, Upgrades, Patching & Platform Conversion

runInstaller, OPatch, MOPatch, BRTools, exp/imp, expdp/impdp, SQLLoader, PL/SQL, RMAN

Data Modeling / Relation Design

3rd Normal Form for OLTP, Star and Snowflake for Data Warehouse, and Operational Data Store Design Patterns

Oracle Related Backup Tools, High Availability, & Replication

RAC, Oracle Data Guard, HP Service Guard, RMAN, Oracle Streams, VMWare, Golden Gate

BCV Splits, TSM / TDB Tivoli Backup, Veritas Netbackup, Legato Backup

Web Design And Development

HTML, XHTML, XML, CSS, JavaScript, jQuery, HTTP, HTTPS, Dreamweaver CC

Development Languages, Tools & Scripting

Korn, Bash, Perl, DOS, PL/SQL, SQL, SQLPlus. Java, Visual Basic, C, C++, Perl, Toad, SQLDeveloper, Putty, VNC

Project Management, And Documentation Tools

MS Office - Word, Project, Excel, Visio, Outlook, PowerPoint

Senior Oracle DBA / Architect - Gulfstream Aerospace, Savannah, GA Nov 2015 - March 2017

Providing production DBA support in a large enterprise environment comprising 120 production instances and 3X that in development, QA, and other type instances. My DBA responsibilities were split about 50/50 between SAP based Oracle databases and non-SAP using versions 12.1.0.2 and 11gR2 of Oracle’s Enterprise Database product.

Performed database upgrades, PSU patching, license management, database cloning / duplication and Oracle Home cloning. Supported SAP stack patching and quarterly OS patching.

Supported a mission critical 7x24x365, large upgrade of a multi-TB OLTP database that provided Gulfstream’s Aircraft Service functionality 6000 users – Corridor / Continuum from V8 to V11 Corridor while upgrading from Oracle 10gR2 to 12.1.0.2 Oracle Enterprise and implementing Oracle partitioning in the rollout. Benchmarked several architectural options to position the Client with the best solution going forward to minimize downtime during the database and application upgrade by being a driving force in the tuning of all aspects of the very large migration code set and accompanying infrastructure.

Created and supported several RAC and many Active Data Guard instances, both JFS2 and ASM based, in AIX (870 IBM Frames) and Linux VMWare/Intel hosted environments connected to stand alone JBOD, and EMC VPLEX / VMX & VNX storage tiers on premise. Used EMC Data Domain / DDBoost based storage appliances and strategies integrated with Oracle RMAN backups. Implemented and supported Data Guard instances, and Golden Gate replication. Performed Weblogic 11g & 12c provisioning and administration.

Used Oracle Enterprise Manager 12.1.0.3 and later OEM 13c for corporate wide support, blackout window definition and alert distribution, corrective actions, and assisted with OEM 13c upgrade. Rotated to DBA-ON-CALL one out of every eight weeks providing 7x24 support. Provided regular weekend / night maintenance support for systems mentioned.

Thoroughly documented processes and procedures and mentored less senior personnel. Presented to all corporate levels via the governance hierarchy, architectural and process documents using verbal, and written communication tools including. MS Office, MS Project, MS Visio, WebEx, Jabber & SameTime / Notes, Used Remedy/SRMS and later Service Now for Incident, Requests, Work Order and CRQ remediation.

Senior Oracle DBA / Architect - City of West Palm Beach, FL - Feb 2015 – Sept 2015

Oracle EBS R12 Application DBA, Oracle DBA, and Solaris Admin, supporting all activities related to EBS application DBA including the design, testing and documentation of the R12.1 upgrade to R12.2. Performed all Oracle production, test & development DBA tasks, and Solaris administration. EBS patching, cloning, refreshes, & user administration and all trouble shooting activities; DBA activities including backups, refreshes, OEM, performance tuning, & Solaris administration, configuration, zone administration, ZFS tasks, shell scripting, monitoring, troubleshooting etc. Supported TSM / TDP based RMAN DB backups.

Supported the city of West Palm Beach through an Oracle LMS audit, providing consulting and technical services to comply and minimize costs.

Senior Oracle DBA / Architect - Verizon Communications – Tampa Florida – Jan 2014 to Dec 2014

Performed in a number of roles (mainly Oracle Development DBA) for the largest communication company in the US. Initially installed Linux & provisioned four RHEL 6.5 nodes to support the group’s development Oracle RAC DB environment that supported Verizon’s proprietary AI network service system. Installed Oracle 11gR2 RAC 11.2.0.3. Installed and provision five RHEL 6.5 nodes to support the team’s application server tier. Worked with Developers tuning very high transaction rated DB related applications. Instrumental part of the team that installed OBIEE on a couple of the app servers and provisioning the database to support OBIEE. Linux support included RPM, and security management, and kernel tuning to support the software stacks. Supported MySQL with installs and administration on RHEL platform for light weight DBs.

Worked in Verizon Standard Operating Environment (SOE) for development, offshore development, user acceptance, performance, and production (including DR). SOE platforms, which, up to production, were ESXI / VM / vSphere 5.5 based Linux environments. Production environment was hardware based. Provided provisioning support using VMWare data stores, and VMs with vSphere console. Primary resource in provisioning shared storage for Oracle RAC with vSphere 5.5.

Performed and supported proprietary application maintenance, development and tuning with timely version rollouts / change management for mainly database related activities. This involved using a highly customized and integrated code management system / service request system, CVS / IPM based.

Additionally, heavily utilized and administrated VNC, Putty suite, SQLDeveloper/Toad, Korn and Bash Shells, Oracle Enterprise Manager, Oracle RAC command line utilities (crsctl, srvctl, asmcmd), RMAN, and logical backup (exp/imp and expdp/impdp) to address the team’s and my activities.

The main application that I supported was Verizon's proprietary network surveillance application - which provides Verizon with the ability to monitor, identify events, alert & alarm, root cause analysis with correlation and generally help to resolve internal network, and topology problems. This application did not monitor Verizon's Client devices - only Verizon owned resources. Rolled out (installed, configured, and administrated including Weblogic ) OBIEE 11g with the latest release to reporting and analytical requirements.

Installed 12c RAC in SIT (development environment); imported production data & cleansed; assisting Development team with application upgrade process and testing / verification with 12c.

Senior Oracle DBA / Architect - State Of California (Dept. Of Water Resources) – Sacramento – April 2011 – Nov 2013

The last 1.5 years (of more than 2.5 years on contract), I was part of a good-sized team during the full life cycle, design, development, QA and production rollout of a multi-TB Data Warehouse / Data Mart / Business Intelligence solution for power and water scheduling and costs. Performing architectural, development and DBA related tasks, analysis, data mart design (star and snow flake schemas, End User Data Mart view definitions, partitioning, local partition indexes, statistics gathering etc.). I was also the sole APEX Developer 4.2 supporting DW reporting using, Windows 2008 Server, Oracle 11g, OS and database respectively.

Apex requires a decent knowledge of HTML, CSS and JavaScript, which I’ve been doing at an intermediate level for many years. The opportunity to do Apex Development here at DWR has again significantly enhanced my web developments skills. Also, acted as the provisioner / installer / configuration manager and administrator for the Oracle APEX product in all life cycle environments.

Performed as a full-time production DBA for the first year of engagement and on demand throughout the entire Client commitment (more than 2.5 years). Executed database administration, and middle tier administration, architecture definition (hardware and software), installs, new COTS implementations, upgrades, DR, and technical documentation activities required to support the state of California Dept of Water Resources.

Upgraded mission critical 10g production databases TB DB from 10g to 11g. Created, tested, documented 11g Data Guard environment for production and QA 1/2TB OLTP databases.

RMAN cloned many instances. Performed DBA and Development tasks with 11g Oracle Enterprise Manager, Toad 10X+, and many windows command line and Windows based utilities (.e.g. DOS Command, RegEdit, Services manipulation etc, VBScript, WScript. The state of CA DWR is a Windows only shop, so all work was performed on Windows Server 2008 R2, 2003 R2 – Dev an some QA instances were VM’d – all Dell and EMC hardware. Performed OEM 10g and Weblogic 11g provisioning and administration.

Revamped RMAN backups to improve recovery reliability and space utilization by implementing redundant target and incremental backup strategies. Performed day to day production DBA tasks and DBA support of QA and third party Development groups.

Bank Of America - Los Angeles, CA - Senior Architect DBA and Developer August 2010 – April 2011

Responsible for database administration, architecture and detailed design, implementation, and technical documentation activities required to support the mortgaging side of Bank Of America. More specifically, supporting imaging and content management environments, addressing very large (multi-terabytes with thousands of concurrent connections) Oracle / Documentum based OLTP and Decision Support RAC databases on very large IBM P-Series / AIX and EMC Symmetrix based hardware based systems.

Company is in the midst of an extremely large systems merger as a result of Country Wide and Bank of America merger / acquisition - complicating IT activities.

My strategic directive was enhancement of stability and scalability. Day to day roles, projects and tasks included Streams support for OLTP to dedicated Reporting replication. I also performed extensive DB performance tuning using ADDM, AWRs, SQL Tuning Sets and tuning advisors, connection, and PL/SQL tuning. Aided in design and review of various database migration projects to enhance scalability and stability.

Performed assessments, recommended and implemented architectural changes and smaller enhancements to both hardware and proprietary software running in very active / high concurrency, high volume Oracle RAC environments. Systems were AIX based, Oracle 11gR2 and 10gR2 RAC using Toad and Oracle Grid / Enterprise Manager, and other industry standard tools to sustain and enhance large fairly complex SDLC environments.

Client name left out to protect their interests – may be disclosed with NDA to interested parties – Technical Lead, Linux Administrator and Oracle DBA Administrator - 2006 to 2014 part-time

Analyzed Clients hardware needs and supplied / procured and setup (either myself and or coordinated) all Dell Server hardware (servers and disk arrays). This has swelled to about 6 Dell PowerEdge Servers and 2 drive arrays over the years) to support the Clients growing business and IT demands. More specifically, I have ported and upgraded Oracle and Redhat Linux to a new Dell 2950 production server used to run the company’s main application (a shipping & warehouse management database and application server). Upgraded from Oracle 8i to 10g R2 RAC (standard edition) and upgraded Redhat Linux 2.1 AS to Redhat Linux 4.3 AS and setup RMAN database backups.

2010-2013 Setup a hybrid backup, DR (disaster recovery) and BI reporting server running Linux 5.0 CentOS and Oracle 10g R2 Standard Edition (developed a proprietary failover so the Client had real-time reporting but did not have to pay for Enterprise features – saving the client hundreds of thousands of upgraded production box to Linux 5.

2014 & 2016 – Implemented and supporting Oracle Data Guard for DR and some reporting using Oracle 11gR2. Upgraded RHEL to 6.6 and then to 6.8. Installed and administrated MySQL databases for small proprietary DBs on RHEL 6.6.

Installed Business Objects Enterprise Server XI in a Windows 2003 Server environment specifically for the Crystal Reports Server XI scheduling, and email feature. Ported all Crystal Reports 8.5 reports to XI.

Tuned the production Oracle instance to take advantage of new 10g R2 functionality, PGA aggregate target (instead of sort area size per process), automatic undo (instead of traditional rollback segments), converted to cost based optimization, spfiles, flash recovery and RMAN etc.

Tuned the SGA/buffer cache, shared pool, log buffers, and redo-logs to fit the Client’s load. Generally the buffer cache, log buffers, and redologs were under sized even for the old production box. We upped the allocated resources significantly resulting in significant increases in execution ceilings.

Developed technical documentation for all of the existing systems. Upgraded Client Oracle DBMS this time from 10gR2 to 11gR2 RAC using GNS based SCAN (Single Client Access Name) load balancing listener.

State Of Florida - Senior Architect DBA and Developer Dec 2007 to Dec 2010

Responsible for architecture and detailed design, implementation, administration, development, technical documentation and database activities required to port the Lottery’s large Claims and Pay (OLTP based) system from VMS / Cobol to AIX / Oracle database 10gR2 & 11gR2 and App Server AS10g.

Developed completely new relational design / data model / schema (logical and physical) to enable major improvements in encryption, security, performance, data integrity and functionality. The end result is about a 75 table relational design with full primary key and referential integrity, providing in almost all instances sub-second response to an end user community of about 150 concurrent user statewide. We architected the system such that the current system, future interfaces and extensions are all data driven providing flexibility and great extensibility to a rapidly changing and growing profit center for the state. Project rolled out into production on time and under budget Jan 8th, 2010.

Designed and lead developers in migrating historic data out of the legacy into the newer normalized design (approximately 20GB of condensed data). I designed, developed (a series of PL/SQL packages and Unix scripts) and performed the go live migration of all of this mission critical claims and pay data for the legacy system on Jan 8th 2010. Taking 15 years or so of Florida Lottery claims and pay data from about 25 DEC RDB tables and normalized them into a 75 table Oracle 10gR2 AIX based DB/schema.

Lead Development of Oracle based middle tier applications using Apex, PL/SQL & Oracle Forms & Reports tools for the mission critical interfaces (validate claims etc.). The system is made up of about 30 forms, several SOA components/interfaces of varying complexity – some very complex; Apex and Oracle Reports, plus a Webi Universe for the DW component; a few hundred GB database total space; about 75 tables in the DDL; many foreign key and primary key constraints and a few miles of PL/SQL (package based development, using a wide variety of industry common and advanced PL/SQL features). In fact, 90 percent of the database design of which I was the principle Designer, has complete referential integrity built-in using primary key and referential constraints in a standardized fashion throughout.

Performed many of the production and all of the development Oracle DBA activities and many AIX & Linux Admin functions in the development rollout cycle. Aided with the development, configuration and testing of a Data Guard switch and failover environment for the mission critical Pay and Claim application we architected.

Principle on the following mission critical sub-system: Ported, re-designed and implemented real time socket to socket communications application written in Pro*C & C and PL/SQL to validate winning tickets between major state gaming vendor and the state. This involved porting the client side of the socket interface to AIX – C based, linking it into Oracle as a new listener (Oracle Pro*C based external Oracle procedure) and interfacing that to PL/SQL – which ultimately was called from an Oracle Forms 10g GUI. Involved a thorough knowledge of real-time sockets API from C, Pro*C, AIX compliers and linkers and Oracle’s external procedures protocol.

Data 911, Alameda, CA – Senior Oracle Consultant (Part-Time) January 2006 thru Aug 2008

Ported and rolled out Data911’s commercial product to Redhat Enterprise Linux 4.5 on Oracle 10g R2 (10.2.0.3) RAC. Performed ALL administrative and installation activities for both Linux and Oracle 10g RAC, including shared disk array administration, OS install, clusterware install, Oracle RAC install, patching, backup installation and setup at both the database level (RMAN) and OS levels. Worked with a team of Data911 personnel on QA of the product before a go live at one of their largest clients.

Hardware environment for the RAC installation above consists of a pair of Dell PowerEdge 2950s and a Dell MD3000 array for shared storage to support the Linux Oracle RAC cluster as well as a training node. Was instrumental in the choice of hardware at all levels to cost effectively fit the Client’s needs. Installation uses ASM and OCFS2 for shared storage. Gained extensive experience with RAC Database control, srvctl, oifcfg, crsctl and the entire RAC installation. Also setup development Oracle RAC 10g development environments in Data911 and my office using Dell PE 2850s and PowerVault 220s.

The Client’s standard platform is Windows 2000 and 2003 Advanced Server / Dell servers. In the Microsoft environment I installed 9i R2 9.2.0.4, patched the databases to the latest 9i R2 release 9.2.0.7. Installed 10g R2 10.2.0.1 and patched to 10.2.0.4. Upgrade 8i databases to 9i and 10g participated in the process of certifying Data911’s commercial product line with the 9i R2 and 10g R2 databases. Documented the upgrade process from the DBA perspective from 8i to 9i and 10g. Porting COTS dispatching product to 10gR2 RAC Standard Edition to undergo a comprehensive certification process to support Clients that desire a cost effective HA solution.

Tuned the instances to take advantage of new 9i R2 and some 10g functionality and other features that the Client had not yet implemented including, PGA_AGGREGATE_TARGET, automatic undo, converted to cost based optimization, automated statistics gathering and implemented some table monitoring for statistics gathering, external tables, spfiles, RMAN and Flashback technology,

Documented and trained DBA staff in 9.2 DBA Administration and Developers in 9.2 features for Developers.

Performed extensive analysis of Data 911’s Client’s production environment, identified and tuned application SQL that blatantly needed tuning using tkprof and explain plans, Statspack etc.

Gained extensive experience administrating Oracle in a Windows Advanced Server environment. Performed DB cloning and refreshes using hot and cold backups from many different production environments to development and QA databases to support development and QA groups. Expanded knowledge of Windows registry entries for 8i, 9i and 10g and obtained a thorough knowledge of service creation and service startup intricacies.

Implemented another cost effective failover architecture for one of the Data911 Client’s. Put a high speed dedicated network segment from production to failover in place to facilitate a quick transfer; setup read only synchronized shares from production to failover, documented and tested the complete failover scenario, made the process generic.

Florida Lottery (State Government) as a Senior Oracle Architect / Consultant. (August 2003 – Dec. 2005)

2005 Developed a new logical design and implemented a new physical data warehouse to support the new vendor attributes in the reporting / data warehouse environment afterwards (approximately 2 TB). Used materialized views with a combination of fast and full refreshes to maintain warehouse synchronization. Implemented with Oracle Designer for Logical ERD development and Visio to document and communicate relatively sophisticated data and process flow from and to many different entities supplying financial, product and retailer information. Also created materialized views to rollup sales fact tables to support diverse reporting requirements. Designed time, product, and retailer dimensions entities to support the sales fact tables. Exposure to Business Object universes that provided end user reporting capabilities from the warehouse. Tuned the OS, database level init.ora parameters, indexing, partitioning and SQL to optimize performance, implemented on AIX 5L2 and Oracle 9iR2 DB versions.

2005 – Co-project lead with a state employee on the migration of all of the Florida state Lottery’s IBM MVS legacy systems to Oracle 10g / AIX – designed an out of the box staging and ELT process to comply upcoming new vendor contract and Data Warehouse feeds.

More specifically, I was instrumental with providing the Design, Architecture and leadership/mentored a team of about eight full time IT personnel (and 10 or so more part-time) on a project that implemented all new interfaces and translations to existing Lottery legacy systems to support the introduction of a completely new gaming vendor (i.e. the Florida Lottery contracts out the all terminal activity at the retailers site) for all Lottery games (online and instant). For the first time at the FLA Lottery, AIX and Oracle are being used to support all ETL activities between the gaming vendor and the Lottery (previously it was VMS and MVS legacy systems).

Used standard Oracle 9i DB, Oracle’s development tools and languages for the conversion (SQL, SQLPlus, SQL*Loader, PL/SQL) and UNIX Korn Shell) and Tivoli Scheduler on AIX.

The translation system supported the new data warehouse by maintaining the mainframe legacy pass through of data to the Data Warehouse. The proprietary database design I architected for the ETL processes saved time and money. Zero state funds were spent on COTs ETL software and the design was such that practically no legacy software required modifications. The architecture included robust and thorough audit trails, error logging and recovery mechanisms. The project was executed from concept to production in less than 6 months. Used Tivoli Workload Scheduler for scheduling and job control. Toad was used to facilitate the Oracle component development along with Oracle EM and some Oracle Forms and Java Swing based user interfaces. Again Oracle Designer and Visio were used for logical design, communication and documentation purposes.

2003 / 2004 - Provided assistance designing a 9iAS deployment architecture, installed Oracle 9iAS R2 on AIX and Linux, configured OC4J Forms & Reports Services. Deployed J2EE JSPs, ported / redeveloped legacy text based applications. to Forms 9i (9iDS) and trained Development and Operations/Administration in the use of development and administration of 9i R2 database 9iAS and 9iDS. Worked in AIX 5 / 4.3.x and Windows XP environments. Upgraded to 10G AS spring 2004. Performed all Redhat Enterprise (3.0 and 4.0) / Linux Administration, including installs / kickstarts, disk volume management, upgrades, backups, networking config, security etc.

2003 / 2004 Re-engineered data warehouse to increase performance and ease maintenance. Used tkprof and explain plan to optimize index generation and understand optimization opportunities. Converted global indices to local (to ease maintenance and improve performance). Automated future partition creation (to ease maintenance) and optimized granularity of partitioning

Contact this candidate