NOLAN JONES

abjuwe@r.postjobfree.com

PH. 770-***-****

OBJECTIVE

TO APPLY 16+ YEARS OF DATABASE ADMINISTRATOR (DBA)/ DATA ARCHITECT, AND BUSINESS

INTELLIGENCE (BI) EXPERIENCE, IN AN EQUIVALENT POSITION.

TECHNICAL SUMMARY:

DATABASES: ORACLE 12C,11G/10G/9I/8I (16 YRS), ORACLE EXADATA, ORACLE GOLDEN GATE

(2YRS),MSSQL SERVER 2008/2005/2000(6 YRS), DB2, MYSQL, POSTGRESQL

HARDWARE: ORACLE SUPER CLUSTER T5-8 / EXADATA DATABASE MACHINES, HP 9000-800 (2 YRS) SUN

E10000 (3 YRS), SUN 4500(2 YRS), IBM RISC 6000

LANGUAGES: C (4 YRS), C++ (2 YRS), VB.NET, PERL (4 YRS), PERL DBI, OBOL, PASCAL,

REXX, PL/1,

FORTRAN, PL/AS, ASSEMBLER, RXSQL

OP. SYSTEMS: UNIX (16 YRS), SOLARIS (4 YRS), WINDOWS, LINUX (8 YRS), TRUE 64 UNIX (2 YRS),

AIX (5 YRS), HP/UNIX (3 YRS), MVS (3 YRS), VMWARE (3 YRS)

OTHER: ER/STUDIO, VERITAS CLUSTER, UML, ERWIN (5 YRS), VISIO, MS PROJECT .NET,

ASP, ADO, WEBLOGIC, KORN- SHELL (10 YRS), IBM WEBSPHERE, SAP (2 YRS),

PEOPLE SOFT, LDAP

PROFESSIONAL EXPERIENCE:

DELL CORP. DEC 2013 – CURRENT

LEAD ORACLE DBA CONSULTANT

● PERFORM MONITORING, ADMINISTRATION AND PERFORMANCE TUNING OF ORACLE MULTI TB DATABASES.

● PROVIDE ORACLE RAC 11G R2 DATABASE INSTALLATIONS, SCHEMA AND OBJECT CREATION, MIGRATION, UPGRADE

AND PERFORMANCE TUNING.

● ORACLE RAC DATABASES ARE DEPLOYED ON ORACLE SUPER CLUSTER T5-8 / EXADATA DATABASE MACHINES.

● INSTALLED, CONFIGURED AND MONITORED DATABASES THAT ARE REPLICATED USING ORACLE 12C GOLDEN GATE

AND ORACLE DATA GUARD ARE USED TO BUILD OUT APPLICATION MIGRATION AND HIGH AVAILABILITY

ARCHITECTURE.

● INSTALLED AND USE ORACLE 12C OEM FOR ADMINISTRATION AND MONITORING 24/7 DATABASE OPERATION.

● USING ORACLE 11G R2 VERSION WITH THE FOLLOWING COMPONENTS: ASM, DATA GUARD, RMAN

● ANALYZED SQL QUERIES

● PERFORMED DATABASE PLATFORM MIGRATION

● COORDINATE ALL DATABASE CHANGES FOR DATABASE TEAM

● INSTALLED AND CONFIGURED ORACLE REAL USER EXPERIENCE INSIGHT (RUEI) SERVER

● PERFORM ORACLE 11G R2 DATABASE ADMINISTRATION FOR JD EDWARDS ENTERPRISE ONE.

● ORACLE 11G R2 DATABASES RUNNING ON AIX, LINUX (RHEL) AND VM ENVIRONMENTS.

● DATA MODELING CONDUCTED WITH ER/STUDIO

FISERV – FINANCIALS MAR 2013 – OCT 2013

LEAD ORACLE 11G DBA CONSULTANT / MS SQL SERVER 2008

● PERFORMED MONITORING, ADMINISTRATION AND PERFORMANCE TUNING OF ORACLE MULTI TB DATABASES.

● INSTALLED, CONFIGURED, AND PATCHED ORACLE RAC 11G R2 IN LINUX ON SYSTEM Z

● USED ORACLE 12C OEM FOR ADMINISTRATION, MONITORING, AND P&T.

● INSTALLED, CONFIGURED, PATCHED AND ADMINISTERED ORACLE 11 R2 GRID/ASM AND DATA GUARD

● PERFORMED ASM DISK (SAN) MIGRATIONS

● USED RMAN FOR DATABASE BACKUP AND RESTORE

● PROVIDED MS SQL SERVER DATABASE ADMINISTRATION FOR MIGRATING 200 DATABASES TO A VM

ENVIRONMENT.

● COORDINATED ENTERPRISE BUSINESS UNITS IN ORDER TO ESTABLISH AN APPLICATION IMPACT ASSESSMENT FOR

MIGRATING DATABASES TO VM ENVIRONMENT.

● DOCUMENTED MS SQL SERVER UPGRADE AND MIGRATION EFFORTS TO VM ENVIRONMENT

● PROVIDED ORACLE CONSULTATION FOR SAP ENVIRONMENT.

XEROX – HEALTH CARE SYSTEMS MAY 2012 – OCT 2012

ORACLE 11G / ORACLE 10G DBA CONSULTANT

● DEVELOPED PL/SQL STORED PROCEDURES AND PACKAGES TO TRACK MEDICAL REIMBURSEMENT PAYMENTS.

● PROVIDE ORACLE RAC DATABASE INSTALLATIONS, SCHEMA AND OBJECT CREATION, MIGRATION, UPGRADE AND

PERFORMANCE TUNING FOR ORACLE 11G AND ORACLE 10G WITHIN PEOPLE SOFT, AND COGNOS DEVELOPMENT,

QA, AND PRODUCTION ENVIRONMENTS FOR MULTIPLE STATE GOVERNMENT HEALTH CARE MEDICAID AND

MEDICARE SYSTEMS.

● PROVIDED GLOBAL DATABASE SUPPORT IN A 24/7 DATA CENTER.

● INSTALL AND ADMINISTRATION OF 11G R2 RAC ON AIX ENTERPRISE SERVER 3 NODE CLUSTER.

● IMPLEMENT ORACLE DATA GUARD.

● RMAN USED FOR DATABASE BACKUPS AND DATA PUMP FOR DATABASE MIGRATION.

● GOLDEN GATE ONE-DIRECTIONAL REPLICATION FROM OLTP DATABASE TO WAREHOUSE DATABASE.

● ORACLE ASM ON AIX ENTERPRISE SERVER

● DBA SUPPORT FOR A DEVELOPMENT TEAM CUSTOMIZING AND TESTING NEW RELEASES.

● MONITOR DATABASE EVENTS AND PROACTIVELY OPTIMIZE SYSTEM PERFORMANCE

● TROUBLESHOT DATABASES FOR PERFORMANCE ISSUES.

● MIGRATION OF DATABASE STRUCTURES TO PRODUCTION DATABASE.

● WORKED ON USERS PROFILE MANAGEMENT.

● WORKED ON TUNING OF PL/SQL AND SQL.

● WORKED ON CREATING TRIGGERS, INDEXES, STORED PROCEDURES AND PACKAGES.

● DATABASE MIGRATION OF MS SQL SERVER 2005/2008 SERVERS TO A VM ENVIRONMENT WITHIN

DEVELOPMENT, TEST, AND PRODUCTION ENVIRONMENTS FOR A MULTI-BILLION DOLLAR INTERNATIONAL FINANCIAL

COMPANY.

● DEVELOPED MIGRATION SPECIFICATION DOCUMENTATION FOR DATABASE MIGRATION EFFORT.

● INTERFACED WITH BUSINESS UNITS TO ASSESS IMPACT OF MIGRATION OF DATABASE OBJECTS.

ENVIRONMENT ORACLE 11G/10G DATABASE, GOLDEN GATE, ORACLE RMAN, OEM GRID, ORACLE RAC,

ORACLE ASM, FLASHBACK RECOVERY, ORACLE OEM 12C

ACCENTURE – ATLANTA DEC 2011 – MAY 2012

ORACLE 11G / ORACLE 10G DBA CONSULTANT

● DEVELOPED PL/SQL STORED PROCEDURES AND PACKAGES FOR MEDICAL BILLING REPORTING

● RESPONSIBILITIES INCLUDE DATABASE INSTALLATION, SCHEMA AND OBJECT CREATION, MIGRATION, UPGRADE AND

PERFORMANCE TUNING FOR ORACLE 11G AND ORACLE 10G WITHIN A PEOPLE SOFT ENVIRONMENT, QA, AND

PROD ENVIRONMENTS FOR A STATE GOVERNMENT MEDICAID AND MEDICARE SYSTEMS.

● PROVIDED OPERATIONAL DATABASE SUPPORT IN A 24/7 DATA CENTER.

● ADMINISTRATION OF AN 8 NODE 11G R2 RAC ON HP UNIX ENTERPRISE SERVERS.

● USED ORACLE ASM ON HP UNIX ENTERPRISE SERVER.

● IMPLEMENT ORACLE DATA GUARD.

● WORKED ON ORACLE UPGRADES FROM 10G TO 11G.

● RMAN USED FOR DATABASE BACKUPS AND DATA PUMP.

● ORACLE TABLE SPACE MANAGEMENT.

● REFRESH DATABASE FROM PRODUCTION TO QA AND DEVELOPMENT.

● MANAGING AND ADMINISTERING SEVERAL DATABASE THROUGH OEM

● DBA SUPPORT FOR A DEVELOPMENT TEAM CUSTOMIZING AND TESTING NEW RELEASES.

● MONITOR DATABASE EVENTS AND PROACTIVELY OPTIMIZE SYSTEM PERFORMANCE

● STAR TEAM TOOL FOR VERSION CONTROLS.

● TROUBLESHOT DATABASES FOR PERFORMANCE ISSUES.

● MIGRATION OF DATABASE STRUCTURES TO PRODUCTION DATABASE.

● MANAGED ORACLE NET CONFIGURATION, MONITORED ALERT LOG, LISTENER LOG, REDO LOG STATUS, UNDO

TABLE SPACE AND TRACE FILES.

● GOLDEN GATE ONE-DIRECTIONAL REPLICATION FROM OLTP DATABASE TO DR SITE DATABASE.

● WORKED ON TUNING ON PL/SQL AND SQL.

● ORACLE XML-DB

ENVIRONMENT ORACLE 11G/10G DATABASE, GOLDEN GATE, ORACLE RMAN, OEM GRID, ORACLE RAC,

ORACLE ASM, ORACLE DATA GUARD, FLASHBACK RECOVERY

HOSPIRA OCT 2010 – MAY 2011

ORACLE 11G / MS SQL SERVER 2008 (DBA / DATA ARCHITECT) CONSULTANT

● RESPONSIBILITIES INCLUDE DATABASE INSTALLATION, SCHEMA AND OBJECT CREATION, MIGRATION, UPGRADE AND

PERFORMANCE TUNING FOR ORACLE 11G AND MS SQL SERVER 2008 WITHIN DEVELOPMENT, TEST, AND

PRODUCTION ENVIRONMENTS FOR A MULTI-BILLION DOLLAR INTERNATIONAL HEALTH CARE COMPANY.

● GOLDEN GATE ONE-DIRECTIONAL REPLICATION OF OLTP DATABASE TO QUERY/REPORTING DATABASE.

● PROVIDED DATABASE SUPPORT IN A 24/7 GLOBAL WORK ENVIRONMENT.

● WORKING ON ORACLE UPGRADES FROM 10G TO 11G.

● ADMINISTRATION OF 11G R2 RAC ON LINUX ENTERPRISE SERVER TWO NODE CLUSTER.

● ORACLE ASM ON LINUX ENTERPRISE SERVER.

● IMPORT/EXPORT AND DATA PUMP FOR DATABASE BACKUP.

● RMAN USED FOR DATABASE BACKUPS AND DATA PUMP.

● IMPLEMENTATION OF ORACLE CONTEXT TECHNOLOGY.

● ORACLE XML-DB

● REFRESH QA AND DEVELOPMENT DATABASES FROM PRODUCTION.

● MANAGING AND ADMINISTERING SEVERAL DATABASE THROUGH OEM

● DBA SUPPORT FOR A DEVELOPMENT TEAM CUSTOMIZING AND TESTING NEW RELEASES.

● MONITOR DATABASE EVENTS AND PROACTIVELY OPTIMIZE SYSTEM PERFORMANCE

● TROUBLESHOT DATABASES FOR PERFORMANCE ISSUES.

● MIGRATION OF DATABASE STRUCTURES TO PRODUCTION DATABASE.

● MANAGED ORACLE NET CONFIGURATION, MONITORED ALERT LOG, LISTENER LOG, REDO LOG STATUS, UNDO

TABLE SPACE AND TRACE FILES.

● WORKED ON USERS PROFILE MANAGEMENT.

● WORKED ON TUNING ON PL/SQL AND SQL.

● WORKED ON CREATING TRIGGERS, INDEXES, STORED PROCEDURES AND PACKAGES

ENVIRONMENT ORACLE 11G/10G DATABASE, GOLDEN GATE, ORACLE RMAN, OEM GRID, ORACLE RAC,

ORACLE ASM, ORACLE DATA GUARD, FLASHBACK RECOVERY

AT&T, COLUMBIA, MD APR 2009 – APR 2010

ORACLE 11G LEAD DATABASE ADMINISTRATOR/SOFTWARE DESIGN ENGINEER

● RESPONSIBILITIES INCLUDED INSTALLATION AND ADMINISTRATION ORACLE 11G AND POSTGRESQL DATABASES FOR

GEOSPATIAL INFORMATION SYSTEMS (GIS).

● DESIGN AND IMPLEMENTED GEOSPATIAL/TELECOMM DATABASES FOR PRODUCTION, TEST AND DEVELOPMENT

SYSTEMS.

● IMPLEMENTATION OF ORACLE OBIEE TECHNOLOGY.

● DEVELOPED PL/SQL STORED PROCEDURES AND PACKAGES FOR CELLULAR INFORMATION SERVICES

● GOLDEN GATE ONE-DIRECTIONAL REPLICATION FROM SYBASE ASE TO ORACLE 11G DATABASE MIGRATION.

ENVIRONMENT ORACLE 11G/10G DATABASE, GOLDEN GATE, ORACLE RMAN, OEM GRID, ORACLE RAC,

ORACLE ASM, ORACLE DATA GUARD, ORACLE SPATIAL, ORACLE PARTITION, OIM (ORACLE

IDENTITY MANAGER), ORACLE DATABASE VAULT, OID, APPLICATION EXPRESS 3.0 (APEX)

POSTGRESQL 8.4 COMPONENTS USED: POSTGIS; GIS TOOLS USED: ESRI ARCGIS, ARCSDE,

ARCCATALOG, ARCMAP, QUANTUM GIS (QGIS), VMWARE, LEAD DBA FOR MS SQL SERVER

2005, 2008 FOR INVENTORY APPLICATION.

SEATTLE POLICE DEPARTMENT, SEATTLE, WA JUN 2008 – DEC 2008

ORACLE DATABASE ADMINISTRATOR CONSULTANT

● PROVIDED PRODUCTION SUPPORT, ARCHITECTURAL AND CONFIGURATION FOR ORACLE 10G RAC USING ORACLE

CLUSTER FILE SYSTEM (OCFS2), ACTIVE-ACTIVE CLUSTER ENVIRONMENT, MANAGEMENT AGENTS AND

MANAGEMENT SERVICES. RMAN AND TIVOLI BACKUP SOLUTION WAS IMPLEMENTED. DATA GUARD STANDBY

DATABASES WERE CREATED.

● ORACLE COMPONENTS IMPLEMENTED/UTILIZED:

RAC, RMAN, DATA GUARD, DATA GUARD BROKER, OEM GRID, FLASHBACK RECOVERY, APPLICATION

EXPRESS (APEX), ORACLE XML-DB

GOVERNMENT AGENCY, DATABASE RESEARCH, ATLANTA, GA JAN 2008 - MAY 2008

ORACLE 11G, DB2, MYSQL 5, DB4O, MS SQL SERVER 2005, POSTGRESQL 8

● RESPONSIBILITIES INCLUDED EXTENSIVE RESEARCH WITH RESPECT TO PRODUCT FEATURES AND APPLICATION USAGE

OF PROPRIETARY AND OPEN-SOURCE DATABASES. PERFORM DATABASE ADMINISTRATION FOR PRODUCTION AND

DEVELOPMENT ENVIRONMENTS FOR 24/7 OPERATIONS.

● PROVIDE ORACLE 10G RAC DATABASE INSTALLATION, UPGRADE, PERFORMANCE TUNING AND BACKUP FOR

PRODUCTION TEST AND DEVELOPMENT ENVIRONMENTS USING RMAN.

● ORACLE COMPONENTS IMPLEMENTED AND UTILIZED: RAC,RMAN, ASM, ORACLE XML-DB

WACHOVIA CIB, CHARLOTTE, NC JUN 2007 - DEC 2007

ORACLE DATABASE ADMINISTRATOR CONSULTANT

● PROVIDE ORACLE 10G DATABASE ADMINISTRATION FOR PRODUCTION, TEST AND DEVELOPMENT ENVIRONMENTS.

● RESPONSIBILITIES INCLUDE DATABASE INSTALLATION, OBJECT CREATION, MIGRATION, UPGRADE AND PERFORMANCE

TUNING; SUPPORTING MULTIPLE DATABASES FOR FINANCIAL SERVICES, IN A 24/7 BUSINESS CRITICAL

ENVIRONMENT.

● WORKED WITH SOFTWARE DEVELOPMENT TEAM TO CREATE DATABASE SOLUTIONS TO ACHIEVE BUSINESS OBJECTIVES,

USING RMAN FOR BACKUP, SQL LOADER, EXPLAIN PLANS, EXPORT/IMPORT, AND PHYSICAL DATABASE CREATION.

● IMPLEMENTED A 3 NODE ORACLE 10G RAC LINUX SYSTEM USED FOR LOGGING ALL TRANSACTIONS CONDUCTED

BY FINANCIAL APPLICATIONS. ORACLE COMPONENTS IMPLEMENTED AND UTILIZED: RAC, OCFS2, RMAN, AND

OID.

● PROVIDE MS SQL SERVER 2005 DATABASE ADMINISTRATION FOR DEVELOPMENT AND TEST ENVIRONMENTS FOR

FINANCIAL APPLICATION.

T-MOBILE, ATLANTA, GA JAN 2007 - MAY 2007

ORACLE DATABASE ADMINISTRATOR

● PROVIDE ORACLE 10G DATABASE ADMINISTRATION FOR PRODUCTION, TEST AND DEVELOPMENT ENVIRONMENTS.

RESPONSIBILITIES INCLUDE DATABASE INSTALLATION, OBJECT CREATION, MIGRATION, UPGRADE AND PERFORMANCE

TUNING; SUPPORTING MULTIPLE DATABASES FOR TELECOM SERVICES.

● ON CALL SUPPORT OF BUSINESS CRITICAL DATABASES IN A 24/7 ENVIRONMENT WAS A PART OF MY DUTIES.

● ORACLE COMPONENTS IMPLEMENTED AND UTILIZED: RMAN, OID, GRID

REAL NETWORKS / SAIC, SEATTLE, WA OCT 2005 - JAN 2007

DATA MODELER / ORACLE DATABASE ADMINISTRATOR

● PROVIDE ORACLE 10G / 9I / 8I DATABASE ADMINISTRATION FOR PRODUCTION, TEST AND DEVELOPMENT

ENVIRONMENTS; RESPONSIBILITIES INCLUDE DATABASE INSTALLATION, OBJECT CREATION, MIGRATION USING

EXPORT/IMPORT, UPGRADE AND PERFORMANCE TUNING; SUPPORTING MULTIPLE DATABASES FOR A 24/7 AUDIO/VIDEO

DIGITAL STREAMING APPLICATION SERVICE PROVIDER.

● ORACLE COMPONENTS IMPLEMENTED AND UTILIZED: RAC, RMAN, FLASHBACK RECOVERY, DATA GUARD, OID,

OEM GRID, ORACLE XML-DB

● THE DATABASE ENVIRONMENT ALSO SUPPORTS FINANCIAL APPLICATIONS THAT ARE SOX COMPLIANT.

● PROVIDE DATABASE ADMINISTRATION FOR POSTGRESQL AND MYSQL; RESPONSIBILITIES INCLUDE DATABASE

INSTALLATION, CREATION OF DATABASE OBJECTS AND PERFORMANCE TUNING.

● UTILIZING THE FOLLOWING MODELING TOOLS (ERWIN, RATIONAL ROSE, UML DIAGRAMS AND VISIO).

DELTA AIR LINES, ATLANTA, GA JAN 2005 - JUL 2005

ORACLE DATABASE ADMINISTRATOR CONSULTANT

● PROVIDE ORACLE 10G / 9I / 8.X DATABASE ADMINISTRATION FOR DEVELOPMENT AND PRODUCTION ENVIRONMENTS.

● RESPONSIBILITIES INCLUDE DATABASE INSTALLATION, CREATION, MIGRATION, UPGRADE, PERFORMANCE TUNING

(STATSPACK, SQL TRACE, TKPROF), RMAN BACKUP AND RECOVERY, DATA GUARD, OEM AND OID;

SUPPORTING MULTIPLE DATABASES FOR AIR FARES AND FARE PRICING APPLICATIONS, WEB BASED TICKET SYSTEM

AND DATA WAREHOUSE SYSTEM. SUPPORTED MULTI-TERABYTE DATABASES FOR AIRLINE APPLICATIONS. USED

MICROSOFT PROJECT, DBARTISAN AND ERWIN MODELING TOOL.

AT&T, CHARLOTTE, NC OCT 2003- DEC 2004

ORACLE / SQLSERVER 2000 DATABASE ADMINISTRATOR CONSULTANT

● PROVIDE ORACLE 9I / 8.X AND SQLSERVER 2000 DATABASE ADMINISTRATION FOR DEVELOPMENT AND

PRODUCTION WINDOWS / UNIX ENVIRONMENTS. ORACLE RESPONSIBILITIES INCLUDED PRODUCT INSTALLATION,

PATCH INSTALLS, DATABASE UPGRADE, DATABASE MIGRATION, DATABASE CREATION, PERFORMANCE TUNING, RAC,

RMAN BACKUP, OEM AND OID.

● SQL SERVER RESPONSIBILITIES INCLUDED PRODUCT INSTALLATION, DATABASE CREATION, PT (SQL PROFILER,

SQL QUERY ANALYZER, AND DBCC).DTS USED FOR ETL ACTIVITY IN A SQL SERVER DATABASE.

SUPPORTED MULTIPLE ORACLE AND SQL SERVER CLUSTER DATABASES FOR BILL PAYMENT AND PRINTING

APPLICATION, WEB BASED CUSTOMER INFORMATION SYSTEM, C# .NET CLIENT SERVER APPLICATION AND DATA

WAREHOUSE SYSTEMS.

BELLSOUTH, ATLANTA, GA JAN 2001- JUN 2003

ORACLE 9I DATABASE ADMINISTRATOR

● PROVIDE ORACLE DATABASE ADMINISTRATION FOR WEB BASE APPLICATIONS ON A UNIX PLATFORM. DATABASE

TASKS PERFORMED ON ORACLE 9I / 8.X

● RESPONSIBILITIES / ACHIEVEMENTS: DATABASE REPLICATION, DATABASE INSTALLATION, DATABASE CREATION,

BACKUP / RECOVERY, OBJECT CREATION (TABLES, TRIGGERS, PL/SQL STORED PROCEDURES AND PACKAGES),

DATABASE MIGRATION, DATABASE UPGRADES, DATA MODELING AND PERFORMANCE TUNING. SUPPORTED MULTIPLE

DATABASES RUNNING ON SUN E10K SERVERS IN A HIGH AVAILABILITY (HA) SUN CLUSTER 24/7 ENVIRONMENT.

● IMPLEMENTED BACKUP K-SHELL SCRIPTS IN CONJUNCTION WITH SQL-BACK TRACK. CREATED DATA WAREHOUSING

AND DATA MART DATABASES. THE DATABASE INSTANCES ARE MULTI-MILLION DOLLAR SYSTEMS; RANGING FROM

(BILLING/PAYMENT TO MARKETING WITH A DIRECT CUSTOMER BASE OF TWO MILLION. ALL DATABASES UPGRADES AND

CHANGES WHERE IMPLEMENTED WITH 100 PERCENT SUCCESS RATE.

ARTHRITIS FOUNDATION, ATLANTA, GA AUG 2000- DEC 2000

ORACLE 8I DATABASE ADMINISTRATOR CONSULTANT

● PROVIDED DATABASE ADMINISTRATION USING ORACLE 8 PARALLEL SERVER FOR A CRM APPLICATION ON A

WINDOWS PLATFORM. CONFIGURED DATABASE BACKUP AND RECOVERY USING LEGATO AND RMAN. IDENTIFIED

AND CORRECTED DATABASE PERFORMANCE PROBLEMS.

VIVARA INC., ATLANTA, GA MAY 2000- NOV 2000

ORACLE 8I / SQL SERVER DATABASE ADMINISTRATOR/ARCHITECT CONSULTANT

● PROVIDED DATABASE ADMINISTRATION/ARCHITECT USING ORACLE 8I ON A SOLARIS UNIX PLATFORM OF A HEALTH

CARE INSURANCE PROVISIONING APPLICATION. RESPONSIBILITIES INCLUDED DATABASE INSTALL, DATABASE CREATION

IN A CLUSTER ARCHITECTURE, BACKUP AND RECOVERY, PERFORMANCE TUNING, OBJECT CREATION AND DATA

MODELING USING ERWIN.

● PORTED HEALTH CARE DATABASE FROM SQL SERVER TO ORACLE 8I; USED WITH A WEB BASE APPLICATION USING

BEA WEBLOGIC APPLICATION SERVER.

H.O. SYSTEMS, SAVANNAH, GA JAN 1999- MAY 2000

MANAGER OF DATABASE SERVICES / ORACLE 8I DATABASE ADMINISTRATOR, SQL SERVER

● PERFORMED PROJECT MANAGEMENT AND DATABASE ADMINISTRATION/ARCHITECT USING ORACLE 8I AND ORACLE

PARALLEL SERVER (RAC) VERSION 8.1.6 ON A TWO NODE ALPHA SERVER CLUSTER USING COMPAQ TRUE64

UNIX IN A 24X7 PRODUCTION SYSTEM.

● INTERNET BASED WIRELESS BILLING SYSTEM, WITH A SUBSCRIBER BASE OF 2.5 MILLION.

● FUNCTIONAL TASKS: INSTALL, DATABASE CREATION, PERFORMANCE TUNING, RMAN BACKUP AND RECOVERY,

STANDBY DATABASE, OBJECT CREATION AND DATA MODELING WITH ERWIN.

● OTHER TASKS PERFORMED:

● MANAGER OF DATABASE SERVICES DEPARTMENT, DATABASE ARCHITECT, PROJECT MANAGER,

● EVALUATE, SELECT AND NEGOTIATE PRICING OF DATABASE PRODUCTS:

● ORACLE 8I, ORACLE PARALLEL SERVER (OPS), ORACLE RMAN

● SYBASE, SQL SERVER, DBARTISAN, ERWIN.

● INSTALLED AND ADMINISTER SQL SERVER, IIS 4 WEB SERVER.

● USED ASP, ADO, JAVA, JSP, EJB, JDBC, PERL5, KORN, IBM WEBSPHERE, AND UNIX SYSTEM

ADMINISTRATION.

HIGH MARK, MECHANICSBURG, PA OCT 1997- DEC 1998

ORACLE / DB2 DATABASE ADMINISTRATOR CONSULTANT

● PROVIDE DATABASE ADMINISTRATION USING DB2, ORACLE 8 AND 7.3 ON BOTH SOLARIS UNIX AND WINDOWS

NT 4.0 IN A PEOPLESOFT DATA WAREHOUSE ENVIRONMENT FOR A MAJOR INSURANCE COMPANY.

● FUNCTIONAL TASKS: DATABASE CREATION, PERFORMANCE TUNING, BACKUP AND RECOVERY IN A DATA WAREHOUSE

ENVIRONMENT. PERFORMED OBJECT CREATION (TABLES, TRIGGERS, STORED PROCEDURES) AND DATA MODELING.

BELLSOUTH CELLULAR CORPORATION, ATLANTA, GA JUL 1996- MAY 1997

SYBASE DBA & REPLICATION SERVER ADMINISTRATOR CONSULTANT

● PROVIDE DATABASE ADMINISTRATION AND REPLICATION ADMINISTRATION FOR A CELLULAR RATE PLAN SYSTEM USING

SYBASE SYSTEM 11 AND SYBASE REPLICATION SERVER ON A WINDOWS-NT PLATFORM. THE DATABASE AND

REPLICATION SERVERS ARE DISTRIBUTED ACROSS 20 DIFFERENT GEOGRAPHICAL LOCATIONS THROUGHOUT THE

SOUTHEASTERN UNITED STATES.

PERFORM DATABASE ADMINISTRATION TASKS FOR MS-SQL SERVER, IMPLEMENTED REPLICATION BETWEEN MS-

SQL SERVER AND SYBASE. PROVIDE DATABASE ADMINISTRATION FOR A TROUBLE TICKET TRACKING SYSTEM USING

SYBASE SYSTEM 11 ON A SUN SOLARIS PLATFORM.

● PROVIDE DATABASE ADMINISTRATION USING SYBASE SYSTEM 10 FOR A REAL TIME CELLULAR RENTAL BILLING

SYSTEM ON AN AIX/RISC 6000 PLATFORM. DATABASE ADMINISTRATION TASKS CONSISTED OF INSTALLATION OF

DATABASE SERVER AND REPLICATION SERVER, OBJECT CREATION (DATABASE, TABLE, STORED PROCEDURE)

PERFORMANCE TUNING, DATABASE BACKUP AND RECOVERY.

AT&T, ATLANTA, GA FEB 1996- MAY 1996

SYBASE DBA & REPLICATION ADMINISTRATOR CONSULTANT

● PROVIDED DATABASE ADMINISTRATION AND REPLICATION ADMINISTRATION FOR AN INTERNAL ACCOUNTING SYSTEM

USING SYBASE SYSTEM 10/11 AND SYBASE REPLICATION SERVER ON A SRV4 UNIX PLATFORM. DATABASE

ADMINISTRATION TASKS CONSISTED OF INSTALLATION OF DATABASE SERVER AND REPLICATION SERVER, OBJECT

CREATION (DATABASE, TABLE, STORED PROCEDURE) PERFORMANCE TUNING, DATABASE BACKUP RECOVERY AND

MIGRATION FROM SYBASE SYSTEM 10 TO SYBASE SYSTEM 11.

A.G. EDWARDS, ST. LOUIS, MO JUL 1995- FEB 1996

SYBASE DATABASE ADMINISTRATOR CONSULTANT

● PROVIDED DATABASE ADMINISTRATION FOR STOCK SALES SYSTEM USING SYBASE10.DEVELOPED OPEN SERVER

APPLICATIONS USING C LANGUAGE, SYBASE CT-LIB AND DB-LIB API. SCRIPTING LANGUAGES USED WERE C-

SHELL, BOURNE AND PERL.

● DEVELOPED SYBASE MIGRATION TOOL TO MIGRATE SYBASE 4.9 TO SYSTEM10. ALSO WROTE FEASIBILITY

DOCUMENTS.

● DEVELOPED SYBASE OPEN SERVER API APPLICATION TO AUDIT USER SQL STATEMENT EXECUTION..

● DEVELOPED SYBASE SERVER / DATABASE RE-CREATION DR UTILITY.

THERATX, ATLANTA, GA OCT 1994- JUN 1995

SYBASE DATABASE ADMINISTRATOR

● PROVIDE DATABASE ADMINISTRATION FOR A CENTRALIZED HEALTHCARE DATABASE. SYBASE SYSTEM 10 TECHNICAL

SKILLS CONSISTED OF INSTALLING, PERFORMANCE TUNING, DATABASE MIGRATION, DATABASE DESIGN, DATABASE

CREATION, DATABASE SECURITY, AND DATABASE RECOVERY IN AN HP-UX ENVIRONMENT. SCRIPTING TOOLS

CONSISTED OF C-SHELL AND BOURNE. DEVELOPED SQL STORED PROCEDURES.

DELTA AIR LINES, ATLANTA, GA AUG 1993- JAN 1995

SOFTWARE ENGINEER CONSULTANT (SECOND SHIFT)

● ANALYZE AND DEVELOPED SOFTWARE USING C-LANGUAGE FOR A PASSENGER ACCOUNTING SYSTEM ON A

UNIX/SYBASE CLIENT-SERVER ENVIRONMENT. TECHNICAL SKILLS CONSISTED OF ANALYZING AND DEVELOPING

(RPC) AND OPEN SERVER USING C-LANGUAGE AND DB-LIBRARY CALLS.

● DEVELOPED SYBASE SQL PROCEDURES AND EMBEDDED SQL C CODE.

● CREATE DATABASES, TABLES AND MONITORED SYBASE 4.9 DATABASES.

ISX CORPORATION, MARIETTA, GA JAN 1994- OCT 1994

SOFTWARE ENGINEER/ ORACLE DATABASE ADMINISTRATOR CONSULTANT

● TECHNICAL SKILLS CONSISTED OF DEVELOPING DEFENSE RELATED APPLICATIONS FOR THE U.S. AIR FORCE ON A

UNIX/ORACLE PLATFORM USING X-WINDOWS GUI TOOLS AND C/C++. SCRIPTING TOOLS USED WERE C-

SHELL, BOURNE SHELL AND PERL.

● PROVIDE ORACLE DATABASE ADMINISTRATION TO SUPPORT DEFENSE APPLICATION.

IBM CORPORATION, ATLANTA, GA, VESTAL, NY JAN 1992- JUL 1993

DB2 DATABASE ADMINISTRATOR

● PROVIDE TECHNICAL DESIGN AND CONFIGURATION OF DATABASES, PERFORMANCE TUNING, DATABASE RECOVERY,

DATABASE SECURITY, MIGRATION OF DATABASES USING DB2 AND SQL/DS.

● THE FUNCTIONAL EFFORT WAS TO PROVIDE DATABASE ADMINISTRATION FOR A NATIONAL FINANCIAL /MARKETING

INFORMATION SYSTEM, EDUCATIONAL MANAGEMENT SYSTEM AND A MANUFACTURING SYSTEM IN A CLIENT/SERVER

ENVIRONMENT.

U.S. ARMY

701ST MI AUGSBURG, GERMANY

● INFORMATION SYSTEMS COMMAND MICOM, REDSTONE ARSENAL, AL

● PROGRAMMER/ANALYST CONDUCTED SYSTEMS ANALYSIS AND SOFTWARE DEVELOPMENT FOR A TIME KEEPING

SYSTEM USED BY 12 ORGANIZATIONAL DEPARTMENTS ENCOMPASSING OVER 600 EMPLOYEES FOR THE U.S. ARMY.

EDUCATION:

● BOSTON UNIVERSITY

M.S., COMPUTER INFORMATION SYSTEMS, 2012

ORACLE 11G ADVANCE DATABASE SECURITY AND AUDITING,

ORACLE NOSQL, APACHE COUCHDB

PROGRAM MANAGEMENT,

PROJECT MANAGEMENT,

NETWORK ARCHITECTURE,

COMPUTER FORENSIC,

JAVA SOFTWARE DEVELOPMENT,

WEB DEVELOPMENT (AJAX, GWT, FLEX AND ACTION SCRIPT,

SILVERLIGHT, JAVAFX),

BUSINESS INTELLIGENCE,

DATA MINING, DATA WAREHOUSING AND OLAP TECHNOLOGY

● UNIVERSITY OF MARYLAND

B.S., COMPUTER SCIENCE, 1990

SECONDARY AREA OF CONCENTRATION: BUSINESS MANAGEMENT

● U.S. ARMY COMPUTER SCIENCE SCHOOL

PROGRAMMER/ANALYST TECHNICAL TRAINING

ORACLE TRAINING:

● ORACLE 11G SPATIAL

● ORACLE 9I REAL APPLICATION CLUSTERS (RAC)

● ORACLE 9I DATABASE ADMINISTRATOR NEW FEATURES,

● ORACLE DATABASE ADMINISTRATOR MASTERS CERTIFICATE,

● ORACLE PERFORMANCE TUNING, ORACLE BACKUP/RECOVERY, REPLICATION

● APEX

Contact this candidate