SUMMARY:

More than THIRTY (30) years of IT experience with expertise as a Senior Oracle DBA/Project Manager/Team Lead/DBA MANAGER experience including design, documentation, testing, upgradation, implementation, maintenance, troubleshooting, migration, performance tuning, backup recovery, user training and support using Oracle 8i/9i/10g/11g, MS SQL Server 2000/5/8r2, SQL*Loader, Oracle Partitioning, Oracle Enterprise Manager 12C (OEM GRID), RMAN, JDBC and J2EE apps, ODBC, Oracle Diagnostics Pack, Oracle Stats Pack, PL/SQL, UNIX Shell Scripting, VERITAS/SYMANTEC NETBACKU 7.5/Backup Exec and Windows NT/ 2000/2003/2008 , Citrix, RedHat LINUX, UNIX (HP, AIX, SUN) environment. Oracle 8i Master DBA, Oracle 8i Network and Distributed Master DBA, ORACLE SECURITY SPECIALIST USING DISA STIGS COMPLIANCE FOR ORACLE, WINDOWS, and UNIX ENVIRONMENTS

TECHNICAL SKILLS:

Language: PL/SQL, UNIX Shell Scripting

Database: Oracle 11g/10g/9i/8i, MS SQL Server 2000/5 /8

Other Tools/Skills: SQL*Loader, Oracle Partitioning, Oracle Enterprise Manager (OEM) Expert, RMAN, JDBC and J2EE apps, ODBC, OLEDB CONNECTIVITY, Oracle Diagnostics Pack, Oracle Stats Pack, Informatica Power Center 6/5.1, Omni Back, VERITAS 4.5/Backup Exec, SQL - BACKTRACK, PEOPLESOFT

Operating Systems: Windows NT/XP/2003/, Vista, Citrix, Linux, Unix (HP, AIX, SUN) Networks/Protocols TCP/IP, SPX/IPX, Microwave Wireless, Satellite, HF/UHF/SHF RF Transmission

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA

Confidential, Fayetteville, NC

Responsibilities:

• Oracle Utilities Work And Asset Management Application DBA
• Oracle Utilities Customer Care and Billing Applications DBA
• Oracle Utilities Meter Data Management DBA
• Oracle Utilities Mobile Workforce Management DBA
• Oracle Fusion Middleware DBA
• Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning
• Design, implement and support databases using Oracle RDBMS
• Develops programs using PL/SQL
• Leads and conducts complex backup, recovery and query tuning using Data Domain, Legato, Tivoli TSM
• Serves as interface between users and information systems/processing specialists
• Builds compliant databases, writing scripts in SQL, UNIX commands, and shell scripts
• Created functional and technical specification documents
• Coordinate testing procedures with Q/A group
• Troubleshoot and support production systems
• Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)
• RedHat Linux 5 System Administrator Oracle Linux 5
• Thorough understanding of Oracle internal structure and processing such as detailed knowledge of memory structures
• Created backup and restore scripts and designed backup strategies
• Provided monitoring and performance tuning of very large databases required
• Clone database systems using RMAN and OEM12C GRID CONTROL
• Usage of AIA FP for integration with Oracle EBS R12

Senior Oracle DBA

Confidential, Raleigh, NC

Responsibilities:

• Monitor and resolve HP Services Manager Tickets
• Review DB Status errors including backup history and resolving backup errors
• Monitor and take action emails in UNIXDBA mailbox
• Serve as daytime on call support for the Data Management Team
• Maintained Oracle and IBM DB2 Databases
• Perform project task assignments
• Review Oracle/DB2 SOX Reports
• Review Oracle Grid Control data
• Monitor Oracle/DB2 backups using CommVault
• Patch Oracle/DB2 systems
• Oracle Database Consultant

Senior Oracle DBA

Confidential, Chicago

Responsibilities:

• Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning
• Design, implement and support databases using Oracle RDBMS
• Develops programs using PL/SQL
• Leads and conducts complex backup, recovery and query tuning using Data Domain, Legato, Tivoli TSM
• Serves as interface between users and information systems/processing specialists
• Builds compliant databases, writing scripts in SQL, UNIX commands, and shell scripts
• Create functional and technical specification documents
• Coordinate testing procedures with Q/A group
• Troubleshoot and support production systems
• Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)
• Experienced using modeling tools such as ERWIN
• Extensive experience using SQL and PL/SQL
• Ability to write complex UNIX scripts and has an understanding of the UNIX architecture
• Understands Oracle and OS architecture and interactions between database and applications
• Provide maintenance on all EXADATA environments.
• RedHat Linux 5 System Administrator of the Exadata Machine and ODA's
• Thorough understanding of Oracle internal structure and processing such as detailed knowledge of memory structures
• Created backup and restore scripts and designed backup strategies
• Provided monitoring and performance tuning of very large databases required

Confidential, Pittsburgh, PA

Senior Oracle DBA Team Leader

Responsibilities:

• Generate performance report of server and Oracle database using Statspack, AWR, ADDM and TOAD
• Migrated 17 applications/databases from Oracle 10g Windows 2003R2 to Oracle 11gR2 Windows 2008 R2 igrated 17 Applications/databases from Oracle 11g Windows 2008 R2 to EXADATA.
• Provide Database Administration for Windows SQL Server 2000, 2005, 2008 R2
• Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning
• Design, implement and support databases using Oracle RDBMS
• Write functional and technical specification documents
• Coordinate testing procedures with Q/A group
• Troubleshoot and support production systems
• Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)
• Installed, Configured, and Implemented Oracle 12C Grid Cloud Control and Plugins for Exadata and SQL SERVER and Oracle Service Oriented Architecture for various Fusion Middleware applications..
• Deployed Agents for Windows 32/64 bit Operating Systems
• Provide maintenance on all EXADATA environments.
• RedHat Linux 5 System Administrator of the Exadata Machine

Confidential

SENIOR ORACLE FUSION MIDDLEWARE CONSULTANT

Responsibilities:

• Install and Configure WebLogic 10.3.6
• Install and Configure Oracle SOA 11.1.1.7 Infrastructure
• Install and Configure Oracle Identify Management and Oracle Access Manager 11.1.1.7
• Install and Configure Oracle Forms and Reports
• Installed Repository for OID and Oracle Forms/Reports
• Migrated Oracle 10.2.0.4 to Oracle 11.2.0.3 on WINDOWS 2008/R2

Confidential, Pittsburgh, PA

Senior Oracle DBA

Responsibilities:

• Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning
• Design, implement and support databases using Oracle RDBMS
• Develops programs using PL/SQL
• Leads and conducts complex backup, recovery and query tuning
• Serves as interface between users and information systems/processing specialists
• Builds compliant databases, writing scripts in SQL, UNIX commands, and shell scripts
• Write functional and technical specification documents
• Coordinate testing procedures with Q/A group
• Troubleshoot and support production systems
• Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)
• Experienced using modeling tools such as ERWIN
• Extensive experience using SQL and PL/SQL
• Ability to write complex UNIX scripts and has an understanding of the UNIX architecture
• Understands Oracle and OS architecture and interactions between database and applications
• Thorough understanding of Oracle internal structure and processing such as detailed knowledge of memory structures
• Created backup and restore scripts and designed backup strategies
• Provided monitoring and performance tuning of very large databases required
• Significant experience in data warehousing database architectures

Confidential

Senior Oracle DBA/PERFORMANCE TUNIING DBA

Responsibilities:

• Provide database tuning for .asp pages that were taking 3 - 5mins/ down to under 5secs.
• Re-indexing of fragmented objects
• Generate performance report of server and Oracle database using Statspack, AWR, ADDM and TOAD
• Allocate storage and configure ASM
• Extensive use of performance tools like AWR, ADDM, TKPROF and Explain plan for performance monitoring and troubleshooting with shell scripting.
• To provide a level of senior expertise to define a comprehensive set of procedures through which the integrity, security, operating performance
• Database I/O tuning by reorganization of database and tablespace and re-indexing
• Work with Oracle or other vendors to solve database problems when they occur
• Assist ETL, Report developers with performance tuning ETL jobs & report execution
• Enforce all security policies and perform security audits
• Create, Define & Implement Backup using RMAN.
• Created planned maintenance for rebuilding indexes and gathering statistics to decrease db file sequential reads
• Tuned the SGA using Oracle Best Practices for RAC ASM Systems

Confidential, Columbus, Ohio

SENIOR ORACLE DBA CONSULTANT

Responsibilities:

• Provide Maintenance and Support of People Soft Databases on ATT Hosted Systems in 2 data centers
• Provide Maintenance and Support for Oracle OEM Grid Control Version 11gR2
• Provided SQL Tuning for PeopleSoft Database Migration
• Assisted in the Data Transformation of Sql Database to Oracle Database for PeopleSoft CRM PORTAL FINANCE
• Production Support DBA for over 50 PeopleSoft Databases
• Provided Database Tuning of PEOPLESOFT environments
• Created RMAN duplicate/clone procedure for refreshing of large PEOPLESOFT Databases using RMAN production backups
• Provide Maintenance and Monitoring for Oracle Dataguard Databases

Confidential, Charlotte, NC

Senior Oracle DBA Consultant

Responsibilities:

• Provide Database Support for All Active Databases on IBM AIX Systems
• Oracle Utilities Work And Asset Management Application DBA
• Oracle Utilities Customer Care and Billing Applications DBA
• Oracle Utilities Meter Data Management DBA
• Oracle Utilities Mobile Workforce Management DBA
• Oracle Fusion Middleware DBA
• Provide 24/7 Database Support
• Provide Maintenance and Support Oracle RMAN Environments
• Provide Maintenance and Support Oracle Golden Gate Production Environments
• Provide Maintenance and Support Of People Soft Databases
• Provide Maintenance and Support for Oracle RAC ONE NODE
• Provide Maintenance and Support for Oracle OEM Grid Control Version 11gR2
• Implemented and Maintained AVAMAR backups
• Implemented EMC Domain Backups Using OEM Grid and RMAN
• Created Data Guard Databases for Failover
• Provide Maintenance and Support for Oracle Streams
• Oracle Migration from 9/10 to Oracle 11GR2
• Provided Patch Management and Installation
• Install, configure and apply patches to Oracle database software and related software components on Oracle 11g r2 Grid RAC and 10g RAC on IBM, Sun Solaris and Linux Operating System.
• Upgrade version from 9i to 10G R2, 10.2.0.1 to 10.2.0.3 and 11g r2 Grid
• Allocate, design, installation and Administration Oracle ASM in Oracle 10g & 11g r2
• Monitor database performance and resource utilization
• Patching and bug fixing of Oracle Database 10g and Oracle 11g
• Configure Database Flashback for oracle 10g and oracle11g
• Set Monitoring System OEM for Database and PeopleSoft application and Email notification upon up/down
• Re - indexing of fragmented object
• Generate performance report of server and Oracle database using Statspack, AWR, ADDM and TOAD
• Allocate storage and configure ASM
• Extensive use of performance tools like AWR, ADDM, TKPROF and Explain plan for performance monitoring and troubleshooting with shell scripting.
• To provide a level of senior expertise to define a comprehensive set of procedures through which the integrity, security, operating performance
• Database I/O tuning by reorganization of database and tablespace and re-indexing
• Work with Oracle or other vendors to solve database problems when they occur
• Assist ETL, Report developers with performance tuning ETL jobs & report execution
• Enforce all security policies and perform security audits
• Create, Define & Implement Backup using AVAMAR BACKUP Manager

Confidential, Richmond, VA

Senior Oracle DBA Consultant

Responsibilities:

• Performed Oracle Upgrades from Oracle 10.2 to 11gr2
• Maintained Banner/SunGard Database Systems on IBM AIX Systems
• Provided Production Database Support for TerraDotta Studio Abroad Application
• Implemented Oracle BI for Department of Computer Science School
• Implemented Oracle OEM Grid Control and Intelligent Agent Installations
• Provided Oracle RMAN integration with Symantec Netbackup Version 7.1
• Provided Oracle Production support for various Oracle Dataguard Databases.
• Provided Database Support for MSSQL Sever 2005 and 2008r2
• Documented Resource and Control Environment for Server/Database Management
• Mentored and trained junior DBA S on Oracle Best Practices and Techniques
• Performed normal Daily Production DBA routines of monitoring and proactive maintenance. nstalled, Configured, and Implemented Oracle Enterprise Manager.
• Configured OEM Alerts, Monitoring, and Notification via SMTP

Confidential, Fargo, ND, and Richmond, VA

Senior Oracle DBA

Responsibilities:

• Provide Production Database Support to various Confidential accounts on IBM AIX Systems
• Performed Oracle Database Tuning on Excessive Waits
• Performed Network Metrics for Baseline Analysis
• Provide Backup and Recovery configuration using RMAN and SQL - BACKTRACK
• Install Oracle Binaries and create new databases via DBCA and scripts
• Provide Manual upgrades from Oracle version 9i to 11g.
• Perform daily ticket troubleshooting using Remedy and automated ticket dispatch
• Increased employee production by creating load balancing by implementing 2 listeners
• Upgraded database from 9.2.0.8. to Oracle Version 10.2.0.4
• Provide 24/7 response to all production environments
• Database Cloning and Refreshing using Transportable Tablespaces.
• Install Quarterly Critical Patch Updates
• Provide AWR snapshots to client.
• Provide Database Admin for PeopleSoft and Siebel.
• Provide Database Support for Dataguard Database Configurations on IBM AIX Systems

Confidential, Valley City, North Dakota

Senior Oracle DBA

Responsibilities:

• Provide Production Database Support to various client accounts including RAC on windows
• Created and Implemented Oracle RMAN backups
• Performed Network Metrics for Baseline Analysis
• Created Backup and Recovery Manager documentation for New D
• Documented Oracle Database Environment
• Created Oracle DBA Manual for company to manage the databases in their environment.

Confidential, Fargo, North Dakota

Senior Oracle DBA

Responsibilities:

• Created and Implemented Patch Management for Database and AIX System
• Created and Implemented Oracle Dataguard and Oracle Standby Database on versions 8 - 10g
• Performed Oracle Database Tuning on Redo Logs
• Performed Oracle Database Tuning on Excessive Waits
• Performed Network Metrics for Baseline Analysis
• Troubleshot I/O bottlenecks on EMC DMX3/AIX 5.3 LPAR Systems
• Repaired/Patch Oracle 9.2.0.8 Listener
• Increased OLTP from 30 thousand claims a week to over 30 thousand a day
• Increased employee production by creating load balancing by implementing 2 listeners
• Upgraded database from 9.2.0.8. to Oracle Version 10.2.0.4
• Upgraded database from 9.2.0.8 to Oracle Version 11g
• Developed and Implemented Oracle Advanced Replication for fail over using TAF
• Documented Oracle Environments for ease of management
• Created database objects such as indexes, tables, partitions, materialized views.
• Trained Personnel on Oracle Versions 9, 10, and 11g.
• Created and Implemented Proactive Maintenance
• Increased scalability and processing throughput allowing for new business opportunities
• Project Manager for Application/Database Upgrade and Migration
• Configured Oracle Enterprise Manager Grid Control
• Maintained Oracle Versions 9.2.0.8 - 11.1.0.6
• Maintained Databases in accordance with STIGS V7r2 and V8r1
• Successfully completed 3 major CMS/MEDICARE projects increasing revenue and ROI
• Implemented Oracle Enterprise Grid Control
• Designed, Implemented, and documented Disaster Recovery for several db applications
• Maintain PeopleSoft, Siebel, Remedy, Guardium implemented database systems
• Maintain M2 EDI Translator Software Application
• Implemented RMAN backups vice THRID PARTY software saving over 1 million dollars a year in expenses

Confidential, Phoenix, AZ

Database Management Team Manager/Senior Oracle DBA

Responsibilities:

• Involved in patch management, system upgrades and system documentation.
• Involved for Oracle maintenance, material and management of all infrastructure systems for 42 hospitals.
• Maintained over 300 databases, 800 applications on various platforms.
• Maintained all SERVICE LEVEL AGREEMENT when Perot downsized my CORE DBA group from 14 to 3.
• Provided 24/7 database monitoring and maintenance.
• Implemented Standard Operating Procedures for daily, weekly, monthly and quarterly preventive maintenance.
• Implemented proper Disk, CPU, I/O and database monitoring and provided database troubleshooting guide for all applications using a 6 step troubleshooting standard.
• Submitted 2 employees for Associate of Month and they were chosen. No one in the 5 - year history for the DBA group has ever been selected.
• Provided architectural solutions to various application changes.
• Used REMEDY to provide change management tracking, incident reporting and incident tracking.
• Put several operation changes in the way the backup and recovery was performed.
• Performed performance-tuning baselines on all critical systems.
• Provided specific customer relations to enhance relationship with external and internal customers.
• Corrected 4 years of Audit hits from SOX and maintained MS Clusters. aintained PeopleSoft Database backend
• Used RMAN on several databases and maintained Oracle versions 7.3.3 to 10gR2, SQL Server 2000/2005.
• Maintained Oracle Databases in a Veritas Clustering/RAC configuration
• Installed, Configured and Implemented Oracle Enterprise Manager

Confidential, Greenville, NC

Senior Oracle DBA\ Windows System Administrator

Responsibilities:

• Provided 24/7 Database Administration for Oracle Database Instances versions 7.3.4/8i/9i.
• Provided backup and recovery for 5 - minute point in time recovery, all online backups using RMAN API.
• Created scripts to perform archive log cleanups.
• Performed Oracle Performance Tuning and Windows Operating Tuning Sessions for better database and system performance.
• Trained personnel how to use Oracle Enterprise Manager and manage various database applications.
• Provided Disaster Recovery Tools and FACTS for company implementation.
• Documented all Oracle Database environments and trained staff personnel in Oracle troubleshooting techniques and restoration.
• Provided database tuning and performance optimization.
• Provided database support for MS SQL Server 2000.
• Performed daily database maintenance routines and set up Oracle Enterprise Manager to manage database status, corruption, I/O contention, CPU contention, disk space parameters, archival process, page swapping, application performance and index fragmentation.
• Maintained ADP HRMS Database systems and created scripts to maintain crosschecks of RMAN backups.
• Configured and maintained Oracle 8i standby databases.

Confidential, Des Moines, IA

Senior Oracle DBA/AIX System Administrator/Windows System Administrator

Responsibilities:

• Provided Oracle Support for Oracle Versions 7.3.4/8.1.7.3/9.2.0.4 on Windows 2000/2003 and IBM AIX version 4.3 and 5.3.
• Provided backup and Recovery using Oracle Recovery Manager API to tape and disk.
• Provided instance creation for various UNIX and Windows based Application.
• Provided Security Administration and provided AIX administration.
• Created volume groups, allocate disk space; provide monitoring of the AIX systems via crons and Tivoli Maestro Scheduler and Monitoring Suite.
• Developed scripts to automate administrative functions (Korn Shell etc.) Develop and Document Standard Operating Procedures.
• Facilitated and take direct responsibility for planning, installation, configuration and deployment of AIX based server(s).
• Provided project support for configuring, installing and developing new UNIX based software solutions.
• Provided guidance and training for junior staff to develop them as full system administrators.
• Provided support for development groups on Confidential UNIX servers.
• Performed Oracle backup and recovery using Tivoli Storage Manager ADSM, BMC SQL Backtrack, and VERITAS Netbackup.
• Performed Oracle Performance Tuning and performed oracle migration in test environment from 8i/9i to 10gR1.
• Provided database administration to PeopleSoft Database environment

Confidential, Cary, NC

Technical Support Engineer

Responsibilities:

• Provided Windows, Citrix, and Oracle technical support and training for various States, Counties and Federal Government in support of The National Voter Rights Act and Help America Voters Act.
• Provided database configuration for Oracle/SQL servers and provided system configuration for DELL Power Edge Servers.
• Provided connectivity solutions in support of software application.
• Maintained support - tracking software for internal and external customers.
• Configured network diagrams using Visio 2000.
• Provided tech support for development environment for Oracle 10g.