Lead Database Administrator Resume Ft. Lauderdale FL - Hire IT People

OBJECTIVE: Applicant is an Oracle Certified DBA with over 10 years experience in relational database management systems, quality assurance, technical support and business analysis. Mr. Tomsey possesses strong communication skills with the ability to interact with end users, developers, system administrators and project management.

EXPERIENCE:

Confidential, Ft. Lauderdale FL, 6/2005 to Present Lead Database Administrator

Administered/Maintained 1-2 Node RAC 10.2.0.3 system using ASM storage (200GB) for Laboratory Information System installed on Linux Red Hat 3 and 1 Single Instance 10.1.0.3 (100GB) database residing on Suse64.
Migrate LIS system from 10.2.0.3 to 11.2.0.2
Prepared Linux, Suse64, Unix (AIX), and Windows servers for Oracle installations.
Installed and configured a Test and Development instance for both production databases, both test and development databases were created using ASM for storage management.
Synchronizing of development, test, and production RDBMS. Using shell scripts, sql, and imp/exp.
Development and implementation of all RDBMS backup and recovery policies both RMAN and o/s level backups.
Writing of all audit triggers (pl/sql) to provide an audit trail for custom written apps.
Writing and maintaining PL/SQL Package to perform our batch operations.
Review all development involving pl/sql, sql, and batch operations running against Oracle.
Implement/Compile all sql, pl/sql produced by development
Performance analysis and tuning.
Install and configure all Oracle RDBMS.
Assist Networking team to implement proper connection pooling configuration on production web servers.
Assist and train new development team members on sql and pl/sql best practices and tuning.
Modeling data structures to business models
Troubleshoot and resolve sql, segment, and pl/sql issues
Troubleshoot and iterative testing of application to production.
Troubleshoot all network issues related to db connectivity
Responsible for growth analysis, suggesting and implementing storage solutions.
Created additional ASM disk groups and migrated datafiles to new disk groups using RMAN
Write specs for custom Actuate reports used to provide patient results
Migration of legacy apps to Oracle - Two migrations involving SqlServer to Oracle conversions.
One migration of application from Oracle (10.2.0.3) to SqlServer (2005)
Application migration Oracle8/Oracle10g LIS production migration (150GB)
Review and Interview prospective DBA candidates

Confidential, Ft.Lauderdale, FL, 9/00 to 6/2005 Junior Database Administrator

Assisted lead DBA with day to day troubleshooting and maintenance for 2 Oracle 8.1.6 instances (100gb)
Installed and configured all Oracle clients in-house and nationwide.
Designed and implemented a Sales Application using PL/SQL
Performed datafile relocations to different file systems - multiple moves to reduce I/O bottle neck, eventually placing heavily used datafiles onto a 30GB RamSan SSD
Understanding of SQL scripting, HTML, and MS Project/VISIO, Toad, UML
Wrote ad-hoc queries for business analysis (SQL) - mostly sales information
Work with Oracle support to resolve any issues not resolved in house.
Identify and remove obsolete database objects.
Ad hoc reporting to assist QA and audit personnel.
Created procedures and functions for manipulating batch data imports for custom LIS.
Migrated 100Gb Billing Schema from Oracle version 8.1.6 to 10.1.03 (AIX to Suse64)
Wrote shell scripts (Bash) for trace and log file maintenance
Wrote archival scripts for individual objects and re-organized high use objects on a quarterly basis
Successfully restored/recovered production database using RMAN backups due to known bug in 8.1.6 Oracle RDBMS

Confidential, Ft. Lauderdale FL, 01/99 - 09/00 Database Administrator (Unpaid Internship) Internship at an Oracle specializing consulting company. Trained in data modeling, application development, SQL*Plus and PL/SQL. Responsible for the creation of two applications; which upon completion were critiqued and graded by senior consultants.

SKILLS: Oracle RAC and Oracle Single instance RDBMS, Primary Focus has been Oracle RAC, RMAN, ASM, SQL, PL/SQL, Export and Import Utilities, Export Data Pump and Import Data Pump, OEM, Database Control, Grid Control, Log Miner, Sqlplus, SqlLoader Suse64 Linux, RedHat Linux, Scripting (BASH), Unix, AIX, Visio, SQL Server, TOAD, Statspak, JDeveloper, TkProf, Remote access services, Microsoft Office 2000, Windows 95/2003 64bit

CERTIFICATIONS:

OCP Certified Database Administrator Oracle 9i
OCP Certified Database Administrator Oracle 10g

EDUCATION: Oracle 9i DBA Fundamentals Oracle 9i Database Performance Tuning R2 Oracle 10g New Features For Administrators

We provide IT Staff Augmentation Services!

Lead Database Administrator Resume

Ft Lauderdale, FL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship