SUMMARY:

• Senior Oracle Database Administrator, PMP and ITIL Certified with over 15 years proven experience with strong Oracle, Data Warehouse and Security experience. Managed over 80 databases running Oracle 10g/11g/12c on Linux and Windows including 24x7 support. Highly motivated, team player with excellent oral and written communication skills.
• Roles include Project Management, Backup and Recovery, Security, Disaster Recovery, Data Warehousing, Database Design, Physical Database Implementation and Performance Tuning,
• Created, installed, patched, configured and tuned Oracle 10g/11g/12c databases and Oracle Applications 11i/R12. Strong hands - on database administration, replication/cloning, unix shell scripting and PL/SQL skills. Reduced unplanned outages and call-outs by 85% using Enterprise Manager and unix shell scripts.
• Implemented and supported Recovery Manager (RMAN), Real Application Clusters (RAC), Automatic Storage Management (ASM), Data Guard, Exadata and Oracle Database Appliance Engineered Systems.
• Received numerous awards from business and project teams for excellent service.

SKILL:

Databases: Oracle 10g, 11g, 12c

Operating Systems: Red Hat Linux, HP-UX, Windows, Solaris

Enterprise Tools: Recovery Manager (RMAN), Enterprise Manager Grid, Automated Storage Management (ASM), Data Guard, Real Application Cluster (RAC)

Performance Tuning: Explain Plan, ASH, AWR, ADDM, Tuning Pack

Database Tools: SQL Developer, Toad, DBArtisan, SQL Navigator, brtools, Virtualbox

Software: SQL, PL/SQL, Unix Shell Scripting, Data Pump, Import/Export

Oracle Applications: SAP, Oracle E-Business Suite/R12, ArcGIS, Landmark

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Administrator

Confidential, Bakersfield, CA

• Supported over 80 Oracle and MS SQL databases in Production, QA and Dev and provided 24/7 on-call support. Expert level knowledge of Oracle. Maintained OLTP and Data Warehouse systems running Oracle 10g, 11g and 12c on Unix//Windows platforms for over 1,200 users. Utilized PMP, Lean, and Kaizen training to organize, design, and lead projects to implement business solutions and new technologies. Excellent at documenting requirements, processes and procedures for DBAs. Mentored DBAs and Developers.
• Installed, created, configured, upgraded, patched, maintained and migrated Oracle 10g/11g/12c databases. Performed deployment, migration, replication, alarming, performance tuning, backup & recovery and security. Managed tablespaces, data files, archive logs, flash recovery area, exports and backups. Troubleshot complex issues across multiple technologies. Utilized Toad, SQL Developer, DBArtisan, SQL Navigator and Enterprise Manager.
• Increased database and SQL performance using Explain Plan, Autotrace, the SQL Tuning Advisor, ASH and ADDM in both SQL Developer and Enterprise Manager Grid 12c by identifying performance bottlenecks and implementing tuning plans.
• Used Enterprise Manager to monitor, alarm and proactively maintain 24/7 production systems. Wrote unix/shell and sql scripts for maintenance, space management, performance tuning and security.
• Utilized performance tuning methodologies and tools including Explain Plan, ASH, AWR, ADDM, statistics and Tuning Pack to meet performance SLAs. Tuned spfile/init.ora parameters, created partitioned tables, materialized views, and indexes. Worked with developers to re-write SQL and redesigned programs to use SQL more efficiently. Implemented workload balancing for greater server throughput.
• Strong experience with Recovery Manager (RMAN) for backup, recovery, disaster recovery and cloning/replication. Wrote hot/cold backup unix scripts. Scheduled backups using Enterprise Manager, TWS, Stonebranch UAC and cron. Member of Disaster Recovery Team and planned and performed off-site disaster recovery. Coordinated Attunity Replication with SQL DBAs.
• Security included “defense in depth” including grants, Virtual Private Databases (VPD), application security, auditing data, users, DBAs, and privileges, password management, Oracle Wallet, and encryption. Represented Aera at security audits. Designed and implemented security policies and controls to insure audit compliance.
• Created fast and highly-available systems by implementing and supporting Real Application Cluster (RAC) and Automated Storage Management (ASM).
• Supported Exadata and Oracle Database Appliance (ODA) including RAC, ASM, RMAN, EM Grid, and Data Guard. Specialized training certification from Accenture Enkitec for performance tuning and administration.
• Specialized and supported SAP and Oracle Applications E-Suite R/12, ArcGIS/ESRI, and Landmark applications. Provided strong support for Unicode migration. Configured, patched and troubleshot Oracle Energy (P2/EU) applications.
• Designed and implemented auditing controls for database administrators and users including auditing parameters, audit reports, and represented Oracle systems to both external and internal auditors.

Senior Oracle Database Administrator

Confidential, Albany, NY

Responsible for tuning a 20 Gigabyte Claims Processing Data Warehouse and Data Mart. A proprietary OLTP system populated the Data Warehouse which then populated the Data Mart. High Performance was critical for keeping the down-stream Data Mart in-sync with the upstream OLTP system. Cubes generated by Cognos Powerplay and Impromptu were also tuned to enable analysts to create and view cubes in a timely manner. Supported the integration of Informatica and Oracle 8i tuning strategies.

Performed a complete “top-down” and “bottom-up” tuning analysis of the Data Warehouse and Data Mart. Optimized data extraction, loading, transformation and validation and querying procedures. Implemented Advanced Oracle 8i tuning features such as: Partitioned Tables/Indexes, Parallel DML, Star-Schema query optimization, Bit-Mapped Indexes, Locally Managed Tablespaces, and Materialized Views. Tuned many new “8i” Init.ora parameters. Used Explain Plan and Autotrace to tune slow queries. Used Log Miner to diagnose certain performance problems. Wrote many Unix scripts to tune and monitor the database. Used cron to schedule the scripts to run on a periodic basis and email the results to the DBAs. Wrote Tuning Documentation and Mentored DBAs in Oracle 8i Tuning. Used Oracle 8.1.6 running AIX on an IBM RS-6000 with 6 CPUs and 16 Gig of RAM.

Senior Oracle Database Administrator

Confidential, New York, NY

Responsible for installing Oracle 8.1.6, created Development, Test and Production databases, and performed database optimization and application tuning for the Financial Data Warehouse. Worked with managers, business users and developers to resolve complex problems regarding data, application processing and performance. Participated in database design with business users, developers and database administrators. Performed DBA mentoring and provided database and application documentation. Wrote Unix scripts to perform backups, database monitoring, and increase performance. Used Oracle 8.1.6 running on Sun OS 5.7.

Senior Oracle Database Administrator/Technical Project Manager

Confidential, New York, NY

Performed Database Administration to support the E-Commerce tasks of the nytimes.com website including a database upgrade from Oracle V7.3 to 8.15, backup/recovery, and performance tuning for 1,500 concurrent users to maintain 24 X 7 availability. The Registration Database stored user profile and billing information. Technical resource for developers writing applications in PERL, Java, XML, C++, PL/SQL and shell scripts for a number of Internet applications. Helped integrate QPASS within Registration to perform all credit card billing. Used Erwin to perform logical design and recommended design changes based on business and performance goals. Wrote reports on the number of archived articles downloaded.

Supported a 300 gigabyte Decision Support System/Data Warehouse that analyzed data from the Registration System and other sources. This system analyzed user patterns within the website for promotional marketing based on user demographics and interests. Provided support to in corporate data from many different sources, including external content server logs, registration data, and data from recent company/website acquisitions. Also provided support to generate mailing lists of up to several million email addresses for advertising promotions. Performed tuning at the database and application levels. Reviewed and tuned INIT.ORA parameters, defragmented tables/indexes, and reviewed loading and report code including PERL, PL/SQL, Oracle Reports and SQL*Loader. Implemented Recovery Manager to perform full and incremental backups. Used Oracle 8.1, 8.0.5, and 7.3.4 on Sun Solaris.

Oracle Database Administrator/Project Manager

Confidential, New York, NY

Performed Oracle Database Administration in addition to planning, scheduling, and managing all phases of the Year 2000 remediation of a risk management system. Created and administrated multiple database environments, performed backups, security and acted as an Oracle technical resource for all Oracle tools in addition to providing mentoring to an international team of 14. The project was completed on time and within budget. Remediated over 2,000,000 lines of code including SQL*Forms, Pro*C, Pro*Fortran, SQL*Plus, SQR, and DCL that ran on Oracle 7.1, Unix and VMS. Installed, configured and optimized Oracle8 on NT.