Post Job Free

Resume

Sign in

Oracle Database Administrator

Location:
44136
Posted:
June 27, 2012

Contact this candidate

Resume:

PROFILE

Exceeding four years experience in a lead Oracle database administration role and six years total experience as an Oracle DBA. Proven results working on a global team managing over 300 Oracle databases and providing 24x7 support. Working closely with other IT personal including UNIX, Windows and Storage administrators to architect new enterprise systems. Optimize performance for all Oracle systems including Oracle 11i e-Business suite for Americas and European financials applications. Responsible for all aspects of database and Oracle applications administration.

SOFTWARE Oracle Database (8i, 9i, 10g, 11g), Microsoft SQL Server (2005, 2008), Oracle E-Business Suite (11i, R12), Oracle Enterprise Manager, RMAN, Exadata, OBIEE, Apache, PL/SQL

SYSTEMS

Linux, UNIX (HPUX, Solaris), Windows Server (2003, 2008)

PROFESSIONAL EXPERIENCE

Eaton Corporation

Lead DBA August 2007 - Present

• Deployed enterprise wide RMAN backup solution for over 300 Oracle databases and automated the process through BMC Control-M job scheduling application.

• Served as project lead to migrate 50+ databases from HPUX to Linux Red Hat 5 platform.

• Coordinated and performed dozens of database upgrades from 9i to 11g.

• Responsible for database and Oracle applications patch maintenance.

• Monitored databases via Oracle Enterprise Manager and identified areas for performance tuning.

• Deployed Oracle Advanced Compression for multiple VLDBs (Very Large Databases), including Exatada.

• Established excellent business relationships with internal and external customers and vendors, and designed internal solutions for third party applications.

• Performed instance refreshes for core Oracle database and Oracle applications environments in a timely manner in order to meet project needs for customers.

• Trained and managed a staff of nine offshore DBAs to perform all production support activities.

• Managed service requests with Metalink/My Oracle Support to resolve database issues.

ICI Paints

Database Administrator January 2006 - August 2007

• Monitored development, QA and production databases to ensure nightly backups, exports and loads completed successfully.

• Performed database installations and patch maintenance.

• Responsible for coordinating SQL scripts to ensure successful promotion of projects from development to production.

• Created dynamic SQL through PL/SQL stored procedures to automate monthly database administration tasks.

• Monitored tablespaces and file systems to ensure data was appropriately managed from the physical and logical side of the database.

• Responsible for maintaining technical documentation for Sarbanes-Oxley compliance.

Cuyahoga County Court of Common Pleas, Juvenile Division

Programmer/Analyst 2 May 2001 - January 2006

• Develop and automate daily, monthly, quarterly, and annual management reports for internal and external use using Oracle 9i SQL, PL/SQL and Crystal Reports, and respond to ad hoc data requests on a daily basis.

• Create, update and maintain Oracle database entities, and populate tables with data using SQL*Loader.

• Support internal and external users of the Juvenile Information Management System by helping users navigate screens, develop ad hoc reports and tutoring/training users.

• Used knowledge of the information system to trouble-shoot data versus programming issues.

EDUCATION Bachelor of Arts, Criminal Justice Studies, Kent State University (Cum Laude)

Minor in Computer Information Systems

REFERENCES Available upon request.



Contact this candidate