Troy S. Clark
2015 W. Cactus Rd., Apt. 250
Phoenix, Arizona 85029
[Send email to request phone number] 28-0906
[Send email using form at bottom]
PROFESSION
Sr. Oracle DBA
Systems Architect
GENERAL SKILLS
I possess a deep knowledge of system architecture, design, analysis and
implementation of database systems including advanced storage systems and server
hardware. Senior level database architect and administration skills including
database modeling, performance tuning, high availability planning, capacity
planning, scaling, upgrades, migrations, disaster recovery and standby database
preparation. Good leadership, mentoring and team building skills with the proven
ability to successfully plan, manage and implement large databases and software
systems; excellent relational database design skills using traditional methods
and case tools; thorough understanding of full life cycle development, accounting
and project management.
Strong problem resolution and tuning skills at both the hardware and software
level with an emphasis on optimizing SQL statements, stored procedures and
triggers. I have a very strong development background in 4GLs, C, C++, SQL,
PL/SQL, Oracle Portal with some exposure to Java and J2EE technologies. I am a
true team player with experience as a Sr. Developer, Sr. Database Administrator,
DBA Group Leader and Lead Systems Architect.
CERTIFICATIONS
Oracle 8i, 9i Certified Professional Database Administrator
Expect to complete OCP10g certification within the next 30 days.
RECENT TECHNICAL TRAINING
Oracle Database 10g: RAC for Administrators (completed February 9, 2007)
RECENT EXPERIENCE
Re-architected a HIPAA EDI processing infrastructure using RHAS 5, Oracle 11g,
ASM, RMAN, IBM Optim Data Archiving, FC SAN to include full HA and DR
capabilities.
Migrated Oracle databases from AIX/RS6000 infrastructure to a Linux/Intel Grid
infrastructure using PolyServe MatrixServer, SLES9 and Oracle 10g for improved
performance, higher availability and reduced costs.
Designed and implemented a HIPAA Data Repository using Oracle 9iAS & 9iR2,
XMLType and Oracle Portal
Migrated Claims Clearinghouse Oracle database running on AIX from version
8.1.7 to 9.2.0
Implemented Oracle9iAS on AIX and Linux to host J2EE application and for web
based report deployment.
Architected a Data warehouse and inflow process using Powermart, Oracle8i,
Solaris8.
Lead the efforts to define a scalable Web Software Architecture and
Implementation using J2EE (JDK 1.2.2, JSP 1.1, Servlet 2.1, EJB 1.1) and select
tools Jbuilder 4.0, Weblogic 5.1, Struts 0.5, ANT, etc.
Managed a Team of 4 DBAs: Mentoring, Training, 24x7 Support Rotation,
Technical Leadership.
Oracle 8i Performance Tuning of a mission critical financial transaction
processing system.
Architected Fibre-Channel SANs for shared server storage and off-network high
speed backups.
Planned and Implemented a Disaster Recovery Site using Oracle 8i Standby
Database.
Troy S. Clark
2015 W. Cactus Rd., Apt. 250
Phoenix, Arizona 85029
[Send email to request phone number] 28-0906
[Send email using form at bottom]
Title: Sr. Database Administrator Company: Blue Cross Blue Shield of AZ
From: Oct 2007 To: Present
Duties / Responsibilities:
Implemented a HIPAA Data Repository using Oracle 9i and 9iAS which stored
EDI/HIPAA transactions as complete XML documents using XMLType with CLOB storage.
Finely tuned the production version of a Claims Clearinghouse database. Created
backup, restore and recovery and disaster recovery plans for Oracle database
systems. Designed and implemented an Oracle Security Policy that has withstood
several audits. Capacity planning, hardware system recommendations, database
design, developer mentoring, technical consulting to the other groups, etc.
Migrated 3 oracle databases running on AIX 4.3 from 8.0.4 to 8.1.7 and from 8.1.7
to 9.2.0. Provided diagnostic and tuning support for SQLServer databases.
Implement and administer Oracle9iAS for J2EE applications and report deployment.
Recently migrated from AIX/RISC to Linux/Intel based grid infrastructure using
SLES9, PolyServe Matrix Server and Oracle. Also provided Systems Architect
services to the EDI processing group in addition to my regular Sr. Database
Administrator services. Requirements analysis and advanced storage architecture
design that not only met the current project requirements but defined a best
practice and a storage technology road map for the future of BCBS of AZ.
Upgraded the infrastructure to reduce the number of physical database servers
from 12 to 4 and to reduce the number of storage arrays from 4 to 2 while making
large gains in capacity/performance and reducing total cost of ownership and
administration required to support BCBS of AZs HIPAA EDI processing system.
Designed and implemented a data archiving solution to allow 7 years of data to be
kept available while reducing the size of the working data store in production
for higher performance and higher probability of maintaining service level
agreements in such that the internal customers didnt even realize or need to be
concerned with where the data was stored (i.e., is the data in the production
data store or in the archive storage?) since they simply use a single
user-interface to access the data by date range. Increased the High Availability
and Disaster Recovery capabilities of the infrastructure, etc.
Title: Sr. Oracle DBA / Systems Architect Company: i-Beacon.com
From: June 2000 To: May 2001
Duties / Responsibilities:
I took a rough conceptual data model and produced a refined physical model used
to create a health care industry data warehouse on an E6500 running Solaris 8 and
Oracle 8i. I was the technical lead responsible for designing a distributed data
warehouse inflow process including network, data security, data cleansing, ETL
processing, etc. I designed a de-identification engine that allowed transmitting
health care data in a HIPPA compliant fashion while still allowing for person
centric data warehouse records. This involved using SHA-1 and MD-5 one way hash
encryption algorithms, etc. I also helped establish their web software
architecture. We chose the J2EE platform running on BEA Weblogic and designed
web applications using the Model-View-Controller pattern via STRUTS, Stateless
Session Beans and DataAccessor Classes using JDBC to Oracle 8i. I also designed,
implemented and maintained databases used as the backend of the web applications.
I supported web developers by providing them with tuned SQL statements and
stored procedures and by assisting them in their object to relational mapping
efforts. I was also responsible for all traditional DBA maintenance duties.
Completed a migration from 8.1.6 to 8.1.7 (64 bit). The production operating
environments were Windows NT, Windows 2000 and Solaris 8. We used Oracle 8i
(8.1.6) and associated tools (e.g., SQL*Loader, etc.), PowerDesigner, SQL
Navigator, Powermart, Weblogic 5.1, etc.
Troy S. Clark
2015 W. Cactus Rd., Apt. 250
Phoenix, Arizona 85029
[Send email to request phone number] 28-0906
[Send email using form at bottom]
Title: Sr. Oracle DBA / Systems Architect Company: eFunds, Inc. (Formerly Deluxe
Data)
From: October 1998 To: June 2000
Duties / Responsibilities:
Chief technical consultant for hardware and software architectural direction.
Standardized NT based system on Compaq clustered servers, Storage Works switched
fibre-channel SAN RAID Storage with a custom arbitrated loop fibre-channel SAN
for doing high speed backups without impacting the network. Responsible for the
support, upgrades, tuning and general administration of all database servers in
production, QA and development. Completed Oracle migrations from 7.3 to 8.0.5;
8.0.5 to 8.1.6. Designed and implemented business recover procedures which
involved creating an Oracle 8i standby database at a remote location a scripting
log file transfers and auto-recover at the remote location, etc. Supported the
development organization with mentoring, database design, sizing, stored
procedures, triggers and tuning (i.e., hardware and software). Represented my
site on a corporate wide web based application architecture planning team. I
hired, mentored and scheduled other DBA staff.
Title: DBA Consultant Company: Intel Corp., Phoenix Newspapers,
Touch Technologies, Deluxe Data Systems
From: Sept., 1996 To: October 1998
Duties / Responsibilities:
Contracted to design and implement the distribution and return processing
modules of a large scale ACH Project using PowerBuilder, Oracle 7.2, MSVC 4.2,
Pro*C. Migrated a production database from Oracle 7.2 to 7.3
Contracted to provide emergency Oracle DBA and Delphi front-end development
necessary assist the client in successfully meeting their contractual obligation
to complete a smart card, stored value project by March 1997.
Contracted to provide software maintenance and performance tuning of a large
scale ad order entry / sales agreement system using PowerBuilder, Blueprint,
PowerTool, PadLock, SQR, Unix Shell Scripts, Sybase Store Procedures.
Contracted to do MS SQL Server stored procedure development and performance
tuning and to design and implement Database SCHEMA changes and enhancements to
the backend of a web based Manufacturing Assembly, Test and Yield Analysis
System.
Title: Sr. Info. Systems Analyst Company: Deluxe Data
From: Sept., 1995 To: Sept., 1996
Duties / Responsibilities:
Project Technical Lead responsible for analyzing functional requirements,
creating technical specification documents, schudules and PowerDesigner database
models as well as doing the actual development of client server programs for the
banking industry using PowerBuilder 4.0, Oracle 7.2, MS-Visual C++ 4.2 and Oracle
Pro*C 2.1. Designed and implemented application frameworks for RAD development
in PowerBuilder. Oracle DBA role (installation, client setup, tuning, etc.);
Leader of team of 6 developers.
Title: Programmer/Analyst Company: Magnum Engineering, Inc.
From: Sept., 1994 To: Sept., 1995
Duties / Responsibilities:
Used FoxPro 2.6 for Windows to design and implement a custom MIS System spanning
GL, AR, AP, PR, JC, SO, PO, EDI, INV, Shop Labor, Shop Floor Control with a
combination of custom and 3rd party software and bar-code scanning hardware,
etc.
Title: MIS Manager Company: De Lellis Development, Inc.
From: Sept., 1991 To: Sept., 1994
Duties / Responsibilities:
Developed custom programs to enhance automation, including a complete
estimating, quoting, purchasing and billing system using Microsoft Access.
Implement a complex construction bidding/accounting system.
Title: PC Specialist Company: J.R. Lewis & Assoc.
From: May, 1983 To: July, 1991
Duties / Responsibilities:
I wrote CAD macros, implemented custom databases and designed and programmed GUI
applications and desk-accessories required to automate routine business functions
using Pascal and C. Two major achievements were the creation of a custom
accounting system and an auto-balancing electrical load- scheduling program. I
became an Apple Certified Developer in 1986. |
