Manager Oracle
Resume:
Bret Higginbotham
Gainesville, GA 30506
Technology Skills Summary
As a Senior Information Technology professional specializing in database
technology including, administration, architecture, modeling for DB2 LUW,
Oracle and MS SQL environments, I have compiled technology experience
achieving successful results implementing custom applications, customizing
third Party solutions and performing database conversions. My most current
experience has been as a DBA for performing all aspects of database
management: installation/implementation, maintenance, database tuning,
backup/recovery and SQL tuning.
1. Experienced in Financial Services, Banking, Government, Computer
Software, Retail, and Human Resources.
2. Database systems management experience in database re-hosting,
capacity planning, logical and physical design, implementation,
monitoring/tuning, maintenance, and backup/recovery with DB2 LUW,
Oracle and MS SQL Server
3. Define requirements for the database environments, data retention,
sizing and technical implementation plans
4. Develop a progressive approach to database maintenance that has helped
prevent down time and expedite recovery
5. Analysis of current schema design and suggest changes to schema
design, providing performance improvements
6. Subject Matter Expert in DB2/UDB areas of application interface
configuration with DB2 Connect and Websphere
7. Conduct JAD sessions to collect and shape business requirements,
evaluating data processing techniques, and information system concepts
8. Conduct environment reviews and recommend infrastructure changes to
hardware, software, applications and business processes using
Oracle,DB2 LUW and other products
9. Full Life Cycle Experience: Data Architecture, Database Design,
Performance Tuning, Database Administration, JAD Facilitation,
Business Analysis, Project Management, Training and Quality Assurance
10. Functional Operating System platforms include: AIX, Sun Solaris,
LINUX, Windows NT, 2000, XP, OS/2
11. Database Contingency planning and configuration with HACMP, Hitachi
True Copy, HADR, Oracle Hot Standby, Data Guard
OS: AIX, LINUX, Sun-Solaris, HP-UX, Windows NT, 2000, XP, 2007
Network: TCPIP, SQL*Net, Oracle Names, ODBC, JDBC Thin client, VPN, RAS,
Citrix
Applications: Quest Central for DB2, DBArtisian, TOAD, Peregrine Service
Center, Foglight,
Spotlight, Tivoli TEC and Inventory, Information
Engineering Workbench, SQL
Developer, SQLWays, Application Development
Workbench, KASE: VIP for OS/2,
Oracle Express, PeopleSoft (HR), Designer 2000,
Tuxedo, Websphere, IQ/Live Web,
Exceed, MAS, Desktop DBA, MS-Office (Word, Excel,
Project, Access, Outlook), VISIO
Database Tools and Languages: Oracle (7.2, - 10.0.2), DB2 LUW ESE,
WSE (6.0 - 9.5), MS-SQL
Server (7.0, 2000), SQL*Plus, SQL*Loader,
Designer2000, Oracle Enterprise
Manager (OEM), ERWIN, Oracle Migration
Workbench, Real Application Clusters, Oracle
Parallel Server,
PL/SQL,
HADR, Data Guard,Oracle Call Interface (API),
RMAN, DB2 Connect,, DB2 Audit, DB2 Governor,
Oracle DRDA Gateway 11.0, HACMP, True Copy,
Visio Architect, UML, SMIT, SAM, Visual Basic
4.0, C-Shell, JPL, JAM, PMBOK (Project
Management Body of Knowledge), Six Sigma, RAD,
IDEF, IE, TOAD, DB Visualizer, SQL Developer,
ERStudio
Employment
Manager Database Management Technology
United Community Bank Blairsville, GA 1/2010-
Present
. Implement a database server architecture plan.
. Refine and publish Meta data and data dictionaries in order to
clarify data and business relationships for each business unit.
. Responsible for managing a team of 4 database developers using a
T-SQL and Cognos to provide reporting services.
. Developing database infrastructure and incorporating best
standards and practices for database design including naming
conventions, security, object and file systems layout.
. Manage all aspects of production database administration
Applications RDBMS Operating Systems
E Corp DB2 LUW 9.5 Windows
RegE SQL Server 2008 Windows
Prime Daily SQL Server 2005 Windows
Financial Reporting SQL Server 2005 Windows
360View SQL Server 2005 Windows
Senior Database Management Specialist
TSYS Prepaid Alpharetta, GA
4/2007 - 8/2009
. Mapped and converted existing production DB2 LUW database
structures to a new Oracle database, as well as writing
procedures to load data into the new structures.
. Developed and managed the conversion process, converting DB2
database objects to Oracle and incorporating changes to the
physical object structures.
. Maintained a DB2 to Oracle replication process that was used for
keeping DB2 and Oracle production databases synchronized.
. Supported a large development teams by providing assistance with
database structural changes, promoting changes through the
system development life cycle and optimizing application Sql.
. Performed all phases of database administration in a large DB2
LUW environment. Activities include development support,
performance tuning, backup and recovery, and disaster recovery
support using HADR.
. Manage database reporting infrastructure, translating
requirements and writing stored procedures.
. Implementation of a structured, standardized environment to
improve efficiency and availability. This included common
scripts for monitoring DB2 processes, size issue, and DB2
alerts.
. Created systems, policies, procedures and methods to minimize
data downtime, loss
. Senior DBA responsible for developing new production
environment, including migration of development, production data
systems, NY data center to Columbus GA
. Served as database conversion specialists. Performed database
conversions from Postgres, MYSql, and DB2 LUW databases to DB2
LUW 8.2 64-bit and Oracle 10G.
Applications RDBMS Operating Systems
CEA DB2 LUW 8.2 FP 15 LINUX
BPA DB2 LUW 8.2 FP 15 LINUX
CVA Oracle 10.2 AIX
SOR Oracle 10.2 AIX
AUTH Oracle 10.2 AIX
Senior Database Administrator
Bank of America Atlanta, GA
6/1997 - 5/2007
. Senior DBA in Relational Database Systems Management supporting
bank databases over 100 mid-range applications, performing all
phases of database administration; responsible for software
integration, monitoring, tuning, upgrades backup/recovery
. Staged and conducted database upgrades from DB2 UDB 7.2 to 8.2
for over 60 production and development databases. The last
release level for DB2 UDB databases supported is DB2 8.2.7, FP14
. Served as lead database administrator for the CRM project,
coordinating database integration efforts with Websphere, MQ,
DB2 Connect and Siebel. Integration efforts were coordinated in
an N-tier environment with Siebel application servers, 3 web-
server domains running DB2 UDB 7.x and Websphere 5/6 and MQ,
retrieving data from DB2 os/390 transmitting data to Siebel
application server
. Configured and managed dual redundant-high availability
environment with DB2 databases on AIX using HACMP and HADR
. Worked with the bank's information security and audit groups to
develop and implement our DB2 and Oracle Security baseline;
implemented the security baseline and placed 150 DB2 and Oracle
database servers in compliance
. Design, write, implement, and maintain Information Technology
standards based on industry best practices and standards
. Configured database integration with Web Sphere 5.0 for Oracle
and OS/390 DB2 data retrieval using JDBC thin client
. Implemented Oracle 9i RAC on Solaris clusters. This was RAC
environment is built on RAW devices without a cluster manager
. Developed standard build templates that has allowed 100% Oracle
new server build to be complete within the prescribe timeline
. Implemented Oracle SAFE method technique to improve physical I/O
on Oracle databases. All tables and indexes are separated by
uniform extent size to reduce contention and fragmentation on
data files
. Worked with the System Administration team to configure
redundant-high availability SAN replication for large OLTP and
reporting databases, this was a 100k transaction per hour
application utilizing HACMP, DB2, DB2 Connect, and disk
redundancy.
. Served as a Contingency and Fail-over specialist/engineer using
Log Shipping, Data Guard, HACMP, Hitachi True Copy, and HADR.
Work with Business Continuity Solutions to certify applications
meet SLA contingency guidelines.
Applications RDBM Operating Systems
ASSET CENTER DB2 8.2 AIX
PEREGRINE DB2 8.2 AIX
LRM (Liability Risk Mgmt) DB2 8.2 AIX
CRM with Siebel/Web Sphere DB2 8.2 AIX
CFC (Check Fraud Claims) DB2 8.2 AIX
NEWS DB2 8.2 LINUX
NCG Web Oracle 10.0.2 Sun
Solaris
ARIS Oracle 9.2.0.6 LINUX
PCTI Oracle 9.2.0.6 HP-UX
PSIE Oracle 9.2.0.6 HP-UX
Tivoli Oracle 7.3.x/8i
Aix
PeopleSoft HRMS Oracle 7.3/8.x HP-UX
Talent Management SQL Server (7.0/2000) Windows NT
Technology Manager/Data Architect
Grant Thornton Vienna, VA 3/1994
- 6/18/97
. Managed data architecture team re-designs of the Veteran's
Benefit Administration Benefit Delivery System.
. Responsible for facilitating re-engineering business models
using BPR and IE structured techniques to translate into logical
data models, targeting an Oracle database environment.
. Developed an information architecture plan and coordinated the
data modeling of business requirements, producing key relational
database projects at the Environmental Protection Agency.
. Vendor Account Relationship Manager with Oracle's Decision
Support Systems group, performing product evaluation, and
performing proof of concepts in conjunction with Oracle. All
evaluations were used to develop customer recommendations for
the implementation of Oracle Express
. Primary role in developing Grant Thornton's client server
development methodology and system development guidelines.
. Aided senior management in formulating contracting strategies
for RFP's proposals with government agencies, including EPA,
DOD, DOT and Veteran's Affairs and the Department of
Agriculture.
Applications RDBMS
Operating Systems
VETSNET Oracle 7.3
HP-UX 10.x
Rural Utility Service Oracle 7.x HP-UX
10.x
AVAPS Oracle 7.x Sun Solaris 4.x
System Engineer
KASEWORKS Norcross, GA 12/92 - 3/1994
. Supported sales by providing product expertise and proof of
concepts for key customers
. Served as Quality Assurance department manager, responsible for
testing, product release certification and source code change
control
. Develop GUI interfaces for client server applications
. Re-engineered software quality control procedures, resulting in
the lowest defect level for any product released by KASEWORKS
. Implemented automated testing, comprehensive tests, reviews,
customer beta program.
. Conducted classroom training on GUI design and RAD techniques
with KASE: VIP
Applications RDBMS
Operating Systems
KASE:VIP Oracle 6.x OS/2 1.0 -
3.0
KASE: VIP Sybase SQL Server 4.x
Windows, MS-DOS
Education
Western Carolina University
Bachelors of Science in Business Administration
Computer Information Systems
University of North Carolina Charlotte
Master Certification
Information Technology Management
Honors
Bank of America Teammate Celebration Award
PI GAMMA MU, National Honor Society
Graduate with Honors: 3.36 GPA
Dean's List Western Carolina University
Certifications
Oracle 7 Masters
Oracle Certified Professional 8i
Community Associations
International DB2 User Group - current
Northern Virginia Technology Council, 1995
Data Processing Management Association, 1991-2004
Oracle International Users Group - current
Contact this candidate