SUMMARY

• I’m an experienced Oracle professional. My past experience includes but is not limited to the following: Installation, configuration, creation and upgrades in Oracle environments (9i/10g) using OS via. Sun Solaris, UNIX and Windows XP/NT servers, database analysis of components and configuration of database migrations, ability to implement migration, consolidation and upgrade strategies which include source to target migrations and cutover.
• I have a great attitude and a strong desire to succeed.
• I possess excellent leadership ability and the ability to drive issues to completion.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• On call 24x7 supporting database operations on UNIX servers
• Develops, revises, and implements policies, standards, procedures, and guidelines to effectively administer the database environment
• Installation and Configuration of Oracle 9i/10g and associated tools on UNIX/NT
• Installation and Configuration of SQL Server and associated tools on Windows 2003/2008
• Leads task force to develop and implement an Enterprise database system
• Plans and conducts structured testing of database designs to confirm functionality and performance
• Develops and implements plans to oversee the database administration function, and ensures smooth transition to new technology
• Manages security administration.
• Assists task force to develop and implement an Oracle data warehouse
• Provides guidance to Developers
• Capacity planning of databases and creation of databases
• Creation and Management of various schema objects like tables, indexes, views etc
• Manages performance, tuning, research and evaluation of new tools and techniques
• Wrote database administration and performance monitoring scripts
• Complete the Life Cycle procedures for Oracle and SQL Server (Installation, Patching/Upgrading, Monitoring, Backup and Recovery, and Decommissioning)
• Install Grid Infrastructure and administer multi - node oracle RAC 11gr2 databases performance tuning of oracle 10g/11g/11gr2 RAC databases
• Manage dataguard in a clustered environment
• Install and Manage ASM 11gr2 for both multiple nodes and single instance databases in a Grid Infrastructure environment
• Experience with Oracle Databases Migration and Patches
• Solid Oracle 11gR1/R2 RAC experience including installation, general administration, troubleshooting
• Experience in database upgrades to 11G
• Experience in backup and recovery and migration using RMAN, datapump and export
• Experienced in maintenance and management of databases using Oracle Enterprise Manager Grid Control
• GoldenGate process Administration, monitoring, processing and maintenance
• Managing GoldenGate file cleanup

Confidential, VA

Oracle DBA

Responsibilities:

• On call 24x7 supporting database operations on UNIX servers
• Installation and Configuration of Oracle 9i/10g and associated tools on UNIX/NT
• Installation and Configuration of SQL Server and associated tools on Windows 2003/2008
• Capacity planning of databases and creation of databases
• Creation and Management of various schema objects like tables, indexes, views etc
• Monitoring databases and their performance tuning
• Strong SQL and PL/SQL skills
• Perform Hot/Cold backups & recovery using shell scripts and RMAN
• Wrote database administration and performance monitoring scripts
• Complete the Life Cycle procedures for Oracle and SQL Server (Installation, Patching/Upgrading, Monitoring, Backup and Recovery, and Decommissioning) and get them all into ITOP
• Install Grid Infrastructure and administer multi-node oracle RAC 11gr2 databases performance tuning of oracle 10g/11g/11gr2 RAC databases
• Configure and Manage dataguard in a clustered environment
• Install and Manage ASM 11gr2 for both multiple nodes and single instance databases in a Grid Infrastructure environment
• Experience with Oracle Databases Migration and Patches
• Solid Oracle 11gR1/R2 RAC experience including installation, general administration, troubleshooting
• Experience in database upgrades to 11G
• Experience in backup and recovery and migration using RMAN, datapump and export
• Experienced in maintenance and management of databases using Oracle Enterprise Manager Grid Control

Confidential, SC

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 9i/10g and associated tools on UNIX/NT
• Installation and Configuration of SQL Server and associated tools on Windows 2003/2008
• Capacity planning of databases and creation of databases
• Creation and Management of various schema objects like tables, indexes, views etc
• Monitoring databases and their performance tuning
• Person should have Strong SQL and PL/SQL skills
• Person also should carry out Hot/Cold backups & recovery using shell scripts and RMAN
• Wrote database administration and performance monitoring scripts
• Ability to work with minimal supervision
• Experience utilizing data modeling tools and management tools (TOAD, OEM)
• Installed Clusterware (GRID Infrastructure) - CRS management and configuration
• Performed Oracle ASM administration and Installation
• Experienced with Solaris 9 and 10, Linux and AIX 6.1 OS

Confidential

Oracle DBA

Responsibilities:

• Finish assessment of the SQL Server databases. Create a good backups and monitoring procedure of the databases
• Complete the Life Cycle procedures for Oracle and SQL Server (Installation, Patching/Upgrading, Monitoring, Backup and Recovery, and Decommissioning) and get them all into ITOP
• Getting all of the assessments and documentation done
• Complete the procedures for doing 11g Upgrades. Identify all of the databases that need to be upgraded, which then need to be checked with the vendors as to whether or not the vendor supports 11g
• Performed Partitioning of tables for faster performance, increased availability, improved manageability, and to promote cost efficient use of storage. performance tuning of oracle 10g/11g/11gr2 rac databases administered multi-node oracle rac databases
• Configured and Managed dataguard in a clustered environment

Confidential

Oracle DBA/ADBA

Responsibilities:

• Worked in an environment with 200 members
• Work on Confidential &T OMS, ACS, IPTV and CRM ATT Applications. Perform Emergency Fix (EF’s) and Hot Fix (HF’s) staging and patching. Investigates the offshore team deployment of the EF’s and provide necessary assistance required
• Backup and Restore of Oracle 10g/11g/11gr2 Rac databases
• Great understanding of oracle rac background processes and general architecture
• Perform Application upgrade, refresh and conversion from R14B B240 etc. Develop scripts necessary for importing new data from a ifferent environment to new environment, loading dumps to db accounts and recompiling invalid objects. Develop and run scripts that would check sequences and update BPM tables, verify and update various db accounts where there are structure changes in the tables
• Plan and implement Conversion on the different apps that I support
• Handle any defect issue that arises during conversion or failed upgrades. Verifying and approving EF’s in the Quality Center (QC) before staging the EF’s
• Create and maintain a proper adhoc querrying and upgrade procedure in the document center and update script parameters to meet all build requirement before upgrades
• Perform the sanity once the env is rebooted and post results
• Performed cross-platform database migration from Sun Solaris to Linux systems on Oracle 10g Database
• Modified system specific scripting (i.e shell, etc.) for use in systems backups and program products under control of SA staff knowledgeable about Linux OS patching, system hardening, and other security best practices
• Backup - tar, cpio, dump (ufsdump)
• Excellent - Shell scripting (Bourne, Bourne Again, Korn)
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring. Cloned databases using rman, DBCA and manual copy
• Performed numerous Oracle Database and Tools migration from RDBMS version 8.x through 11G using oracle migration workbench and manual
• Install Oracle software and patchset with the use of Hummingbird 10 and readme file provided by the vendour
• Performed numerous Oracle Database and Tools migration from RDBMS version 8.x through 11G using oracle migration workbench and manual tools. Worked with system administrators to configure the system for optimal performance
• Responsible for installation, upgrades, patches, TAR support, database tuning, concurrent manager administration, cloning and Oracle Apps SYSADMIN functions. Duties included database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting

Confidential

Oracle Consultant

Responsibilities:

• Worked with a small team of 7 people.
• Performed database backup and recovery using RMAN. Configured and implemented data replication and integration using Oracle Streams. Experience scripting the alert log file for proactively monitoring of databases
• Provided high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
• Worked with a team of Database Administrators and developers to design, configure and deploy high availability solutions for a Customer Relationship Management application client.
• Tuned Oracle database instances using EXPLAIN PLAN,AWR Reports, Advanced Database Diagnostic Monitor, StatsPak, SQL*TRACE and TKPROF
• Performed disaster recovery using Oracle Recovery Manager. Performed database maintenance such as upgrades and patches, Experience in database Migration from SQL SERVER databases to ORACLE and vice versa,
• Managed multiple node Oracle 10g/11g Real Application Clusters (RAC) databases with ASM Storage to provide high Availability, Wrote Shell scripts for automation of various Oracle Jobs from database backup to tablespace monitoring
• Excellent in planning, managing of global naming using Oracle Names server and Oracle Internet Directory
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring. Experience with
• Oracle Dataguard for physical and standby databases, Cloned databases using rman, DBCA and manual copy
• Performed numerous Oracle Database and Tools migration from RDBMS version 8.x through 11G using oracle migration workbench and manual tools. Worked with system administrators to configure the system for optimal performance
• Configured and managed database security on Oracle 10/11g
• Responsible for creating standard database creation scripts, installation, upgrades, migration, and applying patches to Oracle databases
• Worked with system administrators to configure the system for optimal performance
• Experienced with configuring and administering oracle dataguard databases (D.R Strategy) 10g/11g/11gr2

Confidential, GA

Oracle Database Administrator

Responsibilities:

• Worked with a team of 12-20 people.
• Installation and configuration of Oracle 9R2 and 10GR1, Application server, 9iAS, 10G Release 2 on Sun Solaris, AIX, HP and Windows operating systems
• Installation, configuration and management of Oracle Business Intelligence: Oracle Discoverer, Oracle Forms & Reports. Designed and deployed backup and recovery strategy, using Oracle Recovery Manager (RMAN), shell scripts, import and export and Integrate Veritas Netbackup with RMAN
• Perform database performance tuning activities - undertake troubleshooting, research and finding resolution of complex database problems by closely monitoring and tuning database performance issues;), Automatic SQL Tuning, OEM. Perform database reorgs and index rebuilds to reclaim spaces and optimize database performance
• Perform documentation, tracking, analysis, development, and validation of functional requirements and database design in a client/Sever environment. ETL and data integration experience in developing ETL mappings using Informatica Power Center 6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor
• Develop, test and deploy Oracle Stored Procedures, Functions, and Packages for database and application development, and administration. Install, configure and manage Oracle 9i and 10G Real Application cluster (RAC) on Linux and AIX Unix servers
• Apply Oracle patches and bug fixes for Oracle database and Oracle Application Server. Clone and refresh Oracle databases from one environment to another. Perform configuration of Data Guard, and switchover activities as the need arises. Perform object level, session, logon and system wide database audits of users to ensure user compliance with corporate security and controls standard, and SOX Act.
• Used Flash Back option for quick recovery of dropped database tables, as well as rolling back the database to a point in time. Perform data extraction, transformation and Loading (ETL) from OLAP to Data Warehouse. Provide on-call 24/7 production database support and management.
• Monitor OS file system, I/O, CPU, Swap, memory and network utilizations on UNIX and Windows 2000 and ensure efficient use of disk storage; reclaim dead space; optimize space allocation and avoid out-of-space conditions. Creation and configuration of high availability databases, using standby databases, and data guard to guard against system failure. Manage transaction logs, redo logs and archive logs.
• Installation and configuration of Oracle Enterprise Manager for monitoring and management of databases. Loading databases using SQL-LOADER, import and export, and Data Pump. Create and Manage tables, partition tables (range, list, hash and composite), indexes, and data dictionary. Configure complex distributed database environments, using Materialized views, synonyms and database links. Perform database, and OS capacity planning for optimal resource allocation and utilization. Interface with vendors, project implementation groups & end users
• Generate weekly database health check for project managers. Troubleshooting, and monitoring network, and system related problems. Configuration of SQLnet, Tnsnames & Listeners for all databases. Manage a combination of small, medium-sized and large scale projects in a fast-paced environment.

Confidential

UNIX Administrator/ Oracle DBA 02/

Responsibilities:

• Worked with a team of 100 people
• Worked on a two (2) months assignment with Confidential as a Senior UNIX Administrator. Performed server Verification on various repository within the Confidential intranet
• Loaded proprietary ( Confidential ) scripts into Confidential ’s CMI, URT, SysReg and ECM repository. Remotely updated Confidential employees system with the latest security patches. Created and compared reports of data from HC and CMI (systems use internally by Confidential ). Acted as an in-house Sr. UNIX Administrator for Govo Consulting, LLC
• Upgraded Govo Consulting servers from Solaris 9 to 10. Responsible for the overall health of the in-house servers. Assisted Jr. UNIX Administrator and Oracle DBAs with users account maintenance and both servers and database backup.