SUMMARY

• Over 15 years of IT experience specializing in Oracle database administration, development and programming
• Extensive knowledge of Oracle running on UNIX (Solaris, AIX, HP-UX), Linux and Windows operating systems
• Expertise in translating requirements into ER diagrams and logical/physical data models using ERStudio and ERWin
• In-depth experience with database installation, performance tuning, capacity planning and systems administration
• Strong experience implementing backup/recovery strategies using RMAN to tape (Netbackup, Commvault) and disk
• Experience with installation of Oracle 10g RAC (Red Hat Linux), Data Guard (physical standby) and Grid Control
• Proficient in writing PL/SQL stored procedures, functions, triggers, complex SQL queries and UNIX shell scripts

TECHNICAL SKILLS

Databases: Oracle (11g, 10g, 9i, 8i, 7.3), SQL Server (7, 2000), MS Access
Operating Systems: UNIX (Solaris 9/8/7, HP-UX 11i, AIX 5.3), Linux (Red Hat) 5.x, Windows 7/Vista/XP/2003/2000
Software/Languages/Tools: PL/SQL, SQL, T-SQL, Java, C/C++, Pro*C, HTML, ERStudio, ERWin, Visio, DBArtisan, TOAD, Enterprise Manager (OEM), Grid Control, Oracle Forms/Reports, Oracle Application Server, SQL*Loader, SQL*Plus, SQL*Net, Import/Export, Data Pump, RMAN, Tkprof, Explain Plan, JDeveloper, isql, bcp, JBoss, Apache, Weblogic, Deltek Costpoint (ERP), Siemens Teamcenter, Cognos, Crystal Reports, Microsoft Office, Veritas Netbackup,
CommVault, CVS, SourceSafe, sar, iostat, vmstat, top, putty, vi, make, ant, bash, ksh

PROFESSIONAL EXPERIENCE

Senior Database Administrator { Technisource Consultant } 6/10 - 12/10
Confidential, Tempe, AZ

• Performed database administration supporting 150+ Oracle Production/QA/Dev databases running on AIX and Linux
• Installed Oracle 11g/10g software on standalone and clustered servers; created databases using DBCA & custom scripts
• Migrated databases from 9i to 10gr2 and 10gr2 to 11gr2 on AIX/Linux servers; applied quarterly critical patches
• Performed RMAN hot/cold backups using Netbackup; wrote PL/SQL and UNIX/Linux shell scripts
• Tuned and troubleshoot database problems; monitored databases using Enterprise Manager and cron executed scripts
• Worked incident tickets (Remedy); rotated on-call 24/7 support; trained co-workers; implemented & tested new releases
• Attended project meetings; interfaced with managers, developers & end-users; worked independently without supervision
• Tools utilized included impdp, expdp, imp, exp, ksh, putty, vi, TOAD, DBUA, Enterprise Manager (OEM) and SQL*Plus

Senior Database Administrator { Superior Technical Resources consultant 4 months then permanent } 2006 - 2009
Confidential, Chandler, AZ

• Performed Oracle database administration, application support, programming and systems administration tasks
• Supported financial, engineering and manufacturing databases and associated applications installed in two datacenters
• Installed and maintained 100+ Oracle 10g/9i/8i databases running on Solaris/Linux based servers using Netapp storage
• Monitored databases for performance and availability through Grid Control, OEM, TOAD and cron executed shell scripts
• Installed and configured Oracle 10g RAC on Red Hat Linux servers with 3-node primary and 2-node Physical Standby
• Implemented and tested database backup/recovery procedures using RMAN (CommVault) and hot/cold shell scripts
• Migrated legacy Oracle 8i/9i databases to Oracle 10g; cloned/refreshed databases for testing, development and QA
• Installed, maintained and troubleshooted Web and Java-based middleware components installed on Citrix servers
• Customized source code (PL/SQL, SQL, Java, C++, COBOL) and database schemas to add enhancements and fix bugs
• Resolved performance issues by examining reports (AWR, ADDM, ASH); optimized SQL queries (tkprof, explain plan)
• Worked with infrastructure in standardizing server builds, applying OS patches and adjusting kernel/storage parameters
• Applied metalink service pack upgrades and security patches; developed and maintained company standards and policies
• Provided technical expertise to co-workers; assisted with budget planning; worked independently without supervision

Senior Database Developer 2005
Confidential, San Bernardino, CA

• Developed and supported Oracle 9i based software products sold to the healthcare industry
• Tools and technologies utilized included PL/SQL, SQL, SQL*Plus, SQL*Loader, TOAD, ksh, MS Office

Senior Database Administrator / Architect { MBS Outsourcing consultant } 2004
Confidential, San Diego, CA

• Installed, monitored & maintained production Oracle 9i databases running on HP/UX servers supporting manufacturing
• Wrote scripts (ksh, PL/SQL) to automate backups, monitor databases and gather statistics (Statspack)
• Developed PL/SQL packages, stored procedures & triggers; wrote complex SQL queries; created reports
• Implemented and tested RMAN backup/recovery procedures to tape (Omniback); cloned databases for testing
• Installed and migrated a SQL Server 2000 database (including T-SQL code) to Oracle using Workbench and ERWin

Senior Database Administrator / Developer
Confidential, Valencia, CA 2002 - 2003

• Responsible for the implementation and support of databases and cheminformatics applications used in drug discovery
• Installed and maintained production Oracle 9i/9iAS running on a Sun Fire V880 (Solaris) and Dell PowerEdge servers
• Performed UNIX and Windows systems administration tasks including installation, configuration (RAID) & maintenance
• Gathered and analyzed statistics used in performance tuning; monitored databases using Enterprise Manager (OEM)
• Worked with users to analyze data, perform statistical calculations, write complex SQL queries & generate ad-hoc reports
• Implemented and tested hot/cold backup strategies using RMAN, Veritas Netbackup, imp/exp and shell (ksh) scripts
• Interfaced with vendors, IT staff, users, scientists and managers; helped prepare budget; worked independently

Senior Database Administrator / Architect
Confidential, San Diego, CA 2000 - 2001

• Installed, tuned and maintained Oracle 8i running on production, development & test servers (Solaris, Linux, Windows)
• Designed and implemented databases for company’s e-learning software products (n-tier & J2EE based)
• Used Embarcadero ERStudio to translate requirements into logical and physical data models and to generate build scripts
• Developed reports, graphs and charts using Crystal Reports; optimized SQL queries using Explain Plan and hints
• Created stored procedures, functions, triggers, views, database links, indexes, sequences, roles, profiles and scripts

Senior Database Engineer / Oracle DBA
Confidential, Newbury Park, CA 1999

• Designed a data warehouse (star schema) containing terabytes of manufacturing data collected from three legacy servers
• Used ERStudio to reverse-engineer & design databases utilizing table partitioning, materialized views & bitmap indexes
• Installed and maintained Oracle 8i running on a Sun E450 server; gathered user requirements; interfaced with managers
• Wrote PL/SQL (packages, procedures, functions, triggers) and external programs (C, Pro*C) to perform ETL operations

Scientific Application Developer / Oracle DBA
Confidential, San Diego, CA 1994 - 1998

• Performed database/systems administration, application development, programming and database design/development
• Installed and maintained production Oracle 7.x/8.0 databases running on UNIX (SGI/IRIX) and Windows NT servers
• Created company-wide (300+) information system (OLTP) used by scientists to enter, query and analyze research data
• Designed, coded, tested & implemented complete life-cycle (SDLC) client/server and web-based database applications

Software Engineer
Confidential, Bethpage, NY 1989 - 1994

• Designed, coded, tested & implemented complete life-cycle (SDLC) applications supporting defense related projects
• Developed 200+ forms & reports; wrote PL/SQL packages, procedures, triggers; held a Secret Clearance

EDUCATION

M.S., Computer Science, Confidential, NY - GPA: 3.5
Certificate, Computer Science, Confidential, NY - GPA: 3.9
B.S., Medical Technology/Chemistry,Confidential Buffalo, NY - GPA: 3.6