Oracle Database Administrator Resume Profile
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:
|
|
|
|
|
|
|
|
|
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.