SUMMARY

• A certified Oracle 7.x, 8, 8i, 9i, 10g,, 11g and 12c professional with over 25 years’ experience as a Database Administrator, focusing on database administration and information systems. Results oriented professional, with the ability to logically think through processes in a systematic way as to provide the best solutions.

TECHNICAL SKILLS

HARDWARE/SOFTWARE: Oracle 7.x, 8.x, 8i, 9i, 10gr2 RAC, 11g, 12c RAC, Oracle Enterprise Manager OEM 12c/13c, Sun Solaris 2.8, Microsoft - SQL Server, Oracle Forms, HP/UX 11, LINUX, Microsoft Windows NT, Sybase, and IBM AIX. Relational Database Design and Data Modeling, Oracle Designer, Oracle E-Business Suite, Networking communications, Oracle Exadata, Operating Systems, Architecture Case and GUI tools, Information Systems, Database administration and ERWIN case tools. Extensive experience with designing and implementing Oracle databases, including systems architect, project management, data warehouse design, implementation and tuning, Oracle SQL tuning, and tuning of very large Oracle databases.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle - Consultant

Responsibilities:

• Set up database monitoring using OEM Version 13c.
• Oracle 11g/12c, RAC Architecture, Configuration, and Administration.
• Excellent troubleshooting skills for performance issues.
• Oracle DataGuard across multi - data oracle standby instances.
• Oracle database quarterly patching.
• Oracle Exadata and Oracle Data Guard Broker/Golden Gate.
• SQL Tuning using Oracle SQL Tuning Advisor.

Confidential

Senior Oracle - Consultant

Responsibilities:

• Upgrading Primavera Release 7.0 to Release 16.2.0.0 on a Sun Solaris Release 5.8 environment. Migrate current Oracle environment 10.2.0.2 up to Oracle Release 12.1.0.2. Worked in all phases of migration and testing with the new releases of Oracle and Primavera.
• Supported Oracle’s PeopleSoft 9.2 instances on LINUX platforms.
• PL/SQL coding of Packages, Procedures, Functions, and Triggers.
• Set up database monitoring using OEM Version 12c.
• Oracle 11g/12c, RAC Architecture, Configuration, and Administration.
• Excellent troubleshooting skills for performance issues.
• Oracle DataGuard across multi-data oracle standby instances.
• Oracle database quarterly patching.
• Oracle Exadata and Oracle Data Guard Broker/Golden Gate.
• SQL Tuning using Oracle SQL Tuning Advisor.

Confidential

Senior Oracle / SYBASE / Database Administrator

Responsibilities:

• Administered all phases of database administration for various clients in an Oracle 12c, Oracle 11g, Oracle 10, Oracle 9, and Oracle 8 environments. PL/SQL coding of Packages, Procedures, Functions, and Triggers. SYBASE and MicroSoft SQLServer database administration support were part of my responsibilities.
• Migrated Kaplan University’s Oracle databases from AT&T to Amazon AWS. Transposed instances from AT&T via Amazon’s KBS environment and then up to Amazon’s RDS infrastructure. Set various servers using AWS console. Use of VPC (Amazon’s Virtual Private Cloud) also utilized.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Administered all phases of database administration in an Oracle 11g RAC environment.
• PL/SQL coding of Packages, Procedures, Functions, and Triggers
• Administered all phases of database administration in an Oracle 10g / 11g environment.
• Primary responsibilities include supporting an Oracle 10g (10.3) RAC DataMart for

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Administered all phases of database administration in an Oracle 10g /11g RAC and Oracle Data Guard environment.
• Primary responsibilities are the design, maintenance, tuning, security, and development of Oracle Applications.
• Working knowledge of the Oracle E-Business Suite (Release 11) which contains the Oracle Human Resources Management System.
• Administered database administration in a Microsoft SQLServer 7.0 environment.
• PL/SQL coding of Packages, Procedures, Functions, and Triggers.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Administered all phases of database administration in an Oracle 9i and 10.3 environments.
• Primary responsibilities are the design, maintenance, tuning, security, and administration of PeopleSoft Financials residing on AIX and LINUX.
• Additional responsibilities include supporting an Oracle 10g (10.3) RAC database for Equifax, Empire Blue Cross, SONY, Discover, and AstraZeneca.
• Performed tuning and optimization for database server.
• PL/SQL coding of Packages, Procedures, Functions, and Triggers.
• Installing and upgrading Oracle server and application tools.
• Allocating system storage and planning future storage requirements for the database.
• Creating primary database storage structures once developers have designed an application.
• Creating primary database objects (tables, views, and indexes) once the application designers have designed an application.
• Modifying the database structure as necessary, from information given by application developers.
• Enrolling users and maintaining system security.
• Ensuring compliance with Oracle licensing agreements.
• Controlling and monitoring user access to the database.
• Planning for backup and recovery of database information using RMAN.
• Maintaining archived data on appropriate storage devices.
• Management of object related features.
• Determination of LOB storage options.
• Assistance with RAID configuration.
• Determination of proper index strategy (normal, reverse, IOT, bitmapped)
• Education of Developers in Oracle features and their use.
• Management of distributed environments.
• Management of parallel server and parallel query.
• Determine and manage partitions and sub-partitions.
• Determine proper use of outlines and SQL profiles
• Create, manage and maintain resource groups.
• Create manage and maintain global temporary tables.
• Create and manage materialized views, summaries and snapshots.
• Monitoring and managing the automatic and dynamic sizing parameters.
• Monitoring and managing the automated UNDO
• Monitoring and tuning RAC environments, especially the cluster interconnect.
• Manage and maintain fine grained auditing (HIPPA/SOX requirements)
• Manage and maintain row level security
• Manage and maintain fine grained access controls.

Confidential

Lead Oracle Database Administrator

Responsibilities:

• Administered all phases of database administration in an Oracle 9i environment.
• Primary responsibility are the design, maintenance, tuning and administration of our data warehouse residing on Sun Solaris for decision support using Abinito ETL software, UNICA client selection, and Oracle Discover reporting applications.
• Schema design and modification changes for all database environments using ERWIN.
• Performed tuning and optimization for database and application server.
• Secondary responsibilities were for our Financial Systems running on Microsoft SQLServer.

Environment: Oracle 9.2.0.4, Oracle 10.1.0.2, Oracle Discover, Oracle Financials, Sun Solaris 2.8, Oracle Application Server 11.5, Abinito ETL, UNICA, Microsoft SQLServer 7.0, VERITAS, and Microsoft Windows NT