OCP Oracle DBA with more that 10 years
oracle Certified Professional (OCP) DBA with over 15 years experience in database design, administration, development, data modeling, and programming. Worked on all project life cycles including administration, data modeling, PL/SQL programming, front-end design, Y2K testing. Supported and developed applications in the Financial, Health Care, Banking and e-commerce industries. Performed DBA functions including: installations, upgrades, creation, design and maintenance of databases, also performance tuning, backup, recoveries, query optimization.
DATABASE: oracle 7, 8i, 9i, 10g, DB2-UDB 6, 7
DATA MODELING: ERWIN , SilverRun
PROGRAMMING: Shell script, PL/SQL, PRO*C, Powerbuilder, C, PL/1.
OS: Windows NT, Sun Solaris UNIX, AIX, VAX-VMS, VOS
UTILITIES/TOOLS: Migration Work Bench, SRDF, Time Finder, Informatica, ERWIN, AUTOSYS, LECCO TECH, SQL*LOADER, DBArtisan, OEM
APPLICATIONS: TRILOGY, PACE, SECLEN, IFTS, HPS, SWIFT, CHIPS, ALGO
Sr. DBA/DATABASE Specialist - Team leader
Responsible for support of Risk Management application with more than 20 oracle and UDB Production, QA/UAT and development databases. Personally responsible for the following:
· Performance and tuning .
· Database Capacity and High Availability Planning.
· Backup strategy and Disaster Recovery .
· Database installation, configuration, and upgrades.
· UDB to oracle Conversion .
· Team Leader for other DBA?s .
· Data Modeling, loading, exporting and importing.
· Configuration of Crontab and Autosys jobs.
· oracle 9i and 10g installations and upgrades.
· Production Support.
· DB and security auditing and Sarbanes-Oxley compliance.
· oracle Internet Directory
· Change Managment
02/2000-02/2004 Prudential Financial Inc
DBA/DATABASE Specialist (Sharp Decisions Inc)
Responsible for support of PACE (Prudential Advanced Compensation Engine) application with more than 15 oracle and UDB development, QA and UA instances. Personally responsible for testing and implementation of the following:
· Performance and tuning
· Database Capacity and High Availability Planning
· Standby DB
· Backup strategy and Disaster Recovery
· Database installation, configuration, and upgrades
· SQL Tuning using Lecco Tech tools
· UDB to oracle Conversion testing using oracle Migration Work Bench
· Used EMC Timefinder for databases backups and restores
· Data Modeling, loading, exporting and importing.
· Developed Stored Procedures (PL/SQL) to support TRILOGY application
· Worked on Object/Relational Mapping and conversions
· Configured Autosys jobs.
· oracle 9i upgrades
· Production Support
· Data Privitization
DBA/Data Modeler (NDS Inc)
Designed and implemented Database model (ERWIN). Defined and maintained tables, indexes, tablespaces, synonyms and sequence definitions. Installed oracle 8i under NT and Sun Solaris. Provided support for production, QA and development environments. Backup/recovery planning. Designed and developed stored procedures and triggers.
02/99-7/99 MEMORIAL SLOAN KETTERING
DBA (SGA Inc)
Installed and configured oracle versions 7.x and 8.x, and oracle on AIX and NT environments.
Developed and deployed oracle Backup Methodology which included Hot Backups,
Cold Backups and exports.
Personally responsible for Y2K testing and certification of oracle components and applications.
Establishment of Security procedures.
1997-1999 MERRILL LYNCH
DBA/Developer (ExecuSys Inc)
Installed and configured oracle 7.x on Windows NT and UNIX.
Developed SQL*Loader scripts for MS Mail chargeback applications.
Developed triggers, PL/SQL application programs and SQL scripts.
Performed HOT and COLD backups, exports and imports.
Designed and developed ADMIN application, to allow administrators of various applications an easy way to administer user roles and their privileges.
Involved in database performance and tuning.
Created Data models for new and existing applications using ERWIN.
Provided production support. Set up development environments.
1996-1997 INDUSTRIAL BANK OF JAPAN
Application DBA. (Pierce Technologies Inc)
Installed, upgraded and configured oracle 7.x instances on AIX.
Performed database maintenance duties, including backup and recovery, performance monitoring and tuning.
Working in VAX-VMS environment, designed and developed PRO*C and PL/SQL programs for data manipulation and reports for Securities Lending System. Created data models for applications. Provided application support. Database design was done using ERWIN, used oracle PL/SQL, and PRO*C, developed stored procedures and triggers.
1993-1996 LEWCO SECURITIES CORP.
General database administration, wrote SQL*Loader scripts, performed installations, exports/import. Designed and developed figuration server system and interface to On-line trading system. System allowed traders to calculate various customers fees, yields, rates, interest and commissions. Provided support and maintenance. Database design was done using SilverRun, front end was developed using POWERBUILDER4. Used oracle PL/SQL, and PRO*C, developed stored procedures and triggers.
1988 - 1993 IBM JAPAN CORPORATION. IFTS Project
Programmer Analyst (Logica North America and Japan Research Institute)
Developed an international funds transfer system, based on IBM System/88 and RS6000 hardware. The system, interfacing with CHIPS, SWIFT, FEDWIRE and TELEX communication networks and providing an external system interface, automates the transfer of multiple currency funds between financial institutions. Designed and coded various areas of the system, including: message routing and repair, Fedwire securities transfers, system wide error handling and reporting, CHIPS cable charges, start of day and end of day processing, SWIFT II emulation, database conversions, CHIPS format repair, payment entry testkey customization, various reports and message prints, CHIPS II changes.
First Boston Corp.
As part of a team, designed and developed the OTP (ORDER/TRADE processing) system, which used Stratus, IBM mainframe and IBM PC as part of HPS (HIGH PRODUCTIVITYSYSTEM Areas of involvement includes coding for processing of I/O requests from IBM PC to STRATUS, development of procedures for converting DB2 tables into VOS files, creation of master files, file definitions and indices. Also performed I/O benchmarks and conducted tests to assess system?s performance. Documented an on-line government trading securities system (RMJ), and wrote specifications for in-memory database for multi-national date processing.
BROOKLYN COLLEGE, City University of New York. BS in Computer and Information Science.
TRILOGY SC commission Training.
Completed oracle DBA OCP certification for oracle 7 and 8.