Senior Oracle DBA Resume

Title
Senior Oracle DBA

Primary Skills
RMAN, OEM Grid, 10g

Location
US-GA-Snellville

Posted
Feb-01-09

Objective: A challenging position as an Oracle Database Administrator in a major corporation that will utilize both my technical and managerial skills.


Experience: Vesdia Corporation Atlanta, Georgia
Database Administrator Nov 2008 to Current
• Responsible for 7 production, development and testing environments hosted on Dell servers.
• Manage production, UAT and QA Database environments, including design, trouble shooting, performance and backup/recovery.
• Provide direction and coordination between the Production, Project and IT Operation teams for all aspects of Database Operations
• Manage the Database Operations Team and vendors responsible for Database development and support.
• Provide day to day end user Database support
• Troubleshoot and resolve database and/or application problems encountered by end users.
Technical Environment: Oracle 10G, 11G, SQL Server 2000, Bash Shell, Vi, Data Pump, PL/SQL, SQL, Red Hat 4, Windows XP, Windows 2003, Red Gate, OEM DB Console, SQL Developer, VPN

T-Mobile USA Atlanta, Georgia
Lead Database Administrator Nov 2005 to Nov 2008
• Responsible for 76 multi-terabyte databases in production, development and testing environments hosted on HP servers. Total storage for databases: 175 terabytes. Largest database: 26 terabytes.
• Responsible for RMAN backups of test and development databases.
• Installed and administrate OEM Grid Console.
• Led DBA team responsible for 9i to10G database upgrades for development and test environments.
• Led DBA team responsible for relocating 10 multi-terabyte databases from Tampa data center to Seattle using RMAN clone process.
• Installed and configured 2 node 10G Linux RAC test environment using ASM & OCFS2.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Monitor the progress of DBA projects and resolve issues as necessary.
Technical Environment: Oracle 8i, 9i, 10G, 11G, Korn Shell, Vi, PL/SQL, SQL, HP UX 11.23 & 11.3, Linux, RAC, RMAN, Veritas Netbackup, OEM Grid Console, DB Artisan, Toad, SQL Developer, VPN, EMC, HP 9000 Superdome


Silverpop Systems Atlanta, Georgia
Oracle DBA Feb 2005 to Nov 2005
• Responsible for the administration of 4 700GB+ production high availability (Veritas Cluster) databases hosted on Sun V480 & V490 servers.
• Responsible for production backup and recovery strategy using RMAN.
• Monitored database performance via STATSPACK and Quest Central.
• Maintained metrics on database growth patterns in order to insure adequate storage was available.
• Participated in design reviews for upcoming application enhancements.
• Recommended infrastructure changes that would enhanced scalability.
• Worked closely with system engineer to determine optimal server and storage configurations for Oracle databases.
• Applied Oracle patches as necessary.
Technical Environment: Oracle 9i, PL/SQL, SQL, Korn Shell, Vi, Solaris 2.8 & 2.9, RMAN, Veritas Netbackup, Oracle Enterprise Manager, Quest Central, VPN, EMC

Darwin Partners T-Mobile USA Atlanta, Georgia
Contractor Jun 2004 to Feb 2005
• Performed data extracts/loads in the testing environment.
• Resolved test engineer requests submitted via Remedy and Mercury Test Director.
• Created SQL scripts to extract or move data.
• Tuned SQL statements for test engineers.
• Upgraded database portion of AMDOCS Ensembler & Enabler software releases in test environment.
• Created PL/SQL procedure that was used track BPTCR (code) changes in the test environment.
• Assisted in the design and implementation database triggers to prevent unauthorized changes in test environment.
Technical Environment: Oracle 8i, 9i, Korn Shell, PL/SQL, SQL, HP UX 11.23, Oracle Enterprise Manager, Toad,VPN

ING Atlanta, Georgia
PeopleSoft Oracle DBA Feb 2004 to May 2004
• Administrated production, development, and test Oracle9i databases hosted on IBM servers.
• Assisted lead project DBA with HR module upgrade.
• Tuned problem SQL code identified in Mercury Test Director.
• Reviewed init parameters and recommended changes for HR project databases.
• Configured STATSPACK to monitor production, test, and databases.

Technical Environment: Oracle 9i, Korn Shell Peoplesoft HR and Financials, PL/SQL, SQL, AIX, Oracle Enterprise Manager, Toad,VPN, EMC

FleetCor Norcross, Georgia
Senior Oracle DBA Nov 2002 to Feb 2004
• Administrated production, development, and test Oracle 8i/9i databases hosted on Sun and Fujitsu servers.
• Defined database migration strategy to relocate production database to new Sun servers.
• Backup and recover test and development databases using RMAN.
• Defined Oracle9i upgrade strategy for production, development, and test databases.
• Installed and configured 9ias Release 2.
• Assisted developers troubleshoot SQL and PL/SQL code.
• Installed and configured STATSPACK to assist with production database tuning.
• Responsible for policies and procedures that track changes in all databases.
• Created daily, weekly, and monthly DBA checklists for each environment.
• Documented database/server configuration for production, test, and development databases.
• Planned, presented, and executed database performance tuning in all environments.
• Coordinated production database maintenance (upgrades, patches, changes) with EDS and FleetCor management.
• Provided recommendations to Senior Vice President of IT concerning Oracle solutions that that would complement FleetCor's business objectives.
• Achieved Oracle 9i certification.
Technical Environment: Oracle 8i, 9i, Korn Shell, PL/SQL, SQL, Sun Solaris 2.7, Oracle Enterprise Manager, VPN, Linux, SQL Navigator, Spotlight Veritas Cluster, Oracle 9ias

Segue Solutions (formerly Stonebridge Technologies Inc, formerly Tactics, Inc.) Atlanta, Georgia
Consulting Manager/Senior Consultant Aug 1997 to Oct 2002
Assignments included projects at the following companies: UPS, Georgia Pacific, AT &T, MCI WorldCom, Blue Cross Blue Shield, E*Trade, and Habitat for Humanity.

Consulting Manager
• ?Managed and mentored 20+ database administrators, system engineers, and network engineers.
• Conducted performance reviews.
• Assisted consultants create career development plans.
• Provided technical advice to consultants in the field.
• Developed proposals, statements of work, and project plans.
• Allocated technical resources for client projects.
• Managed & resourced infrastructure emergency response teams.
• Provided business development support for local sales and delivery teams.
• Engaged with clients in architecture design, analysis, project management, and solution delivery.

Senior Consultant
• Installed and configured Oracle 8i/9i on Solaris, OpenVMS, HPUX, and Windows environments.
• Performed numerous production database migrations/upgrades.
• Performed data loads using SQL*LOADER.
• Created materialized views in order to extract data from SAP source database.
• Tuned SQL and PL/SQL code using Oracle Enterprise Manager tools and explain plans.
• Installed and configured Oracle Parallel Server on VMS and UNIX platforms.
• Installed, configured, and tested RMAN in client production environments.
• Assisted with upgrading Oracle Financial Applications from 10.6 to 10.7.
• Designed and implemented database partitioning solution to enhance client's application performance.
• Participated in data center build out for client in Alpharetta, Georgia and Rancho Cordova, California.
• Created SQL code to extract requested data from data mart.
• Created and or modified UNIX shell scripts to automate processes.
• Provided on call support for remote clients.
• Created and or modified UNIX shell scripts to automate processes.
• Created data model of client's databases using Erwin 4.0.
• Created fact and dimension tables to support data mart.
• Led team that outlined transition plan to move data mart to corporate data warehouse.
• Achieved Oracle7 Database Administrator certification.
Technical Environment: Oracle 7, 8i, Korn and C shell, PL/SQL, SQL, HP UX, AIX, NT, Solaris, SCO-Unix, Novell, VMS, Enterprise Manager, Erwin, Toad, VPN, EMC, Oracle Financials 10.6, 10.7, & 11.0 & 11i, Oracle Parallel Server (OPS), Digital Unix AdvLSM, PKMS


Lockheed Martin Aeronautical Systems Company Marietta, Georgia
Lead Systems/Oracle Database Nov 1992 to Aug 1997
Administrator
• Created, maintained, and monitored Flight Test Configuration Control System Oracle7 database for next generation C130 aircraft. Database was hosted on Digital Alpha 2100 with Digital UNIX 3.2 operating system.
• Supervised Jr. DBA & Jr. Systems Administrator.
• Installed, configured, and maintained Oracle Reports and Forms for development staff.
• Installed, configured, and tuned Sun SPARC 10/20 and Digital Equipment Alpha 2100/4100 servers.
• Created logical volume file systems using AdvLSM.
• Created UNIX shell scripts to automate system and database administration tasks.
• Developed and implemented Service Request Tracking System using Oracle Forms and Reports for SEPD.
• SECRET security clearance.

Lockheed Martin Aeronautical Systems Company Marietta, Georgia
Facilities Coordinator Aug 1991 to Nov 1992
• ?Coordinated office relocations within the Engineering branch.
• Designed office layouts.
• Designed and maintained 3166 (ticket tracking) Tracking System for the Engineering branch database using Nomad database software on IBM mainframe.
• Frequently requested to handle special assignments for Vice President of Engineering and Directors.
• SECRET security clearance.


SKILLS:
Operating Systems: DOS/Windows, Windows 95, Windows 98, Windows NT, Windows 2000 XP, Linux, Digital UNIX, VMS, AIX, HPUX 11.0,11.23 & 11.30, Sun Solaris 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, SCO-Unix, Novell, Linux
Database Software: Oracle version 6, 7,8, 8i, 9i, 10G, 11G
Oracle Financials 10.6, 10.7, 11i
SQL Server 2000
Database Tools: SQL*Plus, SQL Loader, E SQL*Plus, SQL Loader, Erwin 4.x, Oracle Enterprise Backup Utility, RMAN, Oracle Parallel Server, RAC, OEM Grid Console, Oracle Forms, Oracle Reports, Oracle Designer, Quest Database tools, DB Artisan, Oracle Enterprise Manager, SQL Navigator, Spotlight, Oracle9ias, Peoplesoft HR & Finance modules, Oracle Financials, ASM, OCFS2, Veritas Cluster (High Availability), Nomad, Red Gate
Application Software: SQL, Microsoft Word, Microsoft Excel, Microsoft
Project, Visio, Power Point, RTM, Interleaf, PCMS, PKMS
Languages: COBOL, PL/SQL, SQL, C, Korn Shell, C Shell
Servers VAX 11/780, Micro Vax Sun SPARC, Sun 6500, SunUltra, V480 V490 Digital Alpha 2100 Alpha 2100 & 4100, Fujitsu PrimePower, HP K, L, N, 9000 Superdome & Itanium servers
Certifications Oracle Certified Professional (OCP) 7 & 9i Database Administration




Education: Georgia Southern University Statesboro, Georgia
BBA Business Management/Computer 1985 & 1991
Information Systems

References: Available upon request

Certifications
Certifiied 7 and 9i


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

Resumes in Snellville, GA | Resumes in Georgia

View other Senior Oracle DBA resumes, Database Administrator resumes