Home · About · Blog · Contact · Sitemap

You are here: Home / Sample Resumes / IT Resume / DBA Resume Sample Three

DBA Resume Sample Three

Any Town, NY 99999
(999) 999-9999 (Mobile)
(999) 999-9999
E-mail: email@yahoo.com

BRIAN WILSON

TECHNICAL SUMMARY

Oracle Database Administrator And Oracle Applications DBA

Over 10 years of experience as production Oracle DBA and Oracle Applications DBA (E-Business Suite) in various industries: manufacturing, construction, software, banking and financial, and retail. Proven ability in administering databases and application systems with complex architectures. Experienced in administering, supporting, installation, upgrade and maintenance of Oracle in UNIX, Linux, and Windows platform. Familiar with full life cycle support and implementation and upgrade of Oracle Applications E-Business Suite. Experienced in UNIX, Linux and Windows basic system administration. Familiar with 9iAS and 10gAS. UNIX shell scripting. Effective organizational, multi-tasking and prioritizing skills. Excellent communication, interpersonal skills, and teamwork. Strong customer focus. Clear, concise and detailed documentation. Self-learner, resourceful, and dependable.

Database:

Oracle 11g, 10g, 9i, 8i, 8.0, 7.0

Applications:

Oracle Clinical (OC), Remote Data Capture (RDC), Thesaurus Management System
(TMS), Adverse Event Reporting System (AERS), Application Server 10g Release 2
(AS10gR2), Application Server 9iAS, AS10g Forms and Reports Services,
Oracle Applications 11i, 11.0, 10.7 (E-Business Suite),

Operating Systems:

UNIX, Linux, HP-UX, DOS, VMS, IBM-AIX, Windows 2003, XP, NT, 2000

Hardware, Platform:

Solaris, HP, Linux, IBM, Microsoft PC, VM Ware (ESX, ESXi)

PC Applications:

Microsoft Office Suite (Word, Excel, Power Point, Project)

Languages:

SQL, PL, SQL, C, HTML, XML, unix shell scripts, perl

Tools, Utilities, Other:

RMAN, Data guard, SQL*Plus, SQL*Loader, SQL*Navigator, J2EE, JAVA Servlets,
Apache, Jserv, TCP, IP, ftp, OEM, OAM, SQL*Net, SYSADMIN, AD tools

PROFESSIONAL EXPERIENCE

Job Title: Senior Consultant (Oracle DBA)
Employer: ABC Inc., ANY TOWN, NY
Dates: 9/2008 to 11/2009

  • Created stored procedures and functions which enabled cutting process time down.
  • Fine tuning ad-hoc processes of 15 hours down to 15 minutes.
  • Scripting SQL code to eliminate manual work.
  • Configured and maintained MS SQL 2000/2005 database servers for maximum resources usage.
  • Ran SQL 2005 Upgrade Advisor and made preparations.
  • Migrated logins, DTS packages, and databases of SQL 2000 to SQL 2005.
  • Low-level performance tuning, OS file level defragmentation and database level index defragmentation.
  • Fine tuned, stream lined, and automated existing SQL statements.
  • Ran Profiler to support application and database developers to improve the database applications.
  • Optimized performance at application level processes.
  • Secured database server and database objects.
  • Monitored and administered services and hardware components of Domain Member Servers.
  • Capacity planed on disk storage usages and added internal and external SATA drives.
  • Processed average of 200GB Oracle database files monthly.
  • Managed average of 500GB flat text file and MS SQL database files monthly.
  • Managed 50 GB of the mission critical business logic files.
  • Set hot, cold backup, restore routines for business logic and data in different databases.
  • Migrated MS ACCESS 2002 databases to SQL 2000/2005 databases.
  • Helped team members with C#. NET, ADP, MDB with ADO, and SQL Server Technical Insights.
  • Installed and configured Windows 2003 Server Enterprise on RAID 5 SCSI and SATA systems.

Job Title: DBA & Developer (Consultant)
Employer: XYZ Corp., ANY TOWN, NY
Dates: 3/2000 to 8/2008

  • Administration of development and production servers running SQL Server 2000, 2005, 2008 and Oracle databases, including creation of indexes, tables, stored procedures, security policies.
  • Administration and creation of the Provisioning Training Database back end to train new hires on real time data without affecting production data.
  • DBA responsibilities also included routine maintenance such as backups and recoveries, applying patches, upgrades and performance monitoring.
  • Ensured SQL Server replication and mirrored databases were operating as planned.
  • Scripting of stored procedures, ad hoc queries & triggers.
  • Scripting of existing embedded SQL code within applications into stored procedures.
  • Responsible for assisting application development team to streamline and optimize queries to adhere to best practices and deliver better performance.
  • Contributed to the design of enterprise grade solutions.
  • Worked with Data Architects to develop data models.
  • Maintained SSRS report servers.
  • Developed reports based on well-defined requirements using complex stored procedures and packages to derive the data extracted for analysis.
  • Reports included line usage, sales tracking, and cost analysis and frequency analysis reports.
  • Crystal Reports 11 and Microsoft Reporting Services were both utilized at the time as a conversion to one reporting system was planned in the future.

Job Title: Sr. Oracle And SQL Server DBA
Employer: BCD Inc., ANY TOWN, NY
Dates: 11/1998 to 2/2000

  • Responsible for all SQL Server 2000/2005/2008 production databases in large scale, maintenance, upgrade and installation in clustered failover and SAN storage environment, database instance and server level performance, and space usage monitoring.
  • Developed and maintenance various TSQL, stored procedures, DTS packages and jobs for People-soft application, which the scalability is over 2000 concurrence users and up 1.5 terabyte database size.
  • Detail plan for database replication, backup and restore procedure for disaster recovery and standby database log-shipping, daily database DTS, SSIS developing and implementation.
  • Support developer and QE database including database maintenance, application design, functional coding and performance turning.
  • Responsible for providing production support of 200+ production Oracle databases and data warehouse servers (15 terabyte) with 99.999% up time requirements running on Solaris with various replication techniques to provide redundancy and load balancing.
  • Worked extensively on database administration, storage maintenance, software upgrade, installation, replication monitoring, backup &recovery planning, partition tables, indexes, and performance tuning.
  • Documentation and establish standards, guidelines and procedures for all aspects of database optimization and service level agreement.
  • Installation & configuration Oracle 10g RAC, Grid, 9i replication, RMAN repository, and UNIX shall script for database monitoring and automation maintenance.
  • Application develop support, physical data mapping with application team on vary application including SAP, PeopleSoft CRM, provision process.

EDUCATION

University of Southern California
B.S. in Electronics and Communications Engineering

Texas A&M University, College Station
Operating Systems, UNIX Shell Programming, C Programming

Michigan State University
Oracle 9i SQL and PL, SQL, HTML Web Design and Programming

Sample Resume in PDFClick to download the DBA Resume Sample Three in PDF.

Related Resumes

Mistake #1
click here
Mistake #2
click here
Mistake #3
click here