We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

2.00/5 (Submit Your Rating)

TECHNICAL SKILLS:

DBMS: Oracle 9,10,11,12, MS SQL Server, DB2, MySQL, IDMS

OS: Unix (AIX, RHEL, Solaris), Windows, z/OS

Languages: SQL, PL/SQL, PERL, Shell, SAS, REXX, COBOL, Assembler

Modeling Tools: ERWin, Bachman, IEF, ADW

Miscellaneous Tools: BMC Blade Logic, BMC Remedy

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

  • All database support on DBA team for about 200 Oracle instances using native Oracle tools plus Toad, RMAN, shell scripts.
  • All technical support, troubleshooting and development for enterprise wide Internet Banking, Mobile Banking, Strong Auth and ancillary databases providing 24x7 customer access for 800,000+ customers.
  • DBA support for MTS Wires database, Enterprise Loan Management products, plus miscellaneous smaller applications.
  • Developed Disaster Recovery standards and automation, Blade Logic automation, and various DBA standards and procedures. All backup, recovery, development and installs, patching, performance tuning, troubleshooting and Disaster Recovery.
  • Off - hour support rotations for all Oracle databases.

Confidential

Database Administrator

Responsibilities:

  • DBA for Development and Production databases in an Oracle 9i and 10g environment.
  • Oracle DBA Team manages hundreds of Oracle servers using SQL Developer, OEM, Oracle Utilities, PL/SQL, RMAN.
  • Provide DBA support for all vendor packages and custom client applications. Coding of Unix Shell and Perl scripts.
  • DB2 for zOS Applications DBA in mature Data Sharing environment of three active production subsystems (30 million threads/day) via CICS, IMSDC, Java and fat clients .
  • Off - hour support on a rotation for DB2 and Oracle applications.
  • Performance monitoring and tuning using BMC tools.
  • Database structures maintained using BMC Change/Catalog Manager for 27 Applications systems through the full SDLC.
  • Modify and maintain CDB Utilities REXX environment and other REXX ISPF tools.

Confidential

Database Administrator

Responsibilities:

  • Systems and Application DBA in a large DB2 data - sharing environment.
  • Applications include a nation-wide bulk prescription fulfillment service, and Point-of-Sale applications systems servicing 65,000 pharmacies, plus insurance provider and eligibility systems.
  • Heavy OLTP shop supports upwards of 20TB of production systems over 17 DB2 subsystems running 3 million CICS transactions daily, over multiple LPARs. Significant DBA development support encompassing 11 levels of testing and QA staging.
  • Off-hour support on a monthly rotation for the systems group, plus performance monitoring and tuning using SAS, DB2PM and BMC Mainview.
  • R&D projects involving Java Stored Procedures, JDBC (J2EE) and IBM JCC Universal Driver.

Confidential

Database Systems Administrator

Responsibilities:

  • Systems and application DBA responsible for subsystem installation, maintenance, performance tuning, backup.
  • Implement disaster recovery plans and testing. Install and support DB2 software from IBM and other vendors, including APARs and PTFs for maintenance, planning and coordination with the MVS (zOS) group for DB2 and other products.
  • Support and advise development teams including database changes and performance tuning.
  • Tuning and trending accomplished with IBM Performance Monitor and other tools, including SAS & QMF.
  • Developed, installed and tested production and warehousing subsystems.
  • Setup and tune SMF traces, Zparm changes and bufferpools for all systems.
  • Developed, tested and implemented CICS applications environment including Development, Test (QA) and Production platforms for the IBM Content Manager product supporting a document imaging system with IBM OAM, DFSMS and DB2. Developed JCL and Procs for all backup procedures and other DB2 utilities.
  • Installed IBM Perfmon, QMF and Smart/RRSAF. Supported and advised Applications teams in SQL architecture and tuning.
  • Provided technical expertise in planning and implementation of a major IDMS to DB2 conversion effort.

Confidential

Database Systems Administrator

Responsibilities:

  • Systems and Application DBA responsible for DB2 UDB OS/390 Microsoft SQL Server.
  • Perform system performance and tuning, SQL troubleshooting and design, all database tasks and network administration for this data warehousing environment.
  • Implemented DB2 OS/390 subsystem tuning changes including zparm, RCT and buffer management.
  • Reconfigured UDB for Windows NT configuration, buffer tuning and other system level changes for increased performance and stability.
  • Developed export/load procedure (mainframe to client server) to improve the monthly warehouse refresh from 120 hours to 18 hours.
  • Upgraded software to current versions for better maintainability, performance and flexibility. Troubleshoot all platforms, systems and clients, for DB2 and SQL Server.
Confidential

Database Systems Administrator

Responsibilities:

  • Systems and application DBA responsible for subsystem installation, maintenance, performance tuning, backup, disaster recovery and 24x7 product support.
  • Install and support DB2 software from BMC, Platinum and Relational Architects for Y2K compliance and maintenance.
  • Participate in enterprise Y2K compliance for DB2 and related tools. Support and advise development team including database changes and performance tuning.
  • Tuning and trending with BMC Activity Monitor, SAS & MICS, SAS/Access, Platinum tools for database, DASD and DB2 subsystem reporting.
  • Perform CICS transaction improvements via RCT macro, SQL techniques, tablespace partitioning and index changes.
  • Subsystem improvements via modified bufferpool architecture for increased performance and throughput, appropriate trace classes, adjusting DSNZPARM and dispatching priority parameters.
  • Implement daily and weekly SMF offload and reporting.
  • In conjunction with applications development, operations and job scheduling, develop project plans for production reorgs, V4 migration, software upgrades, PTFs, batch scheduling, performance and efficiency improvements.

Confidential

Database Administrator

Responsibilities:

  • Responsible for multiple DB2 production and test subsystems, in support of a wide Year 2000 compliance conversion.
  • The Y2K environment consists of one baseline subsystem with six additional discreet subsystems, each supporting separate application conversion efforts.
  • Activities include daily support for Production, Test, and Y2K environments, performing database changes, and data migrations utilizing the PLATINUM DB2 suite of tools.
  • Production troubleshooting and systems evaluation.

Confidential

Database Administrator

Responsibilities:

  • Support and maintain multiple DB2 production, quality assurance and test subsystems, with off - hour support.
  • Perform database analysis and monitoring for pro-active maintenance via IBM, BMC and Platinum DB2 utilities.
  • Monitoring and performance tuning for applications and DB2 subsystems using Omegamon II for DB2 and SMF and SAS/MXG.
  • Establish backup and recovery procedures, security audit, enhancements and migration tools and strategy.

Confidential

Database Administrator

Responsibilities:

  • Logical and Physical database modeling, design and implementation in DB2 for the ORS project. System architecture fulfilled using the ERWin Modelmart CASE tools, in conjunction with PLATINUM tools.
  • Perform database analysis and monitoring for pro - active maintenance of applications and DB2 subsystems using Platinum Database Analyst, Omegamon II for DB2 and SMF.

Confidential

Database Analyst, Data Administration

Responsibilities:

  • Logical and Physical database modeling, design and implementation with XDB and DB2 environments, with Bachman CASE, BMC and PLATINUM tools.
  • Support and maintain multiple DB2 subsystems, with off - site support and disaster recovery. Database analysis and monitoring for pro-active maintenance for applications and DB2 subsystems using Platinum Database Analyst, Omegamon II for DB2 and SMF SAS/MXG. Admin for Sybase on DEC Alpha, Windows NT and Sun Solaris.

Confidential

Database Engineer

Responsibilities:

  • Logical and Physical database modeling, design and implementation using the Bachman CASE tools.
  • Created Data Modeling Standards for applications development.
  • Database analysis and monitoring for pro - active maintenance. Installed BMC utilities and other productivity related software.
  • Produced standard JCL for production utilities. Performance tuning using BMC Activity Monitor and SMF.
Confidential

Applications Database Administrator

Responsibilities:

  • Serving as an IBM Application DBA responsible for Logical and Physical database modeling, design and implementation.
  • Multi - CASE IE methodology utilizing both ADW Analysis/Design/Construction workstations and Bachman/DBA.
  • Performance tuning and trending utilizing BMC Activity Monitor, and SAS for DB2 to provide database, DASD and DB2 subsystem reporting.

Confidential

Senior Systems Analyst

Responsibilities:

  • Provided a significant level of database modifications including tables/indexes/tablespaces and an overall evaluation for this client's DB2 database design.
  • Additional ad hoc CLIST changes to provide value - added interface for the user community.

Confidential

Database Specialist

Responsibilities:

  • Responsible for logical and physical database modeling, analysis, design and implementation for both DB2 and IDMS database systems.
  • Extensive database analysis, performance tuning for applications and systems for IDMS Central Versions and DB2 subsystems, backup and recovery, hot - site recovery and troubleshooting.
  • Systems programming support including assembler and C/370 routines for performance tuning and monitoring.
  • Implemented a system software routine in all IDMS Central Versions to facilitate dynamic program registration and allocation/deallocation of IDMS BDAM files.

Confidential

Database Analyst

Responsibilities:

  • Provided database design and systems installation for all IDMS database implementations.
  • Performance tuning, monitoring, exception reporting and application design reviews were detailed.
  • Provided 24 hour support for data center activities.

Confidential

Programmer Analyst

Responsibilities:

  • Provided development and maintenance of COBOL programs for billing, invoicing and reporting.
  • Responsible for remote printing and communications (RJE). Assisted in machine room during monthly billing cycle.

We'd love your feedback!