SUMMARY:

• 22 years of Professional IT experience in Oracle database administration, database design, conceptual analysis, in Oracle 7/8/8i/9i/10g/11g/12c.
• Leadership role in Oracle technical design, hosting and administration, development and support.
• Hands on providing technical leadership and direction for the design, installation, customization, implementation, and support of an Oracle client server and web based environment with over 200 clients and up to 100 servers including experience in configuring and supporting SQL*NET V1 & V2, and Net8.
• Expertise in using Oracle Enterprise Manager, OEM 10g Grid Control, OEM 12c Cloud Control and is certified in Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, and Oracle 12c.

TECHNICAL SKILLS:

Technologies: Client Server, Web Server, ASM, CRS, Oracle 11g,OEM 12c Cloud Control, OEM Grid Control, Red Hat Linux, UNIX, Sun Solaris, RMAN, Oracle Enterprise Manager, ADDM, Oracle 11g RAC, TOAD, Grid Control, Windows, SQL.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administration/DBA Team Lead

Responsibilities:

• Support the Veterans’ project.
• Overseeing the DBA tasks and providing assistance to Oracle DBAs to complete their assignments.
• Led the Oracle Upgrade from Oracle 11g RAC to Oracle 12c RAC.
• Re - created Oracle 11g RAC standby databases.
• Maintained Oracle 11g RAC R2 production databases including performance tuning and troubleshooting.
• Performed database installation, patching and upgrades of Oracle 11g RAC R2 to 12c RAC databases in production, test, and development environments on RHEL servers.

Environment: Client Server, Web Server, Oracle 11g,OEM 12c Cloud Control, Red Hat Linux, Sun Solaris, RMAN, Oracle 11g RAC, 11gR2, ASM, Oracle 12c RAC.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Setup and configured Oracle Wallet on Oracle 11gR2 on Linux.
• Installed and configured Oracle 11gR2 database on Red Hat Linux Server.
• Performed Linux System Administration tasks.
• Wrote Unix shell scripts and applied PSU patches.
• Performed 11g RAC database performance tuning and setup RMAN backups.
• Maintained OS disk space using Automatic Storage Management (ASM).
• Performed Oracle 11gRel2 Standalone and RAC Install

Environment: Client Server, Web Server, Oracle 11g RAC, ASM, OEM 12c Cloud Control, Red Hat Linux

Confidential

Senior Oracle Database Administration

Responsibilities:

• Installed Oracle 11g RAC R2 on Windows
• Performed Database tuning using AWR and ADDM reports.
• Wrote PL/SQL procedures to implement Database alerts.

Environment: Client Server, Oracle 11g, Oracle Enterprise Manager, HP UNIX, TOAD, SQL Developer, Data Guard, RMAN, 11gR2, Oracle 11g RAC, OEM 12c Cloud Control, ASM, Linux, PL/SQL

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Successfully installed, configured, and maintained Oracle Enterprise Manager 12c Cloud Control.
• Successfully created, managed, and tuned Oracle 12c databases.
• Setup Data Guard physical standby databases using RMAN on Oracle11g R2.
• Duplicated databases and performed backup recovery strategies using RMAN.
• Performed database creation, setup, administration, management, performance tuning, and backup.
• Performed schema refresh using export/import data pump.
• Performed database performance tuning using ADDM and AWR.
• Installed, configured, and maintained 11g R2 RAC, ASM on Windows 2008.
• Applied Oracle Quarterly security patches on the Oracle grid and the databases.
• Performed index rebuild, tables re-org to improve performance.
• Performed schemas’ comparison using SQL Developer and created scripts to resolve data issues among schemas
• Successfully installed Oracle Management Agents on remote servers to communicate with OEM 12c.
• Implemented email notifications using PL/SQL procedures.

Environment: Client Server, Oracle 11g, Oracle Enterprise Manager, HP UNIX, TOAD, SQL Developer, Data Guard, RMAN, 11gR2, Oracle 11g RAC, OEM 12c Cloud Control, ASM, Linux, PL/SQL

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Provides Oracle Database Administration for DTIC.
• Responsible for troubleshooting 11g RAC errors as well as Oracle database 11g issues.
• Uses Oracle Enterprise Manager 12c Cloud Control to manage databases, troubleshoot and correct performance issues.
• Rectified communication issues between Oracle Management Server and Agents.
• Added database services to be managed by OEM 12c Cloud Control.
• Tunes Oracle 11g databases using ADDM tool, AWR.
• Responsibilities include highly technical expertise and guidance in the design, implementation, operation, maintenance, and tuning of 60 databases to improve performance.
• Applies the Oracle Quarterly Security patches.
• Provides technical leadership to appropriate personnel on highly complex system administration activities.
• Develops and analyzes highly complex system standards, thresholds, and recommendations to maximize system performance.
• Performs backup and recovery using RMAN.
• Performs import/export to refresh schemas in the production databases.
• Provides technical solutions and escalated support for non-routine, highly complex technical issues.
• Modeled databases based on a logical data structure created in support of data architect.

Environment: Client Server, Web Server, Oracle 11g,OEM 12c Cloud Control, Red Hat Linux, Sun Solaris, RMAN, Oracle 11g RAC, 11gR2, ASM

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Provided Oracle Database Administration for Department of Army.
• Installed and configured Oracle Enterprise Manager 12c Cloud Control and plug-ins.
• Configured, installed, deployed, and maintained OEM 12c Agents.
• Installed and configured Oracle Audit Vault, tuned 11g database instances, SQL queries, installed Oracle 11g database on Red Hat Linux Server, performed database backups using RMAN. Fixed database backup issues using RMAN
• Upgraded several databases from 10g to 11g in Linux, Sun Solaris.
• Responsible for troubleshooting 11g RAC errors as well as Oracle database 11g issues.
• Responsibilities include highly technical expertise and guidance in the design, implementation, operation, maintenance, and tuning of 60 databases to improve performance.
• Used Oracle Enterprise Manager to manage databases, troubleshoot and correct performance issues.
• Tuned databases using ADDM tool, AWR, and Statspack.
• Applied STIGs to Oracle 11g databases and Exadata servers.
• Maintained Oracle 11g RAC in Exadata environment.

Environment: Client Server, Web Server, Oracle 11g,OEM 12c Cloud Control, Red Hat Linux, Sun Solaris, RMAN, Oracle 11g RAC, 11gR2, Peoplesoft, ASM, Exadata.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Provided Oracle Database Support for GSA.
• Performed Oracle database backup, fixed database backup issues using RMAN, re-built 11g test databases, and troubleshot 11g RAC errors.
• Tuned databases using ADDM tool, AWR, hints, and Statspack.
• Performed flashback recovery.
• Worked with Weblogic.

Environment: Client Server, Web Server, ASM, Oracle 11g, Oracle 10g, Oracle 10g Grid Control, Linux, Windows 2008, RMAN, Oracle 10g RAC, Oracle 11g RAC, 11gR2, Flashback, Weblogic

Confidential

Senior Oracle Database Administrator/DBA Lead

Responsibilities:

• Has provided Oracle Database Administration for Federal Emergency Agency.
• Setup a Dataguard physical standby, exported and imported data between databases, performed backups and recovery using RMAN, tuned database instances, SQL queries, and installed Oracle 11g database on Red Hat Linux Server, migrated 10g to 11g database.
• Responsible for maintaining Oracle 9i, 10g, and 11g databases and managing a Data Guard physical standby database.
• Exported and Imported data between databases, performed backups and recovery, tuned databases, and SQL queries for i Confidential eased performance.
• Setup Dataguard and performed switchover of primary and standby databases.
• Syncing primary and standby database whenever they are not in sync.
• Created and setup Oracle 11g database. Installed Oracle 11g database on Red Hat Linux server.
• Migrated Oracle Database 10g to Oracle Database 11g.
• Performed tuning using Oracle Statspack, Backup and recovery processes, Space management, and user management. Backed up databases using Recovery Manager, RMAN.
• Run MySQL scripts to populate tables with data.

Environment: Client Server, ASM, Web Server, Oracle9i, Oracle 10g, Oracle 11g,Oracle Enterprise Manager, HP UNIX, Red Hat Linux 64 bit, Linux Red Hat server, SQL Developer, Data Guard, RMAN, 11gR2, MySQL.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Has provided Oracle 10g RAC support for State Department. Setup streams on Windows environment, rectified streams as well as Oracle replication issues.
• Performed export and import of databases to refresh dev and test environments.
• Responsible for keeping approximately one hundred 9i and 10g RAC databases running on Windows 2003 on 24x7 in support of State Department issuance Visa and Passport.
• Performed installation and setup of Oracle on new servers, applying patches and upgrades on new servers.
• Exported and Imported data between databases, performed backups and recovery, tuned databases using ADDM, AWR, and Statspack to improve performance.
• Rectified Streams and replication issues on 10g RAC environment. Installed Oracle 10g RAC.

Environment: Client Server, Web Server, Windows 2003, Oracle9i, Oracle 10g RAC, Oracle Enterprise Manager, TOAD, Grid Control.

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Has provided Oracle database support for Association of American Medical Colleges. He performed performance tuning of Oracle 9i and Oracle 10g databases on UNIX environments.
• Migrated several databases from Oracle 9i to Oracle 10g database.
• Worked with application teams to design and build databases, database objects, and optimized SQL.
• Installed, configured and managed Oracle databases 9i and 10G.
• Conducted routine database tasks including the following: Backup and Recovery, Data imports/exports, SQL Optimization, Database Tuning using ADDM, AWR, Statspack, Database Patching, and ticket solving.
• Proactively prevented production incidents through daily monitoring and review/verification of the database environment and scheduled database jobs. Performed 24x7 support for production systems.
• Recommended, implemented procedures to ensure integrity, security, and privacy of the corporate database.
• Managed database security through user administration and granted correct roles and privileges.
• Created, maintained, and enforced corporate database standards, procedures, and documentation.
• Migrated several Oracle9i databases to Oracle database 10g.

Environment: Client Server, Web Server, UNIX, Sun Solaris, Windows 2000, Oracle9i, Oracle 10g, Oracle Enterprise Manager, TOAD, Statspack, OEM 10g Control Grid, ADDM

Confidential

Database Architect

Responsibilities:

• Has provided Oracle database administration support for EPA.
• Created Materialized views in a Data Warehouse to enhance the performance of the production database.
• Responsible for maintaining, creating Materialized views in a Data Warehouse environment and troubleshooting any performance issues using Statspack and Oracle Enterprise Manager Tools.
• Refreshed the data warehouse using Perl and shell scripts, tuned SQL statements on IBM-AIX and HP-TRUE platforms, maintained space in Database and UNIX, and troubleshooted any database errors.
• Migrated several databases across platforms in UNIX as well as changing the database character set.
• Migrated a legacy database using Oracle Database 10g.
• Created tables, columns in support of Data Warehouse.
• Handled data load in the production database.

Environment: Client Server, Web Server, IBM-AIX, HP-TRUE UNIX, Windows 2000, Oracle9i, Oracle Enterprise Manager, TOAD, Perl, Statspack, OEM Grid

Confidential

Senior Database Administration/Contractor

Responsibilities:

• Has provided Oracle database support for DISA. He maintained, configured, and tuned Oracle 10g databases.
• Backed up Oracle 9i databases using RMAN scripts and upgraded databases 10g release 1 to 10g release 2.
• Maintained, configured, and tuned Oracle 10g databases, resolving database integrity issues, resolving connectivity issues, and applying Oracle security patches on Sun Solaris and Windows 2003 platform.
• Backed up databases using RMAN scripts and upgraded databases from 10g release 1 to 10g release 2.
• Converted ASM file system to regular RAID 5 file system. Maintained and provided database tuning for Oracle7/8i/9i/10g databases.
• The range of database support also included installation of Oracle9i in Sun Solaris platform, Windows 2003, supporting a Data Warehouse, resolving database integrity, applying Oracle security patches, migrating databases from Oracle 7 to Oracle 9i, upgrading databases within 9i releases, writing Unix shell scripts, writing PL/SQL procedures, optimizing SQL statements, and backing up Oracle9i databases using RMAN scripts.
• Helped configure and provide support to the centralized government database that supported 2000+ clients.

Environment: Client Server, Web Server, Sun Solaris, Windows 2000, Windows 2003, Oracle7, Oracle8i, Oracle9i, Oracle 10g, Oracle Enterprise Manager, Toad, SQLAB, RMAN

• Provided performance tuning of Oracle9i databases.
• Tuning entailed tuning database parameters using Statspack tool, tuning SQL statements, gathering statistics, rebuilding indexes, and rectifying row migration.
• Monitored database locks to avoid deadlock situations.

Confidential

Senior Database Administrator/Apps DBA

Responsibilities:

• Has provided Oracle Apps database support for Pension Benefit Guaranty Corporation.
• Provided 11i application database Administration for Pension Benefit Guaranty Corporation.
• Provided installation and cloning of 11i application, CRM, Oracle 8.1.7.4 databases, troubleshoot CRM application, JTF, and Apache server errors.
• Applied patches to the 11i application and Created database links to facilitate communication among databases. Used Toad and SQLAB tools to tune SQL statements.

Confidential

Senior Database Administrator

Responsibilities:

• Has provided a variety of Oracle database support for Department of Justice.
• He performed Oracle database migration from Oracle 7 SCO Unix to Windows NT.
• Performed database tuning, troubleshooting database errors and provided on-going database support for more than 200 clients.
• Involved in migrating several Oracle v7 databases in a SCO Unix platform to Oracle8i in a Windows NT platform.
• Supported a Data Warehouse and performed monitoring and tuning many mission-critical EOUSA databases built in NT and Unix platforms in order to optimize database processes and performance. Tuning involved improve the database performance by configuring and adjusting database parameters, create primary/ foreign keys, analyze schemas, partition tables, resize an application indexes
• Provided database administration support and technical guidance related to the design, implementation, operation and maintenance and enhancement of the Oracle8i RDBMS to the System Managers (SMs) at all 94 United States Confidential orney’s Offices (USA) districts nationwide (consisting of over 200 locations including branch offices) consisting of browser based and client server applications with multiple servers and well over 200 clients and 200 servers.

Environment: Client Server, Web Server, SCO UNIX, Sun Solaris, Windows NT, Windows 2000, Oracle8i, Oracle9i, Oracle Enterprise Manager

Confidential

Senior Consultant/Database Administrator

Responsibilities:

• Has provided a technical lead database support for Sprint, Telecom Company. He also provided a variety of database support including migrating of MS Access databases to Oracle 8i using Oracle Migration Workbench utility. Designed and implemented security code and features at the database level.
• Migrated several MS Access databases to Oracle8i using Oracle Migration Workbench utility.
• Provided technical training for the application to applicable clients at various levels, from end users to hardware/software administrators.
• Configured the Oracle databases parameters and resolved configuration and database server integration problems. Created and tuned several Oracle8i databases.
• Provided technical training for hardware and software systems directly related to the database.
• Installed the Oracle 8.0.5 RDBMS binaries and created databases on both NT and Sun Solaris servers.
• Developed several PL/SQL procedures and database triggers that automatically generated email notifications to all MS Project plan owners.

Senior Consultant/Database Administrator

Confidential

Responsibilities:

• Has provided Oracle database support for Federal Emergency Monitoring Agency. Performed SQL and database performance tuning. Provided DBA operational support and developed Tuning Subsystems for Federal Emergency Monitoring Agency (FEMA).
• Tuned SQL queries to minimize response time (i.e. CPU time usage, and number of blocks used by the optimizer to retrieve rows from memory).
• Used Performance Tuning Pack to capture the n top sessions that degraded performance. Changed the optimizer mode to choose the optimum path for queries.

Confidential

Database Administrator 8

Responsibilities:

• Provided 24 x 7 Oracle database support for State Department. He setup replication of databases, performed performance tuning, maintained tablespaces and indexes at optimum level.
• Prepared and maintained work plans, schedules, and technical approach for replication of databases for the State Department. Provided 24x7 configuration and database server integration support to US Embassies and Consulates worldwide (approximately 100 servers and 200+ users).

Confidential

Database Administrator

Responsibilities:

• Provided Oracle Database Administration for Department of .

Confidential

Developer/Database Administrator 6

Responsibilities:

• Responsibilities involved working with the online operations staff to analyze potential problems with the software, recommend and implement the solutions within the software.
• Functions performed included updating forms, performing data manipulation functions, data definition language, creating database instances, developing and updating scripts for referential integrity constraints, and other integrity constraints.