EXPERIENCE SUMMARY:

• Responsible for Installation, Upgrade and Maintenance of a set of Oracle Databases comprising of 7.3, 8.0.5.1, 8.1.5, 8.1.6 and 8.1.7,9.2, 10.2, 10.2.4, 11.2.3 on Windows NT, Windows 2003, Windows 2008 R2,UNIX,Redhat Linux, Solaris. Utilized SQL’s Data Definition, Data Manipulation, Transaction Control, and Data Control Language commands.
• Proficient in Oracle 8i, 9i,10g and 11g Oracle Architecture installation, SQL, SQL - PLUS, PL/SQL, Application and Database Tuning, Database Backup and Restore, Security and Authorization. Used Net8 configuration, Oracle Built-in Packages, Object-relational techniques, Large Objects (LOBS). Creation and maintenance of Database Objects including Database, Table Spaces, Tables, Indexes, Procedures and Triggers, Views, Snapshots, DB Links etc, ODBC, JDBC,
• Oracle Products include PL/SQL, Enterprise Manager, Designer and Developer-2000. Extensive experience in database installation and management. Operating Systems I have worked on include Windows NT Server 2000, UNIX, Windows 2003, Windows 2008 R2, Redhat Linux, Solaris, UNIX, Windows SQL Server 2005, Hardware Platforms include HP, SUN Solaris, COMPAQ and IBM,
• Performed data migrations, backup and recovery, imports and exports for the Docks and IRS Systems.
• Wrote script files, PL/SQL procedures and functions with flow control statements, loops, and cursors.
• Developed IRS System reports using Oracle Reports and PL/SQL. These reports include master-detail tables, multi-table queries, summary data, matrices and dynamically labeled data.
• Created entity based, workflow based client applications using Designer 2000.
• Written System requirements for IRS and Docks applications.
• Database design, build and implementation of a Department of Energy Dock Correspondence System.
• Created user interface screens using PL/SQL and HTML packages.

PROFESSIONAL SKILLS:

Oracle 8i,9i,10g and 11g Database, Oracle Designer 9i & 6i, PL/SQL Programming, Oracle Forms and Reports, SQL*PLUS, SQL Station, Web DB, Oracle SQL Developer, Oracle Enterprise Manager(OEM), Oracle Grid Control, Oracle Real Application Cluster (RAC), Oracle Replication, Oracle Automatic Storage Management( ASM), Oracle Datapump, Oracle BI Publisher, Oracle Discoverer, Erwin, Microsoft Excel, PowerPoint, Windows NT Server, Windows NT Server Enterprise, Windows 2003, Windows 2008 R2,Redhat Linux,Solaris, UNIX, Windows SQL Server 2005, Deltek Costpoint, Time Collection, Impromptu, TOAD, Oracle Application Express.

EXPERIENCE:

Confidential, Bethesda, MD

Oracle DBA

Responsibilities:

• Enterprise Engineering Section(ESS), Identity and Systems Management Unit(ISMU) comprised of installing and upgrading Oracle the database management software and to configure and installed 13 Oracle databases on Windows 2008 R2 and Redhat Linux to support the installation, configuration and full Software Life Cycle Development of HP Business Service Management (BSM), HP Network Automation (NA),HP Service Manager (SM),HP Operations Orchestration (HP OO),HP Universal Configuration Management Database (UCMDB) as well as supporting the deployment of these HP tools in four enterprise environments.
• This consisted of upgrading Oracle databases from Oracle 10.2.3 to 11.2.0 and installation of Oracle 11.2.0.while also being on call in the event of mission critical database failure.
• I have created and monitored RMAN backups and implemented recovery procedures. I created/modified and shell scripts to monitor processes and users.
• I have configured Oracle Data Guard for COOP and disaster recovery in all environments as well as Oracle Multi-master Replication for HP Network Automation.
• I have installed and configured Oracle Enterprise Manager (OEM). Implement Oracle Datapump for database, Tablespace, Table and Metadata export and import.
• I have configured database auditing for user actions such as inserts, updates and deletes as well as configured auditing for the SYS user and configured the REMOTE LOGING PASSWORDFILE to deny remote logon for the SYS user.
• I have used Oracle Grid Control’s SQL TUNING ADVISOR to check long running sql and evaluate the execution path as well as to schedule and monitor backup jobs, ASM to check space usage and to create tablespace usage reports.
• I have configured Oracle Data Guard in a physical standby database configuration and Maximum Performance Mode for disaster recovery and failover using redo log transport.
• I am also responsible for and have installed Oracle Critical Update patches on the production, test and development databases.

Confidential, Fairfax, VA

Oracle DBA

Responsibilities:

• My duties at Confidential as the senior Oracle database administrator for the Immigration and Custom Enforcement (ICE) Office of the Chief Information Officer (OCIO) IFS production database at the Confidential are to ensure the database is available and functional for users during normal business hours.
• As well as being on call in the event of mission critical database failure I have created and monitored RMAN backups and implemented recovery procedures when needed.
• I have installed and upgraded the test, development and production databases from Oracle 10.2.4 to
• Oracle 11.2.3 on Windows 2003 and 2008.
• I have developed a build script that can be used to recreate the full production database.
• I have configured database auditing for user actions such as inserts, updates and deletes as well as configured auditing for the SYS user and configured REMOTE LOGING PASSWORDFILE to deny remote logon for the SYS user.
• I have used Oracle Grid Control’s SQL TUNING ADVISOR to check long running sql and evaluate the execution path as well as to schedule and monitor backup jobs, to check space usage and to create tablespace usage reports.
• I am also responsible for and have installed Oracle Critical Update patches on the production, test and development databases.
• I led the migration effort of the IFS database to the new ICE data center.

Confidential, Mclean, VA

Oracle DBA

Responsibilities:

• My duties at Confidential are primarily as an Oracle database administrator involving daily and weekly maintenance of the Synergy and Standard databases headquarters Database Administration Unit.
• This involves the development and implementation of weekly full and daily incremental backup strategy using Oracle RMAN.Installing and configuriing OEM for monitoring & notification of events, create/modify Solaris cron jobs and shell scripts to monitor processes and users, and overall 24x7 support for production, test and development environments running Oracle.
• I'm also called on to assist with tuning or helping developers tune sql & PL/SQL code. Additionally, I'm tasked with tuning our schema objects for optimal performance, manageability, and good practices.
• I am also involved in the effort to create and implement and update functional pieces of the application and front-end and back-end objects that interact with the database.
• This entailed creating and running scripts for Oracle Text CTX IFILTER, CTX MARKUP FUNCTION, indexes and index synchronization.
• I installed, configured and administered Oracle Business Intelligent Publisher (BI Publisher) and Oracle Discoverer for reporting.
• As apart of the DBA Team I administered Oracle BI Publisher I assisted the developers in migrating their reports from Oracle Apex and Flash to BI by deploying .ear and .war files.
• I implemented Fine Grained Auditing for application security.
• I created database build scripts using TOAD. I developed scripts to create tables, procedures, functions and packages to enhance the user interaction and administration of the production application. I am also responsible for running upgrade patches and scripts for the Standard production database and application.
• I have installed, configured and monitored Oracle RAC in a 3 node configuration. I’ve configure Oracle ASM for database storage and storage monitoring.
• I have participated in COOP testing and disaster recovery using Oracle Data Guard.
• I am responsible for the Planning and implementation of the distributed architecture for the connected and non- connected sites.

Confidential, Fairfax, VA

Oracle DBA

Responsibilities:

• This includes but is not limited to daily check of the alert logs for any error messages, insuring that all listeners of up and running.
• Also making sure that all nightly exports are being done through Oracle Enterprise Manager and that all cold backups are being done using Oracle RMAN.
• I must run scripts to check database growth and storage, as well as checking for space-bound objects, and overall tuning of the database.
• I must also do weekly a weekly purge of all log files ( alert, listener, nmi) to prevent them from growing to large.
• I am also involved in the effort to upgrade the database from Oracle 8.1.6 to Oracle 9.2.
• I am also the administrator for the Deltek Costpoint and Time collection system. In this capacity I must add user profiles and maintain user groups.
• I must also create custom reports using the Impromptu report writing tool.