EXPERIENCE SUMMARY:

An experienced Information Systems Professional skilled in formulating automation solutions, interacting effectively with business customers, third party software vendors and data processing team members for over fifteen years.

TECHNICAL SKILLS:

Languages: Oracle V6, V7, 8, 8i, 9, 10G, 11g SQL Server 6.5, 7, 2000

Operating Systems: UNIX, (AIX, ATT Unix, HP Unix, Sun/Solaris Unix, Dec Unix) Microsoft Windows, Novell Netware, Digital Apha Open VMS.

Ancillary Skills: Oracle RAC, OCFS2, ASM, Grid Control, Data Guard, Oracle Advanced Replication, Oracle Transparent Gateways for SQL Server, IMS and DB2, Netscape Application Web Server, Oracle Application/Web Server, Oracle Clinical 3.11/3.2/4.0 , Oracle Financials and Manufacturing 10.X and 11i, Documentum, Citrix, MS SQL Server.; Desktop tools S - Designer, ER*WIN, Brio Query, Sas, Business Objects, and Data Junction, PeopleSoft, Confidential Banner, Oracle Application Server 9i.

WORK EXPERIENCE:

Oracle Database Architect

Confidential

Responsibilities:

• Implement Federated Data Warehouse Solution using Oracle, Netezza, Sybase and DB2 Federation Server.
• Install and configure DB2 Federated Server on AIX and Windows platforms.
• Design access utilizing wrappers to different disparate data sources. (relational and non relational.)
• Tune, Troubleshoot technical issues as they arise.

Confidential

Senior Oracle DBA

Responsibilities:

• Support Oracle 9i upgrades, supporting four Data Guard standby instances, (one for recovery (local), one instance at Confidential (remote recovery) and two for reporting.).
• Responsible for tuning, running AWR, ASH reports, sql traces, catching the bad sql that pops up in production and in our QA environment/and tuning it. supporting developers, releasing code to production, qa and test. (not in that order.)
• Working on migrating to 10g, 64 bit platform (windows) we have starting upgrading our lower environments, have also installed 11g, our grid control repository is using ASM 11g.
• Involved in planning 3Q next year migration to RAC - destructive system testing/ plans and TAF testing/ plans.
• Environment is a 4g SGA, 300-500 daily concurrent users a across the county on a Windows 32 bit system, its a Heathcare system that Doctors and Hospitals use for clinical information and billing.

Confidential

Senior Oracle DBA

Responsibilities:

• Supported the following Document Technologies, Documentum, Orchestria and Calligo.
• Tune, troubleshoot, set up new environments, upgrade, performance tuning activities as needed.
• Monitor database performance issues in Oracle Grid Control, using AWR, ASH and ADDM reporting to examine top performance issues and top poor performing queries.
• Implemented Confidential solution for an online reporting database for one environment.

Confidential, Windsor, CT

Oracle DBA

Responsibilities:

• 4 Terabyte E Business Oracle Applications environment. Primary responsibility OATM migrations, testing and releasing to production in phases.
• Tune and troubleshoot performance problems, installation and configuration of patches to all environments.
• Clone Oracle Applications environments as needed to support testing activities.
• Investigate Data Guard Solution for reporting environment.

Confidential, Hartford, CT

Senior Oracle DBA Consultant

Responsibilities:

• Support Oracle 9i 4 terabyte OLTP Claims database release process, tuning and troubleshooting performance issues on a daily basis.
• Cover for Tech Team lead as needed. Manage the timely release schedule to dev, test and production environments, assisting developers with structured coding techniques.
• Ensure backup and nightly mirror split processes complete successfully. Implement a proactive weekly performance review process.
• Perform test database environment refreshes on demand.

Confidential, Bloomfield, CT

Senior Oracle DBA Consultant

Responsibilities:

• Project Management duties for Oracle 10g upgrades.
• Support Oracle in a production environment.
• Implement Grid control for all Oracle Databases.

Confidential, Hartford, CT

Senior Oracle DBA

Responsibilities:

• Implement/Support Oracle 10g Release 2 in a RAC environment using OCFS2 and ASM.
• Migrating Oracle Databases from stand alone to a RAC environment.
• Daylight Savings Time patching for all environments.
• Attended/completed Oracle Education RAC 2 for Administrators Training in January.
• Set up hot backups and automated database maintenance in a clustered database environment.
• Mentor junior DBA’s. Implement Grid Control for Enterprise monitoring solution. Install and configure Data Guard.

Confidential, Windsor, CT

Senior Oracle DBA

Responsibilities:

• Production Support DBA Data Warehouse Financial Service Application DBA and System DBA support, Oracle 9i. Support code release process in Dev, Test, QA and Production.
• Maintain schema changes in Oracle Designer. Troubleshoot and Tune long running queries.
• Database refreshes to support testing environments. Completed Project Management Training through George Washington University.

Confidential

Senior Oracle DBA

Responsibilities:

• Oracle Financials and Manufacturing upgrade from 11 to 11i.
• Support Confidential Banner production, test and development environments.
• Implement structured production release methodology and procedures.
• Modify Web configuration from static html pages to Listener Servlet configuration.
• Manage Banner upgrades in all environments.
• Assist developers with structured coding techniques.

Confidential

Oracle DBA Senior Consultant

Responsibilities:

• Production Support Claim IT.
• Assisted Developers in structured coding of SQL.
• Troubleshot, tuned, and monitored and released modifications and enhancements to development, test, training and production environments.
• Tuned SQL statements for performance.
• Off hours production support duties as required.
• Planned and executed upgrade of Oracle 8i to Oracle 9 for 1TB data warehouse.

Confidential

Oracle DBA Senior Consultant

Responsibilities:

• Oracle Database Administrator duties.
• Designed and Modeled a Hardware Inventory system utilizing ERWin and Oracle.
• Worked with Developers to tune their SQL statements.
• Installation and configuration of Oracle Rdbms production and test instances, including Oracle Replicated environments, MS SQL Server Transparent Gateways, Oracle, Documentum, Netscape Web servers, SQL Net Listener server and client.
• Database maintenance, forecasting hardware requirements, tuning and troubleshooting as required.
• Coordinated schedules external to Database group in order to maintain timely deliverables of projects.
• Implemented backup and recovery procedures and process for all instances.
• Supported Oracle Clinical and Sas, TMS customization and installation for validation database(s) and test database(s) in a fully replicated environment.
• Documented Oracle on Unix Standards and database/application startup and shutdown procedures.
• Modeled and prototyped/implemented a Hardware Inventory system utilizing ERWin and Oracle. Korn shell scripting for automation of database startup, shutdown, software installation, monitoring and maintenance.

Confidential

Database Manager

Responsibilities:

• Responsibilities included logical data model in S-Designer, and physical implementation of Data Warehouse.
• Capacity planning of Data Warehouse, which included data elements from the Student, Human Resource and Financial legacy systems.
• Worked with IS host system staff programmers to resolve and automate load programming issues, data cleansing.
• Led effort to evaluate and selection of front end query and reporting tool.
• Coordinated project deliverables across groups. (Mainframe feeds, desktop applications, Web Services).
• Maintained conceptual and physical data model for data warehouse effort.
• Defined and administered database security and standards.