Qualifications:

SUMMARY of QUALIFICATIONS

• Over 10 years of experience as an Oracle DBA on Linux, Unix and Windows platforms.
• Administered both OLTP and Data Warehousing databases to 8+ TB.
• Provided 7X24 DBA support for Oracle Financials, SAP and Peoplesoft.
• Extensive tuning experience at database level and with SQL using a variety of tools.
• 11g, 10g, and 9i Cluster and RAC experience including installation and administration.
• Created and managed 10g and 11g ASM disk groups.
• Implemented and maintained database backup and recovery plans with RMAN, 3rd Party vendor products and OS image copies.
• Architected and managed distributed systems including multi-master replication and snapshots/materialized views.
• In-depth experience with high availability solutions such as standby databases with DataGuard and Veritas clusters.
• Highly skilled with Unix shell scripting.
• Many years of experience with installations and migrations.
• Developed PL/SQL procedures and triggers.
• Designed, implemented and maintained data partitioning schemes for tables and indices.
• Experienced with cloning production databases.
• Capacity planning/database sizing skills.
• Setup and configured OEM management server with events/alarms at multiple sites including 10g Grid Control.
• Strong logical and physical modeling skills including star/snowflake schemas.
• Excellent verbal, written and interpersonal communication skills.
• Able to mentor co-workers and serve as a knowledge base for others.

TECHNICAL SKILLS
Software
DBMS: Oracle (11g,10g, 9.2, 9.0, 8.1.x, 8.0.x, 7.3.x), Teradata, DB2, SQL Server
Enterprise Solutions: Oracle Financials (AP, AR, GL, FA, INV, FA, PO, Concurrent Manager, Autopatch, AD Utilities), SAP R/3. Peoplesoft HR and Financials
CASE: ERWin, S-Designor, Oracle Database Designer, ADW/IEW, IEF, BACHMAN, Visio
DBMS Related: SQL*Loader, SQL*PLUS, Oracle Enterprise Manager (OEM) - DBA Studio, Diagnostics & Tuning,
StatsPack,AWR,ASH, B/EStat,TKPROF,IMPORT/EXPORT,TOAD, BTEQ,ITEQ, FAST/MULTILOAD, DQM, SPUFI, BMCPatrol
OLAP/Decision Support: Oracle Express, Financial Analyzer, Metaphor/DIS, AS
Application: Oracle Developer 2000, Oracle Application Server w. PL/SQL & JAVA, Interwoven Teamsite, JCL, MVS
Utilities, ISPF, REXX
Programming Languages: Korn/Bourne Shell, COBOL, FORTRAN
Security: ACF2, TDP Exits, Unix ACLs, Braintree
System: Veritas Volume & File Managers, Veritas Cluster
Backup & Recovery: Recovery Manager (RMAN), ARCserve, SQL-Backtrack, Tivoli TSM & Oracle TDP, Veritas NetBackup
PC: Microsoft Windows XP/2000/98/NT, Word, Excel, PowerPoint
Hardware
Sun Solaris (UNIX) Compaq (NT) AT&T 3500/3600 SMP & MPP (UNIX)
HP(NT, UNIX) Teradata DBC/1012 IBM/COMPAQ/DELL Desktop& Laptop
IBM Mainframes (MVS) AIX (UNIX) Dell (Linux)
Storage: Sun and EMC Symmetrix, Clariion

PROFESSIONAL EXPERIENCE
Advanced DBA Confidential,
Duluth, GA, 3/09 - Present
Installed Oracle 10g Clusterware, ASM, OCFS2 and database software for Manufacturing Execution System (MES) to protect single Oracle instance on Redhat Linux platform. Also installed Oracle 11g Clusterware/ASM for financial data mart. Installations included defining tasks for system administrator (e.g., how to layout storage, rpms, kernel parms), creating instance, testing failovers, setting up monitoring scripts and backup procedures and tuned queries. Defined archiving strategy, acquired business approval and implemented using database scheduler chains.

Created physical model for human resources data mart using Oracle Data Modeler. Included adding relationships, foreign key constraints, and indexes. Installed Oracle 11g software on Redhat Linux platform and created database, security roles and users, implemented and maintained model and tuned queries including setting up multi-column statistics. Setup security procedures including encrypting key values and exceptions auditing.

Consultant – Sr. DBA Confidential,
Alpharetta, GA, 8/08 – 1/09
Designed, developed, and managed apartment, residential and lease frontend/backend databases on the Linux platform:

• Installed Oracle Intermedia and Location Services and assisted developers in using geo features.
• Installed Oracle 11g gateway and setup/tested Oracle 10g database ODBC connectivity with MySql database.
• Monitored/improved database performance at database level such as setting optimal initialization parameters for asynchronous and direct i/o and at application level such as usage of bulk collect.
• Upgraded six 9.2.0.3 dev/test and prod databases to 10.2.0.4 with Oct. 2008 critical patch updates.
• Migrated production databases to new SAN including setup of mount options.

Consultant – Sr. DBA Confidential,
Alpharetta, GA, 8/07 – 6/08

• Installed 10.2.0.1 Grid Control for Sun Solaris databases and applied 10.2.0.3 patchset to OMS and agents. Customized host and database metrics, notification rules.
• Created 10g upgrade design document to outline manual upgrade method, standardize Oracle homes, and identify patches. Upgraded 9.2.0.6 dev/test/qa/prod databases to 10.2.0.3.
• Created DBA procedures for on-call duties, naming conventions, object migrations, Grid Control troubleshooting.
• Enhanced and tested RMAN backup procedures for recovery and performance (e.g., added channels, included archive log current, implemented 10g change tracking file for incrementals). Documented backup schedule. Setup database cloning jobs including duplication of standby database.

Consultant – Sr. DBA Confidential,
Alpharetta, GA, 5/06 – 6/07
Provide database administration support for Bellsouth Billing’s oracle databases:

• Upgraded all databases from 8i and 9i (9.0, 9.2.0.1) to 9.2.0.7 with latest criticalpatch updates. And, later upgraded all to 10.2.0.3.
• Setup monitoring scripts (e.g., recycle alert logs, page if backup errors, collect statistics, rebuild indices).
• Performed reorganizations of high availability tables using online redefinition package.
• Replaced SQLBacktrack backups with RMAN backups.
• Designed views for management dashboard.
• Configured 10g Grid Control EM. Included installing 10.2.0.1, applying 10.2.0.3 patchset, Critical Patch Update and Agents.

Consultant - Sr. DBA Confidential

, Alpharetta, GA, 10/05 – 5/06

• Installed and administered 9.2.0.6 Real Application Clusters (RAC) in multiple Linux environments for network inventory application.
• Created and managed 10.1.0.4 databases with ASM disk groups for Work Force Administration application.
• Designed and implemented materialized views to support field site reporting access for Remedy Help Desk.
• Provided production support for legacy environments,custom applications and Peoplesoft HR. Participated in on-call rotation.

Consultant - Sr. DBA Confidential,
Atlanta, GA, 5/05 – 9/05

• Participated in security audit: scanned operating system and databases for specific conditions; documented violations and prepared

action plan to remedy; activated database auditing and created daily violations report; created and enabled separate database security profiles for clients, developers and dbas; encrypted sensitive data and created a secured cross reference; defined second listener
for secured access and without cluster dependency.

• Created logical and physical models for new application using Oracle Designer. Implemented schemas (tablespaces, accounts, tables/indices, sequences, synonyms) in development, test and production environments.
• Reverse engineered two applications and created data warehouse enterprise entities and merged data into model.
• Migrated 128 SQL Server tables to Oracle using Migration Workbench. Converted T-SQL to PL/SQL.
• Monitored production databases and enhanced monitoring in scripts (e.g., backup failure detection and notification; monitoring filesystem space available).

Consultant - Sr. Architect Confidential,
Alpharetta, GA, 8/04 – 4/05

• Created logical and physical models utilizing Erwin for Teradata and Oracle platforms.
• Wrote technical specifications for five ETL developers.
• Developed workflow for both processing platforms.
• Performed capacity planning for Oracle platform and designed tablespace structures (sm/med/large), created tables/indices, set-up statistics collection job, analyzed statspack output and tuned poor performing SQL.
• Fulfilled source data analysis during project start-up and data quality assurance during implementation.

Sr. Technical Staff Member, Confidential,
Alpharetta, GA, 10/03 – 8/04
Provide 7X24 Oracle DBA production support for five web-hosting clients. In addition to daily operations support:

• Planned and implemented database upgrades from 8.1.7.4 to 9.2.0.4 and from 9.0.1.0 to 9.2.0.5. Upgrades included migrating to locally managed tablespaces and undo tablespaces. Also converted from 8.1.7.4 32 bit to 64 bit.
• Tested disaster recovery plan using standby database and DataGuard.
• Installed 10g in test environment and upgraded two 9.2.0.4 databases to 10g.
• Converted OS image backups to RMAN backups.
• Created Veritas clustering checklist for other DBAs.
• Implemented MTS to reduce memory usage on database servers.
• Redesigned materialized views using partitioning.
• Set-up BMC Patrol TAS Logs for monitoring (e.g., tablespace space usage, alert log, locking, object growth).

Sun Solaris platform.

Consultant - Sr. Oracle DBA Confidential,
GA, 1/02 – 9/03
For Peoplesoft Financials and Peoplesoft HR at Accenture Peoplesoft Delivery Center:

• Led transition of two outsourcing clients. Transitions included creating databases, setting up backup scripts (OS hot backups and full exports) and monitoring scripts (e.g., long running SQL, full table scans, redos written but not archived) and directing the efforts of junior staff.
• Prepared production readiness checklist for outsourcing database administration functions.
• Researched and applied Oracle security patches.
• Converted database to Unicode character set.

Sun Solaris platform.

• Implemented Oracle 9.2 Standby and Data Guard for disaster recovery.
• Migrated test and production databases from Oracle 8.1.6 to 9.0.1.3.
• Converted four production databases to locally managed tablespaces with uniform extents.
• Developed scripts to configure advanced replication for three master sites.
• Merged databases of two independent business units, which included producing a physical model and resolving data inconsistencies.
• Set-up Enterprise Manager events for monitoring databases and nodes.
• Installed Statspack and analyzed wait events to reduce bottlenecks.
• Tuned initialization parameters and SQL.
• Cloned instances.
• Coached junior DBAs.

Windows 2000 platform.

Oracle DBA Systems Engineer, Confidential,
GA, 12/00 – 12/01

• Implemented Oracle Recovery Manager (RMAN) for fourteen e-commerce databases (Release 8.1.6) including installing Tivoli Data Protection media management software.
• Provided database support for e-commerce applications (Websphere Commerce Suite) as well as for Interwoven Teamsite and SAP R/3.
• SAP support included rebuilding indices after corruption, backing up through SAPDBA and transaction DB13 and recovering databases, creating rollback segments for batch processing and performing upgrade to Oracle 8.1.7.

Sun Solaris platform.

• Created SQL Server 2000 databases and tuned (e.g., added secondary datafiles).

Windows 2000 Platform.

Sr. Oracle DBA, Confidential,
Atlanta, GA, 12/99 – 11/00
Led data warehouse support of an Oracle 8 distributed property tax database (200 GB):

• Split/merged large partitioned tables and indices.
• Supporting advanced replication between three master sites.
• Tuned parallel query.
• Maintained logical/physical models in ERWin.
• Controlled data definition language versions across multiple environments.
• Performed software upgrades (8.0.4 to 8.0.6 and 8.0.6 to 8.1.6).
• Created PL/SQL procedures and profiles for security.
• Setup archiving of redo logs for 7X24 availability.
• Modified backup and recovery Unix scripts.
• Implemented standby databases for disaster recovery.
• Mentored junior staff.

Sun Solaris platform

Consultant with Maxim Group at Wachovia, Inacom/Vanstar and BellSouth, Atlanta, GA, 5/98 – 11/99
Set-up development, quality assurance and production Oracle environments for a PeopleSoft application (HRMS) in the Telecommunications industry:

• Installed Oracle 8 and Braintree security software.
• Created and refreshed instances.
• Developed Unix backup/recovery scripts.

HP platform
Provided sole support for Oracle Financials database (35 GB):

• Identified and eliminated performance bottlenecks (e.g., increasing stripe width for RAID 5 temporary tablespace, adding rollback segments and indices, rebuilding indices, eliminating chained rows).
• Managed database space (e.g., increasing extents, adding datafiles, resizing rollback segments).
• Maintained standby database.
• Backed up and recovered (e.g., 7.3.3 bug damaged redo logs which required performing a point-in-time recovery; documenting ARCserve and SQL-Backtrack procedures).
• Refreshed test and conversion databases from production.
• Applied numerous patches, including Y2K, to Oracle Financials (10.7 SC) and Developer 2000.
• Upgraded Oracle 7.3.3 to 7.3.4.4.
• Attended 11i installation class.
• Developed preliminary 11i upgrade project plan with non-technical managers and technical staff.
• Installed 11i Application on test servers.
• Installed and configured Oracle Express Server (OES 6.1.0.1.2) and Oracle Financial Analyzer (OFA 6.0.1.1) on a new production server and migrated existing Express databases.
• Upgraded OES and OFA to 6.2. Major upgrade tasks included: exporting existing databases; installing and configuring Express; applying OES patch; migrating existing databases; tightening security by defining new group and permissions and utilizing Access Control Lists; incorporating custom code database; installing and configuring OFA; applying OFA patches on client/server.
• As part of Operating System upgrade from 5.5 to 5.6 and hardware upgrade (8 to 16 CPUs, 2 to 9 GB of RAM and 1 TB of disk storage): upgraded ARCserve Open from release 2.2.b to 2.2.c, upgraded SQL-Backtrack for Oracle from release 2.0.5 to 3.1, performed level 0 backups/recoveries and coordinated client communications. Upgrade tasks for SQL-Backtrack included: creating catalog; setting up profiles for cold and hot backups and export; defining storage pools; converting existing scripts.

Sun Solaris platform

• Installed Oracle Application Server (4.0.6.4) and Oracle 8.0.5.
• Created sample applications in PL/SQL and JAVA to demonstrate potential of platform.

Windows NT platform

• Stabilized Asset Insight: stopped crash of database in rename job; modified shutdown process to prevent session waits; ensured "good" backup by copying after shutdown complete; recovered disk space and recommended disk upgrade; added datafiles; expanded size of redo logs to prevent too frequent log switches.

Windows NT platform

• Installed Oracle 7.3.4 on two servers.
• Created four Oracle instances.
• Implemented vendor package to process credit card applications.
• Established naming standards.
• Configured Oracle Enterprise Manager to perform cold backups, exports, analyze statistics, pin objects.
• Created and maintained physical models with ERWin 3.5.2.

AIX platform

Manager Database Administration, Confidential,
GA, 3/97 – 4/98

• Set direction in database management including product standards, processes, principles and metrics.
• Planned, coordinated and implemented Oracle software upgrade to Release 7.3.3 on four servers.
• Installed Release 8.0.2 in development/user acceptance test environments.
• Configured Oracle Enterprise Manager.
• Symmetric Replication: synchronized data between two master sites; enhanced conflict resolution routines; modified database structures; added objects; conducted benchmark comparison between Releases 7 and 8.
• Implemented Optimal Flexible Architecture standards.
• Backup/recovery: set ARCHIVELOG mode for two production databases; modified backup and recovery procedures; trained operations staff.
• Reverse engineered and maintained physical models with Oracle Database Designer tool.

Window NT platform

Database Administrator IV, Confidential,
GA, 11/93 – 2/97
Performed database administration functions for an Oracle/Unix data warehouse that measured fountain operations:

• Created and tuned Oracle instances for production and test environments.
• Developed optimal physical database design.
• Created, modified and migrated data structures.
• Tuned application level SQL (e.g., parallel execution for scans, best optimizer for task).
• Setup paralleling load procedures.
• Managing space utilization.
• Implemented backup procedures and security measures.

AT&T Unix platform
Performed system administration functions on the Teradata DBC/1012 and V2R1 (UNIX) data warehouse platforms:

• Defined and implemented tasks for the downsizing of a test configuration.
• Migrated to a new production configuration (102 AMPs).
• Developed reports/charts to evaluate performance.
• Problem determination and resolution.
• Produced/maintained maps of machine configuration and object hierarchy.
• Projected space requirements.
• Archive/recovery.
• Tracked security events.

DBC/1012 and AT&T Unix platforms
Designed, implemented, maintained and tuned Teradata data structures for a sales volume data warehouse (1+ TB):

• Tuning efforts included query and index improvements as well as summary and pre-join structures.
• Set-up production loads using database utilities.
• Provided assistance to developers on technical aspects of the DBMS.
• Installed and customized the Deferred Query Manager product. Implemented advanced product features such as class assignments, workload balancing and concurrency controls.
• Performed DB2 database structure changes and data migration using BMC software. IBM MVS Platform
• Produced a physical model for a product/package subject area using IEF. Performed all pre/post transformation tasks. Managed the effort for the remaining subject areas. Evaluated and selected a strategic presentations graphic tool.

Sr. Technical Consultant Confidential,
IL , 10/92 – 10/93

• Performed capacity planning, which resulted in the doubling of the Teradata DBC/1012 machine size.
• Led software/hardware upgrade projects. Tasks included developing plans, test scripts and coordinating vendor activities. Received bonus for successful project completions.
• Daily tasks included monitoring and administering databases, managing the data dictionary (Metaphor/DIS) and determining indexing strategies for new applications.

DBC/1012 platform

Consultant with Cutler- Confidential,
TX and Northbrook, IL, 3/90 – 9/92

• Developed a normalized data model for a decision support application (200 entities).
• Gathered data requirements through interviews with business executives.
• Forwarded the model into a physical, relational design by applying denormalization and indexing techniques (73 tables) as well as by defining summary tables.

DBC/1012 platform.

• Captured an existing customer order relational design using BACHMAN tool.
• Added referential integrity constraints and new attributes for physical model.
• Enhanced the performance of the new design.

MVS DB2 platform.
Led a Business Area Analysis in the personnel data area:

• Created logical data model.
• Created function analysis (process model).
• Performed interaction analysis (process action diagrams).
• Developed a data model (over 500 entities/subtypes covering engineering, drilling and well operation subject areas for an inventory project to access environmental impacts.
• Conducted group sessions to gather data requirements.

Activities performed with Information Engineering Facility (IEF).

Data Administrator, Pacific Confidential,
TX, 5/88 – 2/90

• Created subject data models for an integrated oil and gas system as part of a reverse engineering effort.
• Enhanced the models through normalization of entities and validation with end users.
• Developed association matrices between all system files and programs with properties.
• Activities performed with IEW.
• Prepared a DB2 Migration plan for six existing applications.

EDUCATION

M.L.S. in Information Science
GPA: 4.00 (4.00 equals A)

Purdue University, W. Lafayette, IN
B.A. in Education, Highest Distinction
GPA: 5.97 (6.00 equals A)

Professional Affiliations: IOUG

Accomplishments:

• In my four years of military service, I won several meritorious masts
• Lead a squad of Marines in an Expeditionary Unit (MEU-22) during a six month tour
• Received recognition for weapons safety training

Professional Work Experience:

Confidential,
March 2008 to present

Crew Foreman – June 2008 - present

• Responsible for daily work duties to meet production goals
• Demonstrates a strong work ethic and oversees the safety of the crew
• Training new hires in daily requirements, company policies and proficiencies

Groundman – March 2008 - June 2008

• Daily responsibilities include setting up the truck for the Crew Foreman
• Strategically placing Temporary Traffic Control Devices to provide a safe working environment

Confidential,
– October 1996 to January 2008

Loss Prevention Specialist – April 2005 – January 2008

• Monitored consumer traffic through the use of electronic surveillance device
• Patrolled property with company vehicle
• Responsible for implementing security plan

Warehouse Manager – January 1999 to April 2005

• Responsible for staff scheduling
• Increased safety awareness in warehouse
• Trained new hires on equipment (box cutters, forklifts, etc.)

Inventory Control Associate –October 1996 to December 1998

• Unloaded and loaded product from delivery trucks
• Stocked product on sales floor
• Other duties as assigned

Military Experience:

Confidential,
December 1991 to December 1995

Non Commissioned Officer – Corporal

• Accountable for the daily training of twelve Marines
• Liable for the safety and development of each individual in my platoon

Education:

BS in Psychology: Concentration in Forensic Psychology, Southern New Hampshire University. Continuing Education Program, Enrolled part time

1991 Manchester Memorial High School