Oracle Dba Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- 15 plus years as an Oracle DBA. Have worked extensively mainly in the database field with Oracle and Access databases.
- Experience designing end to end database systems and involved with all facets of design, implementation and coding
- Perform Migrations, Clones and Upgrades of Banner Systems.
- Fluent with both OLTP and OLAP, ETL and data models and processing.
- Work well either alone as a senior DBA or in team environments working with others.
- Backup and Recovery with RMAN. Developing ETL processes for SqlServer Databases.
- Confidential Oracle DBA . 9i,10g and 11g. PerformanceTuning,Troubleshooting and upgrading.
- Oversee all facets of design and implementation of two large transactional databases and a data warehouse.
- Migrated databases in real time to new hardware and Oracle versions via Standby databases.
SKILL:
Databases: Oracle7, 8, 8i, 9i, 10g,11g SqlServer, Access, FoxPro, Dbase, GRID
OS's: UNIX (Solaris, Linux, DG - UX, HP-UX), DOS, Windows 2003
Languages: BASIC, C, C++, HTML Java, Perl, C#/VB.NET, PL/SQL, SQL, UNIX shell scripts, Visual Basic, PHP, Javascript, XML.
Web Tools: Middleware Weblogic/Oracle 9ias, Dreamweaver/HTML
PROFESSIONAL EXPERIENCE:
Confidential
Oracle DBA
Responsibilities:
- Database maintenance and support in a critical 24X7 RAC/ASM database(s).
- Database migrations and performance tuning.
- Backup and recovery with Oracle and Sql Server and Sybase.
- OBIEE Datawarhousing in a multi Terabyte environment.
Confidential
Oracle DBA
Responsibilities:
- Performance tuning on mass queries in a multi RAC terabyte environments for Agile application
- Scripting with PL/SQL to build out data fixes Production RAC/ASM 11.2 Oracle Environment using GRID Toad and SQL
- Application redesign
- Worked with replication technologies streams and data guard.
Confidential
Oracle DBA
Responsibilities:
- Maintaining SQL Server Databases.
- Updated existing reports and DTS processes to 2008 with SSIS/SSRS
- Install Database 10g on Test and Production servers and upgraded databases.
- Clone and configure databases.
- Trained and Supervised personnel new to the Oracle Database system
- Created Programs for importing security information into BANSECR
- Used Oracle Apex/HTML DB to connect and serve secure reports
- Developed Pro*C programs to optimize reports
- Worked with ASP.NET 2008 to revamp old classic ASP web applications
Confidential
DBA/Developer
Responsibilities:
- Utilize oracle 9i’s extent management with localized tablespaces.
- Troubleshooting Oracle and SQL Server database applications.
- Automated/Streamlined the Dataware house it transitioned from manual/out of state to in house and automated.
- Worked with Perl/PL/SQL/Pro*C and .Net to develop routines and modules for the applications.
Confidential
Oracle DBA, Nashville TN
Responsibilities:
- Oversee all facets of design and implementation of two large transactional databases and a data warehouse.
- Implemented stored procedures and triggers to facilitate data loading of a class 2 ODS.
- Optimized queries and resolved issues with the databases.
- Migrated databases in real time to new hardware and Oracle versions via Standby databases.
- Worked with PL/SQL to develop triggers to facilitate DW/ETL tasks.
- Installed Oracle 9ias application server and performed database migrations and upgrades.
- Performed tuning on database structures and memory structures when necessary to provide optimum performance.
- Vanderbilt Management Services - Oracle DBA, Nashville TN 9
- Managed Heatlh123’s Oracle Server 7.3.4 Data Warehouse on HP-UX 10.20
- Transferred the data warehouse onto Red Had Linux 6.2 platform and 8i database with interruption in service.
- Performed tuning and monitoring on the databases to ensure optimum performance
- Enhanced the design of the data warehouse to yield enhanced performance and reliability.
- Successfully set up application server 408.1 to run the company intranet.
Confidential
Oracle DBA, Dayton, OH
Responsibilities:
- Oracle DBA support and performance tuning for 50+ Oracle installations using mainly Oracle 7 databases on UNIX and NT platforms.
- Implemented proactive database administration procedures that reduced costs and increased quality of service. Frequently restored or recovered damaged databases.
- Installed/Maintained Oracle 7.x databases on UNIX, NT, VAX, HP platforms.
- Streamlined installation process for Oracle at client sites.
Confidential, Cincinnati, OH
Contract Database Designer/Programmer
Responsibilities:
- Projects involved custom design and implementation of two databases.
- Project involved working with Visual Basic 4.0 and was designed to replace a Man Machine Interface ( Confidential ) or Smart screen system which interfaced the PLC controller of the client’s systems.