We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume Profile

3.00/5 (Submit Your Rating)

Newark, DE

Application Development

Versatile IT professional delivers elegantlydesigned solutions that are simple and well functioning, and effectively meet business requirements inlarge, high availability environments. Creative problem solver, whoenjoys maintaining the integrity of existing systems as they are updated to meet changing business requirements. Analytical thinker with a passion for automation takes a structured, methodical approach to interpreting legacy system code. Expertise in identifying and incorporating lessons learned,and best practices to facilitate process improvements enterprise-wide. Core strengths in:

  • Application Development Mainframe Programming
  • Legacy System Analysis Design
  • Database/System Administration Configuration
  • Project Leadership Management
  • Disaster Recovery Business Resiliency
  • Requirements Gathering/Specifications
  • Database Performance, Monitoring, Tuning
  • Version Release Patch Maintenance
  • System Maintenance Support

TECHNICAL SKILLS

Languages:

COBOL Micro Focus COBOL IBM Assembler SQL Shell, AWK, PERL scripting VBA

Software:

IMS DB/DC Oracle SQL Oracle Utilities IBM Mainframe Utilities CICS VSAM Easytrieve LoadRunner MS Excel with ODBC Macros

Technologies:

COGNOS BI Reports Certified Designer Tivoli Storage Management TSM SAP Tivoli Workload Scheduler TWS

Platforms:

IBM Mainframe AIX HP-UX Linux, UNIX

Other Skills:

Job Control Language JCL , Time Sharing Option TSO , ISPF with Dialogs Panels, CLISTS, IBM Utilities

PROFESSIONAL EXPERIENCE

Confidential

Key contributor to JPMorgan Chase product platform.One of nation's largest credit card issuers.

Confidential

Oracle Database Administrator

Selected as Technology Administrator for Mortgage Banking program after successfully taking on two significant administrator roles for Enterprise Management and Tivoli Storage Manager.Report to senior management on application and Line of Business LOB environment for operations management, capacity planning, and growth management.

  • Conducted analysis of backup statistical information for servers and databases, creating reports utilizing COGNOS BI and Excel VBA reports reviewed by management to monitor backup health.
  • Managed internal IT operations, including monitoring and resolving problems with ticket flow,system capacity dashboard, and file transfer documents and information from business partners. Devised and implemented new monitoring requirements, utilizingPERL scripting.
  • Served as second to upgrade a critical system originally implemented by consultants and plagued with production problems rigorously tested file transfer softwareand retested upgrade toensure an error-free environment. Successfully migrated system from Windows based to LINUX, completing projecton time.
  • Overhauled Disaster Recovery procedures, creating a repeatable, streamlined process that improved readiness and ensured successful Disaster Recovery testing.
  • Regularly conducted system analysis, creating statistical reports and graphs to show resource utilization upper management used information to determine application health.
  • Engineered scripts against TSM system using UNIX, AWK, and PERL scripting, plus SQL to automate routine tasks and monitoring.

SAP Basis Administrator

Managed Software Development Lifecycle SDLC in SAP environment.Conductedbusiness resiliency testing, administeredchange control processes, enhancedinterface system, and diagnosed system issues. Coordinated user testing during Disaster Recovery drill and fullydocumented all procedures.

SAP Basis Administrator/Oracle Database Administrator/TSM Administrator

Implemented SAP R/3, and managed Oracle databases and SAP system.Performed Disaster Recovery testing, executed upgrades, and trained end-users.

  • Designed and implemented infrastructure to backup and recover newly installed open system architecture, ensuring Disaster Recovery readiness for 500 GB database delivered a well-documented and thoroughly tested solution.Automated system to eliminate need for dedicated TSM administrator.
  • Developed monitoring tools to quickly resolve problems with Oracle databases and SAP systemsusing UNIX shell scripts, SQL, and Oracle tools established new performance monitoring and metrics.Set proactive schedules for Oracle DB reorganizations, server restarts, and Oracle Critical Patch Updates CPU .
  • Took over highly visible project to get Tivoli Workload Scheduler TWS system and staff up-to-date after software sunset by vendor. Completed software and user interface upgrade. Quickly set up training and conducted classes on new functionality, delivering project on time.
  • Migrated250 GB database to enterprise system that enabled advanced storage options. Redesignedtablespace structure and negotiated outages with user community to ensure a smooth transition.
  • Planned, researched, coordinated, and executed upgrade of SAP system, including underlying database. Conducted capacity testing of new system hardware.
  • Scope of responsibilities included program enhancements and rewrites, programming systems design, legacy system replacements, and new employee training.
  • Took over failing projectand resolved problems with inaccurate discrepancy reporting by rewriting physical inventory process to easilyinput data, locate discrepancies, and identify recounts.
  • Overcame very tight scheduling issues by quickly becoming proficient with SQL. Migrated from mainframe legacy system to UNIX/Oracle based software, utilizing Oracle utilities, MicroFocus COBOL, and UNIX utilities. Managed conversions to warehouse management system PkMS .

Sr. System Engineer

Key member of team to rewrite main deposit account systems' posting programs.Provided project leadership within larger project structure.Conceptualized on-line menuing structure for deposit accounts system. Designed, tested, and implemented interfaces from deposit systems to ATM system.

Programmer

Began rewrite of Lab system from Assembler Macro CICS to PL/I Command CICS.

We'd love your feedback!