SUMMARY:

• Systems consultant and Oracle database administration services.
• System support expertise in the areas of database backup/recovery, database migrations, risk analysis, high availability/database clustering, installation and upgrade of Oracle RDBMS and disaster recovery planning.
• Database configuration, performance tuning, query optimization, troubleshooting and monitoring.
• Database design and development expertise.

TECHNICAL SKILLS:

DBMS: Oracle, SQL Server, MySQL

Applications: PeopleSoft, Oracle Fusion Applications

Languages: C++, C#, MFC, .NET, SQL, PL/SQL, T - SQL, Perl, Python, UNIX Shells

Technologies: Oracle Clusterware, Automatic Storage Management (ASM), Oracle RAC, Oracle Cloud Control, Oracle Internet Directory (OID), Oracle Data Integrator (ODI), MongoDB

Operating Systems: Linux, Solaris, Windows

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA

Confidential, Richland, WA

Responsibilities:

• Part of a team that provides ongoing, day-to-day operational support of all Oracle databases in the company. This encompasses over 150 databases, running in a high availability and clustered environment (RAC).
• Perform Oracle kernel tuning and performance monitoring, space management, problem resolution, security management, backup and recovery services, and Oracle product software upgrades and migrations.
• Provide SQL code optimization services
• Provide technical guidance and consultation to both development staff and management regarding Oracle technologies.
• Key database resource on the successful migration of Peoplesoft applications to Linux from Solaris.
• Member of the team that successfully implemented Oracle Fusion Applications on site.
• Played a leadership role in migrating all Oracle databases from Solaris and Windows platforms onto a Linux based RAC cluster. The result was a large reduction in overhead costs, improved performance and increased availability.
• Developed a utility in C# that parses SQL code and then automatically generates objects and mappings within Oracle Data Integrator (ODI), Oracle’s data warehouse product. This utility was used to migrate over 4,500 legacy queries into ODI mappings and resulted in an estimated savings of at least 100% of labor costs for the project.
• Developed a self-service web application that allows developers to perform privileged and common development database operations themselves, but in a controlled, audited and delegated manner. This increased the database staff’s productivity by allowing them to concentrate on higher priority tasks.
• Built an application that notifies end-users that their database password is due to expire and provides a mechanism, via a web application, that allows them to manage their own database accounts and passwords.
• Developed an Oracle database performance monitoring and tuning product, in C++ and MFC, called OraInsight. This tool allows a very detailed view of an Oracle instance’s internals and provides an easy way to identify performance problems and bottlenecks.
• Built a credential management application called Keymaster that securely stores, administers and retrieves credentials in the form of usernames and passwords. Technologies used were C#, .NET RESTful WebAPI, cross-platform codebase written in C++ (Linux and Windows).

Senior Oracle DBA / PeopleSoft DBA

Confidential, Richland, WA

Responsibilities:

• Provided database administration support to all Oracle databases in the company.
• Acted as the Oracle knowledge expert to analysts and provided consultation on various technical topics related to the Oracle product set.
• Developed a scripting language and interpreter, called Data Transformation Language (DTL), that was specially designed to facilitate the transfer and transformation of data between disparate datasources. This tool is essentially an Extract, Transform, and Load (ETL) utility, in the form of a scripting language, and provides a way to implement any ETL process using the ease and flexibility afforded by a high level scripting language.

PeopleSoft DBA

Confidential

Responsibilities:

• Performed application upgrades (Tax Upgrades, Fix Packs, Service Packs) and PeopleTools upgrades as required.
• Provided installation services as required, including WebLogic, Tuxedo, PeopleTools and new Application Modules.
• Configured, diagnosed and tuned the core PeopleSoft infrastructure (WebLogic, Tuxedo, Application Server, Process Scheduler)
• Provided configuration control support by migrating all projects from the QA environment to the production environment and generating and running all scripts that build database objects.
• Developed a PeopleSoft monitoring utility in C++, called PSInsight, that monitors and diagnoses the overall health and status of the PeopleSoft application framework. It ties all tiers of the PeopleSoft infrastructure together (Web, Tuxedo, application server, process scheduler and the database), and presents a unified picture of the health of the application and gives a complete picture of all processing occurring on the system

Oracle DBA

Confidential, Seattle, WA

Responsibilities:

• Provided production and operations database support in a distributed, n-tier environment. DCAC is a very large, 7x24 environment with 30 production databases and over 250 test and development databases. Duties included: Performance monitoring and tuning, space management, problem resolution, security management, Oracle product software upgrades and migrations, and architecture consultation.
• Regularly built new database environments. This included installation and configuration of product software, creation of database instances, and loading of source data.
• Collaborated with developers on database design issues, such as design of database objects, performance issues and PL/SQL coding.

Senior Oracle Database Consultant

Confidential, Dallas, TX

Responsibilities:

• Provided production Oracle database support in a 20 instance environment, with total disk space in the multi-terabyte range. Duties included installation and configuration of product software, performance monitoring and tuning, database reorganization, backup and recovery operations, security management, database problem resolution and capacity planning.
• Successfully migrated a large Oracle data-warehouse from an OpenVMS platform to HP/UX.
• Re-engineered and re-configured an Oracle database that supports a critical credit card authorization system.
• Worked with the DBA team and developers to create database standards.
• Developed and implemented a comprehensive database monitoring system.
• Provided production Oracle database support.
• Managed multiple database instances supporting manufacturing and distribution operations.

Oracle DBA / Developer

Confidential, Sacramento, CA

Responsibilities:

• Participated in designing the system infrastructure, which is a highly secure, web-based solution that provides parolee information to over 600 local and state officials over the public internet.
• Installed and configured Oracle product software.
• Designed and implemented the physical database, created a backup and recovery mechanism, and developed a database loading process.
• Monitored and tuned at both the database instance and the application level.
• Developed a custom, multi-threaded database request broker in PRO*C to act as the link between the web server and the database.

Senior Developer

Confidential, Rancho Cordova, CA

Responsibilities:

• CMIS is a comprehensive system used to manage every aspect of correctional facility operations.
• Responsible for the overall design of the Sentence Adjustment (SA) and Release Date Calculation (RDC) applications.
• Developed the physical database and application design. This included coding stored procedures and developing database triggers.

Oracle DBA

Confidential, Olympia, WA

Responsibilities:

• Application and database performance tuning, troubleshooting database problems, implemented back-up and recovery procedures, developed and maintained database security, installed and configured Oracle software and other duties associated with the administration of an Oracle RDBMS.
• Developed logical and physical database designs using CASE tools to support structured development methodology.