Resume of Sr. Oracle Apps DBA




Title
Sr. Oracle Apps DBA

Primary Skills
Oracle DBA

Location
US-TX-Dallas

Posted
Jan-29-08

RESUME DETAILS
Oracle Certified Database Administrator (since 1997)


OBJECTIVE:

Provide clients efficient, budget-conscious, and long-term solutions for everyday business challenges in project management, system architecture, backend infrastructure, performance tuning and optimization, and data warehousing.

SUMMARY OF EXPERIENCE

• Over 13 years of experience with Oracle products in production and development environments spanning several industries: oil and gas, transportation, health care, insurance, financials, and high tech.
• 9 years as a lead technical consultant with Oracle e-Business suite.
• 4 years of 9i and 10g RAC: Ameripath, LaneLogic.com, Agistix, datareturn, albridge, Bright House Networks, and DISD. Installation, Implementation and troubleshooting.
• Oracle 11i subject matter expert and DOUG presenter in the area of 11i upgrades/maintenance, troubleshooting oracle database issues, and standby databases. Presented 8 times in the last 4 years.
• Hands on system design and architecture of client systems included installation of Oracle Server (6,7,8i, and 9i, 10g) and Apps (10.7 and 11i); creation of databases (OLAP/DSS/OLTP); tuning; backup and recovery; migration and upgrades; security auditing; replication, and hot standby databases.


EXPERIENCE

Resmed -- San Diego April 2007 -- August 2007

• Architected, Installed and administered 11.5.10.2 in a multi-tier architecture (Red Hat AS 3.0 and 4.0 - HP and Itanium/Dell hardware)
• Migration of HP UX and True 64 to Linux Red Hat 4.0 (HP hardware)
• Mentoring of client dba's


Hitachi Consulting at Ameripath, HealthMarkets and Lanelogic April 2005 -- February 2007

• At Ameripath and HealthMarkets: Architected, Installed and administered 11.5.10.2 in a multi-tier architecture (Red Hat AS 3.0 and 4.0 - HP and Itanium/Dell hardware)
• Supported financials and hr/payroll implementation efforts
• Upgraded apps database (9i) to RAC 10g Rel 1 and migrated apps database to RAC
• At Ameripath, performed RAC installation (10g Rel 1 ) on a two node cluster (Itanium) for the Lab Information system database
• At Ameripath, performed RAC installation (10g Rel 2) on a two node Sun Fire hardware (Solaris 10)
• At Lanelogic.com, Performed RAC installation (10g Rel2) on a 3 node cluster running Oracle standard edition on Red Hat Linux 3.0
• Worked with Developers to tune plsql code
• Comprehensive application and backend tuning

Raytheon, Dallas, Texas Feb 2005 -- March 2005

• Upgraded Oracle applications from 11.0.3 to 11.5.10; Sun OS 2.6
• Database upgrade to 10g
• System migration to Linux from Sun
• Mentor dba staff

Texas Insturment, Dallas, Texas October 2004 - January 2005

• Upgraded financial systems from 11.0.3 to 11.5.19; Sun OS 2.6
• Database upgrade to 9i
• Automated patching procedures
• Troubleshot Performance issues and Worked with Developers to improve coding standards


Esorterix, Inc. - Austin, Texas March 2004 -- May 2004

• Upgraded client financial systems from 11.5.1 to 11.5.9; Sun OS 2.6
• Database upgrade to 9i
• Mentor dba staff
• Automate patching procedures
• Troubleshot all priority 1 issues

Dallas Independent School District - Dallas , Tx April 2003 -- Ongoing

• Provided DBA support for an implementation of 11i public sector financials, Human resources, payroll, and public sector grants, i-Procurement, and i-Expense
• Performed system upgrade from 11.5.6 to 11.5.9; Compaq tru64
• Installation of 9iAS for an implementation of LDAP/OID/SSO and discoverer
• Installation, configuration and testing of a 2 node 9i RAC cluster running on tru64
• Comprehensive performance tuning of HR and Payroll modules
• Documented in a “How To” manual the information needed by Jr. DBA's to administer the database and the middle tier
• Troubleshot application issues and communicated with Oracle support
• Process automation

CNL Financial Group - Orlando, Fl July 2002 - March 2003

• Lead a team of 2 DBA's and 3 developers to accomplish financial applications upgrade 11.0.3 to 11.5.7 Customization included host programs, forms, reports, work flow, and discoverer reports.

• Conducted first test upgrade to 11i and documented the entire process; Sun OS 2.6 and 8.0
• Physical standby architecture and implementation
• Worked with developers on testing customizations.
• Worked with the functional staff to test the newly created environment
• Backend and application tuning
• Mentor DBA staff

Visa Dinning privileges - San Francisco, Ca July 2001 - Ongoing

? Ongoing support of a 9i database running on linux
? 9i upgrade from 8i
? Physical standby creation and support
? Provided an affordable solution for backups
? Comprehensive application and database tuning
? Staff mentoring
Oracle Consulting at CommerzBank New York, NY July 2001 - July 2002

• Lead a team of 2 DBA's, 2 system administrators, and 3 developers to accomplish a financials implementation
• System design and architecture; Compaq Tru64
• Conducted the first 11.5.3 install and documented the process
• Worked with the Unix team to architect a standby database
• Application upgrade: 11.5.3 to 11.5.5
• Backup and recovery process automation
• Capacity planning
• Conducted training sessions on 11i administration and security auditing
• Worked with functional staff to test the newly created environment
• Troubleshot all priority 1 issues

Servicelane.com -- Dallas , Tx Dec. 1999 - July 2001

• Infrastructure design and architecture
• Installation, configuration, and administration of 8i databases and 11.5.3 E-Business suite. Sun OS 2.6
• Application upgrade: 11.5.3 to 11.5.7
• Oracle Application Server installation, configuration and administration.
• Vignette installation, configuration and administration
• Kana installation, configuration and administration
• Integration of WAP/WML infrastructure with the database
• Worked with developers on change control process and tuning
• Worked with functional staff to test and configure the financial environment.
• Troubleshot all priority 1 issues

Database Consultants, inc. - Dallas, Texas July 97 -- Nov 99

• Provided DBA support in mission critical production environments in the fields of health care, oil and gas, financials, and manufacturing.
• Database and apps installation, configuration, migration and upgrading
• Database logical and physical design
• Pl/sql, C, and C ++ development
• Unix /Oracle process automation
• Implementation of backup and recovery solutions
• Database monitoring and administration
• Mentoring client employees

Technical Analyst / DBA - Oracle Corporation, Redwood Shores, California July 95 -- July 97

• Installation, configuration, and administration of Oracle 7 and 8 databases
• Troubleshot all applications and database problems
• Worked with developers on change control process and tuning
• Developer 2000 testing
• Documentation
• Provided support for a remote sales force
System Integration Engineer - Kodak Health Imaging Systems, Dallas, Texas Jan 94 -- July 95

• Installation, configuration and administration of Sybase database
• Installation and configuration and administration of sun hardware and OS
• LAN configuration and testing
• Writing test plans
• Process automation

SKILLS SUMMARY

Programming Languages -- C, PRO*C, SQL, PL/SQL,4-Test (QA Partner), HTML, WAP/WML, Perl
Case tools -- Erwin and Designer 2000
Development tools -- Oracle Enterprise Manager, sql*plus, Toad/Navigator, Developer 2000
DBA admin tools -- DBArtisan , OEM, sql navigator, and bmc patrol
Operating Systems -- UNIX, LINUX, Macintosh, NT
Database -- Oracle (7,8,8i,9i); Sybase; Fox Pro; 4th dimension
Patching tools: Ring Master
Applications -- Vignette StoryServer 5.0; Kana email management system; Phone.com up.sdk
Application Servers -- Oracle Application Server 4.0.8, 8iAS, and 9iAS; Netscape iplanet; Apache
Oracle Applications -- 10.7, 11, 11i


TRAINING & EDUCATION

Oracle Technical Training
QA partner; UNIX system administration; Developing Web Server applications; InterOffice technical/sales training; AutoInstall 10.6; SQL, PL/SQL, and Developer 2000 technical training.

Education
Bachelor of Science in Industrial Engineering, 1993. University of Texas at Arlington.

Certifications
Oracle Certified dba

CONTACT DETAILS

You must be logged in and have a current resume access subscription. Login or Register »


View all resumes in US-TX-Dallas »
View all resumes in US-TX »

View other Sr. Oracle Apps DBA resumes, Database Administrator resumes