OBJECTIVE:

A position in Database Administration or Development requiring proven analysis, creative and planning skills to ensure the safety and recoverability of corporate data.

SUMMARY:

Over fourteen year experience in Database Administration and Application Development.

EXPERTISE INCLUDES:

• Design
• Installation
• Recovery
• Configuration
• Tuning
• Creation
• Backup
• Load Process
• Documentation

TECHNICAL SKILLS:

Databases: Oracle 7.2, 7.3, 8.0.5, 8.1.5, 8.1.6, 8.1.7, 9.2,10.2.0.1,10.2.0.2, 11.1.0.6, 11.2.0.1, HTMLDB, Oracle Streams, RAC, Oracle9i Application Server, SQL Server 7.0, 2000, Access 97, 2000, Sybase Server 6.0, 8.0 for NT.

Languages: SQL, PL/SQL, Oracle Forms 4.5,6.i, 9i, Oracle Reports 3.0, 6i, 9i, Visual Basic 6.0, Oracle Portal 3.0, WEBDB 2.2, 2.1, Oracle WEB Toolkit, HTML, DHTML, XML, Java Script, VB Script, UNIX, Shell Script, Perl Script, Windows Script.

Development Environment: Oracle 10.7, 11i (Financial, Clinical), Oracle TMS, Server Manager, DBA Studio, RMAN, SQL* PLUS, SQL Developer, Erwin, TOAD, SQL Navigator, Reflection for Unix, Visual Studio 6.0 including Visual Interdev, PC Anywhere, Sybase SQL Anywhere 8, Oracle Application Express 4.1

Operating Systems: UNIX SUN (E450, E4500, E10K, Sun Fire 480R, Sun Fire V890), AIX, and HP - UX11i, Linux, Windows XP, NT, 2000, 2003 and DOS.

EXPERIENCE:

Confidential, Berwyn, PA

Senior Oracle DBA/ EPMR Admin

Responsibilities:

• Full installation, setup, backup and recovery, restoration, duplication, optimization, tuning and security enforcement of Oracle databases releases 10 and 11 RAC and standalone units.
• Full (24/7 x 365) DBA support for DIS (Data Integration & Standardization) department projects, tuning scripts and users statements.
• Transfer data between databases using Oracle datapump and export/import utility.
• Creating new PL/SQL packages, functions, procedures and other objects.
• Extensive implementation, management and deployment of Oracle Packages, Procedures, Function, Triggers, User Defined Types and Queuing mechanism.
• Trouble shooting database and user processes, fixed users error, optimize and improve existing database applications and database objects.
• Create documentations for validation of the new code. Administrating Internal Financial application (EPMR) and creating reports and enhancements from user’s requests.
• Creating new tables, triggers, procedures, functions and packages. Create jobs to refresh EPMR from Solomon System (Microsoft Dynamic) connecting MS SQL Server and Oracle Databases.
• Create data guard for software development team using Oracle 11g. Hands-on experience with Data Guard, ASM, OEM/Grid, RMAN, RAC and Oracle Streams.
• Involved in project to move production data to Oracle Exadata Database Machine.
• Backup databases using RMAN and UNIX shell scripts.

Confidential, Wayne, PA

Senior Oracle DBA / Application Developer

Responsibilities:

• Full (24/7 x 365) DBA support for DIS (Data Integration & Standardization) department projects, tuning scripts and users statements.
• Load data using SQL Loader called by SAS proc.
• Transfer data between databases using Oracle datapump and export/import utility.
• Creating new PL/SQL packages, functions, procedures and other objects.
• Create documentations for validation of the new code.
• Upgrade production database from SE to EE.
• Converting data to FDA accepting format (SDTM) using Oracle database and OWB.
• All client data files converting to SDTM model and sending back to client or FDA.
• All work and documentation complain with FDA regulation CFR 21 part 11.
• Creating new application for PM and finance.
• The application using Oracle on backend and Oracle Application Express as a front end.

Confidential, Horsham, PA

Senior Oracle DBA

Responsibilities:

• Working knowledge - hands-on experience with Data Guard, ASM, OEM/Grid, RMAN, and Oracle Streams. Experience in SQL tuning and or PL/SQL debugging/tuning. Experience working with Oracle Support Services to resolve issues and familiar with Oracle's escalation procedures to use as needed.
• Full (24/7 x 365) DBA support for 12 databases storing over 6 TB (6,000G) of data implementing on SUN Solaris, including 2 production OLTP databases (50G and 300G), and 2 production data warehouses (1,030G and 4,200G). Backup and Recovery - verification procedures using CommVault and Rman, DR exercise participation, restoring production databases on different machine. Perform 7 x 24 hour support on a rotation basis and wear a pager and / or blackberry device, standard setup, procedures and documentation.
• Installation and configuration of Oracle EM 10.2.0.1 and agents on Solaris 10 machine using 10.2.0.2 database as repository.
• Provide 24/7/365 primary support of all Oracle databases and related systems.
• DBA support for development process; table design as requested, trigger / procedure development, query tuning, DDL promotion process between environments - enhancement, enforcement, documentation. Monitor all database systems utilizing vendor supplied and standard tools.
• Ensure that all systems are backed up and monitored according to the business requirements and notify the data owners when there are failures.
• Ensure optimal resilience of deployed systems and meet all disaster recovery and compliance requirements dictated by the business.
• Upgrade databases from 9.2.0.5 to 10.2.0.1 and 10.2.0.2. Installed http server and htmldb on development and test environments with 3-month implementation in production.
• Installed software and upgraded databases from 10.2.0.1 to 10.2.0.2.
• Create processes and jobs by users request using shell and perl scripts and PL/SQL packages, procedures and functions.
• Rebuild schemas to partition tables and indexes for easy manageability and performance.
• Tuning databases using init.ora parameter file and UNIX utilities.
• Tuning sql statements for developers using explain plan and tkprof utilities. Install and administrating Oracle Dataguard for production server.
• Install and move production data warehouse to ASM. Install Oracle software and created new production Oracle 11g databases (release 11gR2) on Linux.
• Migrating existing production Oracle 10gR2 databases on UNIX (San Solaris10) to Oracle 11gR2 to Linux. Install Oracle Enterprise Manager 11g and all agents on Linux.
• Create development environment using 11g option of duplicating from active database.

Confidential, Philadelphia, PA

Oracle Consultant

Responsibilities:

• Back end support for BUS application. Develop and tune Oracle procedures, functions, packages, and views for Blue Exchange project.
• The project used for marketing department to supply companies and individuals with new insurance quotes.
• Load data from flat files using SQL Loader utility and Unix shell scripts for government programs of Blue Exchange project.
• Create and administrate new data warehouse for management reporting systems.
• My responsibilities included but not limited to: tuning data warehouse implemented on SUN Solaris and using Oracle 9.2.0.5, tuning of SQL and PL / SQL.
• Synchronized data between OLTP and data warehouse.
• Create scripts, function and procedures for daily and monthly jobs.

Confidential, Langhorne, PA

Oracle Consultant / DBA

Responsibilities:

• Designed, developed, managed and implemented the Test Data Input System (TDIS) project for major Defense Company.
• Managed development and test process for the project.
• Test data, stored on special secure cartridges, plugged into special device to read data and create multiple flat data files, which could include BLOB Data and Timestamps with high-resolution requirements. My responsibilities included but not limited to: Managed development staff helped and trained users.
• Data Base design (logical and physical models) with constraints and indexes tuned to achieve strict performance requirements;
• Developed set of dynamic stored procedures to provide hi performance of data load and transfer between different databases;
• Wrote Unix/Windows batch/shell scripts to load data from flat files into Oracle 9i tables using SQL*Loader and stored procedures;
• Wrote ADHOC Reporting tool, by using Dynamic SQL and Oracle Reports 6i, to allow users to observe test results;
• Created Unix/Windows script/shell for backup and recovery processes;
• Performed tuning of many system processes including reports, SQL statements, load processes and procedures; g) Developed Unix/Windows batch/shell script to totally automate deployment of TDIS on any Unix/Window based machine within minutes.

Confidential, Blue Bell, PA

Oracle Developer / DBA

Responsibilities:

• Back end support for eVOC (Electronic Vocabularies) applications.
• Load MedDRA 7.0 (full and sequential files) into TMS (Thesaurus Management System).
• Help with tuning of Confidential specific queries and processes for MedDRA load. Help in upgrade process of TMS from version 4.0.3 to version 4.5.1.
• Wrote test plan for UTF-8 migration. Work on creation of the test plan and procedures for migration from Oracle 8.1.6 to Oracle 9.2.0.4 with RAC (Real Application Clusters) implemented on HP-UX9000.
• Develop scripts and packages to insert new services and subscribers.
• Created new shell scripts and fixed existing for External Client project.
• Created DBA scripts to analyze and compile objects.
• Create packages, functions, procedures and shell scripts to support existing and new application.
• Load data using SQL Loader, and load Java classes into Oracle account using loadjava procedure.
• Create java store procedures to transfer XML files.
• All work and documentation complain with FDA regulation CFR 21 part 11.

Confidential, King of Prussia, PA

Oracle Developer / Consultant

Responsibilities:

• Interviewed primary users in both locations; London UK, and King of Prussia US. Managed and administrated development staff involved in ICDS application. Transfer, convert and load data from different sources (flat files, CDs, clinical applications) into Oracle database.
• Create new system to download WHO Drug and MedDRA files using UNIX shell scripts, and SQL Loader. Work on migration database to Oracle 9i with Real Application Clusters.
• Transfer data from Sybase database into Oracle using Ascential DataStage 6.0. Administrate Oracle database on HP-UN machine.
• Create new users, tables, indexes, database triggers, packages, stored procedures and function.
• Created new tablespaces and migrate tables for decommissioning project.
• Wrote UNIX shell scripts to load files into Oracle from flat files using SQL Loader utility.
• Create reports that combine data from the dictionaries and Clinical Trial applications.
• Transfer XML files using java store procedures.
• Administrated NT Server, IIS Web Server, and Oracle 9i Application Server using remote tools like TOAD, PC Anywhere, Oracle WebDB 2.2, and Oracle Portal 3.0.
• ICDS application consists of Oracle Forms, Oracle Reports, WEBDB 2.2 and Oracle 9.2.0.4, ASP pages; Java stored procedures and VB 6.0 modules. Created documentation and physical files (text, Oracle export) for decommissioning of the old system and store the files in Electronic Data Archive (EDA). Build reporting system based on analysis from clinical trials. Reports outline all standards for adverse events and medications.
• Involved in business analyses for loading data into dictionaries from investigational drug studies. Created Migration Load Utility for load MedDRA and Drug into dictionaries.
• All work and documentation complain with FDA regulation CFR 21 part 11.

Confidential, Horsham, PA

Oracle Developer / Database Administrator

Responsibilities:

• Designed, configured and installed development and test Oracle database environments on Sun Solaris platforms for Confidential ’s projects.
• Designed logical and physical database, planned capacity, tuned performance, created tables and indexes, ensured database security, and loaded data into database tables from FLAM and ZIP files using SQL*Loader and Shell script.
• Designed, developed, tuned, installed and supported all objects on database and WEB for Neutral Control project.
• Member of DBA Group for 600GB Data Warehouse with Oracle Parallel Server. Coded, analyzed and converted existing reporting system from Cobol to the WEB using Oracle 8i database, WEBDB, Oracle Reports, Oracle Forms, ETL, SQL Loader, and shell scripts.
• Established and wrote the Database Administrators Procedures document for the IT department. This document outlines all standards for DBA group including installation of all objects, ETL processes for HV-AGM, TDP, MAXBLUE and other projects on test, and production Data Warehouse.
• Designed and developed several shell scripts, PL/SQL packages, procedures, functions, Oracle reports and WEB pages.