Career Profile

Oracle Certified Database Administrator with over 15 years of experience in Database Administration & Application analysis/design. Excellent problem solving and trouble shooting skills balanced with strengths in communication, teamwork and leadership.
Experience includes:

• Installing and maintaining “High Availability” Oracle configurations.
• Monitoring production systems on a 24/7 basis to achieve maximum system availability.
• Installing, patching, upgrading and maintaining Oracle databases and Oracle application servers.
• Maintaining data integrity by enforcing security standards and user access controls
• Capacity planning with forecasts of future database utilization and equipment requirements.
• Maintaining database performance by using system monitoring and results analysis.
• Managing physical data base layouts and review hardware configurations.

Technical Skills

Oracle 11g, 10g, 9i, 8i, SQL Server 2000, MYSQL

Operating Systems

Solaris 8,9,10 RHEL 3,4,5 Windows NT/2003, HP-UX Unix, IBM AIX 5

Tools

RMAN, Enterprise Manager, Erwin, SQL*Plus, Veritas Netbackup and Backup Exec, SQL*Loader, exp/imp & data pump, VMware ESX4

Languages

SQL, PL/SQL, Unix shell scripting

Application Server

Oracle AS 10g, 9iAS R1& R2

Storage

ASM, EMC SAN, PowerPath, Net App Filer NAS & SAN, iSCSI

OCP Certification

8i DBA, 9i DBA, 10g DBA

Employment History

Confidential,Ann Arbor, MI

Senior Consultant (Jan 2004 – Present)
Served as DBA/technical lead for several projects. Provided mentoring to DBA’s and developers as an Oracle subject matter expert. Utilized project best practices, such as change control, project task estimating, version control. Installed and maintained Oracle High Availability configurations. Experience with databases over one-terabyte (VLDB) and data warehouse methodologies.

Key Skills:

• Installed and configured Oracle Database 11g on RHEL/OEL Linux 5 64 bit/HP-UX/Solaris
• Installed and configured Oracle Database 10g on Solaris, RHEL/OEL, HP-UX and Windows.
• Installed / configured Oracle Application Server 10g on Solaris, AIX, Linux and Windows.
• Implemented RMAN backup procedure using catalog and nocatalog modes.
• Upgraded Oracle 8.1.7, 9.2 to 10gR1 and 10gR2 using the dbua tool
• Apply interim patches with Oracle Opatch.
• Installed and Managed SQL Server 2000 & manage SQL Server backups and transaction logs.
• Installed and Managed one and two tier 11i E-Business Suite 11.5.10

High Availability

• Installed and configured 11gR2 RAC on RHEL5 with ASM.
• Installed and configured 10g RAC on RHEL4, and Sun Solaris 10 with ASM.
• Upgraded and patched 10g RAC from R1 to R2 on RHEL4 and Sun Solaris
• Identified and correcting RAC interconnect issues on 2-4 node clusters.
• Configure TAF and test failover for issues.
• Implemented 9i & 10g Data Guard.
• Installed and configured 10g ASM on Solaris and Linux.

• Utilized table partitioning, materialized views, and bitmap indexes for performance
• Utilized PL/SQL bulk binding, applied direct load inserts and parallel DML.
• Design and develop data mart fact and dimension tables using star schemas.
• Utilize EMC and Hitachi SAN split mirror & shadow copy technologies for VLDB backups.
• Implement incremental RMAN backups with 10g change tracking feature
• Configured Oracle flashback database for data PIT data recovery.

• Utilized AWR/statspack to identify performance-tuning opportunities.
• Monitor Oracle Disk I/O Performance.
• Monitor UNIX environment with sar, vmstat, iostat, top and smit.
• Tuned SQL and PL/SQL where performance or complexity was an issue.

Senior Consultant (July 2000 – Jan 2004)
Served as DBA and Technical Lead for several TUSC projects. Designed and Supported web based and client/server applications, provided mentoring to DBA’s and developers, and taught TUSC training classes. Utilized project best practices, such as version control, change control, project task estimating.
Key Skills:
Administration

• Installed/configured oracle 8i & 9i database on Solaris 9, AIX 5, Linux, and Windows.
• Installed / configured Oracle Application Server 9IR2 and 10g on Solaris, AIX, Linux and Windows.
• Implemented RMAN backup procedures.
• Enabled/troubleshoot archive log mode and database back up issues.
• Implemented database level security using roles and privileges

• Implemented statspack to identify system tuning issues
• Tuned SQL with explain plan/auto trace, trace/tkprof, utlbstat.
• Oracle disk management and Oracle disk I/O Performance.
• Refined SQL and PL/SQL where performance or complexity was an issue.
• Manage 9i histograms for skewed data and stored outlines for optimizer stability.

• Utilized Oracle Designer and ERWIN and to create logical/physical data models.
• Created schema designs using Designer 2000 and generated ERD’s
• Created database constraints/tables/indexes and schema objects to support applications.
• Developed PL/SQL packages/procedures/database triggers to support business logic.

• Utilized table Partitioning, Materialized views, and bitmap indexes for performance and VLDB maintenance.
• Utilized PL/SQL bulk binding, applied direct load inserts and parallel DML.
• Design and develop datamart fact and dimension tables using star schemas.

BS in Business Administration