Sample Resumes From HR Pros

Database Administrator Resume Example



Below is a great Database Administrator Resume Example.  This sample database administrator resume includes a summary of qualifications in the front of the resume.  The summary in this database administrator resume example is designed to provide the employer a synopsis of your technical credentials and achievements as a dbase admin before attention is lost.

Brad Pitt

4444 Spring Street                                                Home: 123-456-7890
Calgary, AB, K5P 8M9

OBJECTIVE
To secure a position as a database administrator ( DB2, UDB, DBA) in the retail and pharmaceutical industry.

SUMMARY OF QUALIFICATIONS

  • Over 15 years experience as certified DB2/UDB DBA
  • Performed database system and SQL performance tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor, and OS commands(topas, vmstat, and iostat), updating DB and DBM configuration parameters, using Explain Plain, db2exfmt, and db2expln tools, and running the reorgchk, reorg, runstats and db2rbind commands
  • Planned, designed, implemented, and promoted the physical databases, table spaces, tables, views, Indexes, triggers, and securities into the Develop, QA, and Production environment by making procedure of shell scripts and using PVCS version management based on SDLC
  • Implemented and managed DB2 Security using OS group and user ID, DB Authentication, DB Authorization, and database object privileges
  • Created, maintained and implemented Stored Procedures(C, SQL) and triggers in DEV, QA, and Production database system
  • Established backup and recovery strategies( Full, Online backup) using Korn shell scripts
  • Planned and implemented HADR(High Availability Disaster Recovery) environment bypreparing Primary database and Standby database, configuring parameter, and cloning the primary database (backing up primary database and restoring to standby database)
  • Designed and implemented logical and physical database using CASE tool, ERWin
  • Planned, Designed, and implemented MDC, MQT, and Data partitioning for improving performance
  • Planned, designed and implemented backup schedules and procedures, and DB system
  • monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment
  • Built and managed data mart and large data warehouses on DPF(EEE) system
  • Developed and implemented backup(online, offline), runstats, reorg, rebind, and tablespace capacity monitoring report using Korn shell scripts on DEV, QA(UAT), and PROD system
  • IBM Certified DB2 DBA and Oracle Certified DBA

TECHNICAL SKILLS

Operating system:  AIX 5L(p595, p690), Linux, Windows, OS390/ZOS
DBMS:   DB2 UDB V7 EEE/V8.1/V8.2/V9/V9.5, SQL Server
Case Tool:  ERwin, Composer, IEF
Language:   SQL, SQL/PL, Stored Procedure, C Language
Software:  Unix Korn Shell, IBM Tivoli TSM, JCL, TSO, HADR, HACPM,
DB2 Utilities, Query Patroller, CVS, PVCS, ETL tool

PROFESSIONAL HIGHLIGHTS

  • IBM – Contract, 2004 – Present
    • Client (TD Bank, BMO Bank, CIBC Bank, RBC Bank, Shoppers Drug Mart)

Shoppers Drug Mart, 2008 – Present
DB2 UDB DBA

  • Configured and implemented multi-partitioned databases for Development, QA, UAT, and Production DW environment
  • Designed, implemented, and promoted databases, tablespaces, tables, indexes, views, and triggers in Development, QA, UAT and Production DW environment using Erwin system
  • Design and implement DB objects(DB, table spaces, indexes, views, triggers, MDC, MQT, Data(Range) partitioning, stored procedure) on multi-partitioned databases for Develop, QA, UAT(User Test Accept), and Production DW environment
  • Planned, designed, and implemented index and partitioning key strategies on multi-Partitioned DB to minimize data shipping between partitions for improving performance
  • Planned, designed and implemented backup schedules and procedures, and DB system monitoring system with Unix Shell scripts on the Develop, UAT, and Production environment
  • Improved DB system and SQL performance by rewriting SQL, and tuning partitioning key, buffer pool, sort area, active log files, and temporary tablespace, and by analyzing access plan for Develop, QA, UAT and Production environment databases
  • Built and implemented stored procedures using C and SQL languages
  • Monitored and tuned DB system analyzing log files, Snapshot monitors, and Event Monitors for Develop, QA, and Production environment databases
  • Developed and implemented backup(online, offline), runstats, reorg, rebind, and tablespace
  • capacity monitoring report using Korn shell scripts on DEV, QA(UAT), and PROD system

EDUCATION

DB2 UDB Administration workshop for Unix
DB2 UDB Performance tuning and monitoring workshop
DB2 UDB Advanced Administration workshop
DB2 UDB Advanced Recovery and High Availability workshop
DB2 SQL Tuning workshop
IX Basics and System Administration
Bachelor of Computer Science, National University, Canada, 2000 to 2004

CERTIFICATIONS

IBM Certified DB2 DBA
ORACLE Certified Professional (OCP) DBA


Database Administrator Jobs


Check out who is hiring DBA's in your city. Apply today and get a great DBA job and make more money in a lab in the Database Administrator industry, apply today you have nothing to lose!

Database Administrator job openings in your area

GreatResumeExample.com

Switch to our mobile site