We provide IT Staff Augmentation Services!

Oracle Resume

Summary

A database administrator with eight years experience on database system implementation, configuration and troubleshooting. A database administrator with experience on operating system administration, backup and recovery, performance tuning, high availability, reverse engineering and effective system implementation.

Technical Skills

Database System: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005, Sybase SQL Server 12.5/15.0, Netezza DB 3.5
Web Servers: Apache-Tomcat, Microsoft IIS, Bea Weblogic,
LANGUAGES: PL/SQL, T-SQL, C, Shell Scripting
ERP System: Oracle EBS 10.7/11.5.9, SAP 4.7, PeopleSoft 7.0-9.0
Operating System: Solaris 8/9/10, AIX 4.3/5L, HPUX 10.2/11.0, RedHat Linux AS 3.0/4.0/5.0, Suse 10.0, Windows 2000/2003
Hardware: Sun 12K/6800/880, Dell 1650/1850/2850, HP 9000, MAC G5, IBM P670 RS/6000, HP Proliants
Other Tools: ERWin, DBArtisan, RapidSQL, Visio, Erstudio, TOAD, Oracle OEM, Oracle Grid Control 10g, Crystal Report Server XI, MS Office 2000/2003,Visio 2000/2003, Spotlight for Oracle and MS SQL Server, Oracle HTMLDB, Microstrategy, Oracle 10g RAC, Oracle RMAN, SQL, Litespeed, Oracle ASM, Informatica, NetApp, Quest Stealth collect

Employment History

Confidential - 08/2010 to 10/2010
Windows Network/SQL Database Administrator (Contractual)

  • Maintain and support network file servers and desktop workstations.
  • Maintain routers, switches and net screen fire wall.
  • Maintain, patch and support Windows2003 /MS SQL Servers 2005.
  • Maintain users via Active directory.
  • Wrote MS Access reports for reporting purposes.
  • Maintain DTS packages for custom application.
  • Setup and maintain IIS web application.
  • Install and recommended RHEL servers/MySQL servers on old files servers.

Confidential - 2008 to 2009
Oracle RAC Database Administrator(Contractual)

  • Maintain, patch and support Oracle 10g RAC on HPUX 11i Itanium systems 24/7 for our online customer tracking system.
  • Maintain, patch and support Oracle 10g RAC on HPUX superdome for our data warehouse system.
  • Maintain, patch and support Oracle 10g on Solaris for our GIS system.
  • Maintain capacity planning and performance tuning on Oracle, Sybase and MS SQL database.
  • Backup DBA for our Sybase ASE 12/15 and Sybase replication system.
  • Backup DBA for our Microsoft SQL Server Cluster 2005
  • Perform annual disaster recovery procedure for all databases on production environment.
  • Created materialized views for reporting purposes.
  • Upgrade Oracle 10g to 11g for certain applications.

Confidential- 2007 to 2008
Enterprise Database Administrator (Contractual)

  • Responsible for a three terabyte Netezza database for our data warehouse.
  • Worked with the enterprise data architect for any database object implementations using Erwin.
  • Performance and tuning on all production data marts.
  • Document policies and procedures for our data warehouse environment.
  • Administer, maintain and clone Oracle EBS11.5.9 ERP system for production, test, training and development.
  • Perform patch management for multiple Oracle EBS environments.
  • Implemented backup and recovery standards for the agency's ERP system (Oracle 11i).
  • Support Informatica cluster and Business Objects as part of our Data warehouse environment.
  • Perform annual disaster recovery procedure for all databases on production environment.
  • Maintain, patch and support all in house databases - Oracle, MS SQL and Netezza.

Confidential - 2006 to 2007
Oracle/MS SQL database administrator(Contractual)

  • Responsible for various activities related to the design, implementation and maintenance of the Oracle and MS SQL databases.
  • Ensure database definitions, structures and documentation.
  • Design and analyze policies, procedures, and standards relating to database management.
  • Support business applications running on MS SQL Server 2000 cluster.
  • Maintain and monitors PSFT application running on Oracle database.
  • Design and analyzes policies, procedures and standards relating to database management.
  • Design, plan and test disaster recovery and fail-over tests for Oracle/MS SQL databases.
  • Evaluate, tested, upgrade and rolled out new versions and patches of Oracle and MS SQL Server.
  • Backup support for PSFT application and web server.

Confidential, Incorporated - 2005 to 2006
Enterprise Database Administrator

  • Implement and manage SQL 2000/2005 databases for a dozen applications. Maintain and support DTS applications.
  • Setup and manage OAS 10g and 10g Grid control for automated backup.
  • Automate database administration tasks geared towards Oracle 10g databases running on RedHat Enterprise 4.0.
  • Setup and maintain three node Oracle RAC on RHEL environment.
  • Administer Two Terabyte Netezza Data warehouse database and implement back/recovery solution.
  • Assist developers in tuning SQL queries.
  • Maintain capacity planning and performance tuning on Oracle, SQL Server and Netezza.
  • Perform system administration and upgrades for all Oracle databases connected to mySAP 4.7 instances.
  • Support the all enterprise databases (Oracle, SQL Server and Netezza) 24 by seven.
  • Perform annual disaster recovery procedure for all databases on production environment.

Confidential - 2002 to 2005
Oracle Apps DBA/MS SQL DBA/AIX Administrator

  • Install and configured AIX on IBM/RS6000 servers.
  • Perform patch management for multiple Oracle environments.
  • Maintain user profiles, system printers, oracle job scheduler and concurrent manager for the agency's ERP system (Oracle 11i).
  • Written Oracle SQL loader and PL/SQL programs for Oracle 11i ERP system.
  • Implement database security standards.
  • Troubleshoot and resolve application and database performance issues on a daily basis.
  • Monitor user activities and database disk space.
  • Perform Oracle application and database migration to the latest version and platform.
  • Cloning of Oracle E Business Application Database for our test, QA and training environments.
  • Implement backup and recovery standards for the agency's ERP system (Oracle 11i).
  • Administer and propagate Oracle discoverer for all agency users.
  • Maintain custom integration between Oracle 11i, Kronos and Railfocus.
  • Administer and patched AIX 5L Operating system.
  • Manage and implement SQL 2000 databases for our document imaging system and corporate website.
  • Support main critical applications with Oracle/MS SQL Server 24/7.
  • Perform annual disaster recovery procedure for all databases on production environment.

Confidential 2000 to 2001
Enterprise Database Administrator

  • Support Oracle, MS SQL and Sybase databases 24 by seven.
  • Worked with the enterprise data architect for any database object implementations using Erwin.
  • Setup, configure and patch Oracle databases for our Peoplesoft version 7 in production and test environment.
  • Setup, configure and patch Sybase 11 database for our due diligence system on Solaris.
  • Support ODS (Operational data store) process for our data warehouse system.
  • Troubleshoot and resolve database issues in a timely manner.
  • Perform annual disaster recovery procedure for all databases on production environment.
  • Write bulk copy and SQL loader programs for automatic batch process on our ODS.
  • Administer our version control system for developers, QA and management.
  • Perform for disk capacity planning and patching.
  • Clone databases for our test, development and QA environments.

Confidential -1999-2000
Oracle/MS SQL Database Administrator

  • Support, upgrade and install Oracle 8.1.7.4 database for our Oracle 10.7 NCA system. Support, install and configured HPUX 10.2 operating system. Implemented backup and recovery scheme for the companys ERP system (Oracle 10.7 NCA). Responsible for the tuning, performance and capacity planning of the Oracle server. Configured and maintained Symbiator application running on MS SQL 6.5.

Training

Green Technologies
Bachelor of Science in Computer Science

Certifications

  • Oracle Certified Professional 10g
  • Microsoft Certified System Engineer
  • A+ certified

Hire Now