Oracle DBA Resume

Title
Oracle DBA

Primary Skills
Oracle database administration, PL/SQL development, data modeling

Location
US-FL-Orlando

Posted
Aug-13-08

SUMMARY

Results-oriented professional with over 4 years of Mid-level experience with Oracle database administration and SQL development, RAC, standby, replication, installation, configuration, migration, sizing and space management, backup and recovery, performance tuning and troubleshooting. Strengths include Leadership, Interpersonal Skills, Communication, Problem Solving, Highly Energetic, Team-Oriented, Flexible, and Ability to Work in Parallel. Seeking database opportunities in Information Technology, Product Development, Management, or similar.

EDUCATION

PhD, Organization and Management, Capella University, 2009 (ABD), GPA: 3.8
MS, Computer Information Technology, Regis University, 2003, GPA: 3.8
BS, Business Administration of Technical Studies, Bellevue University, 2001, GPA: 3.7

TECHNICAL PROFICIENCY

Software: Oracle 10g Grid, Oracle 9i, and 8i RDBMS, Oracle Net, OEM, RAC, RMAN, SQL*NET, TOAD, SQL*Loader, SQL Developer, Data Guard, Oracle Security, Microsoft SQL Server 6/7/2000/2003, Microsoft Visio 2003, Microsoft Access, Crystal Reports, Maximo, CostPoint, SPSS 13.0/14.0/15.0, CA AllFusion ErWin.
Operating Systems: Windows 98/2000/XP, Sun Solaris 8, HP/UX, AIX.
Languages: SQL, PL/SQL, T-SQL, Unix Shell Scripting, MySQL.


Experience

Marriott Vacation Club International (MCVI): Orlando, FL, (January 2008 -- April 2008)

Systems Analyst & Developer: Supported the architecture and development of the Marketing Solutions Database which provided Marriott Vacation Cub International Timeshare Representatives with resort owner, customer, and prospect data throughout the Central Florida region.

Software Development: Provided operational support for the Marketing Solutions Database through implementing predefined SQL processes. Developed ETL processes using TOAD, SQL*Loader and SQL*PLUS to meet key marketing and project initiative requirements. Created transactions and ran tests to find errors and confirm program specifications. Modified and maintained software programs written by others.

Technologies: SQL*PLUS, SQL*LOADER, UNIX, PL/SQL, Import/Export

Products: TOAD, Oracle Enterprise Manager (OEM), Oracle 9i OEM, Oracle 10g OEM, SQL Developer, Microsoft Access 2003

Environment: HP/UX, Linux, Windows XP, Windows Server 2003


Science Applications International Corporation (SAIC) (Contractor): John F. Kennedy Space Center, Florida, (May 2007 -- January 2008)

Database Administrator II: Served as Oracle DBA for application programs Maximo and Costpoint in the Space Gateway Support (SGS). The application programs supported NASA-specific strategic asset, service management, and project accounting data. Performed database tuning using Explain Plan, TOAD, and Enterprise Manager. Establish standby/cloned databases via Data Guard for Database Disaster Recovery. Created, procured, and maintained various database-related documents such as manuals and spreadsheets. Employed pre-defined Unix scripts to clean up database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories. Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases. Assisted a team of DBAs in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2. Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.

Technologies: Unix, Shell, Cronjobs, PL/SQL, SQL*PLUS, SQL*Loader, Import/Export

Products: Oracle 8i RDBMS, Oracle 9i RDBMS, and Oracle 10g Enterprise Management (OEM) Grid Control, TOAD, CA AllFusion ErWin, Maximo, Costpoint, Microsoft Visio 2003, RMAN, Oracle Streams

Environment: HP/UX, Linux, AIX, Windows XP, Windows Server 2003

Database Sizes: 10+ Oracle databases totaling 5TB


CACI, Inc. (Contractor): Panama City, Florida (July 2006 -- May 2007)

Database Analyst III & Database Administrator: Provided system development life cycle support of Enterprise Environmental Safety and Occupational Health (EESOH) database within adequate safeguards. Helped maintained the re-engineering of a J2EE web-architected, Oracle-based, relational database to replace numerous independent stove-piped tracking systems operating in several different environments, which ranged from Oracle client-server applications to Microsoft Access databases.

Database Administration: Implemented database monitoring and tuning, application, and queries using TKPROF, Explain Plan, OEM, and custom scripts for optimum performance within testing, development, and production environments. Installed, configured, and upgraded Oracle 9i and Oracle 10g RDBMS software and tools on HP/UX, AIX, and Sun Solaris 8. Installed and Configured Oracle RAC on Windows 2003 Server--4 node cluster with OCFS2 and ASM for testing and development. Monitored, tuned, load balanced RAC environment using OEM, Statspack, and V$ dynamic views. Coordinated installation and configuration of Oracle 9i Application Server, Oracle Internet Directory (OID), and LDAP to enhance database security. Helped implement and maintain disaster recovery and archiving procedures for data. Aided systems administration in Unix disk implementation and management. Implemented database backup strategy and performed full, incremental and cumulative backups using RMAN utilizing the Recommended Backup strategy through Grid control.

Software Development: Reviewed, developed, and designed data models with application development team. Utilized ErWin to ensure logical data models were mapped efficiently into physical data models. Developed applications utilizing pre-defined PL/SQL packages, stored procedures, functions, and triggers. Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, Statspack and TKPROF utility. Coordinated with various departmental agencies to trouble-shoot proposed system designs. Created ERwin entity relationship diagrams for a data warehouse database.

Technologies: SQL*PLUS, SQL*LOADER, UNIX, PL/SQL, Import/Export, Unix, Shell, MySQL, Perl

Products: Oracle 9i and 10g OEM, Oracle Toplink, Oracle Application Server, Oracle Internet Directory, CA AllFusion ErWin, Microsoft Visio 2003, RMAN, Microsoft Access, SQL Developer, SQL Trace, Statspack

Environment: HP/UX, Linux, AIX, Windows XP, Windows Server 2003, Compaq Proliant Thinline and Sun Microsystems enterprise-class servers

Database Sizes: 12 Oracle databases totaling 1 TB.


United States Army -- Civil Service: Fort Benning, Georgia (November 2005 -- March 2006)

Information Technology Specialist - Data Management: Provided optimization and data management on CHCS I, CHCS II, and other Department of Defense (DOD) Standard Medical Health Systems.

Software Development: Investigated factors such as amount of storage space consumed, access times, frequencies of reads and writes, and problems encountered by other application and systems programmers using the Oracle 9i and SQL Server 2003 database management software. Analyzed, designed, developed, and maintained healthcare database structures on Oracle 9i and SQL Server 2003 database structures and applications to support current and future organizational business needs. Defined problems in database design and determined alternatives and initiated corrective action to recover/restore data and return system back to normal operations.

Technologies: SQL*PLUS, PL/SQL

Products: Oracle 9i OEM, RMAN, Microsoft Access

Environment: Windows XP, Windows Server 2003, SQL Server 2003


Science Applications International Corporation (SAIC) (Contractor): San Antonio, Texas (September 2003 -- August 2005)

Database Administrator/IT Manager: Database Administrator and Task Manager in charge of key IT personnel System/Networking Division. Coordinated project activities with operations, customer support, and client staff to ensure goals and requirements were met.

Database Administration: Provided Oracle 9i Real Application Clusters in supported of environmental databases including: determining the Oracle 9i RAC architecture, choosing the best MPP RAC servers and hardware, configuring the Distributed Lock Manager (DLM), configuring the raw disks for Oracle RAC, installing Oracle 9i RAC software, installing and testing Oracle 9i Transparent Application Failover (TAF), performance tuning for Oracle Real Application Clusters (RAC). Planned and coordinated Oracle Security. Tuned the databases resulting in a 10% performance boost (20% is excellent). Used OEM and RMAN to perform the HOT/COLD database backups and restores. Successfully planned, implemented, and upgraded database management system from Oracle 8i, version 8.1 to Oracle 9i, version 9.2 using Oracle Data Migration Assistant and Oracle upgrade checklist. Monitored the database performance through the Oracle 9i Enterprise Manager, Performance Manager, and SQL*Plus. Monitored and managed database backups, logs, installs, and upgrades as required. Addressed a variety of database integration issues including migration, integration, maintenance, conversion, new applications, and capacity planning issues.

Software Development: Collaborated on the design and development of databases to meet user needs. Designed and tuned key organizational databases with instances greater than 100 GB for maximal performance, scalability, flexibility, and reliability while utilizing Oracle 9i built-in DBMS Packages. Used PL/SQL and SQL*Plus programming to write stored procedures, queries, triggers, objects, and views on normalized database tables. Utilized CASE tools (Oracle 9i Designer, ErWin, & MS Visio 2003) to develop organization-wide information models for use in designing and building integrated, shared software and database management systems. Worked closely with other systems staff to ensure high, overall database performance, network communication, and security within an OLAP database environment. Maintained effective backup/recovery strategy and support documentation. Wrote SQL*Loader scripts for data extraction and transformation of data from external files into Oracle 9i database tables.

Technologies: SQL*PLUS, PL/SQL, T-SQL

Products: Oracle 9i OEM, RMAN, Microsoft Access, Oracle 9i Designer, ErWin, & MS Visio 2003

Environment: Microsoft Windows Server NT and 2003, SQL Server 6.0, 6.5, 7.0, 2000, and 2003

Database Sizes: 3 Oracle databases totaling over 500GB


United States Air Force, Enlisted (Completed Service Commitment -- Honorable Discharge): Transportation and Logistics Specialist (October 1992 -- December 2001)


Professional Memberships and Activities

BDPA -- Orlando Chapter: 2007 -- Present
Central Florida Oracle Users Group (CFOUG): 2007 -- Present
Lake Nona YMCA -- Youth Soccer and Basketball Coach: 2007 -- Present

Certifications
Oracle 10g Database Administrator Certified Professional (OCP): Oracle Corporation, April 2006

Oracle 9i Database Administrator Certified Professional (OCP): Oracle Corporation, November 2003

Oracle 9i Forms Developer Certified Associate (OCA): Oracle Corporation, January 2004

Oracle 9i PL/SQL Developer Certified Associate (OCA): Oracle Corporation, November 2003

Oracle 9i Database Administrator Certified Associate (OCA): Oracle Corporation, July 2003

Microsoft Certified Professional (MCP): Microsoft Corporation, December 2003



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

Resumes in Orlando, FL | Resumes in Florida

View other Oracle DBA resumes, Database Administrator resumes