SUMMARY:

Enthusiastic Senior Oracle Database Administrator with more than 25 years of IT experience. Administer Oracle on the AIX, HP - UX, Linux/Cent OS, Solaris, Windows and VM-Ware platforms. Have extensive knowledge of Oracle database architecture, RMAN, Data-Pump, Export/Import, Data Guard, partitioning, schema management, installation, upgrades, security patches, performance tuning, user management, cloning and migration.

TECHNICAL SKILLS:

• Oracle 7,8,9i,10g,11g,12c
• Oracle Installation and Administration
• Database Creation
• Database Migration
• Oracle Data Guard
• Database Upgrade
• Oracle RAC 10g
• Oracle ASM 10g
• Oracle CPU Patching
• Database Space Management
• Data Migration
• SQL Performance Tuning
• Oracle Application Server Installation
• Oracle Enterprise Manager
• Oracle Grid Control
• Oracle Export and Import
• Oracle DataPump
• Oracle RMAN Backup and Recovery
• Oracle Job Scheduler
• Oracle User Account Management
• Oracle SQL Loader
• Oracle Flashback Technology
• Standby/Failover Administration
• Unix Shell Scripting
• HP UX
• AIX
• Solaris
• Cent OS - Linux
• Windows - Windows VM-Ware
• TOAD
• ErWin
• ER Studio

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Senior Oracle Database Administrator

Responsibilities:

• Acts as Team Lead and mentor to Junior Oracle DBAs, serve as Tier 3 contact for complex database issues
• Installs Oracle RDBMS software versions 11G on Linux, Windows and Windows VM-Ware platforms
• Ensures Oracle (CPU) Critical Patch Updates are installed
• Performs database performance tuning using AWR and ADDM reports, implements backup and recovery solutions, space management and capacity planning, participates in disaster recovery exercises
• Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues
• Migrate databases and data using data pump, export/import, clones database using RMAN, restores databases from cold and hot backups
• Deploys database schema changes through system development life cycle (development, test, quality assurance and production)
• Upgrade databases from Oracle 10g to Oracle 11g and Oracle 12c
• Creates and monitor Oracle scheduled jobs, creates database links, tables, indexes, table partitions
• Uses Oracle Data Guard to configure physical standby databases, ensures log file transport and switch over
• Monitors and adjusts the SGA (System Global Area) as needed
• Work with System Administrators to set OS (Operating System) parameters are set for databases
• Work with Oracle Support to resolve bugs and issues
• Manage database and user accounts
• Work with Business Analyst and Developers to review Business Requirements and creates Logical database models using ERWin. Review data elements with Data Architect Team to ensure that naming standards are adhered to
• Uses ERWin to create Physical Database (forward reverse) models generating DDL (database definition language) to create database objects
• Use ERWin to Reverse Engineer current database schemas and provide updates for the Corporate Data Dictionary (Metadata Repository)
• Provides on-call support during non-business hours
• Submits weekly status report

Confidential, Arlington, VA

Principal Oracle Database Analyst

Responsibilities:

• Installed Oracle RDBMS software versions 10G, 11G and 12c on the HP-UX, Linux/Cent OS, Windows and Windows VM-Ware
• Applied Oracle (CPU) Critical Patch Updates
• Created new databases using DBCA and database creation scripts
• Upgraded databases from versions 9i & 10g to 11G on HP-UX, Linux/Cent OS and Windows
• Performed database object changes to accommodate application changes
• Managed database user accounts, roles and profiles
• Configured RMAN backups/recoveries, and worked with System Administrators to configure backups with Simpana’s CommVault
• Created and administered Physical Standby databases using Oracle Data Guard
• Migrated schemas and database objects using data-pump, export/import and SQL scripts
• Used RMAN to clone databases from HP-UX to Linux/Cent OS
• Managed database security posture using the Department of Defense (STIG) Security Technical Implementation Guide
• Tuned queries/used Toad and wrote batch files and shell scripts to streamline database administration tasks
• Generated ADDM and AWR reports, perform SQL and database tuning
• Monitored database storage usage
• Participated in the 24-by-7 on-call support rotation
• Used Remedy to resolve and manage database help desk tickets and database change control requests

Confidential, Alexandria, VA

Oracle Application Database Administrator

Responsibilities:

• Installed the Oracle RDBMS 11g software on Sun Solaris
• Installed the Oracle Application Server version 11g on Sun Solaris
• Created databases for the training and production environments
• Migrated database application schemas from Oracle version10g to Oracle 11g for the training and production environments
• Worked with Solaris Administrator to configure databases to use Sun Cluster for failover/high availability
• Managed database security posture using the Department of Defense (STIG) Security Technical Implementation Guide
• Installed Oracle (CPU) Critical Patch Updates
• Configured databases to use RMAN for backups and recoveries
• Installed the baseline CCaR application onto the Oracle Application Server on Sun Solaris
• Deployed upgrades and patches to the CCaR application
• Wrote UNIX shell scripts to automate database tasks
• Used TOAD to streamline database tasks
• Troubleshot data transfer and load processes
• Prepared status reports as needed

Confidential, Alexandria, VA

Senior Oracle Database Administrator

Responsibilities:

• Installed the Oracle RDBMS software on HP-UX and Windows platforms
• Installed Oracle (CPU) Critical Patch Updates
• Created databases using DBCA and SQL scripts
• Performed manual database upgrades and used DBUA from version 7, 8, 9i, and 10g to 11g
• Worked with HP-UX Administrator to configure databases to use HP Service Guard for failover
• Created tables and indexed to use hash and range partitioning for performance and data manageability
• Used RMAN to configure backups/recoveries, and worked with System Administrators to configure backups with EMC’s Legato
• Deployed database schema changes through system development life cycle (development, quality assurance and production)
• Migrated databases from HP-UX RISC server to HP-UX Itanium servers
• Worked with Application Developers to tune SQL queries
• Worked with System Administrators to migrate databases from EMC to NetApp
• Created CRON jobs to automate database refresh processes
• Migrated database schemas and data using data-pump, export/import and SQL Loader
• Participated in Disaster Recovery exercises by restoring databases to cold sites for COOP (Continuity of Operations)
• Administered database user accounts, roles, privileges and profiles
• Used RMAN to duplicate databases for testing
• Managed the Oracle Name Server
• Installed and configured databases to use Oracle RAC 10G Release 2 in the development environment
• Configured table spaces to use Oracle ASM in the development environment
• Compiled triggers, stored procedures, package and package bodies
• Created sequences and database links
• Created and updated logical and physical database models using ErStudio
• Used ERStudio to reversed engineered database schemas for the purpose of reviewing business requirements
• Worked with Data Standardization team to create new database elements and ensure approved data elements are being used correctly
• Participated in the on-call support for non business hours
• Prepared weekly status reports

Confidential, Arlington, VA

Database Administrator

Responsibilities:

• Installed and upgraded the Oracle RDBMS software versions 7, 8 and 9i on Sun Solaris
• Created databases based on application requirements
• Created and updated logical and physical database models using ER Studio
• Created triggers, stored procedures, sequences and database links
• Used export and import to migrated database objects and data
• Maintained users, roles, privileges and profiles
• Participated in stress test scenarios for performance tuning
• Rebuilt tables, indexes and other database objects
• Monitored table space usage and planned for database growth
• Used SQL Loader and other ELT processes to load data
• Wrote Unix shell scripts to streamline database operations
• Used Toad to generate database schema scripts
• Performed database change control requests
• Supplied technical direction to junior level database administrators
• Provided 7 by 24 hour on-call support

Confidential, Rochester, NY

Database Administrator

Responsibilities:

• Installed Oracle 7, 8i RDBMS software on Sun Solaris servers
• Upgraded databases from Oracle 7 to (
• Managed space used and planned for future growth
• Installed and maintained the Oracle Names Server
• Installed and configured Oracle Client software on application servers
• Compiled stored procedures, triggers, packages and package bodies
• Loaded data using export/import and SQL Loader
• Administered database security, roles and privileges
• Maintained database consistency through the development, test and production life cycles
• Provided 24-by-7 on-call support