SUMMARY
Oracle Database Administrator with over fourteen years of experience developing, maintaining, and supporting Oracle Databases in the Pharmaceutical, Manufacturing, & Software Industries. Five years of experience supporting SQL Server Databases. High effectiveness collaborating with Computer Operations, AIX/Linux/UNIX/Windows System Administrators, Developers, End Users, and Vendors to successfully design, test, and implement Applications into Test and Production Environments. Highly skilled in Installing/Upgrading/Patching Oracle software, creating Databases/Oracle objects, Designing/Testing Backup/Recovery, and Performance Tuning of SQL and Database Instances. Maintained SAP databases comprising of SAP R/3. Result driven, self starter, and multi-tasker with minimal direction. Strong communication skills.

Oracle 11g (11.2.0), Oracle 10g (10.2.0.4), Oracle9i (9.2.0.6, 9.2.0.4), Oracle8i (8.1.5, 8.1.6), Oracle8 (8.0.5, 8.0.6), Oracle7 (7.3.3, 7.3.4), SQL Server (7,2000)

SQL, SQL*PLUS, Import/Export, Data Pump, SQL*Loader, Data Guard, SQL*NET, NET8, SVRMGR, UNIX – HP/Solaris/Linux/AIX, Explain Plan, Autotrace, Utlbstat/Utlestat, Quest Software SpaceManager 6.2.1, Idera SQL Diagnostic Manager 4.6.8, Windows NT,Backup/Recovery, Installation/Upgrades/Patches, Performance and Tuning, Security, Oracle Enterprise Manager, RMAN, SQL Server Enterprise Manager, SAPDBA, BRTOOLS, Disaster Recovery Planning and Testing, Physical/Logical Design, Sarbanes - Oxley Compliance, Ticketing – Vantive/Remedy/ Gforge, SIR, TechAlert, Veritas

Confidential,White Plains, NY August 2009 – December 2010
Associate Project Manager July 2002 – December 2003

• Obtain financing for development of single and multi-family homes
• Interacted with municipalities to successfully acquire Building Permits
• Develop Blueprints and Site drawings for homes
• Coordinate selection of items to be included in customized modular homes with Modular Home Representative (floor type, cabinets, doors, shingles, windows, siding)

Confidential,Norwalk, CT January 2004 – March 2009
Acquired Kodak Polychrome Graphics in 2006
Senior Database Administrator

Key member of staff that successfully transitioned company to Eastman Kodak Company WWIS (World Wide Information Systems) support model due to company acquisition in June 2006

Developed and implemented strategy that drove the shutdown/startup and testing of Oracle/SQL Server databases and applications for 14 servers to company wide datacenter

• Interacted with UNIX SAs, Windows SAs, and End Users to prepare databases for move
• Coordinated shutdown/startup of applications and databases
• Facilitated testing of databases and applications upon relocation to Rochester Datacenter

Undertook project to standardize Global Communication Group (KPG) Databases to WWIS compliance

• Researched differences between GCG/Kodak environments, prepared and upgraded all UNIX databases to Oracle10g, applied patches and executed/reviewed output to ensure successful implementation
• Created directories, executed scripts to prepare SQL Server environment, updated parameters as input for monitoring scripts, applied service pack upgrades and reviewed output to ensure successful implementation
• Reviewed monitoring reports daily to ensure databases were operational and performing to standard
• Assisted UNIX SAs when applying patches to database environments by negotiating/communicating outages to users, and coordinating functionality check of database and application after completion

Performed Performance Tuning of Oracle Environment

• Analyzed SGA, Shared Pool, Buffer Cache, Dictionary Cache and resized initialization parameters utilizing STATPACK
• Reviewed problem SQL using Explain Plan , Autotrace, SAP Tools. Based on findings implemented changes to Indexes, REORGed tables/indexes (using EXP/IMP & BRTOOLS) during weekends, maintenance window, & off peak hours. Recommended code changes to Developers
• Reviewed Filesystem I/O and recommended/implemented changes for datafile placement
• Utilized SAP transactions to Monitor Space, Locks, Database Alerts, Waits, and View Backups

Assumed role of SAP Basis Administrator due to attrition of team

• Part of Day and Weekly Night on Call rotation support team for SAP R/3 System
• Daily monitoring of system, resolving issues during and after close of business
• Resolved problem tickets, attended weekly maintenance window reviews, and assisted in monthly maintenance window activities

Managed reporting, posting, and review of SOX compliance information for GCG Applications (Business Warehouse, Rebate, SAP R/3, and Creo SAP R/3)

• Created/executed scripts to report DBA Failed/Successful Logins, audit information for Privileged Accounts, Semi-Annual User Account and Privilege Report
• Performed daily review, weekly posting, resolved conflicts or issues, supported internal/external audits, and resolved audit issues in a timely fashion

Successfully transitioned support of Oracle, SQL Server, and Web Based Database applications from (4) IBM outsource employees to KPG (Kodak Polychrome Graphics)

• Provided 24/7 support of Oracle/SQL Server Databases and Applications
• Revised backup/recovery strategy for all SQL Server environments to reduce space utilization
• Planned/implemented/documented successful Disaster Recovery Testing. Identified applications to be tested, met with Application Owners to discuss recovery requirements. Documented recovery procedures, criteria which exemplifies successful recovery test, hardware/software required for test (this includes User laptops, printers, etc.), potential offsite venues where testing would take place
• Responsible for logging all Production problems and resolutions
• Worked with Basis Administration, Windows SAs, & Disaster Recovery team to implement a Disaster Recovery solution for GCG SAP SQL Server related Applications (Tidal, Vertex, Business Connector). Tasks included analyzing transaction log sizes, installing database software, performing recovery test & documenting database recovery process
• Periodically tested restore of SQL Server Databases from tape or disk backup, to ensure recoverability
• Investigated, trialed, recommended and gained approval for purchase and installation of 13 product licenses for SQL Diagnostic Manager (which allowed monitoring of 13 databases from a single screen)
• Assisted SAP Basis Administrators with SAP Early Watch Review sessions by reviewing reports, investigating SAP notes, discussing findings, planning implementation of solutions into Test and Production environments, and supporting day-to-day Oracle problems (space issues, patches and resolving Oracle errors)

Successfully worked with UNIX SAs & Basis Administrators to refresh GCG SAP Test Systems from SAP R/3 & Business Warehouse Production applications

• Removed files (log, trace, datafiles, controlfiles,) from Test Systems
• Confirmed ALL datafiles restored after restore by UNIX SA
• Rebuilt Test database utilizing backup controlfile
• Load SAP tables, reset database passwords, ensured database startup, & confirmed the operation of database environment
• Coordinated testing of environments with End Users
• Ensured UNIX SA performed backup of environment after restoration

Confidential,May 1993 – July 2002
Senior Oracle Database Administrator, Stamford, CT

• Performed 24/7 database support, installation, upgrades, and patching of Oracle Software
• Migrated Oracle 8.0.6 databases to Oracle 8i
• Created databases, designed/maintained security, planned/tested/implemented Application and Corporate Disaster Recovery Tests
• Performance tuning of applications and databases. This entailed gathering/analyzing data (explain plan, autotrace, utlbstat/utlestat), testing/presenting recommendations and implementing solutions.
• Researched new Oracle8i functionality, developed/administered test plan, compiled results, and recommended functionality to be implemented in Oracle8i applications
• Participated in the successful planning, scheduling, testing and implementation of Y2K compliant database/application software

Masters of Business Administration