We provide IT Staff Augmentation Services!

Senior / Principal Database Administrator Resume

4.00/5 (Submit Your Rating)

Washington, DC

SUMMARY:

  • Senior Oracle RDBMS and SQL Server Database Administrator with years of experience in complex UNIX and Windows Server environments supporting production, testing, and training databases.
  • Outstanding experience in design and creation of databases, including cross platform applications, with extensive background in backup and recovery, upgrades, and patch maintenance.
  • Recognized for superior troubleshooting and problem solving skills and commitment to customer service; establish trust with IT and stakeholder management and deliver essential database support.
  • Supervise contractors and train application analysts & junior DBA’s; proven track record of effective communication throughout complex organization to ensure success of new enterprise - level projects.

TECHNICAL SKILLS:

Expertise: Database Design, Data Warehouse, Application Development Support, Server Clustering, High Availability (HA), Storage Capacity, Consolidation, Migration, ETL

Platforms & Systems: Windows 95/98/NT/XP/2003, UNIX, AIX, HP UNIX, Linux

Software & Tools: SQL, Oracle RAC, RMAN, Tivoli Enterprise Backup systerm, Toad, BMC Patrol, Cerner Database, Lawson Database, CommVault Simpana Enterprise Backup System & SQL Server Cluster

Database Technologies: Oracle RDBMS 8/8i/9i/10g/11g/, SQL Server 6/7/2000/2005/2008/2008

PROFESSIONAL WORK EXPERIENCE:

Confidential, Washington, DC

Senior / Principal Database Administrator

Responsibilities:

  • Design/install SQL Server & Oracle databases, build clusters, migrate data, change schema, optimize performance, consolidate databases, plan capacity, and control database scripts for 24/7 High Availability (HA) environment.
  • Partner with and communicate with senior managers and directors regarding changes, deployments, enterprise problems, security concerns, etc; develop/present recommendations to overcome/mitigate issues.
  • Develop database procedures for the helpdesk, operators, analysts, and users; provide support to super & end users; collaborate with application programmers & analysts and system/storage engineers to design/plan database servers.
  • Configure new Oracle & SQL Server databases (2-nodes & single node); monitor/manage database space utilization, growth, and table space usage; oversee/lead critical upgrades to databases; personally manage migrations.
  • Restore/fix corrupt databases, backup databases with RMAN, scripts, Commvault, and export; use Cerner tools, Commvault, scripts, and export/import to refresh, replicate, and test pre-production databases.
  • Troubleshoot database errors and diagnose fragmentation, chained rows, and contention; utilize BMC Patrol and Toad for database health check.
  • Installed/created SQL Server databases for CNMC SharePoint, Intranet, timecard application (Kronos), Medical Records, Pharmacy, and billing.
  • Installed/configured Oracle 10g and 11g; created databases on AIX, Linux, Windows, and VMware; migrated Oracle 9i to Oracle10g and 11g.
  • Led database efforts surrounding 3-year project with team members from IT and business groups across the hospital to design, migrate, and implement High Availability solution.
  • Led team of 5 on 1-year project to design/install Lawson Payroll system.

Oracle and SQL Server Database Administrator

Confidential

Responsibilities:

  • Administered Oracle 8i Lawson, Remedy, and PPLUS Databases on AIX, HP UNIX, & Sun Solaris platforms and SQL Server 6, 7, and 2000 cluster on Windows.
  • Provided day-to-day support, created users, loaded Oracle client on computers, upgraded applications, granted privileges, controlled database security, and tuned databases for better performance.
  • Monitored/managed database space utilization and growth & table spaces usage; debugged/controlled existing scripts, backed up/recovered databases using scripts, and reorganized/changed database schema and configuration.
  • Repaired and modified tables using export/import, tracked and fixed chained rows, rows migration, and fragmentation in Oracle databases.
  • Collaborated with developers to ensure functionality of applications and intranet.
  • Trained application analysts on database fundamentals; authored procedures for operators.

Confidential, Crystal City, VA

Database Administrator

Responsibilities:

  • Managed Oracle 8i Data Warehouse on HP UNIX platform and supported Business Objects and Visual Basic developers.
  • Reorganized and restructured database to meet OFA standards.
  • Debugged scripts, performance tuned individual instances, changed schema & configuration, managed space utilization and growth, diagnosed/resolved fragmentation and tracking contention,
  • Created users & views and granted privileges; implemented database security via Oracle roles and views.
  • Resized table spaces, tables, and indexes and utilized export/import to repair and modify tables; performed extraction, transformation, and load (ETL) with Constellar, SQL Loader, and PL/SQL.
  • Scheduled and controlled Cron jobs; analyzed end-user reports using Business Objects; developed Visual Basic applications to simplify database security for users.

We'd love your feedback!