Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Lead Oracle Database Administrator

The duties I performed as a DBA include but are not limited to the following:

• Managed and supported Databases ranging between 320Gb and 600GB
• Supporting and managing SAP and non-SAP Databases on oracle 10.2.0.4, 10.2.0.5 and 11.2.0.2 databases
• Managed and supported 2-node RAC Databases on Oracle Version 10.2.0.4 on Solaris
• Resolved space and performance issues on the RAC Databases
• Upgraded the RAC Databases from 10.2.0.4 to 10.2.0.5
• Migrating 25 mission critical stand-alone Databases from Solaris 9 on physical servers to AIX 6.1 on LPARs with minimum business impact.
• Upgrading 25 UNIX servers from Oracle version 11.2.0.1 to 11.2.0.2
• Upgrading and migrating 10 Databases from version 9.2.0.4.0 to 11.2.0.2 and from Solaris physical servers to AIX 6.1 LPARs
• Implemented Oracle Enterprise Manager Grid Control 11g to manage and monitor Oracle Databases
• Using various Oracle and Unix Utilities like RMAN, Export and Import DataPump, TOP, iostat, etc to perform critical tasks
• Installed Web Logic Server as part of the OEM Grid Control installation
• Deployed OEM GC Agent 11.1.0.1 on all servers
• Developed shell script to automate RMAN backup
• Upgrading and migrating 15 Databases from version 10.2.0.4.0 to 10.2.0.5 and from Solaris physical servers to AIX 6.1 LPARs
• Installed WLS as part of OEM Grid Control Installation for 11.1.0.1
• Completed the installation of OEM GC 11g and configured it to manage Databases
• Implemented Oracle Databases using ASM Automatic Storage Management and File Systems
• Created Documents for DBA processes and Procedures.
• Implemented 2-node RAC cluster as part of High Availability in a Development environment
• Installed Web Logic Server as part of LDAP and configured it.
• Installed and configured XML DB on all 10.2.0.5 Databases
• Installed and configured Oracle Internet Directory LDAP on some servers / Databases.
• Provide support to developers and users with trouble-shooting and performance tuning of 11g
• Oracle Database 10g Administrator Certified Professional OCP

Confidential

Lead Oracle Database Administrator

The duties I performed as a DBA include but are not limited to the following:

• Supporting and managing 80 SAP and non-SAP Oracle Databases 9.2.0.8, 10.2.0.4 and 11.2.0.2 databases
• Managed and supported Databases ranging between 400Gb and 8TB
• Applied SAP/Oracle SBP Sap Bundle Patch and Oracle Patches on all 80 Databases using MOPatch and OPatch utilities.
• Manage SAP/Oracle Databases using BRTOOLS/ BRGUI, forms, reports DBACockpit, Toad and OEM Grid Control
• Managed and supported 2-node RAC Databases on Oracle Version 10.2.0.4 on Solaris
• Performed Switchover-Switchback to test DataGuard setup and Disaster Recovery with success at first attempt
• Implemented Backup, Restore and Recovery on the SAP Databases using BRTOOLS and RMAN Recovery Catalog and scheduled the backup using Netbackup
• Upgraded Oracle Databases from version 9.2.0.8 to 10.2.0.4, then 11.2.0.2
• Performed fresh Oracle software installation on newly built servers and created 11.2. Databases as requested by the users
• Planned and implemented a direct restore process clone of a new Database on a fresh new server using Netbackup, BRRestore and RMAN.
• Developed and deployed scripts in Crontab to manage database and server activities.
• Migrated some development, Test and Production Databases from IBM Data Center in Lexington on physical Servers to Cirrus One Database Centers in Houston and Dallas on Logical Partitions LPAR .
• Consolidated File systems on the OS level with no impact on the Databases and applications. Consolidated the amount of the File systems from 300 to less than 20.
• Successfully build an RMAN recovery Catalog for backup
• Implemented Oracle Enterprise Manager Grid Control to manage and monitor both SAP and non-SAP Oracle Databases.
• Installation, configuration and maintenance of oracle 10g and 11g environments.
• Modified the existing backup shell script to address business requirements
• Installed, configured Oracle 11gR2 software and related products Unix AIX 5.3 and 6.1 platform
• Installed Web Logic Server, Oracle Identity Management system and Database Repository as part of the OEM Grid Control installation.
• Installed and deployed Grid Control Agent version 11.1.0.1on Database servers
• Re-org a 5Tb OLTP to address HighWater Mark and fragmentation issues. 3TB of space was reclaimed. This activity was repeated on a couple of other Databases.
• Converted Long Raw DataType columns to BLOB and Long DataType columns to CLOB on more than 30 Thousand tables in order to schedule regular online reorganizations on the tables without taking database outages using the DBMS REDEFINITION PL/SQL package.
• Provide support to developers and users with trouble-shooting and performance tuning of 11g
• Oracle Database 10g Administrator Certified Professional OCP .

Confidential

Lead Oracle Database Administrator

The duties I performed as a DBA include but are not limited to the following:

• Designed, Installed, configured and maintained oracle 10g Databases on Linux SLES10.
• Designed and implemented a Disaster Recovery configuration using Dataguard, by creating a standby from a primary Database
• Successfully performed a switchover-swtichback to test the reliability of the DR setup
• Upgraded some Oracle Databases from 10.2.0.4 to 10.2.0.5
• Migrated some Oracle 10g Databases to 11G from physical servers to LPARs.
• Migrated Schemas from one Database to another and reorg Database Schema objects using Exp/Imp DataPump
• Managed Oracle Databases using OEM, PL/SQL Developer, Toad, forms, reports etc
• Restored and recovered Databases from production backup using RMAN
• Created and managed user accounts
• Created scripts to refresh/ clone Database environments from Production backup.
• Addressed Database and OS related issues as assigned to the DBA ticketing system, which included various performance issue related to space, slowness, corrupt indexes, etc
• Modified the existing backup shell script to address business requirements
• Implemented 2-node RAC cluster.
• Installation, configuration and maintenance of oracle 10g and 11g environments.
• Addressed performance issues on RAC instances
• Managed Oracle Databases using ASM and OCFS.
• Resolved space issues on RAC instances
• Added a new instance to a RAC cluster
• Resolved high-watermark issues on tables
• Removed a node from a 2-node cluster to make the Database a standalone
• Installed Web Logic Server, Oracle Identity Management system and Database Repository as part of the OEM Grid Control installation
• Implemented 2-way and 3-way streams replication on RAC Instances
• Upgraded a 2-node cluster from 10.2.0.2 to 10.2.0.4
• Migrated a RAC database from one server to another with minimal downtime
• Managed RAC instances using Grid Control
• Oracle Database 10g Administrator Certified Professional OCP

Confidential

Oracle Database Administrator

A team member of Oracle DBAs responsible for administration and support of Oracle 9i, 10g and 11g Databases.

The duties I perform as a DBA include but are not limited to the following:

• Installation, configuration and maintenance of oracle 10g and 11g environments.
• Managed Oracle Databases using OEM Grid Control, PL/SQL Developer, Embarcadero DBArtisan, forms, reports etc
• Migrated / upgraded some Oracle 10g Databases to 11G.
• Created Schemas from a backup of another and reorg Database Schema objects using Exp/Imp DataPump
• Planned, implemented and managed a 2-way and 3-way Oracle Streams Replication
• Resolved streams related errors and issues pertaining to Capture, Propagation and Apply.
• Setup streams between schemas
• Create and managed databases based on user and organizational requirement develop and execute data migration and import/export routines in support of operational database maintenance and space utilization tune and reorganize database to ensure optimal performance and availability of data troubleshoot performance problems and access issues.
• Managed system and database security security planning, security rights administration, compliance with organizational security policy, identify malicious activity, develop and deploy access controls, apply security patches and updates as necessary.
• Resolved performance issues in Databases related to DB file read/write
• Successfully migrated some of the oracle 9i and 10g databases from Unix Solaris to Linux SLES 10 to meet business requirements.
• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases for clients which includes various configuration like standalones, RAC, Primary Database with standby DataGuard
• Administer database user accounts. Create, modify and deactivate user accounts assign and monitor user access rights. Manage database back-up and recovery plans develop disaster recovery/continuity of operation plans perform routine database backup and recovery operations as necessary.
• Tuning the database and applications for faster and better performance also performing goal-oriented tuning as necessary.
• Provide 24x7 production supports and participate in On-Call schedule.
• Successfully Migrated some exiting 10g databases from Unix Solaris to AIX and installed some new Databases to meet business requirements
• Developed various Unix Script such Korn Shell, C Shell to automate Database Backups, Database Startup and Shutdown, schema migration from one DB to another.
• Develop standards for application programming. Load databases create test procedures troubleshoot applications.
• Provide training and application support to user and application developer to ensure database performance, integrity and security.
• Developed shell scripts to automate various tasks like Schema refreshes, DB clone from production, Production DB backup, placed standbys in MRP mode then Read-only mode as needed, etc
• Consolidated servers with minimal / no downtime
• Managed clustered Databases and servers using OCFS and CRS
• Upgraded Databases from version 10.2.0.2 to 10.2.0.4 and from 9.2.0.8 to 10.2.04
• Provide support to developers and users with trouble-shooting and performance tuning, including SGA analysis, buffer management, shared pool management, etc
• Planned and implemented partitioning on some huge schema tables, to aid performance and to purge and keep needed data according to the guideline given.
• Created and managed DR configuration by creating physical and logical standby DBs as needed for Production DBs.
• Capacity planning and efficiently allocate and manage space on the OS and on the Database by allocating the right size to the Database components like Datafiles, Tempfiles, Redologs, etc to accommodate multiple instances and Databases on both clustered and single servers
• Apply patches to Database to fix bugs as requires or to upgrade a DB from one version or release to another.
• Managed space on Database servers and in Databases
• Creating new users and Schemas on Databases and determining size of spaces and object
• Regularly monitor and analyze DB activities and performance using custom utilities like ADDM, AWR, SQL Advisor, ASH etc
• Setup Oracle Enterprise Manager on Databases and installed Grid Control on 10g Databases.
• Performed Switchover-Switchback to test DataGuard setup and Disaster Recovery with success at first attempt.
• Migrated Databases from one host to another and exported users as required
• Scheduling and administering Database backups using RMAN
• Documenting DBA processes and procedures
• Using various Oracle and Unix Utilities like RMAN, Export and Import DataPump, TOP, iostat, forms, reports etc to perform critical tasks
• Performed database refreshes, restores, cloning and duplication from one Oracle database to another. Provide support to developers and users with trouble-shooting and performance tuning of 11g
• Capacity planning and efficiently allocate and manage space on the OS and on the Database by allocating the right size to the Database components like Datafiles, Tempfiles, Redologs, etc to accommodate multiple instances and Databases on both clustered and single servers
• Oracle Database 10g Administrator Certified Professional OCP

Confidential

Oracle Database Administrator

A team member Oracle DBAs responsible for administration and support of Oracle Databases of approximately 200 Oracle 9i and 10g instances.

The duties I perform as a DBA include but are not limited to the following:

• Planning, installation, configuration, management and troubleshooting of Oracle 9i and 10g databases.
• Administer database user accounts. Create, modify and deactivate user accounts assign and monitor user access rights. Manage database back-up and recovery plans develop disaster recovery/continuity of operation plans perform routine database backup and recovery operations as necessary.
• Modeled data using tools like Erwin, TOAD, etc
• Managed Oracle 9i and 10g on UNIX and Linux
• Creating standby Databases from production
• Installed Web Logic Server, Oracle Identity Management system and Database Repository as part of the OEM Grid Control installation
• Successfully performed Switchover- switchback to test Disaster Recovery
• Upgraded existing 9i Databases to 10 on AIX
• Installed new 10g Databases on AIX
• Competent in opening and escalating Oracle TAR to resolve critical Database-related errors
• Installation of Oracle 10g Grid Control to manage all the Oracle databases on the network.
• Performed database refreshes, restores, cloning and duplication from one Oracle database to another.
• Capacity planning and efficiently allocate and manage space on the OS and on the Database by allocating the right size to the Database components like Datafiles, Tempfiles, Redologs, etc to accommodate multiple instances and Databases on both clustered and single servers
• Schedule backup jobs, stats gathering, schema emp and imp using CRONTAB, Oracle OEM, DBMS JOBS,
• Competent in documenting standards and procedures.
• Successfully Migrated some of the oracle 9i and 10g databases from Unix Solaris to Linux SLES 10 to meet business requirements
• Developed shell script to automate RMAN backup
• Performing Capacity planning and Load-balancing
• Address and resolved space issues both on the Database level and Filesystem
• 24x7 Primary and Secondary pager rotation
• Refreshing and cloning a Database from production standby
• Scheduling and administering Database backups using RMAN
• Troubleshoot and resolve various Oracle Problems such as connectivity problems, backup and performance issues.
• Designed and implemented a Disaster Recovery configuration using Dataguard, by creating a standby from a primary Database
• Installation and application of several relevant Oracle critical Patches to each database.
• Developed, Implemented and Maintained an Enterprise Oracle backup, recovery and disaster recovery strategy.
• Perform and responsible for Oracle cold and hot backups using RMAN.
• Troubleshoot and resolve various Oracle Problems such as connectivity problems, backup and performance issues.
• Providing Oracle Network troubleshooting, technical and administrative support to the development staff.
• Regularly monitor and analyze DB activities and performance using custom utilities like ADDM, AWR, SQL Advisor, ASH etc
• Patching and upgrading Databases and Database migration from one host to another.
• Migrating Database from one OS platform to another
• Reorganizing Database structure and migrated Database from one Oracle binary user to another
• Developed Stored Procedures, Functions, Triggers, Packages and views used by the database instance. Modeling data using TOAD, PL/SQL Developer. Implemented the use of Oracle Recovery Manager RMAN and Oracle Recovery Catalog to backup the databases.
• Documenting DBA processes procedures, Database structure, changes, problems, issues for future reference
• Using various Oracle and Unix Utilities like RMAN, Import Export, TOP, iostat, etc to perform critical tasks
• Tune the database and applications for faster and better performance also performing goal-oriented tuning as necessary.
• Tune the database for performance using STATSPACK, EXPLAIN PLAN, AWR etc
• Provide support to developers and users with trouble-shooting and performance tuning of 11g
• Oracle Database 10g Administrator Certified Professional OCP

Confidential

Oracle Database Administrator

The duties I perform as a DBA include but are not limited to the following:

• Installed, configured and maintained oracle 9i. UNIX
• Manage fourteen different Oracle databases on two networks comprising of Production, Development and Staging
• Migrating 25 mission critical stand-alone Databases from Solaris 9 on physical servers to AIX 6.1 on LPARs with minimum business impact
• Developed Stored Procedures, Functions, Triggers, forms, reports Packages and views used by the database instance. Modeling data using TOAD, PL/SQL Developer, and Erwin.
• Performed and responsible for Oracle cold and hot backups.
• Installation, configuration and maintenance of oracle 10g and 11g environments.
• Provide technical expertise and knowledge leadership in the design, implementation and maintenance of relational database management systems.
• Planned and migrated of Oracle 8i database to 9i and 9i database to 10g database.
• Performed database refreshes, cloning and duplication from one Oracle database to another. Troubleshoot and resolve various Oracle Problems such as connectivity problems, backup and performance issues.
• Perform and responsible for Oracle cold and hot backups using RMAN.
• Designed and implemented a Disaster Recovery configuration using Dataguard, by creating a standby from a primary Database
• Managed system and database security security planning, security rights administration, compliance with organizational security policy, identify malicious activity, develop and deploy access controls, apply security patches and updates as necessary.
• Administer database user accounts. Create, modify and deactivate user accounts assign and monitor user access rights. Manage database back-up and recovery plans develop disaster recovery/continuity of operation plans perform routine database backup and recovery operations as necessary.
• Oracle Database 10g Administrator Certified Professional OCP