Oracle Project Management

Scott T. Keller

***** ******* ***** **, ******, TX 77386

Contact: 720-***-**** Email: **************@*****.***

References Available Upon Request

OBJECTIVE:

I am seeking a great opportunity to use my growing leadership skills and experience in a win-win arrangement.

SUMMARY:

Experience

• 1 year as DBA supervisor in current role. 5 DBA direct reports 3 Oracle, 2 SQL.

• 6+ yrs project management experience.

• 13 Yrs Consecutive IT – 18 years total.

• 13 Yrs Oracle 7/8/8i/9i/10g/11g – Database admin, modeling, mentoring, and pl/sql support.

• 11 Yrs OEM and Grid Control – installation, troubleshooting, maintenance

• 11 Yrs Oracle modeling, configuration, installation, DR/backup/recovery, patching, migration, tuning

• 11 Yrs Programming with PL/SQL and SQL

• 13 Yrs Production support

• 10 Yrs Creating and maintaining standby databases (Dataguard)

• 6+ Yrs Oracle replication – including multimaster, shareplex, streams, dataguard

• 6 Yrs working with RMAN to backup and restore databases

• 5+ Yrs Oracle partitioning

• 4 Yrs Teaching Oracle

• 3 Yrs in a lead role

• 2.5 years specifically with Shareplex.

• 1.5 Yrs Data Warehouse

• 1 Yr Direct RAC including 11g upgrade.

• 2 Yrs ASM including setup.

• 3 Yrs RAC backup support for DBA team + 10+ years exposure to concepts (since parallel server days).

• 1.5 Yrs Streams.

• 1 Yr as Work Center Supervisor for Reactor Operations in the Navy

Platforms

• Windows

• AIX

• UNIX • Linux

• Solaris

Oracle

• SQL*Loader

• Shareplex

• DBArtisan

• Enrcryption Tool

• Grid Control

• GoldenGate

• EBS

• WMS • NetBackup

• Toad DBA Suite

• Metalink

• OEM console & Packs

• DBTools

• Streams

• Dataguard • Financials

• Spotlight

• ERWin

• MS Project

• AWR/Statspack

• RAC

• SQL – PL/SQL

• Peoplesoft

Database

• Oracle 7.x-11g

• Some DB2

• Access • Some SQL Server

• Some MySQL

• dBase

Programming

• Unix scripting

• PL/SQL

• SQL • Perl

• HTML/PHP

• Can use other languages with syntax reference.

PROFESSIONAL EXPERIENCE:

ACS/Xerox, National (1/2012 – Present)

• Started as contract and rolled to permanent.

• Leading a team of 5 DBA’s, all off-shore between India and Latin America to handle the Oracle and SQL database needs of Xerox clients.

• Seeking a more challenging and rewarding role.

• Advisory role for oracle technologies such as Streams, Goldengate, ASM, and RAC to support the broader DBA team.

Thomson Reuters, MI (9/2010-7/2011)

• Performed numerous database copy operations.

• Helped with DR strategies.

• RAC & ASM, dataguard, and RMAN.

• Helped administer Exadata.

• Streams.

• AWR & ADDM.

• Grid Control configuration and management.

• Helped upgrade databases to 11g.

• Migrations between platforms.

• Developed and Tested SQL & PL/SQL

• Extracted Data Models for each production database.

• Established a project tracking method for the team.

• Balanced workload within the team.

• Made recommendations to management regarding DR, Security, and upgrades

• Left due to family illness and death and a desire to return home to Florida.

Xtivia, Colorado Springs, CO (2/2010-8/2010)

Senior Oracle DBA

• Handled various troubleshooting, tuning, and backup/recovery issues for Xtivia clients.

• Worked with RAC & ASM, dataguard, and RMAN.

• Worked with AWR & ADDM.

• Helped with upgrades between 9i, 10g, and 11g.

• Worked with Grid Control configuration and management.

• Developed and Tested SQL & PL/SQL

• Supported AIX, Linux, and Solaris servers.

• Sought a new opportunity due to the lack of leadership challenge, lack of upward mobility, and lack of hours.

Blue Cross Blue Shield of North Dakota, ND (7/2009-2/2010)

Lead Oracle DBA

• Managed 90+ servers with Oracle 9i - 11g.

• Project management – managed development projects.

• Two direct reports, one of them my senior in DBA abilities.

• Implemented Encryption & Data guard.

• Worked with RAC & ASM, and RMAN.

• Worked with AWR & ADDM.

• Worked with Grid Control configuration and management.

• Led the conversion of backup strategy from SQL Backtrack to RMAN

• Helped with DR strategies.

• Led the conversion of databases to 11g.

• Developed and Tested SQL & PL/SQL

• Extracted Data Models for each production database.

• Established a project tracking method for the team.

• Balanced workload within the team.

• Helped team to become organized and efficient.

• Made recommendations to management regarding DR, Security, and upgrades

• Supported AIX, Linux, and Solaris servers.

Fidelity Information Services, FL (7/2008-3/2009)

Lead Oracle DBA

• Managed 90+ servers with Oracle 10g.

• Mentored and trained a team of 4.

• Implemented and maintained RAC, Streams.

• Helped devise plans for an ASM implementation.

• Developed and Tested SQL & PL/SQL

• Supported AIX, Solaris and Windows servers.

• Worked closely with Data Architect on models, including some reverse engineering.

• Worked with Streams, RAC, GoldenGate, ASM, 10g & 11g, data pump, data guard

Verizon Communications, FL (6/2005-2/2008)

Senior/Lead Oracle DBA

• Project management.

• Managed 20+ servers which were configured for production in multimaster replication setup.

• Served as backup DBA for at least 40 more database servers with Oracle versions ranging from 7.3.4 to 10.1.

• Developed and Tested SQL & PL/SQL

• Wrote Unix and SQL scripts for performing monitoring and corrective actions. Responsible for ensuring backups are completed and safely transferred to tape using Rman (catalog and no catalog modes) and NetBackup.

• Worked extensively with SharePlex operations (from starting and stopping SharePlex processes to troubleshooting problems occurring with those processes.

• Helped with multiple database migrations between platforms and versions.

• Supported 24x7 operations on multiple applications.

• Interacted with Client Support team as well as development team to coordinate upgrades and patches.

• Identified bottlenecks and performance issues on Oracle level as well as hardware level and successfully implemented several performance enhancements.

• Worked with Oracle Enterprise Manager, Statspack, and several new tools including space managers, difference managers, performance managers, and more.

• Reverse engineered the current production database to reveal design issues that had been unnoticed prior to my arrival.

• Recommended design changes based upon data models extracted above.

• Resolved replication issues that had also been unresolved prior to my arrival.

• Helped other DBAs on the team to resolve database issues in their primary applications.

• Troubleshot issues through use of scripts and MetaLink as well as use of other Internet websites (such as user group websites and forums).

Independent Oracle Instructor, FL (6/2002-6/2005)

• Taught Oracle, MS Office, MS Project, Public speaking.

• Taught over 30 full week and extended length courses on Oracle DBA topics including Database Administration, Backup & Recovery, Performance Tuning, SQL, PL/SQL, Advanced PL/SQL, and Network Administration.

• Managed training development projects.

• Taught data modeling basic to advanced.

• Taught on Oracle versions 7.3.4, 8i, 9i, and 10g on Windows and UNIX platforms.

• Helped tailor off-the-shelf course material course documentation and lab exercises to student objectives.

• Performed troubleshooting of class setups, student exercises, database bugs, and other issues that came up.

Pax Clearing, NY (6/2001-6/2002)

Senior Oracle DBA

• Worked as Senior DBA in production Oracle environment.

• Set up backup procedures and specs, established tuning standards for developers, evaluated monitoring and tuning tools, isolated inefficient SQL and recommended changes.

• Restructured indexing to improve OLTP performance and helped developers with PL/SQL procedures.

• Developed and Tested SQL & PL/SQL for DBA tasks.

• Created and edited shell scripts for automating database monitoring.

• Established the ability to monitor and fix database from remote locations across the firewall by utilizing Oracle Connection Manager.

• Set up multi-master replication and hot standby databases.

Lifetime Television, NY (6/2000-6/2001)

Senior Oracle DBA

• Served as Oracle 8/8i DBA.

• Database project management.

• Loaded data with SQL-loader along with utilizing export/import utilities, set up and managed multi-master replication, monitored database for tracking and predicting problems with the database.

• Tuned database parameters, performed backup/recovery, set up test databases, managed user maintenance/security.

• Developed and Tested SQL & PL/SQL

Cablevision, NY (6/1999-6/2000)

Oracle DBA

• Worked as production DBA in Oracle Financials environment.

• Database project management.

• Tracked poorly performing SQL, recommended changes to SQL and design, tested third party applications, worked on trouble tickets, fielded customer calls both external and internal, managed Oracle Financials database including the application server.

• Developed and Tested SQL & PL/SQL

Signal Internet Technologies, SC (12/1998-6/1999)

Oracle DBA

• Managed and participated in a project to Convert the Database environment from DB2 to Oracle 8 and the subsequent maintenance of the Oracle Database. The environments are Windows NT and IBM AIX 4.3 (UNIX).

• Performed extensive database design and re-design work using Oracle Designer 2000 as well as ERwin and necessary tuning and monitoring through Q-diagnostics and Oracle scripts.

• Developed and Tested SQL & PL/SQL

Citizens Utilities, CT (8/1998-12/1998)

Oracle Consultant/DBA/Backend Developer

• Prepared scripts and reports for data warehouse maintenance.

• Set up and run SQL*Loader, wrote PL/SQL stored packages, SQL scripts, and DOS Batch programs for automation of DBA tasks.

• Developed and Tested SQL & PL/SQL

CERTIFICATIONS AND MEMBERSHIPS:

• Certified Oracle 8, 8i, 9i DBA through OCP program

EDUCATION:

• BS Electrical Engineering, The Citadel, 1985.

• US Naval Nuclear Power School.

• Project management – BUCEC – in process.

• Mini MBA for credit with a specialization in management – Florida Tech Online – in process.

• University of Life - Self-education through books, tapes, seminars, online videos, and personal experiences both good and bad

• Project management – Career Center Online Courses, 2003.

Contact this candidate