Sql Server Oracle

John D. Townley

(c) 303-***-**** (h)303-***-****

Email: abhizt@r.postjobfree.com

OBJECTIVE Seeking a challenging, growth-oriented opportunity in Oracle database

administration and/or Oracle development

COMPUTER Hardware: Linux Itanium platforms, AIX platforms, HP platforms, Windows

SKILLS OS Environment: Linux X86-64 RHEL 5.0, HP-UX, AIX

Languages: PL/SQL, T-SQL, C, Visual Basic, Perl, Netezza Procedures

Databases: Oracle 11g, 10g, 9i, SQL Server 2008, 2005, Netezza

Applications: C Shell, UNIX Scripting, Oracle Grid Control, SFTP, SSH, Korn/Bash

Shell, Excel, MS Word, Outlook, DBArtisan, Toad, RMAN, SqlPlus, TFS, Reporting

Services, SSIS, MS Excel, Rally

EMPLOYMENT Senior Database Administrator – Datalogix Inc., Westminster, CO

HISTORY January 2009 to April 2011

Provide database administration and development for data solution provider

• Perform 24/7 on-call database support of Oracle and SQL Server databases up to

20 TB in size

• Develop new incremental/full RMAN backup solution for Oracle RAC environment

• Test RMAN recovery scenarios to determine database recovery time

• Document and train others in RMAN recovery solutions

• Develop multiple internal applications with PL/SQL language

• Develop a PL/SQL and Reporting Services solution to keep track of database

objects/columns added/deleted in system

• Perform Oracle 10.2 upgrades/patches and install Oracle 11.2 on Linux x86-64

• Perform alternative-domain RMAN restoration on production database

• Perform database and SQL tuning of Oracle 6-node 20 TB RAC system

• Upgrade SQL Server 2000 database to SQL Server 2008

• Develop applications with PL/SQL,T-SQL, and Reporting Services using Agile Scrum

methodology on Modeling Team

• Develop applications for Datalogix platform using Netezza procedure language

• Experience using data partitioning, trigger-based programming, and materialized

views

Senior Database Administrator – FISERV ISS, Denver, CO

October 2000 to August 2008

Provide production database administration for Fortune 500 firm

• Perform 24/7 on-call support of Oracle and SQL Server databases varying in size

large (800 GB) to small (4 GB)

• Perform backup and recovery using RMAN

• Perform daily production maintenance of Oracle and SQL Server databases

including log checking, space management and database tuning

• Perform maintenance of the Oracle Data Guard Standby databases, syncing up the

database with production

• Perform 90-day restores of multiple Oracle and SQL Server databases while actively

training others in database restoration

• Convert Oracle non-ASM databases to ASM databases, perform upgrades

• Establish physical database parameters and review internal Oracle tables

• Identify and recover corrupted blocks on Oracle database

• Install multiple Oracle ASM and non-ASM databases on both Linux and Windows

platforms

• Install Oracle 10.2 two node ASM RAC system on Linux Itanium system

• Install SQL Server databases on Windows 2000 platform

• Develop Oracle Data models for internal applications

• Perform SQL tuning using explain plan and Oracle Grid Control

• Develop multiple Cron UNIX scripting jobs using the Bash Shell

• Maintain nightly internal load job application processes

• Develop multiple internal applications with PL/SQL language

Oracle Database Consultant – March First, Denver, CO

March 2000 to October 2000

Provide Oracle database administration for a consulting services company

Senior Consultant – Architel Systems Corporation, Denver, CO

April 1999 to March 2000

Provide Oracle database administration, PL/SQL programming, Oracle tuning and data

modeling for consulting company

Advanced System Engineer – Electronic Data Systems, Denver, CO

September 1985 to March 1999

Implement computer database engineering objectives for a data processing

administrator

• Install Vantive and Oracle databases for clients

• Manage system tests, Oracle 7.3.4/Sybase 4.9.2 database administration,

import/exports, Oracle PL/SQL scripts

• Serve as assistant Oracle database administrator for CLMS team

• Develop Visual Basic/GUI applications and C batch programs in Vantive

• Perform team leadership role in construction phase of COBOL II project

• Create request for proposal document and high-level requirements

• Technical lead of General Motors Fleet Volume, develop using

IMS/DB2/TELON/COBOL II, system test, UAT and implementation

• Develop IMS/DB2/PL1 on-line system, coordinate system test and UAT, serve as

technical leader of Experimental System

EDUCATION B.S. in Computer Management Science – 1985 Metropolitan State College, Denver, CO

TRAINING Oracle Database Administration, Oracle Backup/Recovery and Performance Tuning

Contact this candidate