Manager, Database Engineering

Professional Summary

Currently, I am a Senior Oracle DBA for Affiliated Computer Services, Inc. I have 19 years of experience in full systems life cycle development and project management. My experience includes the analysis, design, development, and implementation of finance, human resources, insurance, pharmaceutical, payroll, and environmental monitoring systems. I currently have 17 years of Oracle database administration and application development experience, which have included assignments with SAP, PeopleSoft, and Oracle Applications.

Professional Experience

Company: Affiliated Computer Services (ACS), A Xerox Company

Title: Manager of Database Engineering

Dates: June 2008 to present

Platform: Linux RedHat 5, Oracle 11g RAC (11.1, 11.2)

Manager of the Database Engineering team supporting Medicare/Medicaid claim processing applications.

Accomplishments:

Assist the Vice President of Government Health Solutions (GHS) with strategic planning initiatives

Mentoring 2 Senior Oracle/SQL Server DBA's, 1 Application Architect, and 4 COBOL developers

Assign and manage team tasks and workloads

Coordinate database change requests with the Cobol and Java team, and ensure changes are migrated to production on schedule

Assisted with the migration of the COBOL/DB2 claim processing engine, to the Oracle/Linux environment. Project is projected to save the company over $1M/yr.

Configured and deployed a production 4-node Oracle 11g RAC on Linux

Configured and deployed a development 2-node Oracle 11g RAC on Linux

Configured and deployed Grid Control 10.2.0.3 and 11g

Upgraded Grid Control 10.2.0.3 to Grid Control 10.2.0.5

Configured ASM on all database nodes (clustered and non-clustered)

Configured and deployed Oracle Streams for production to ODS replication

Converted COBOL programs to Oracle PL/SQL packages for optimization

Redesigned the Data Mart to support advanced queries, and improve performance

Created PL/SQL packages/procedures/functions to support the claim processing application

Implemented coding standards, and SQL review procedures

Company: Silverpop, Inc.

Title: Senior Oracle DBA

Dates: Nov 2007 to Jun 2008

Platform: Solaris 9/10, Red Hat Linux 4, Oracle 10G, CentOS (Linux)

Senior Production Oracle DBA supporting the company’s email marketing databases. The production databases

range in size from 2TB to 9TB. Responsibilities include the configuration of Oracle EM Grid Control, ensuring

that database backups are current and available, tuning long-running SQL, applying patches during maintenance

windows, code migration to production, and writing Korn shell scripts. One major accomplishment has been the

redesign of the data warehouse (6TB). Using proper dimensional modeling techniques, performance has been

increased by 45% over of the previous architecture.

Total job responsibilities require knowledge and expertise in the following areas:

Oracle Enterprise Manager 10g - Grid Control

Oracle Real Application Cluster 10g (RAC) on Solaris 10 (2 node)

Oracle ASM

Oracle RMAN 10g

Oracle Flashback Database

Dimensional Modeling (Data Warehouse)

Partitioning

ADDM, ASH, AWR, SQL Tuning Advisor, SQL*Loader

Company: GA Department of Revenue

Title: Senior Oracle DBA

Dates: Oct 2006 to Nov 2007

Platform: Windows Server 2003, Linux SUSE 9, Oracle 9i/10G

Senior Oracle DBA supporting government applications. These applications collect and distribute an average of

$10M per day. Responsibilities include the construction and implementation of the department’s Enterprise

Security solution, implementation of Oracle EM Grid Control, ensuring that database backups are current and

available, and managing the database architecture. Managing the architecture also included the logical/physical

creation of the Data Warehouse (2TB). By implementing the STAR schema model, we were able to create

dashboards to keep management informed.

These responsibilities require knowledge and expertise in the following areas:

Oracle Access Manager 10.1.4 (Oblix, CoreId, Thor Xellerate, Netpoint), Integrated Windows Authentication (IWA), Oracle Internet Directory (OID), Oracle Application Server 10g (10.1.2)

Oracle Enterprise Manager 10g - Grid Control

Oracle Real Application Cluster 10g (RAC) on SUSE 9 Linux (2 node)

Oracle Real Application Cluster 10g (RAC) on Windows Server 2003 (3 node)

Oracle ASM

Oracle RMAN 10g

Oracle Flashback Database

Partitioning

Company: American International Group (AIG)

Title: Senior Oracle DBA

Dates: July 2005 to Oct 2006

Platform: Sun E480/490, Solaris 9 & 10, Oracle 9i/10G

Senior Oracle DBA Team Lead supporting automobile insurance applications. Over the course of one year, the

business generated $1B worth of revenue. Responsibilities included the management of production batch

processes, performance tuning of all code/SQL accessing the databases, ensuring that security implementations

conform to Sarbanes-Oxley (SOX) requirements, establishing disaster recovery plans and testing failure

scenarios, automation of manual tasks, mentoring of team members, and providing technical direction for various

company initiatives. These responsibilities required knowledge and expertise in the following areas:

Oracle Data Guard

Oracle RMAN 10g

PL/SQL

Oracle Enterprise Manager 9i

Korn shell scripting

Partitioning

Data Warehousing

Advanced SQL Tuning options

Company: I-Health Technologies

Title: Senior Oracle DBA

Dates: Feb 2005 to Jun 2005

Platform: Sun E6800/E15K, Solaris 9, Oracle 9i/10G

Senior Oracle DBA supporting Medicare/Medicaid claim processing applications. This business processed an

average of $3M of claims per day. Responsibilities included the management of several batch processing

databases, and a 2TB data warehouse. Major accomplishments included (1) tuning of the company’s main

processing engine to increase throughput by 45%, (2) converting backups from custom shell scripts to RMAN,

and (3) automation of the monthly code release cycle.

Company: Affiliated Computer Services (ACS)

Title: Senior Oracle DBA

Dates: August 2001 to Feb 2005

Platform: Sun E4500/E6500/E6800, Solaris 8/9, Oracle 8i/9i/10G, Linux (RedHat AS 3.0), Oracle RAC

Senior Oracle DBA Team Lead supporting Medicare/Medicaid claim processing applications. Responsibilities

included the management of several data warehouses ranging in size from 500G to 4TB, the development of an

ETL strategy using PL/SQL, creation of materialized views to support summarized queries, rewriting of SQL

queries using Oracle data warehousing functions, partitioning tables and indexes, Unix shell scripting, and

backup and recovery using RMAN. Tasks have also included the implementation of database security to support

HIPAA requirements. All modifications and viewings of data are tracked based upon who/what/when

parameters.

Company: Purchase Pro

Title: Production Operations DBA

Dates: August 1999 to August 2001

Platform: Compaq GS160/ES40 (Digital Unix v4.x/5.x), Sun 440R (Solaris8), Oracle 8.0/8i

Oracle DBA on a team consisting of four Oracle Administrators. Responsibilities included the management of

production and development databases, administering Oracle Applications 11.0.3, backup and recovery using

RMAN, Unix scripting using Perl and Korn, SQL Tuning, Capacity Planning, and designing a corporate data

warehouse solution in a fast paced internet environment.

Company: IBM

Title: Implementation DBA

Dates: Sept 1997 to August 1999

Platform: Sun E10000, Sun v2.5, Oracle 7.3.4, IBM J40/J50, AIX

Oracle DBA for Oracle Applications 10.7SC/NCA implementations. Supported implementations for a Fortune

500 technology company that involved resources from six countries. Duties included the development and

enforcement of coding standards, SQL optimization of custom batch and online programs, capacity planning for

a production E10000 server, assisting with the troubleshooting of major conversion routines, building of new

database instances, cloning databases, installing patches, and developing UNIX Kornshell scripts.

Company: PriceWaterhouse

Title: Implementation DBA

Dates: Nov 1996 to July 1997

Platform: Sun E10000, Sun v2.5, Oracle 7.3.4

Lead Oracle DBA for batch and reporting teams during the implementation of PeopleSoft HRMS 6.0.

Responsible for (1) building database environments for development, unit testing, and system testing, (2)

establishing the development and production backup & recovery plan, (3) reviewing program designs, (4)

optimizing SQL statements, (5) and knowledge sharing with the client staff. Role also involved the Stress

Testing of the PeopleSoft application under heavy user connections. The metrics gathered provided a baseline

configuration for the production environment.

Company: PriceWaterhouse

Title: SAP Consultant (FICO Module)

Dates: Oct 1995 to Nov 1996

During the implementation of SAP 3.0D, I led the development of global security standards and profiles for a

leading pharmaceutical company. This task required a knowledge of the business roles and functions performed

in several countries. I also played a vital role in the configuration of the Financial and Cost Accounting modules.

As part of a process improvement initiative, I designed and constructed a data conversion tool using Microsoft

Access. This tool was used to validate the correctness of data conversion programs prior to system

implementation. It required an extensive knowledge of SQL and it’s grouping functions.

Company: General Electric

Title: System Engineer

Dates: Jan 1992 to Sept 1995

Worked on various assignments as part of the Information Management Leadership Program. These assignments

included the roles of programmer, data analyst, and Oracle DBA. The primary role was the support of 119 users

in the Environmental Health & Safety division at GE Headquarters (Fairfield, CT). This role included the

administration of an Oracle database, generating monthly EHS business reports for the Vice President, and

automation of manual tasks.

Education and Personal History

North Carolina A&T State University, BS Computer Science

Date: Dec 1991

GE Information Management Leadership Program (IMLP)

Dates: Jan 1992 to Jun 1994

Oracle Certified Professional 7.3

Date: July 2000

Oracle Certified Professional 8i

Date: June 2001

SAP FI/CO, PeopleSoft Human Resources, PeopleSoft Benefits

Oracle Database Administration, Oracle Backup & Recovery, Oracle Performance Tuning

Software Experience

Enterprise Applications:

Oracle Identity Management 10.1.4

Oracle Application Server 10G

SAP 3.0D (FI/CO)

PeopleSoft HRMS 6.0

Oracle Applications 10SC/10.7NCA/11.0.3

Development Tools:

Oracle Enterprise Manager 1.x/2.x/10g/11g,

Oracle Designer 6i/10g

Toad

SQL Developer

Oracle Features:

Recovery Manager (RMAN)

Data Guard

Real Application Clusters (RAC) on Linux

Automatic Storage Management (ASM)

Application Express

Streams

Parallelism

Materialized Views

Partitioning

Flashback (Query, Database, Total Recall)

LDAP

Oracle Database Versions:

Oracle 11.1, 11.2

10.2

9.2

8.0, 8.1

7.0, 7.1, 7.3

6.x

Languages:

Oracle PL/SQL

SQL-92,

Perl 5

Korn Shell

Sed

Awk

Operating Systems:

Sun Solaris 5.x

AIX

Windows 2000/XP/2003

SUSE 9

Red Hat 4/5

HP

Contact this candidate