Architect Resume

SUMMARY:

Wayne Balmer TEMPhas over 20 years of successful implementation experience with d Confidential base technology and application architecture, especially using Oracle products and other D Confidential Bases such as MS SQL Server.
Wayne Balmer TEMPhas been able to apply each technology enhancement on a variety of architectures from Oracle version 4 up through Oracle 10g, including utilization of logical disk farms, SANS, logical partitioning of servers via virtual machines (UNIX and Windows), web interfaces and transactions, and d Confidential base designs dat keep up with teh servers and needs of OLTP and D Confidential Warehouse applications.
Able to define and work to standards including FDA 21 CFR part 11 and Sarbanes - Oxley (SOX).

EXPERIENCE:

Confidential

Architect

Responsibilities:

D Confidential base Architect for PBM company. Review and rework of established PBM D Confidential Warehouse for Integration. Developed Integration strategy and conversion from Oracle 10 to Oracle 11.
Review of D Confidential Model, ERwin 8.2. Rework strategy for Ab Initio as ETL tool. 2 TB d Confidential base including partitions, Tablespace compression, ASM storage etc.

Confidential

Responsibilities:

DBA for Near-Real-Time D Confidential Warehouse implementation of Oracle Financials for $35 billion company. Support for Development team. Extensive Performance and Optimization tuning utilizing Partitioning, Parallelism, Indexing.
Oracle 10g utilizing RAC, ASM and user interface via OBIEE (Oracle Business Intelligence Enterprise Edition) on Linux.
Responsible for promotion of D Confidential base structures and stored code through SDLC. Report extraction and optimization.
Direction of production DBA members and tasks. Monitoring via OEM, Toad, queries. Planning for migration to Oracle 11g. Extensive re-engineering of ETL and reporting methodologies for performance and optimization.

Confidential

Responsibilities:

Full Architecture assessment and recommendations (technical) current-to-projected for global on-line ticketing company. DBA and Architect support for d Confidential migration and future architecture efforts.
Extensive performance tuning and documentation for standardization of architecture to meet future SLAs, tune existing environments, and prepare for relocation of hardware infrastructure (d Confidential centers). Oracle 10g, Linux, Oracle Streams Replication, PL/SQL, ASM planning. Provided staff evaluation and recommendations.

Confidential

Responsibilities:

Full d Confidential base implementation evaluation. Monitoring and instrumentation design and implementation for a very large world wide Healthcare D Confidential company.
Performance and Tuning evaluation and assessment for a 24 TB D Confidential Warehouse to multi Mart d Confidential factory. Oracle 10g, Solaris, Informatica, Toad, ERwin.

Confidential

Team Lead/DBA/Developer

Responsibilities:

Physical application design and D Confidential base Administrator for Production and Development d Confidential bases from Oracle 10g - Oracle 8i. Application support, application migration, d Confidential base porting. Write SOPs, develop, and implement standards for installation and maintenance of d Confidential bases.
Extensive performance tuning and optimization of existing systems including PeopleSoft financial (OLTP), D Confidential Warehouse, etc. in SOX compliant environments leveraging heterogeneous Oracle d Confidential bases running on HP/UX, SAN storage, and Oracle RAC/Clusterware. D Confidential modeling.
Interviewing and supervision of DBA staff. D Confidential mapping and ETL design. Grid control and automation configuration. Utility and development work in SQL and PL/SQL Packages, Stored Procedures, Functions and Triggers. External tables, SQL Loader. D Confidential Pump.
Application porting and migration. Coordination with 3rd party vendors and Infrastructure.

Confidential

Responsibilities:

D Confidential base Administration and application coordination for D Confidential Warehouse. Oracle 9.2i for 900 GB d Confidential base. Administration and Documentation of Financial D Confidential Warehouse. Utility and automation development.
System Analysis and Modeling maintenance. Performance Tuning and Optimization. Brio/Hyperion tuning and maintenance.
Development and implementation of Sarbanes-Oxley compliant standards.SQL Server TSQL analysis and utilities.