We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

White Plains New, YorK

SUMMARY

Senior 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 R/3 databases.Result driven, self starter, and multi-tasker with minimal direction. Strong communication skills.

DATABASES and 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, SQL Worksheet, 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

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY June 2011 - September 2011
Oracle Database Administrator

  • Responsible for the monitoring and maintenance of Oracle 10g/11g Production, Test, Development and QA databases located in Massachusetts, New York, Virginia, and California
  • Created Oracle Accounts for new users and granted privileges to Oracle objects based on their user profile
  • Refreshed Test, Development & QA systems from Production using Oracle Datapump Export/Import
  • Monitored Database space and allocated additional space as required for Tablespaces and Indexspaces
  • Supported Oracle Data Guard Standby Databases
  • Worked with Developers and QA Testers to implement standardsecurity access to their test environment based on Oracle roles
  • Performed data fixes as required in Production Systems
  • Utilized Vendor tools TOAD, OEM Grid Control, Oracle client, Gforge Ticketing, & NAGIO to support Oracle databases
  • Performed Backup and Recovery of Oracle Databases using RMAN
  • Provided 24x7 Database support

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
Confidential, 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
Confidential, June 1981 - May 1993

DB2 Technical Specialist August 1988 - May1993
New York Financial Branch Office
New York City, New York

  • Developed strategies to assist customers achieve their Application Development goals and objectives. Responsibilities included analyzing, designing, and presenting software solutions
  • Worked with IBM Marketing Representatives, Software Vendors and IBM Business partners to market software products & solutions to customers
  • Provided DB2 technical to customers and kept them abreast of DB2 technological announcements
  • Acted as DB2 Technical consultant supporting Union Bank of Switzerland\'s DB2 environment located on the IBM Information Network (IIN). Planned, coordinated, & assisted in the creation of the environment
  • Lead consultant for the planning, customizing, and installation of a DB2 Operating System at the UBS Data center. Project entailed tailoring DB2 subsystem parameters, executing installation scripts, selecting/executing migration tools, creating the physical DB2 Application environment, and coordinating the migration of the Mortgage Back Securities Application from IIN to the processor
  • Responsible for writing a portion of IBM service contract for the re-engineering of a VSAM/DB2 Trust Application to a fully functional DB2 based application. Activities included analyzing previous VSAM environment, determining database related project tasks, estimating hours to perform tasks, and researching/recommending application development tools to assist in the re-engineering effort

DB2 Database Administrator, White Plains, NY June 1986 - August 1988
Confidential, White Plains, NY

Provided DBA support for Customer Collection System (CCS)

  • Created VSAM files, tables, indexes, implemented security, implemented backup/recovery strategy
  • Coded/tested database maintenance utilities
  • Provided DB2, QMF, & SQL Tuning support for Application Programmers
  • Documented rollout procedures and installed application at 12 locations nationally.
  • Acted as DBA team lead from February 1987 to February 1988. Coordinated & assigned tasks to teammates, trained new DBAs, communicated the status of all projects and progress of staff to management
  • Primary consultant to the Service Support & Operations (SSO) organization for all Production Database related problems
  • Provided 24/7 support
  • Educated Production DBA staff. Responsibilities included hands on training, skills transfer, and documenting daily workflow

IMS Database Administrator March 1983 - June 1986
Confidential, White Plains, NY

Provided support for the re-development of the Division\'s Accounting System

  • Interviewed Users, analyzed requirements, and created project plans
  • Developed logical and physical database designs, entity relationship diagrams, and documented entity access information
  • Responsible for reviewing/resolving data elements conflicts among project teams
  • Entering data element information into IMS DB/DC Data Dictionary
  • Implemented physical database design in test system.
  • Developed preliminary backup/recovery strategy, coded and tested database maintenance utilities
  • Attended Application Design reviews and recommended changes as warranted.
  • Provided Test/Production support to Application Programmers and Operations staff.

Programmer Analyst June 1981 - March 1983
Confidential, White Plains, NY

Member of team responsible for enhancing the Division\'s Accounting System to process new Divisions and Independent Business Units

  • Interviewed users to gather requirements
  • Analyzed current programs to ascertain current data flow
  • Modified/tested programs, documented changes, and installed new programs in Production System
EDUCATION

Masters of Business Administration, Systems Analysis and Design

Bachelor of Science, Management Science

PROFESSIONAL DEVELOPMENT

Project Management Skills Oracle Enterprise Manager
Leadership Development Oracle Network Administration
Oracle Database 11g Admin Workshop 1 SQL Server 2000 Database Admin
Oracle Database 11g Admin Workshop 2 SAPTEC Fundamentals of SAP
Oracle Database 11g Data Guard SAP Oracle Database Administration
Oracle Database 11g Performance & Tuning
Oracle 11g Database Linux for DBAs

Hire Now