DBA Team Lead Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Miracal Breckenridge
309 Robinwood ln apt 8
Hopkins, MN 55001
cell phone 417.434.9876
e-mail breckenridge.miracal@gmail.com

PROFESSIONAL PROFILE

Almost 20 years of experience in Information Technology; experience leading in Operations, Systems Engineering, and Database Administration.

TECHNICAL KNOWLEDGE

Languages: SQL, PL/SQL, Java, korn/bourne/c shell scripting, Perl, C, C++, Pascal, PHP

Platforms: Intel, SPARC, Exadata, PA-RISC, RS/6000, Alpha, AS/400, Mainframe

Databases: Oracle (7.3 to Oracle 11gR2), SQL Server (2000 through 2008), DB2, Sybase

Tools: OEM, Grid Control, RMAN, RAC, Shareplex, Toad, Embarcadero, Coolgen, Sun One Studio, SilverRun

Operating Systems: Linux, Solaris, AIX, HP-UX, Open VMS, Windows

HIGHLIGHTS

Team Lead

·          Hiring DBA and SQL Server DBA Team Lead

·          Leading team meetings and inter-team meetings

·          Mentoring DBA’s in interactions with developers

·          Develop Oracle database, SQL and PL/SQL standards

·          Work with vendors and management for the purpose of license and support procurement

·          Work with vendors for support case escalation

·          Provided leadership in developing regulatory compliance strategy and documentation

·          Working with management, project managers, and developers to ensure that project timelines were appropriate and that projects were completed on time.

Architecture

·          Developed and implemented capacity planning and capacity projection strategies

·          Worked with application developers to provide good database models

·          Led meetings to develop good database standards and performance objectives

·          Provided guidance for disaster recovery strategies and implementations

·          Developed data migration strategies and processes to minimize application downtime

·          Worked with teams to select viable hardware infrastructure to meet business objectives

WORK EXPERIENCE
Cargill – 9380 Excelsior Blvd Hopkins, MN 55343

Jan 2011 to present

Responsibilities: Installation and configuration of OID; Grid Control Agent upgrade to Oracle 11gR2; Performance and tuning of multiple Oracle databases on AIX, HPUX, and Linux.  Architectural review, storage configuration review, and best practices review.

Savvis Communications Inc. – 1 Savvis Pkwy St. Louis, MO 63017

Mar 2008 to Jan 2011 – DBA Team Lead

Responsibilities: Leading weekly DBA Team Meetings, Hiring SQL Server Team Lead, Mentoring and Leading Oracle DBA’s, providing guidance to development agencies writing applications for Coca-Cola global web environment, development of a disaster recovery plan for Coca-Cola global web application environment, database architecture selection and disaster recovery planning for Carlson Marketing, Upgrade and patch planning for Coca-Cola

·       Software Architecture

·                                                                Recommended and implemented Oracle Partitioning for an application with large transaction volumes

·                                                                Recommended and implemented Oracle Advanced Queuing for an application leveraging JMS Queues

·                                                                Implemented PL/SQL changes to support Bulk Operations

·                                                                Recommended Materialized views to replace long running SQL queries in an application performing summary functions

·                                                                Provided Schema and Data Model review for developers experiencing performance issues

·                                                                Recommended the use of services to discern performance issues encountered with different applications using the same database.

·                                                                Implementation of Transparent Application Failover

·                                                                Develop patch and upgrade strategies including working with developers to develop relevant testing strategies.

·                                                                Hardware Architecture

·                                                                Recommended (and am in the beginning stages of implementation) of using Oracle Exadata platform for a Shared (similar to a Virtual Private Database) Database platform

·                                                                Have recommended and are beginning to move database servers away from Bladeframe architecture (Egenera) in favor of HP stand alone servers.

·                                                                Recommended and have leveraged a Capacity Management schema to assist in Capacity planning.

·                                                                Recommended three different Disaster Recovery Strategies for two different customers (Data Guard, Replication using Streams, Virtual Tape Solution)

·                                                                Recommended and implemented Data migration strategies (cross-platform, cross-OS, cross-Data Center) using Shareplex

·                                                                Recommended and am implementing patching via Oracle Home Migration

·       Support 10gR2 OLTP Environment

·       Performance analysis/tuning of WebSphere OLTP environment

·       Performance tuning with AWR, ASH and Grid Control

·       Installation planning and patching including patch testing

·       Oracle technologies used included RAC, ocfs2, RMAN

·       Egenera Bladeframes with 3Par storage

Preferred Resources/Bunge North America – 11720 Borman Drive St. Louis, MO 63146-1000 

Nov 2007 to Mar 2008 – Sr. Oracle DBA - contract

Responsibilities: Oracle 10gR2

·       Support 10gR2 OLTP Environment

·       Performance analysis/tuning of SAP OLTP environment

·       Performance tuning with AWR, ASH and Grid Control

·       Installation planning and patching to SAP specifications

·       Mentor DBA's with regard to Oracle Technologies including RAC, ASM, and Query tuning

Net Effects/Sister's Of Mercy – 3637 S Geyer Rd Sunset Hills, Mo 63127

Apr 2007 to Nov 2007 – Sr. Lead Oracle DBA - contract

Responsibilities: Lead team of Oracle DBA’s, worked with the team to develop and test a disaster recovery strategy for a large data warehouse, and hired an Oracle DBA.

·       Software Architecture

·                                                                Recommended and Implemented Oracle Partitioning for several tables used by a data warehouse

·                                                                Performed Security auditing

·                                                                Support 10gR2 Data Warehouse environment planning.

·       Support of internal Development Environment

·       ASM planning and installation

·       Performance tuning with AWR and ASH reporting

·       ETL administration and performance tuning

·       Mentor DBA's with regard to Oracle Technologies including RAC, ASM, and Query tuning

·       Storage planning with EMC storage administrator and AIX administrators

Distribution Control Systems Inc. - 945 Hornet Drive Hazelwood, MO 63042

Sep. 2006 to Apr 2007- Sr. Oracle Database Architect/Maintenance DBA

Responsibilities: Developed Oracle SQL and Database standards, Presented Oracle SQL and PL/SQL development workshops, worked with developers in architecting a reference data model, lead effort to eliminate need for replication of reference data

·       Software Architecture

·                                                                Provided Architectural and Data Modeling Guidance for the TNG NG application

·                                                                Developed a reporting strategy to leverage Oracle Application Express

·                                                                Worked with Application Architects to solve application design issues

·                                                                Performed Knowledge Transfer sessions and labs to enable developers to develop effective SQL, utilize PL/SQL, and make informed decisions about data storage

·                                                                Worked with Erwin and Oracle Designer to document the Data Model

·                                                                Recommended and assisted with the implementation of Oracle Streams for Replication (Single master, Multi-subscriber)

·                                                                Recommended the use of Oracle Partitioning for a few large volume transaction tables

·                                                                Recommended Advanced Queuing to be implemented in conjunction with JMS

·                                                                Trained developers in writing SQL with consistent execution properties

·                                                                Support of both C/C++ and Java Applications on RS/6000

·       Support of Customer running TNG NG application on Oracle 10gR1 and Oracle 10gR2

·       Support of internal Development Environments

·       Performance tuning with OEM, SQL tuning and performance analysis with OEM and Explain Plan

·       Leveraged Erwin and Oracle Designer to produce DDL for Change Control purposes

AG Edwards and Sons - 1 North Jefferson. St Louis, Mo 63103

Nov. 2004 to Sep. 2006- Sr. Oracle Database Administrator

Responsibilities: Team Lead for online brokerage trading and information system; led team meetings; planned and worked with DBA’s, System Engineers, Storage Engineers, and Network Teams to implement improvements to the disaster recovery solutions.

·       Software Architecture

·                                                                Implemented Advanced Queuing in conjunction with JMS

·                                                                Implemented several PL/SQL modules to facilitate better Decision Support features within an application

·                                                                Provided data model and PL/SQL processing changes to improve performance

·                                                                Participated in Design and Review meetings for a number of OLTP and Data warehouse applications.

·                                                                Recommended XMLDB for XML storage to reduce whitespace, decrease query time and leverage XML query API.

·                                                                Reviewed Erwin and Power Designer Data Models for design inconsistencies

·                                                                Provided guidance on XML storage and XMLDB use

·                                                                Provided support for Developers developing PL/SQL

·                                                                Hardware Architecture

·                                                                Recommended a later version of the Netbackup agent to better facilitate Backup to tape

·                                                                Assisted with the refactoring of the DR fail-over solution.

·                                                                Administration of Oracle 9i on HPUX version 11.

·       Supported RAC, ASM, and Data Guard environments

·       Developed automated archive and purge routines, statistics collection and management

·       Worked with Precise, OEM, and TOAD for SQL tuning and performance analysis

·       Applied patches for Application server clients and databases

·       Developed upgrade plans and patch-up strategies

·       Worked with AQ and Message Gateway for interface to a legacy system

·       Worked with Erwin and Power Designer to generate DDL for Change Control

Leggett and Platt Inc.- No. 1 Leggett Rd. Carthage, Mo 64836-0757

Aug. 2002 to Nov. 2004- Advanced Oracle Database Administrator

Responsibilities: Developed Oracle SQL, PL/SQL, and database standards, developed and implemented Sarbanes Oxley compliance documentation and auditing

·       Software Architecture

·                                                                Recommended, Implemented, and trained application developers on the use of PL/SQL (bulk operations and exception handling)

·                                                                Architected ETL and Data Processing changes to facilitate smaller batch windows

·                                                                Created the security and auditing policy for Sarbanes-Oxley Compliance

·                                                                Developed all of the Best Practices and Development guidelines

·                                                                Created Oracle Development and Oracle Standards Documentation for Sarbanes Oxley compliance

·                                                                Developed Oracle installation, and “Best Practices” guide for security management

·                                                                Trained developers in SQL and PL/SQL best practices and standards

·                                                                Developed Data Model and supporting documentation for ETL and batch processing

·                                                                Hardware Architecture

·                                                                Implemented IBM RS6000 with FASTT storage

·                                                                Architected and implemented a backup solution leveraging named-pipes to perform backup to tape without purchasing a backup agent

·                                                                Creation of backup solution with separate disk and tape retention periods (no media management system)- Implementation included PL/SQL Stored Procedures, Directories, generated scripts, (shell and RMAN) and OMS jobs

·                                                                Developed automated database refresh processes for off-hours database refresh

·       Primary Oracle Database Administrator – 1 year of supporting Oracle on Windows and 2 years of supporting Oracle on AIX. Supporting 3 production databases and 9 test and development databases.  Supported the migration of Oracle on Windows to Oracle on AIX.

·       OMS and OEM Web Console and OEM Reporting Website configuration

·       Assisted Developers with SQL*Loader, external tables, PL/SQL, Java, and .NET development

·       Installation, setup and administration of HTML DB (Sun Solaris 2.9)

·       Database performance monitoring with custom scripts and Oracle Enterprise Manager

·       Database tuning of SQL and PL/SQL; indexes; and materialized views

·       SAN management (FastT- IBM) AIX 5.2/5.1

·       File layout planning to prevent reorganization down time

·       Provided support for 2 to 4 major projects per year

·       Provided support for numerous minor application and database changes

·       Applied all Oracle patches and patch sets

·       SQL Server 2000 Installation – creation of maintenance plans

·       SQL Server 2000 User Administration – Mixed and Windows only modes

·       SQL Server 2000 Backup and recovery – for database refreshes – full/simple/Bulk-logged

St. John's Health System- 1235 E. Cherokee St Springfield MO, 65804
Oct 1999 to Aug 2002- Oracle Database Administrator

Responsibilities: Mentored with the team lead on how to work with other teams, DBA’s, and management, Oracle 7.3.6, Oracle 8, Oracle 8i administration, and SQL Server 2000

·       Software Architecture

·                                   Recommended and Implemented numerous schema changes to facilitate faster transaction times

·                                   Hardware Architecture

·                                   Assisted with the configuration and implementation of an IBM Shark SAN (with multi-pathing) in conjunction with a DEC Alpha VMS server.  (First, in the world at the time)

·       Primary Oracle DBA for 24x7 OLTP Database (5000 users) – migrated the 450 GB database from one storage unit to the IBM ESS with 15 minutes of application downtime utilizing a standby database. Responsible for maintaining the Oracle code tree (appropriate patches, patch sets, network parameters and instance initialization parameters)

·       Secondary Oracle DBA for custom Insurance Data Warehouse over 1 TB in size with approximately 2500 users.  Maintenance included OPS and an upgrade to Oracle 9iR1 with RAC.

·       Implemented Transparent Application Fail-over (TAF for Oracle 8i/9i)

·       Implemented OpenVMS/IBM ESS system with multi-pathing – first in the world

·       Tivoli Storage Manager (TSM) backup implementation (Oracle and SQL Server) including the development of TSM scripts

·       Tivoli Management System and Perl program development for custom monitoring and maintenance

·       Database performance monitoring with OEM, developed SQL scripts, COM batch files (Open VMS), and AIX shell scripts

·       Database tuning of SQL scripts and indexes for 3^rd party application – partition management for data warehouse

·       provided support for 8 to 10 major projects per year

·       provided support for many minor database changes in support of application changes

·       File layout planning on DEC StorEdge and IBM ESS

·       Management of Oracle on IBM p680 and DEC Alpha 8400 Servers

·       SAN management (ESS- IBM) AIX and OpenVMS

·       Management of SQL Server Backups utilizing TSM

·       Took Microsoft MS 2072 and MS 2073 Certified Classes

Cerner Corporation- 2800 Rock Creek Parkway Kansas City MO, 64117
Dec. 1998 to Oct. 1999- Lead System Engineer

Responsibilities:

·       Hardware Architecture

·                                   Moved large database by physically migrating storage arrays into a new storage cabinet

·                                   Developed backup and recovery documentation and process

·       Resource scheduling (third party) for hardware and software upgrades, moves, etc.

·       Technical project planning and scheduling

·       Interpersonal Interaction with client technical staff and management

·       System Administration of AIX RS/6000 computers ranging from F50 to S70. Backup, recovery, disaster recovery planning. System performance tuning and other system administrative roles.

·       Oracle Administrative responsibilities: backup, recovery, and disaster recovery plans.

·       Oracle performance tuning and space utilization reporting.

·       HNAM application administrative duties and performance monitoring on AIX

·       Storage configuration including SSA cabling and planning

·       AIX 4.X certification

St. John's Regional Medical Center- 2700 McClelland Blvd. Joplin, MO 64804
Jul. 1991 to Sept. 1995- Systems

Responsibilities:

·       Training of third shift operations people

·       Lead role on third shift had additional responsibilities including:
Operations Procedure Manual Publishing
Backup and Recovery Procedure planning and testing

·       System Administration of 9672 IBM Mainframe and multiple subsystems including:

     AIX, OS/400, DEC Open VMS, Data General, SCO, and Novell Network     Environments

·       Interaction with end-user teams and technical teams

EDUCATION
Southwest Missouri State University- Jan 1996 to Aug. 1998- Bachelor of Science Computer Information Science - GPA: 3.12 Major GPA: 3.4

Missouri Southern State College- July 1987 to Dec 1991- Bachelor of Science Biology / minor Chemistry

OTHER
willing to complete additional course work/training
willing to relocate/letters of recommendation and transcript available on request

Download Resume Format