SUMMARY:

I have 4 years of experience as an Oracle Data Base Administrator and more than 24 years of experience in analysis, designing, developing, coding, testing, database designing and trouble - shooting complex online and batch Systems. Applications include but not limited to Law Enforcement Systems, Financial, Health, Manufacturing, Loan Accounting, Federal Family Education Loan Programs and Food and Nutrition applications in the client server and mainframe environments.

TECHNICAL SKILLS:

Hardware: Sun E10K, IBM 4381, IBM 4341, AMDAHL 5850, IBM 9672 R65

Software: Oracle 10g/11g, Oracle 8i, RAC, ASM, Linux, ReportBuilder, SQL, PL/SQL, Confidential, IDMS, INFORMIX, UNIX, ADS/O, ADS/A, ADS/G, VSAM, COBOL, JCL, OLM, IDD/M, OLQ, BACHMANN, CASE TOOL (IEF 5.2) and IBM MQ Series Message Queue Management System

Operating Systems: Sun Solaris version 2.8/Unix, Linux, Windows NT, Windows XP, Windows 2000, MVS/XA, MVS/JES2, Z/OS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Creation, installation and administration of Oracle databases
• Database upgrades
• Converted standalone database to RAC
• Monitor production/development alerts and take appropriate actions
• Perform deployments
• Setup user accounts, monitor resolve space issues on ASM and Veritas file systems
• Installed and configured Oracle 11g databases on Sun Solaris
• Database patching/hardening
• Database cloning and database moves
• Performance tuning, backup and recovery Administration
• ASM migrations
• Maintain backup and recovery and database monitoring scripts.
• Experienced with RMAN and Oracle Enterprise Manager (OEM).
• Set up cron jobs
• Production DBA support as needed and during outages and troubleshooting
• Use BMC Remedy Mid Tier 7.6 to create tickets
• On call 24/7 once every 3-4 months

Confidential

Oracle DBA

Responsibilities:

• Planning, creation, installation and administration of Oracle databases.
• Installed and configured multiple Oracle 11g databases on Linux
• Database upgrades
• Performance tuning, backup and recovery Administration
• Provided tuning expertise.
• Installed and configured 2 node Oracle 11g RAC database environment.
• ASM migrations
• Good understanding of Redhat Linux operating system.
• Wrote and maintain backup and recovery and database monitoring scripts.
• Comfortable with RMAN, and Oracle Enterprise Manager (OEM).
• Wrote and set up Unix cron jobs
• Production DBA support as needed and during outages and troubleshooting

Confidential

Senior Programmer Analyst

Responsibilities:

• My primary duties were to take immediate actions to resolve any and all crucial and time sensitive software issues across the country using IBM MQ Series software.
• Duties included making sure all queues and channels, other than the regular maintenance outages, are up and running.
• Functions also include monitoring databases on the Unix and Mainframe systems that affect the data feed in and out of the Queues.
• Also monitors Confidential regions and resolves Confidential related issues in a timely fashion.
• Occasionally performs minor MVS functions when a situation calls for it.

Confidential, Washington, DC

Database Specialist

Responsibilities:

• Maintained Federal Highway's Oracle based Client Server, and IDMS based mainframe systems.
• Wrote several new Online/Batch programs using IDMS and ADSO, developed SQL Reports using Oracle and PL/SQL Procedures while maintaining existing programs.
• Duties also include but not limited to, working on an ad-hoc quires problems and same day resolutions of those problems.
• Also, wrote several conversion programs, data from which is being fed into the new Oracle based Federal Highway's financial system.

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Worked on the Defense Eligibility Enrollment Retrieval System using Confidential /VSAM combination.
• Participated in the data modeling segment of the automated cancer tumor registry ( Confidential ).
• Developed applications using Power Builder 4.0 using Watcom database in the client server environment.
• Also, wrote several Online/Batch programs utilizing Informix, SQL in the UNIX environment while supporting Confidential 's Direct Student Loan contract.

Confidential

Senior Programmer/ Analyst

Responsibilities:

• Worked on the Confidential contract at the prime contractor's (E-Systems) site. Defined and implemented the database conversion techniques for the Confidential, formerly Guaranteed Student Loan Program (GSL), utilizing Confidential, IDMS, VSAM, COBOL/JCL on an IBM 4381 MVS/XA system.
• Heavily involved in analyzing and designing Online and Batch components of the Warehouse Inventory Retrieval (WIR), and Administrative Wage Garnishment systems.
• Participated in the analysis efforts, data modeling, developing entity relationship diagrams and, activity hierarchy utilizing IEF 5.2 in an OS/2 environment.
• Designed and implemented Online Manufacturing Cost Accounting system at the Confidential, utilizing IDMS, ADS/O, ADS/G, COBOL on an IBM 4381 MVS/XA platform. Participated in analysis and re-designing of the entire Food and Nutrition Services ( Confidential ) Food Stamp Renewal system utilizing ADS/A, ADS/G, IDD/M, OLQ, ADS/O, IDMS and, JCL running on an IBM 3090 MVS/VSE environment.
• Restructured and redesigned the financial and non-financial reports, thereby making the future reporting process more effective, efficient and error free.

Confidential

Programmer/Analyst

Responsibilities:

• In support of the Loan Accounting System (LAS), I served as a Programmer/Analyst on the design, development, and testing of complex Online and Batch, database and non-database applications using COBOL, ADS/O, ADS/G, IDD/M, OLM, OLQ, and IDMS running on an IBM 4381 MVS/XA, Model 2.
• I was also responsible for developing financial applications involving Pageable Maps, Premaps and Response Processors utilizing Bachmann diagrams.
• Also, programmed in Culprit to design and produce reports.