SUMMARY

• Profile: IT Professional wif 8 years of experience administrating large OLTP databases running Oracle 8i/9i/10G and MSSQL Server 2000/2005. Member of the DBA team at the Verizon Business “System Operations Center” responsible for daily 24x7 monitoring, management, availability, performance and recovery of more TEMPthan 150 production/staging databases supporting large e - commerce, financial and government sites for companies such American Airlines, Best Buy, Vangent, Equilend, Sony and Scholastic.
• Experienced in performing Oracle installations, configuration and patching. Created multiple Oracle Dataguard “physical standby” databases to support disaster recovery. Skilled in RDBMS architecture and implementation strategies including database physical layout using data striping and mirroring (RAID 0-10), analysis of optimal data, index, and archive placement and creation to support applications.
• Proficient at identifying and solving database performance issues wif proven identification and tuning techniques. Experienced at identifying database wait events and long running SQL, determining/improving execution plans, resolving locking and resource issues and minimizing disk me/O utilizing standard DBA analysis tools such as custom SQL scripts, AWR, and Statspack.
• Administered varied High Availability database systems for Oracle and MSSQL designed to meet strict requirements for fail-over and disaster recovery utilizing Oracle 9i/10G RAC, Veritas Cluster, Sun Cluster, HACMP, Microsoft Windows Cluster, and Oracle Standby technologies.
• Clear ability to interact effectively wif clients, project managers, system administrators, application designers, development teams and other DBAs to facilitate complex change requests for critical e-commerce and HA environments wifin planned change windows and wifout unscheduled outages. A team player, highly organized, and detail oriented.
• Performed RMAN backup/recovery operations on varied Oracle production and staging databases. Maintained/Monitored nightly backup procedures utilizing RMAN, hot/cold backups, exports, split mirror technology. Refreshed staging databases wif production RMAN backups.
• Worked on multi-terabyte Oracle database configurations utilizing partition space management.
• Responsible for regular database maintenance activities such as: index rebuilds, table reorganizations, analyzing tables/indexes, imports/exports and space management. Worked wif partition management scripts to add, drop, merge, coalesce and exchange partitions.

TECHNICAL SKILLS

Databases: Oracle8i/9i/10G, DB2 v.8, SQL Server 2000/2005, MySQL 5.0

Operating Systems: Unix (Solaris, Linux), Windows 2003, HPUX, AIX

HA Environments: Veritas Cluster, Sun Cluster, HACMP, Microsoft Windows Cluster

Operational Tools: SQL*Plus, OEM, RMAN, Sqlloader, Exp/Imp, Data Pump,

PROFESSIONAL EXPERIENCE:

Confidential, Redwood city CA

Oracle Database Administrator

Responsibilities:

• Managed and monitored multi - terabyte Oracle database configurations utilizing partitions and standby configurations for existing backup and DR strategies. Executed partition management scripts to add, drop, merge, coalesce and exchange existing partitions for space management.
• Completed multiple Oracle database, single instance, installs configured for both single and shared client environments. Designed and implemented subsequent Oracle Dataguard physical standby databases to provide disaster recovery for all Silver Springs client installations.
• Provided 24x7, onsite and on-call, NOC database support for existing clients. Opened remedy problem and change control tickets, in addition to Oracle tars, to track and resolve ongoing database issues. In charge of continued monitoring, management and resolution of tablespace growth. Existing storage architecture prevented auto extension of datafiles.
• Implemented database patching and worked wif other DBAs to design, create and implement build, upgrade and problem resolution procedures.

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Worked as on - site DBA for the Verizon Business 24x7 Client System Operations Center (SOC). Monitored/Managed Oracle 8i/9i/10G, DB2 v.8, MySQL 5.0 and MSSQL 2000/2005 database servers on Linux, HPUX, Solaris, AIX, and Windows 2003 platforms. Supported High Availability systems configured for Oracle 9i/10G RAC, Veritas Cluster, Sun Cluster, HACMP, MySQL 5.0 replication and Oracle standby technologies.
• Responsible for reviewing, approving and implementing client database change requests. The Verizon Business change request process requires attachment of a detailed step by step plan for any work to be performed and a review of possible impact to the client s site from such work. Duties included analysis of such plans and a review of detailed production guide information and instructions concerning the client s site. Approval and verification of database work performed was a primary requirement of the position.
• Implemented change requests on client systems for regular maintenance activities such as index rebuilds, table reorganizations/moves, imports/exports, statistic generation, creation of stored procedures/functions, DML execution, granting/revoking privileges, unscheduled backups and restores of standby systems.
• Identified performance issues using installed database monitoring and standard tools such as AWR, Statspack, Execution Plans, Spotlight, Enterprise Manager and custom SQL scripts. Recommended/Implemented varied configuration, indexing, data reorganization and SQL redesign changes to enhance performance.
• Performed and monitored scheduled backup & recovery operations on production/staging databases utilizing RMAN, hot/cold backups, data exports and split mirror technology.