SUMMARY:

• Oracle 10gr2/RAC/ASM, Solaris to Linux migrations, Grid control
• Oracle Server installs and maintenance
• Certified Oracle Professional
• Worked Confidential for 9 years doing RDBMS related functions
• 16 Yrs Information Technology
• 9+ Yrs Confidential
• 11+ Yrs Oracle DBA
• 10gr2 RAC/ASM 2 Yrs SAP 3 years Siebel

TECHNICAL SKILLS:

Technology and Tools: Oracle 5, 6, 7, 8, 8i, 9i, 9.2, 10gr2 RAC/ASM Database sizes: from GB to TB Oracle Installs, upgrades, endianness conversion (Solaris to Linux) SQL, PL/SQL, and UNIX Shell scripting maintenance UNIX cron table setup/programming Oracle jobs, Materialized View Replication, Oracle Streams, Oracle Advanced Replication Tuning, Statspack, Topaz, OEM - Enterprise Manager 9.2/10gr2 BCV (image copy, cloning), Stand-by Databases RMAN database cloning, backups and restores (Disaster Recovery drills) Solaris 2.8, 2.9, 2.10, HP-UX, SUSe Linux 10, AIX 5L, Windows NT/2000 Sun/Linux clusters, ASM High Availability

PROFESSIONAL EXPERIENCE:

Confidential

Production Oracle DBA

Environment: 800+ databases (M,G and T in size) running 10gr2 on Sun Solaris 10, RAC/ASM and HA Clusters, SUSe Linux 10 on RAC/ASM (2-8 node cluster), Solaris to Linux database migrations

Responsibilities:

• Participate in decision making meetings with the project teams, interact with Confidential and Vendor project leads/managers to implement new databases or to upgrade/promote new code to existing databases (Dev,Test,QA,Prod).
• Install and upgrade and migrate 9.2 ASM Solaris databases to 4-8 node 10gr2 RAC/ASM Linux.
• Manage production databases per assigned project (from GB to TB in size)

Confidential

Sr Oracle DBA - Tuning

Environment: MS Windows, Linux

Responsibilities:

• Investigate performance issues, test partitioning alternatives, recommend modifications to SQL code/indexes/Oracle parameters.

Confidential

Oracle System DBA

Environment: 600+ databases (M,G and T in size) running Oracle 9.2.0.7, 10gr2 on Sun solaris, Solaris x86, Linux, HP, Enterprise Manager 9.2 and 10gr2, performance tuning, statspack.

Responsibilities:

• Take the lead for the Oracle support activities during in the Siebel transition and upgrade implementation.
• This engagement also involves the transitioning of dozens of Oracle database systems into the IBM Oracle Support team Confidential .
• Follow established processes, documentations and guidelines as per Confidential and IBM procedures in line with SOX requirements.
• Participate in on-call rotation
• Handle daily requests from the various apps teams via Remedy tickets.
• Apply changes to the various databases as requested
• Provide manual backup/restore where needed via BCV copy or via Netbackup depending on the size of the database.
• Perform 10g Oracle installs, create and maintain databases as required by the Application areas.
• Participate in decision making meetings with the project teams, interact with project managers from Confidential and IBM.
• Help plan and execute Oracle DBA tasks for new projects.
• Take the lead whenever appropriate to help with escalated problem resolution.
• Long term projects: New DR site in Boulder, CO, Rman, migration to RAC/ASM, NetApp testing.

Confidential, Charlotte, NC

Sr. Oracle DBA

Environment: 300+ databases (M,G and T in size) running Oracle 9.2.0.7, 10gr2 on AIX, Enterprise Manager 9.2 and 10gr2, performance tuning, statspack, parallelism, snapshots, partitioning.

Responsibilities:

• Follow established processes, documentations and guidelines as per SOX procedures.
• Find bottlenecks and tune dev/test/uat/production databases.
• Work closely applications teams and vendors to help resolve top performance issues.
• Participate in On-call rotation
• Handle daily requests from the various apps teams via Remedy tickets.
• Apply changes to the various databases as requested
• Create and maintain databases and scripts and introduce automation where necessary.

Confidential, Jacksonville, FL

Sr. Oracle DBA

Environment: Oracle 10gr2 RAC/ASM, 9.2.0.4, 8.1.7.4, Enterprise Manager 9.2/10g, Linux, AIX 5L, Solaris 2.9, Windows 2000/2003, data warehouse, materialized views, partitioning.

Responsibilities:

• Sr. Production DBA taking care of a pool of approximately 300 Oracle databases, participating in on-call schedules, being responsible as Primary DBA for a number of projects, tuning, promoting changes in production from development, following SOX procedures, doing Oracle upgrades, installing and configuring Oracle client software, setting up Oracle networking, installing software, setting up and configuring Oracle databases, monitoring performance, rebuilding indexes, defrag tables online and offline, taking care of RMAN backup setups, Disaster Recovery drills, creating and maintaining CA7 mainframe job scheduling of RMAN jobs, migrating databases to new environments, refreshing dev/test databases from production, taking care of OEM alarms, creating and helping with the maintenance of OEM monitoring events and jobs and a number of other daily production activities such as conference calls with project teams, coordinating problem resolution with Oracle Support, creating Oracle SR's in Metalink, following up resolution, etc.
• Migrate DEV/UAT/PROD databases to 10gr2 RAC on Linux and Solaris.
• Find bottlenecks and tune dev/uat/production databases.
• Work closely with Data Administrators and System Administrators while maintaining the various database schemas and file systems.

Confidential, Atlanta, GA

Sr. Oracle DBA

Environment: Oracle 10g, 9.2.0.4, 9.2.0.3, Enterprise Manager, Solaris 2.9, Windows 2000

Responsibilities:

• Find bottlenecks and tune one of the production databases.
• Cleanup several Materialized View Logs no longer active which were causing performance problems.
• Setup Oracle Streams for a proof of concept.
• Run stress tests in development to make sure Oracle Streams can handle 300 transactions per second.
• Tune the environment in order to improve throughput involving Oracle Streams, multiple streams.
• Find alternative methods in case Streams cannot be used (table triggers, materialized views, procedures).

Confidential, Bothell, WA

Sr. Oracle DBA

Environment: Oracle 8.1.7.4 and Oracle 9.2, Enterprise Manager, Precise, Statspack. Solaris 2.8 on EMC with Quick I/O, BCV backups, over 120 databases in a Team of 11 DBA's.

Responsibilities:

• On-call 12-hour, 24X7 rotation schedule in a Team of 12 DBA's.
• Database management, performance tuning, partitioning, disk image backups and restores.
• Close interaction with developers and project teams.
• Work closely with System Administrators during backups and restores
• Help prepare the database migration to the new EMC DMX storage system in June/July.
• Create and maintain production, development and test databases for each Project Team.
• Setup, monitor and maintain connectivity to the various databases. Setup, start and stop Unix cron jobs for daily routines.
• Provide recommendations to treat bottlenecks in production by providing test plans in dev/test environments.
• Implement such tuning plans, monitor results and provide graphs and charts to management
• Work with Team members to maintain stability on the various environments and promote and maintain standards by providing periodic audits.
• Greatest finding and resolving a major performance problem in one of the billing systems which general opinion was pointing to a database issue. Through many nightly hours monitoring batches, collecting and analyzing statistical, I/O, data access, traces, I was able to conclude that the major problem had to do with the scheduling of batches that were running concurrently causing clashes, hot spots on the disk array that were not being moved by the EMC Symmetrix Optimizer because it was not scheduled properly. backups that were failing due to inadequate scripts and absence of proper alerts.

Confidential, Bothell, WA

Sr. Oracle DBA/Siebel Migration Project

Responsibilities:

• On-call 12-hour shift, 24X7 rotation schedule with another DBA.
• Monitor and take any necessary DBA actions during the Siebel 6.3 to 7.5 data conversion.
• Database management, performance tuning, partitioning, disk image backups and restores.
• Close interaction with developers to meet daily/weekly targets on a 12-hour shift.
• Liaise with management and provide daily activity reports to Project Leaders.
• Participate in technical planning meetings.
• Work closely with System Administrators during backups and restores
• Create and maintain dev and test databases
• Setup, monitor and maintain connectivity to the various databases. Setup, start and stop Unix cron jobs for daily routines.
• Provide daily tuning solutions for bottlenecks that occurred during the various migration steps . Work with developers as their main go-to Oracle expert, helping them find the best solutions for their SQL coding for Siebel and Informatica ETL's.

Confidential, Orlando, FL

Technical Lead/Sr. Oracle DBA - Database Team

Environment: Oracle 8.1.6.3 to 9.2.0.4 SQL Server 6.5 and 2000, SAP/R3, SAP/BW (Data Warehouse), Siebel, Manugistics, Remedy, Kronos, iVantage, HRVantage, plus a series of custom Web systems, Topaz, BMC Patrol, TOAD, Enterprise Manager, Statspack, plus a variety of personal scripts, Solaris 2.6 to 2.9, Windows NT, Windows 2000, 150TB total, mixed storage in general and Hitachi Raid S on the 100+ TB SAP/Manugistics cluster, High availability cluster: monitor and maintain databases in the cluster, Monitor, work closely with Basis Admin, assist with tuning SAP R/3 (ERP) and SAP/BW (Data Warehouse), find solutions to daily bottlenecks.

Responsibilities:

• Manager level Technical Lead and Sr. DBA of 65+ Global Databases on a 24X7 on-call rotation schedule.
• Database management, performance tuning, partitioning, data replication, backups and restores, working closely with development teams.
• Go-to for Database issues, tuning and connectivity expert for the entire organization.
• Team building and coaching.
• Test and stimulate the use of Oracle new features where applicable.
• Respond to after-hours calls from the Operations Desk as well as from the Help Desk.
• Initialized an effort to build a Global Database Team, now a reality
• Participated in a multi-team effort to resolve tuning and I/O problems on the SAP/R3 production database, eventually becoming one of the DBAs of these systems which had been until then entirely maintained by the SAP Basis Team. Upgraded the Remedy Production system to 9.2, stabilized and improved response time in order to provide the Database Team with the latest available release, providing the necessary comfort zone to move other databases to 9.2.

Confidential

Senior Database Administrator/Oracle Support Services

Environment: Oracle 5, 6, 7, 8, 8i, 9i, Sun OS 4.5.1, Solaris 2.1 to 2.6, HP-UX, Linux, SCO Unix, several other Unix platforms, Windows NT, OS./2, Novell Netware, Tuning, Oracle Parallel Server (now RAC), Advanced Replication, Distributed Option, Oracle Internals (corruption, ORA-600's, etc.), SQL*Net, Enterprise Manager, BSTAT/ESTAT, plus a variety of customized scripts

Responsibilities:

• 2 years as Sr. DBA of several OSS Global Production/Dev/Test Databases on a 24X7 support with pager rotation, 12 DBA Database management, performance tuning, partitioning, backups and restores, working with development teams and sys admin Daily DBA activities such as maintaining storage, rebuilding indexes and partitions, etc.
• 1 year as Sr. DBA of several CRM Development Databases with the CRM Development Team in Redwood Shores, CA.
• 2 years as Sr. Oracle DBA Instructor for advanced DBA classes for the DBA Master Program and DBA of the System.
• 1.5 years as Special DBA Consultant for Oracle as DBA of the Oracle Database in Brazil, and several DBA consulting projects such as installation and configuration of databases for the Military.
• 6 years as Multilingual (French/English/Portuguese/Spanish) Senior Support Engineer /Team Leader: responsible for DBA calls in Canada, Switzerland and US
• Worked diligently and proactively to keep all systems under my watch with zero downtime (CRM
• Development and Oracle Support Services)
• Provided DBA support for the first electronic elections in Brazil (07/1996), in Sao Paulo City (HP-UX with EMC and Oracle 7.1).
• Provided cover for Sr. DBA instructors all over Brazil as their backup.
• Worked with the UK Development Team for 18 months on a new Global Database
• Represented Oracle Brazil during a Global Management meeting in Orlando, Florida