Senior / Principal Database Administrator Resume
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.