TECHNICAL
SUMMARY:

Senior Information Technology professional with over nineteen years of experience specializing in Oracle Database Administration and Development in Pharmaceutical, Insurance, Electronics, Logistics and Financial industries.

Databases:
Oracle 8i, 9i, 10g and 11g; SQL Server 2005; MS Access 2000/2003
Database Administration Tools:
Oracle Enterprise Manager (OEM), SQL Server Management Studio, Quest Toad, Quest Spotlight, SQL*Loader, RMAN, Export/Import including data pump, BR*Tools, Platinum Erwin, HP Open View, Manage-IT SQL Station, BMC Patrol, Savant Q-Tools
Applications:
SAP, Customer Rebates (CARS), Government Pricing (GP), Medicaid Rebates, Oracle Financials 10.4, Application Object Library, Interlink, Direct Response, and INet validated system
Languages:
SQL*Plus, PL/SQL, UNIX/Linux Shell Scripting, Transact SQL,
HTML, “C"
Operating Systems:
UNIX: HP-UX, IBM AIX and SUN Solaris; Linux;
Windows: NT, 2000, 2003
Software Packages:
IBM Clear Quest and Clear Case, MS Office, MS Outlook, PL/SQL Developer, Putty, SAP GUI, Service Desk, Visio, Remote Desktop, MKS Toolkit kshell emulation software, Lotus Notes, MS Project, HP Service Center, PC-Anywhere, Terminal Services, Autosys scheduling software
ETL Tools:
Informatica

PROFESSIONAL
EXPERIENCE:

Confidential, Chicago, IL
AVP / Oracle DBA August 2007 – Present

For a large insurance brokerage company, supporting all Oracle installations including 64-bit RAC and stand alone Oracle 9i and 10g databases. Databases reside on several platforms including: Linux, Sun Solaris and Windows 2003. Most of the databases are 64 bit utilizing partitioning and context options. RMAN is used throughout for backups and recovery. Major responsibilities include: applying database requests, performance tuning, design, assisting application development teams, Oracle installations, upgrades and applying critical patches. Mentoring junior DBAs by assisting them in all aspects of Oracle administration and support activities. Managing a group of six off-shore DBAs. Provided the off-shore group with all the documentation, SLAs, SDLC and other support guidelines. Hold weekly meetings and gathering status on all the activities performed and discussing all new objectives. Successfully migrated all of the support activities to the off-shore team. Involved in special projects: to automate several large refreshes, table statistics automation, modifying Linux profiles for easier support of multiple instances, migrating database from 9i to 10g. Utilizing additional features of Oracle 10g including flashback data architecture, data pump, ADDM and AWR reports. Migrating current storage to use Oracle’s ASM technology. Exploring best practices to utilize Data Guard and Standby databases. Sharing the on-call 24 by 7 support with other team members and the off-shore team. Supporting over 60 production databases ranging from 100GB to 2TB.

Confidential, Lisle, IL
Contractor / Oracle DBA April 2007 – August 2007

For a large electronics manufacturing company supporting all Oracle installations including SAP and non-SAP databases. Major responsibilities include: Oracle database installations, applying critical patches and bug fixes, working with Oracle stand-by databases, shell scripting, performance tuning, design and working with the development teams. On daily basis monitoring database growth, stand-by apply logs, deleted users lists and daily proactive scripts. Weekly activities include a refresh of the main SAP installation on to a development server, monitoring a variety of validation scripts. Other tasks include installing Oracle’s critical patch updates, periodic password changes, export/import jobs and business data warehouse growth reports. Participating in a 24x7 monthly support rotation. Environment consists of Oracle versions 10.2.0.3, 9.2.08 and 9.2.0.7, SAP, BR*Tools, SAP GUI, HP-UX 64 bit Unix and Windows 2003 servers. SAP database was over 3TB.

Confidential, Rosemont, IL
Oracle DBA October 2006 – April 2007

For a small Logistics company performing all Oracle Database Administration functions including: Oracle database installation, performance tuning, design, development, upgrades and critical patch installations. Working on special projects which involve all aspects of loading, processing and delivering the information to the clients. One special project involved building from scratch an Oracle database server by installing and configuring the operating system for the Windows 2003 server followed by installing and configuring an Oracle database. Performing hardware and software installation on Windows 2003 servers. Performing many development tasks including writing stored procedures, triggers and batch jobs on both Windows and Linux servers. Writing documentation and standard operating procedures as required. Working with SQL Server database using the Management Studio to look at the database structures and execute stored procedures. Environment consist of Oracle 10.2.0.2, Oracle Enterprise Manager Grid Control 10.2.0.3, SQL*Plus, PL/SQL, SQL Server 2005, Windows 2003, Linux 2.6.11 and Microsoft Office tools.

Confidential, Lake Forest, IL
Contractor / DBA April 2004 – September 2006

For a large Pharmaceutical Company, worked for the product management and compliance team. Performed all DBA duties including: database design, performance tuning, installation and upgrades, backup and recovery. Supported a large data warehouse as well as an OLTP validated system. Mentored and trained other DBAs on features, upgrades, tuning and other aspects of Oracle administration. Wrote Oracle stored procedures, functions, triggers as well as shell scripts. Design, analysis and development was performed utilizing the following tools and utilities: Oracle Enterprise Manager (OEM), Designer 2000, Erwin, PL/SQL Developer, SQL*Plus, MKS Toolkit and Visual SourceSafe all running on Oracle 8i, 9i and 10g instances on HP-UX Unix and Windows 2000/2003 hardware. All documentation was prepared using Microsoft Office tools.

Confidential, Lincolnshire, IL
Independent Consultant / DBA December 2002 – March 2004

For a medium sized Pharmaceutical Company, worked for Sales and Marketing department. Performed Data Warehousing and Transactional systems DBA functions that included: logical and physical design, installation, configuration and upgrades of Oracle instances, capacity planning, query analysis, tuning, backup and recovery. Collected statistics and analyzed instance performance using the Statspack utility. Wrote PL/SQL and UNIX shell scripts to automate manual processes. Enhanced the Data Warehousing monthly load by introducing and configuring parallel processing, which resulted in over fifty percent timesavings. Performed ETL transactions using Informatica scripts. Migrated Oracle instances between different hosts for the hardware replacement projects. Installed Oracle client and application software for the end-users. Prepared company standards and procedure documents. Working with Oracle instances 8.1.7.4 and 9.2.0.4. Data Warehousing hardware: HP-UX 11i connected to the EMC storage. OLTP applications resided on Windows 2000 and NT connected to Network Appliance (NetApp) storage. Using OEM 9.2, Erwin, Toad, SQL*Plus, PL/SQL, PL/SQL Developer, Export/Import, SQL*Loader, Informatica, Unix pipes, shell scripts, MKS Toolkit and MS Office suite. Data warehouse instance was over 1TB.

Confidential, Northbrook, IL
Independent Consultant / DBA October 1994 – December 2002

For a major Insurance Company performed Oracle DBA duties and responsibilities including physical design, capacity planning, tablespace creation, data reorganization, logical and physical backup and recovery, as well as, overall database and SQL tuning. Additionally provided applications support utilizing Oracle’s Advanced Replication, Unix shell scripting, audit trails, backup and recovery methods using export/import functionality, RMAN and HDS. Mentored and managed several junior DBAs as they were starting to perform administration work after several years of development. Oracle database versions 7.x, 8.x, 8i and 9i. Using Oracle DBA tools: OEM, SQL Station, BMC Patrol, Q Tools and Erwin for change management, monitoring and database design. Databases running on SUN/Solaris, IBM/AIX, Windows 2000/NT utilizing SAN and HDS storage technology. Supported an SAP Oracle instance as a backup DBA. The database was over 1.5 TB in size. Supported over 100 Oracle instances on different platforms.

For a major Insurance Company made customizations to the Oracle Financials modules including Inventory, Order Entry, Purchasing and Accounts Payable. Created PL/SQL scripts, Unix shell scripts, Packages, Procedures, Database Triggers, Menus, Messages, Alerts, Forms and many customizations using the Application Object Library. Worked with Oracle Financials 10.4.2 running on Oracle 7.3.4 and AIX UNIX 4.1.

Confidential, Chicago, IL
Senior Consultant / DBA September 1991 - October 1994

Responsible for all Oracle DBA activities including installing and configuring Oracle databases versions 6 and 7. Provided Infrastructure and field support. Developed Oracle Database applications using SQL*Plus, SQL*Forms and SQR Report Writer. Special projects included: development using DOS, UNIX, "C", dBASE IV, Microsoft Word, Excel and Lotus 1-2-3. Supported Human Resources, Finance and Payroll departments. Assisted in all phases of project development from design through implementation. Assisted in development of Remote Time and Expense system enabling users to download, enter and upload their time and expenses from any PC or portable outside the main Chicago office. Created a payroll file, which was used by a 3rdparty payroll vendor to issue overtime and reimbursements for TSC employees. Provided a link between UNIX and Lotus cc:Mail by importing new hire and terminated employee information from UNIX into cc:Mail. Enabled Finance department to receive a DOS flat file used to import Oracle Database\'s financial information into Lotus 1-2-3 or Excel.

Confidential, Wood Dale, IL
Business Analyst May 1990 - September 1991

Maintained and updated an Oracle Database which contained all merchant information. Produced monthly business reports on Yield, Charge-Off and Delinquency using the Oracle Database, Lotus 1-2-3, SQL*Plus and Oracle for 1-2-3. Handled special projects including analysis, design and coding for Senior Management. Served as an in-house Oracle technical resource.

Confidential, Wood Dale, IL
Programmer Analyst August 1989 - May 1990

Maintained and updated existing "C" and BASIC programs on MS DOS which were used by the lending department. Maintained the credit scoring system and wrote changes to the system in "C". Coded area code changes from 312 to 708 in "C". Coded Director program which enabled in-house processing of credit applications and transmittal to remote sites in "C" and BASIC.

EDUCATION:

Bachelor of Science in Commerce

Major: Finance
Minor: Computer Science
Honors: Dean\'s List, College of Commerce Dean\'s Award