SKILL SUMMARY:

VMS

Oracle V6,7,8,8i,9i,10g, 11R2

Manufacturing, Government

Unix AIX, Solaris, Redhat, SUSE, HP/UX

Insurance

MVS

Government

Windows NT40, 2000, 2003

Communications

Printing

Languages

Hardware

Documentation

SQL, PL/SQL, Dynamic SQL

DDL

Sun Microsystems

Requirement documents

Perl

Python

IBM RS6000

Functional specifications

Unix Shells

DEC

System test plans

Unix Utilities

IBM/PC’s

Work Plans

SAS

IRWIN

TOAD

HP9000’s

ANSI C, ProC

IBM390/Amdahl - P690’s

Sql/Forms 3.0, 4.5

Dell Servers

EMPLOYMENT:

Confidential, North Dakota

Database Administrator

Responsibilities:

• Under general direction from the project PMO serve as Confidential in-house liaison to North Dakota Oracle and Unix administrators.
• Ensure proper source code promotion and distribution across both Confidential and North Dakota environments.
• Assist in troubleshooting both Confidential and North Dakota Oracle and Unix related issues.
• Participate in group meetings and meetings involving setup and usage of the Datical code promotion system.
• Assist developers with programing issues relating to Oracle.
• Assisted developer with connection issues regarding Oracle. Monitoring with OEM/Grid, TKPROF, AWR, ADDM. SqlLoader, Datapump, shell scripting (BASH, KSH), partitioning, DBMS STATS and migration of SQL Plans across instances.

Confidential, Texas

Database Administrator/Data Analyst/Engineer

Responsibilities:

• Under general direction from the Projects owners, Project Manager and Information Management provide administration support on Oracle RAC and WebLogic for IT operations located offsite data centers.
• Provide coding, guidance and peer review of user developed conversion scripts regarding
• The Maven TB/STD/HIV projects. Parsing XML and CSV files for developers as needed.
• Creating dynamic SQL DDL scripting. Created API Array loading scripting supporting very large file loads.

Confidential

Database Administrator/Engineer

Responsibilities:

• Information Chief and later the Data Administration Unit supervisor, provide second and third level support for development and production instances of Oracle.
• Duties included SQL tuning, logminer, database replication, roles, views, code promotions, connection issues, general troubleshooting, meetings, and small projects. Interacted with project and group managers as required.
• Load Excel from and to Oracle.

Confidential, Texas

Database Administrator/Engineer

Responsibilities:

• Served as acting expert/advisor and database Administrator on the Oracle product suit for the departments Windows and Linux Oracle databases to upper Management. Closely interacted with management to achieve project goals while interacting closely with IT staff, program staff, other state departments, federal agencies and third party vendors.
• Database consolidation, migration, patching, recovery, production disaster recovery for (PEPAMS), replication with RMAN, TDE exports.
• Failover using dataguard.
• OEM install, management and rule setup.
• Generated the Daily Oracle Reports.
• Installed Oracle Advanced Security. Installed and reported on database auditing exceptions to management.
• Provided advice on RAC setup, resource estimates and subsequent budget cost savings.
• Worked with Confidential Cloud engineers on code promotion and recoveries.
• Attended seminars on Oracle ExaData, ExaLogic, Database security (Oracle). Attended OUGD Austin load balancing with RAC.
• Architected the CMDB schema for DSHS management for web based inventory management. Attended Oracle conference on Data masking with OEM 12C. Off hours support.

Confidential, Chicago, IL

Database Administrator/Engineer

Responsibilities:

• Involved in all phases relating to database operation and administration including remote administration of Oracle databases in a highly FDA, ISO9000 and EMEA regulated environment. Architected environments along with there consuming and feeder applications.
• Performed multiple database migrations from windows to HP open VMS. Performed disaster recoveries for production databases.
• Applied database patches when required.
• Built monitors regarding database security.
• Built windows based databases for the re-agent system in Europe.
• Install configured and maintained RMAN backups and scheduler.
• Created complex Sql queries, triggers, functions and procedures.
• Monitored databases for inefficient SQL, locking and disk hotspots.
• Assisted end users with sql tuning and test database systems migration and setup.
• Migrated Qim’s system to new version and new database server.
• Answered all questions regarding Oracle and it tool set.
• Knowledge transfer through presentations, written documents and meetings.
• Aided developers in debugging C, Java and SQl. Created/re-wrote process flow programs.
• Utilized logminer for answers to questions regarding data.
• Installed and examined Oracle Auditing for questions regarding database security/schema monitoring.
• Performed schema migrations between promotional models.
• Served as backup/standby administrator for ADDWI data-warehouse.
• Exports, schema migration, etc.

Confidential, Madison, WI

Database Administrator

Responsibilities:

• Involved in all phases relating to database administration.
• Actively participated in database recovery operations on the primary 3.2 Terra-byte database performing table recovery using RMAN and non-in-place tablespace recovery methods.
• Database replication using RMAN.
• Troubleshoot performance issues surrounding the 9i to 10g upgrade.
• Performed Database migration between Unix Servers.
• Developed and installed backup and recovery strategy using RMAN.
• Created traning databases via RMAN cloning.
• Migrated 9i database to 10g database and applied patches according to recommendations from Oracle.
• Tuned SQL scripts. Wrote PL/Sql packages when necessary.
• Debugged or created Unix shell scripts, Perl, Pro/C, SQL and DOS batch scripts.
• Rebuild indexes when required.
• Monitored eight production databases the largest being 3.2 Terra-byte data warehouse.
• Participated in weekly rotation for nightly weekly load process.
• This account required no on-call.
• Communicated to upper management regarding disk quotes and supplied future sizing requirements.
• Installed 10.2 Oracle environment and databases and patches on Sun Solaris 10 using ZFS zones with Unix Admins.
• Installed CA ARCserve Backup agent for Unix and connected to the ARCserve backup database for RMAN backup and recoveries. FTP, SSH, SCP, telnet, VPN and remote desktop client. Provided normalization support and training to local staff.

Confidential, Cedar Rapids, IA

Team Lead, Oracle Database Administrator

Responsibilities:

• Involved in all phases relating to database administration, unit management and Oracle/Tools licensing.
• Supported sixty plus Oracle instances on HPUX, Windows 2000 and Redhat Linux for Oracle versions 7.3.4.2 to 10g and ranging from 50 to 850 gigabytes in size with four other DBA’s. One hundred plus developers and third party developers and upper management supported both locally and remotely.
• Participated in on-call rotation. Participated in major rollouts and planning meetings using project and excel as monitoring vehicles.
• Installed, applied database patches, metalink administrator for APAC, create tars and researched patch applications.
• Installed new instances and or cloned existing instances. Planned and monitored transition of backups from scripts to RMAN where applicable.
• Directly involved in all recoveries for Oracle databases. Supported database failover by transporting archivelogs to readonly instance.
• Actively participate in management emergency ‘ALL HANDS ALERTS’ conference calls.
• Conducted security audits and was primary contact for Sarbanes-Oxley audit.
• Worked closely with application managers in defining requirements and database expectations.
• Directly involved in database performance issues.
• Directly involved in disk, network, hardware and other capacity issues.
• I reported directly to Vice President Technical Services, Confidential .

Confidential, Nashville, Tennessee

Information System Consultant

Responsibilities:

• Responsible for the EPIC/ICON EIM translation Pl/Sql written package, a corner stone for automobile production at the Smyrna Tennessee and Canton Mississippi plants. EIM translation provided information to Scheduling, Volume constraints, Inventory control,
• Specification Check and Bill of Materials.
• Additional responsibilities included the data loading and archiving of data for the OneView Reporting package, the Volume/Capacity and auto test builds extracts to Nissan Corporate America.
• Table replication through the use of DBMS SNAPSHOTS. Designed, setup and tested.
• PL/Sql Bulk fetches, array processing and Dynamic Sql for inserts.
• Dynamic Sql for performance index replication.
• Table, index, database links and snapshot creation.
• Source control via Source/Safe.
• Sql tuning, database tuning.
• Assisted other developers in designing and writing PL/Sql and Sql.
• Assisted database administrators with creation and maintaining partition table and index tablespaces.
• Direct loads, no logging parallel inserts

Confidential, Middleton, Wisconsin

Database Tools and Language Specialist/DBA

Responsibilities:

• Serve as physical database administrator for production, development, data warehouse, training, and Forecast21 databases (Oracle 7.3.4 - 8.1.7 ). Perform as administrator for Oracle Applications version 10.7SC. Schedule and perform monthly weekend maintenance activities, applied RDBMS and client patches. Monitored RDBMS performance with OEM, CA’s Platinum and Quest Software SQLDBA/StealthCollect.
• Sized and determined object placement for the Order Management System (OMS). A 240 gigabyte database.
• Monitored Oracle’s concurrent managers for Oracle Applications 10.7SC.
• Installed PL/Sql packages, functions, and stored procedures.
• Created or modified database triggers for OMS.
• Participate in on-call rotation for after-hours support.
• Acted as second level support for application developers, managers and intelligent end users.
• Created customized Oracle Terminal Key Mapping for character-based terminals supporting the online Catalog Order Management System.
• Created training database system allowing trainers to independently perform their own remote site database refreshes, including modules for source control delivery and notification of success or failure.
• Applied database software patches and ERP patches for 10sc using Oracle Client Configuration Manager (OCCM) and Microsoft's SMS.
• Applied RDBMS patches.
• Selected, evaluated, and set up developer tools for programming groups.
• Identified and tuned offending SQL code for the OMS, Confidential Warehouse Management System (PWMS), and Forecast21 mission-critical production databases.
• Created source control delivery system for production and development code utilizing the Merant PVCS as a core component.
• Installed and maintained Microsoft NT40 Oracle 8.0.6 database for telephone tracking.
• Migrated Forecast21 a 7.3.2 database from NT to Unix 7.3.4.3. Migration included extensive modifications of code tree for the UNIX operating system.
• Performed subsequent migrations of Forecast21 from 7.3.4.3 to 8.0.5.0, and later to 8.1.7.0.
• Migrated test, Forecast21 and monitoring databases from the Sun E450’s to Sun E420’s. Migration included setup of oraclehome, oratab, tnsnames and listeners. Required renaming datafile to the new directory structure.
• Created database-testing area for OMS, PWMS E-Commerce.
• Initial investigation into Apache as prep work to Oracle 11I upgrade.
• Integrated Apache listeners into automated database startup/shutdown shell scripts.
• Worked closely with UNIX administrators to protect corporate data by creating a Recovery Manager (RMAN) backup and recovery catalog for Confidential Production, E - Commerce, and Development Systems. Required extensive customized scripting for RMAN to in corporate it into existing scripts for the Veritas Enterprise Backup Utility and Oracle s EBU enterprise backup utility.
• Created test databases for Forecast21 and E-Commerce teams via replication from RMAN backups.
• Created and enhanced NT Bat file scripting to support Oracle s tnsnames replication across NT servers.
• Created scripts to assist in downsizing and purging information from the production databases for both OMS and PWMS.
• Created automated process for nightly rebuild of Oracle index structures.
• Assisted UNIX administrators in migrating tape the Automatic Tape Library (ATL) multiple masters/clients to single master multiple clients, effectively increasing capacity from 54 tapes to 540 tapes.
• Aided with Perl upgrade 5.002 to 5.6 including the DBI module for Oracle.
• Maintained DBA scripting directories and Oracle s tnsnames across 20 Sun servers.
• Datafile reorg s performed with import/export and Confidential .

Confidential, Milwaukee, Wisconsin

Technical Consultant

Responsibilities:

• Provided Oracle software solutions to clients of this firm. Areas of expertise were Client/Server Oracle and the Oracle tool sets. Assignments included;
• Master Lock corporation where I coded PL/Sql functions and procedures in support of there customized Order Entry System to Oracle Applications 10.7 Order Entry Module. Required knowledge of VMS/DCL, Oracle Applications and the Oracle tool set.
• Runzheimer Intl., worked with a team to develop a high-level project plan to convert the companies NT Sql/Server6.5 database to an NT Oracle 7.3.4 database. Data migration, database setup, backup, license and equipment cost and deployment across the organization were planned.