SUMMARY:

Oracle DBA (Database Administrator) Consultant who can “hit the ground running” in Confidential organization. I am looking forward to establishing myself as your most helpful and experienced DBA asset on your team.

SPECIALTIES:

I can integrate my vast technical and professional knowledge and experience into Confidential organization. Do you have major team projects, monitoring tasks, independent or remote positions? I’ve worked with them all And I can work with personalities within your organization, utilizing the teams, processes, and systems which are already in place, and enhance them to be the best in the business. I am looking forward to working with your team, projects, and building towards the future, starting right now.

PROFESSIONAL EXPERIENCE:

Sr. Oracle DBA

Confidential, Brentwood, TN

Responsibilities:

• Senior Oracle DBA part of small team managing over 100 Oracle databases
• Oracle Databases 12c and 11g (R1 and R2) on RAC with ASM, and on file systems on UNIX (HP, Solaris, IBM/AIX) and Linux
• Establishing and standardizing OEM Cloud Control (version 12 and 13) monitors and thresholds and procedures for all DBs
• Assisted with GoldenGate management and replication to and from Oracle and other databases, such as DB2, mainframe, MSSQL, MySQL, etc.
• Writing and implementing scripts supplementing all DB and O/S monitors using crontab and shell and SQL scripts
• Working with application and infrastructure teams during all implementation phases

Oracle Databases interfacing with other database systems: MS SQL, IBM DB2, MySQL, Postgres, Informatica

Application System Engineer

Confidential

Responsibilities:

• Application System Engineer consultant for Confidential, assigned to Confidential
• Oracle database versions from 11g to 12c, including migrating from each of these to newer versions and other platforms
• Working with multiple application teams on integration and migration projects
• Primary project focused on migrating to Exadata environment from traditional Linux/UNIX systems using GoldenGate, Export/Import, and DataGuard
• Added new application functionality incorporating original SQL Loader and other scripts
• ETL subsystems included GoldenGate processes in addition to SQL and PL/SQL

Oracle DBA Consultant

Confidential

Responsibilities:

• Migrating Banner ODS DB to new Banner ODS 9.0 ETL tool
• Multiple dynamic O/S and SQL scripts created for migration effort
• Installed Oracle 12c R2 on Solaris using silent response file scripts
• Worked with UNIX admin team to install Java 1.8 for server
• Installed Oracle ODI 12.2.1 with Weblogic Fusion Middleware
• Migrated Production Banner ODS DB to 12c R2 Banner ODS DB new server using export/import datapump
• Working with application team to link Banner ODS DB to Banner DB source
• Documentation and status communicated regularly

Oracle DBA Consultant

Confidential

Responsibilities:

• Senior Oracle DBA remote consultant support team managing multiple client Oracle databases for multiple clients
• Databases versions are 12c, 11g, and legacy versions 7 through 9 on RAC with ASM and file systems, on Windows, Linux and Oracle Database Appliance
• Oracle Databases primarily supporting JD Edwards application projects and clients
• Primarily Technical JDE, not Functional, but interact directly with technical teams for implementation
• Upgraded and migrated various platforms and versions of Oracle and JDE
• Interacted and coordinated with multiple company development teams and projects for Oracle deployments.
• Designed standard monitoring for managing databases through DBconsole, EM Cloud Control 12c, custom scripts, and logging directly into DB servers.
• Implemented, resolved issues, and managed RMAN and custom backup solutions for all databases, including EMC Avamar and Tierpoint eVault.
• Successfully restored and refreshed multiple development and test databases and application schemas through RMAN Duplicate Database "clones" and EXPORT/IMPORT (datapump and also traditional) processes.
• Established and managed database links and user grants for application access.
• Database upgrades and installations coordinated and performed personally.

Senior Oracle L3 DBA Consultant

Confidential, Deerfield, IL

Responsibilities:

• Senior Oracle DBA Level 3 consultant for Confidential Global, assigned to Confidential corporate office
• Member of team of 8 DBAs managing over 1000 Oracle databases.
• On - call DBA for production and other critical issues.
• Databases versions 12c, 11g, 10g, 9i on RAC with ASM and file systems, on AIX, Solaris, Linux and Oracle Database Appliance .
• Multiple DBs upgraded on AIX, Solaris, and ODA from 11g to 12c.
• ODA grid infrastructure and DBs upgraded from 11g to 12c using oakcli and manual methods
• Interfaced and coordinated with various development teams and projects for Oracle deployments.
• Managed databases through OEM 12c and logging directly into DB servers.
• Implemented and managed RMAN backup solutions for all databases.
• Refreshed multiple development and test databases and application schemas through RMAN clones and EXPORT/IMPORT processes.
• Established and managed user grants and synonyms for application access.
• Database upgrades and migrations coordinated and performed personally.

Senior Oracle DBA Consultant

Confidential, Nashville/Franklin, TN

Responsibilities:

• Senior Oracle DBA consultant for Confidential, assigned to Confidential and Confidential Business Solutions
• Member of small team managing over 100 Oracle databases for all aspects of hospital management for Confidential and software development at Confidential
• Databases and Oracle clients include 12c, 11g, 10g, on RAC with ASM, and single instances on file systems, on both IBM AIX and Redhat Linux .
• Established and maintained monitoring and alerting systems with Oracle Grid Control and writing custom shell scripts. This included setting monitoring templates and thresholds throughout the organization.
• Enhanced business teams and development teams through design and implementation sessions, with performance tuning throughout the software lifetime.
• Scripts and administration duties encompassed upgrades, RMAN backup and restore, Flashback, data migration, table and partition redefinition, multiple deployments throughout the organizations and databases, with zero to minimal down-time.
• Mentored and assisted all Oracle DBAs, including off-shore and novice team members in standardization and professional communication skills. This includes interaction within the DBA team, and also with client support and development teams.

Senior Oracle DBA Consultant

Confidential, Brentwood, TN

Responsibilities:

• Senior Oracle DBA consultant for Confidential, assigned to Confidential, a subsidiary of Confidential
• Managing the Oracle databases on IBM AIX, Sun Solaris SPARC, and Windows.
• Listener log file automated shrink and archive process established - ensured size of log file would not hinder connection attempts
• EMC NetWorker Module for Oracle (NMO) installed, configured - allowing RMAN backups interfacing with EMC storage
• Standardized backups across all Oracle databases, including RMAN configurations, and export datapump processes.
• Managed and migrated Oracle Enterprise Manager dbconsole monitoring, password changes, and jobs.
• Primary DBA on database migrations to new corporate O/S platforms - from Windows and Solaris to AIX
• Assisted with ETL systems interacting with Oracle and SQLserver and DB2 databases.
• Expert in troubleshooting and refinement of shell and SQL/PLSQL scripts - plus RMAN and EM dbconsole job scripts
• Managed Upgrades and Patching from 9i, through 10g, and on to 11gR2 and latest Oracle PSU and CPU patches, including establishing critical modifications for security: laying out the pathways for product lifecycle, from Design/Conception, through Development, implementation in UAT, and coordination into Production
• Database Architect and Designer for Data Warehouse and Core Repository, along with multiple staging schemas.
• Designing and implementing methodology for scripting without passwords, using O/S-based user security

Senior Oracle DBA Consultant

Confidential, Nashville, TN

Responsibilities:

• Senior Oracle DBA consultant for Confidential, assigned to Confidential, also known as Ingram Book Company
• One of a small team of Oracle DBAs handling 14 Oracle databases on Linux, on RAC and standalone configurations, as well as Grid Control and RMAN catalog repository
• This includes all of the Ingram Content "iPage" Oracle Text searches, Sterling EDI transaction system, Oracle Financials, VoiceCollect application, and TIBCO.
• Migrated all Oracle monitoring and cron jobs to Grid Control (OEM) without issues
• Expert in troubleshooting and refinement of shell and SQL/PLSQL scripts
• Primary Oracle DBA on RMAN configurations and setup
• Supported Oracle GoldenGate environments as secondary support.
• Managed ETL on IBM InfoSphere (and old DataJoiner) Replication server on DB2 Linux and Windows for replication processes between DB2/UDB, MS-SQL, and Oracle databases
• Handled Ingram’s Disaster Recovery for Oracle Databases

Senior Oracle DBA Consultant

Confidential, Austin, TX

Responsibilities:

• Senior Oracle DBA consultant for Confidential, assigned to Confidential - Confidential
• Confidential managing the electrical grid for the State of Texas
• Primary DBA in charge of several 24x7 real-time production databases from 9i through 10.2.0.4
• Backups and recoveries handled through RMAN and Grid Control
• Handled performance tuning and ongoing maintenance
• Designed source code, development, and management scripts (UNIX shell and PL/SQL)
• Assisted in coordinating layout of data to Data Warehouse (ODS)
• Worked closely with GoldenGate and Data Warehouse teams and infrastructure.
• Installed, administered, and upgraded Oracle 10g on HPUX and AIX
• DBA handling migration to IBM AIX from HPUX
• Analyzed and coordinated systems using Spotlight, Toad, DBArtisan, OEM Console, CRON
• Expert shell, SQL, and PL/SQL coding

Senior Oracle DBA Consultant

Confidential, Nashville, TN

Responsibilities:

• Senior Oracle DBA consultant for Confidential, assigned to Confidential, a subsidiary of Confidential
• Broadcast music recognition enterprise system across USA
• 25 terabyte (TB) clustered database storing audio BLOB data and metadata data warehouse
• Installed, administered, and upgraded all Oracle 10g (10.2.0.3) RAC on LINUX using Oracle ASM
• Administered Oracle EM dbconsole and Grid Control
• Designed and implemented RMAN backup and recovery procedures
• Wrote UNIX shell scripts for DBA procedures and scheduled in cron
• Assisted developers with PL/SQL coding, programming, and database migration & implementation
• Utilized ERWin, DBArtisan, DBVisualizer, and SQL Developer

Senior Banner Oracle DBA Consultant

Confidential, Nashville, TN

Responsibilities:

• Senior Banner Oracle DBA consultant for Confidential Worldwide, assigned as Confidential DBA for Tennessee Board of Regents schools
• Primary Oracle DBA and Solaris UNIX mentor, managing 19 campus data centers across Tennessee
• Campuses including Memphis, MTSU, East TN State, TN Board of Regents office and others
• Each campus actively utilized 7-12 separate databases - total of 200 DB - over 2 terabytes total
• Installed, administered, and upgraded all Oracle 9i (9.2.0.6) DB & Oracle 10g AS (9.0.4) Application
• Supported, patched, and upgraded Confidential Banner 7.2 - Complete Higher Education ERP
• Mentor for all campus technical staff - they had no prior experience in Oracle or UNIX
• Designed, wrote, and implemented all RMAN backup and recovery procedures
• Wrote UNIX shell scripts and PL/SQL scripts for DBA procedures and scheduled in cron