SUMMARY

• Senior Oracle Database Administrator with around 7 years of experience in administration, installation, configuration and upgrades of Oracle 11gR2, 10G, 9i, 8i databases including applying patches under Linux, Confidential - Unix, IBM-AIX and Windows platforms.
• Experience includes managing Oracle 9i, 10g and 11gR2 RAC and ASM environments using the OEM Grid Control tools. Experience includes Oracle Utilities Data Guard, Flashback and RMAN.
• Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two-node on Linux with ASM).
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, TAR support.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate Databases, Data Guard and FLASHBACK recovery features.
• Design, document, implement, and maintain all backup, recovery including disaster recovery. Procedures using RMAN Backup.
• Strong programming experience in creating Packages, Stored Procedures and Functions, Database Triggers.
• Experience in implementing Automatic Storage Management for simple storage interface.
• Experience in installing and configuring/Monitoring Enterprise Manager Grid Control. Strong knowledge and experience in using Oracle Configuration and Provisioning Pack.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems. Performed complete multi-master replication with updateable Materialized views.
• Experienced in Installation of High availability RAC environment (2, 3 and 4 node clusters), upgraded standalone databases to 10g/11g/12c RAC environment and adding a node to the cluster database for high availability.
• Migrated single instance databases to multimode Oracle RAC environment for high availability and load balancing.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Extensive experience in Data guard configuration, implementing and monitoring standby databases.
• Set up Active Data guard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable table spaces.
• Experience withInstallation, Configuration, Migrations, Oracle Data Guard,Backup and RecoveryusingRMAN, Disaster Recovery and Patching, upgrading
• Good experience in applying PSU and Critical Patch Update (CPU Patches) using OPATCH Utility on Databases, Application Servers and Middle Tiers.

TECHNICAL SKILLS

Databases: Oracle 12C,11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i,8i, MYSQL

Oracle Products: Oracle Real Application Cluster 10g/11g/12C, OEM 12C, Data guard, Import & Export, Automatic Storage Management, Oracle 10g/11g/12c (Grid Control), Oracle Fail Safe, RMAN, Transparent Data Encryption.

Operating Systems: AIX, Confidential -UX, Windows 2000/2003/2008 , Windows NT, Red hat Linux.

Languages: SQL, PL/SQL, Unix shells scripting

Tools: & Utilities: Oracle Grid Control 11g/12c, SQL*Loader, RMAN, SQL Developer.PL/SQL Developer, DBCA, SRVCTL, CRSCTL, ASMCMD.

PROFESSIONAL EXPERIENCE

Confidential, Collegeville, PA

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g,Solaris, Confidential -UNIX, Linux, Windows server 2000/2008, RMAN, OEM 12c, PL/SQL, Oracle Grid Control, SQL Developer, Toad.

Responsibilities:

• Taking care of all the day to day operations on databases which included incidents changes and alerts.
• Creation of database users and by setting default table spaces and temporary table spaces, assigning quotas, roles, privileges and profile to users.
• Creating and administrating database objects like table, views, indexes etc. and maintaining several Database instances running on Windows environments.
• Maintaining all database objects including Schemas, Tables, Indexes, Triggers, Sequences, Primary and Foreign keys, Views, and all Constraints.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN & TAPE backup management.
• Experienced in Oracle installations, upgrades, migration, designing logical/physical architecture, Tuning, Capacity planning, database access and Security and auditing.
• Oracle RAC administration with configuration of ASM storage for 2 Node RAC database.
• Planned and implemented DR using Oracle data guard & Installation and configuration of Oracle client Software and tools.
• Database backup, recovery & cloning using RMAN methodology.
• Data migrated from Oracle 9i legacy databases to Oracle 10g databases using migration utilities Data Pump, Export and Import (schemas and full database) and Transport Tablespaces for different character sets of databases.
• Creating the new basic profiles using the Client password check function and check that there are no default passwords for default accounts.
• Upgrade/Migration of databases from Oracle 10g to 11g.
• Identify performance problems usingwait eventstatistics. Monitor session-level wait events and collect historical data for root cause analysis Supported the development team at offshore in issue fixing, migrations of code & other support activities.
• Controlling and monitoring user access to the database for new and existing databases.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Proficient in performing Data Migrations using export/import.
• Good experience on Schema Level Refresh & Database Level Refresh.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Monitoring & Managing the table spaces and data files growth Blackout Administration and Providing day to day end user database support.
• Installing the OEM agent to monitor the Databases and performance enhancement using session Tracing, Stats pack and CPU utilization.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Provided all kind of high end support for 10 g databases on Solaris and Linux Migration, from Solaris to red hat at same time
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Installation of oracle home and client software and Managing and creating Oracle database, managing listeners and Registering databases to OID.
• Knowledge of ITIL Processes, Problem Management, Change Management, Incident Management and Configuration Management as I have been a part of number of Pre-prod deployments and Prod deployments
• Worked on Golden Gate setup and issue tracking and resolutions with Oracle support.
• Deploying database objects between developments, QA, production, backup database tables with data and structures for selected schemas
• Handling MEDIUM/HIGH/CRITICAL priority incidents for mission critical servers.
• Detailed knowledge of working with services and tools like Confidential Service Centre ticketing tool, TOAD, Oracle Meta link.

Confidential, Chicago, IL

Sr. Oracle DBA

Environment: Oracle 9i/10g/11g, REDHAT Linux 4, Windows Server 2008, Oracle Grid Control RMAN, Dataguard including DG Broker setup, PL/SQL, OPATCH, Oracle Advanced Security, OEM 12c, SQL Developer.

Responsibilities:

• Installing and configuring Grid Infrastructure & Database software. (Troubleshooting & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, de-installation & cleanup of Cluster ware).
• Performed migration of the oracle databases whose database sizes vary from GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Migrated OCR and VOTING disks to newer disks by adding newer disks from SAN and dropping the old disks by using ASM’s native rebalancing feature.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Set up Active Data guard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Configuring and managing ASM instance and migrating database from NON-ASM to ASM.
• Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Hands on experience in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
• Experienced in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Setup physical standby’s (DATAGUARD) for several Databases (via OEM as well). Very good experience with Oracle 10g RAC administration and HA environment.
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and performing production databases Maintenance.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Monitoring and performance enhancement using session Tracing, Stats pack and CPU utilization.
• Monitoring databases and setting alerts using Oracle Grid Control/Enterprise Manager.
• Planning, implementing and validating various versions of Oracle Databases to 10gR2(10.2.0.4,)& 11g R1(11.1.0.7) & 11gR2 upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Installation of 11.2.0.3 RAC (4 node) from the Scratch and the maintenance of the high available Databases.
• Migration of all Oracle 9i/10g databases/clients to 11g.
• Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migrationof all custom application changes through four different instances to production.
• Configured Oracle data-guard (ADG) for Oracle Disaster recovery on standalone databases using11g ACTIVE DUPLICATION.
• Setup the standby via OEM cloud control 12c for several databases.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metal ink.
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.

Confidential, Hartford, CT

Oracle DBA

Environment: Oracle 9i,10.2.0.4,11.1.0.6,IBM Manage NOW, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, LINUX, IBM AIX.

Responsibilities:

• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues.
• Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Upgrade and Migration of Database’s from 10.2.0.5 to 11.2.0.2 and applying patches whenever required.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.
• Good Knowledge in supporting Banner users by writing detailed user menu procedures also assisting HR/Payroll users with verbal instructions to resolve any problems.
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Involved in migrating databases from Windows to Linux, Confidential -UX to IBM AIX.
• Good Knowledge in analyzing Ellucian Banner System HR/Payroll data and Banner Finance data analysis experience.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Support and Administer SQL replication for DB2 on Z/OS environment
• Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
• Patched/Upgraded ORACLE 9i Databases to ORACLE 10g databases using DBUA/Manually.
• Designed various Backups/Recovery strategies for Oracle databases as per SLA requirements.
• Migrating data from development data to Stage and then Stage to production SQL/PLSQL and UNIX Shell Scripting for monitoring space and extent growth.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And legato TAPE backup management.
• Provided a decent range of production DB2 support for all mission critical databases.
• Recovering Databases when there is any Physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks.
• Installed ORACLE Enterprise Manager GRID CONTROL and configured it server targets for a centralized monitoring system.
• Monitored databases Performance using ORACLE Enterprise Manager (OEM) and Grid Control.
• Upgrade and Migration of Database’s from 10.2.0.4 to 11.1.0.6 and applying patches whenever required.
• Configure OEM 12c monitoring with customized templates and email alerts.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
• Served in a team of Supporting Banner HR/Payroll System, troubleshooting and problems resolving the system pays 500 employees supporting Fiscal Year Budgets Roll processes.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Configure DR using Oracle 11gR2 Data-guard & Standby databases. Monitoring, Administrating Primary & Stand-by databases using Data Guard. Resolving Gaps.

Confidential

Oracle DBA

Environment: Oracle 9i,10.2.0.2,11.1.0.7, Maestro 7.0, Confidential service desk, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3.

Responsibilities:

• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Creating Tables, indexes, & triggers to assist developers.
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Involved in 24x7 Oracle Production Database Administration.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Configured Oracle data-guard (ADG) for Oracle Disaster recovery on standalone databases using11g Active Duplication. Setup backup procedures for various PRODUCTION databases based upon SLA.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Responsible for purging and archiving the production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Involved in Analysis, Design, and Development of implementation modules of DB2, COBOL.
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Took Full/Incremental backups using ORACLE Recovery Manager (RMAN).
• Applied various patches on regular basis to oracle software homes. .
• Refreshed PROD, DEV, UAT databases using Data pump, RMAN, Transportable Tablespaces etc.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.
• Object / Data Migration from one DB2 subsystem to another Planning for VSAM to DB2 conversion.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Applied necessary Patches during installation and also in up-gradation of databases on Oracle 11g database versions.
• Designed, tested and debugged external and DB2 native stored procedures. Worked with remote stored procedure calls.
• Extensive Experience with Change Control Management for all database changes. Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.

Confidential

Oracle DBA

Environment: Oracle 9i/10g, Sun Solaris, windows NT/2000/2003, RMAN, DBCA, Data guard, Oracle Enterprise.

Responsibilities:

• Performed Installations of Oracle software on various Windows and UNIX servers
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
• Designed and implemented hot backups using a combination of incremental differential and full backups using RMAN and Hot/Cold.
• Implementation of RAC, ASM, DATAPUMP, FLASH BACK Recovery.
• Creation of database links, estimating the size of Databases and Creating Databases.
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.
• Installed and configured 2 Node RAC on 10gR2 and Upgraded databases using Database Upgrade Assistance (DBUA).
• Export and Import of databases from one database to another databases.
• Monitoring the performance of production database through Instance Monitor (Quest Tool) and growth of the database and suggesting for change in parameters if required.
• Involved in optimizing SQL statements using Indexes and Hints.
• Planning and scheduling for the backup of database information using Crontab jobs.
• Generated daily, weekly and monthly reports regarding total revenue management.
• Volume management using Verities Volume manager to configure Disk group.
• Controlling and monitoring user access to the database for new and existing databases.
• By monitoring production Database through Instance Monitor, suggested some parameters for Database Tuning.
• Performed Smoke testing during the installation of every full build for application to validate the fitness of the application for testing.