EXPERIENCE SUMMARY:

• Over 8 years of experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Wrote scripts to inform the DBA's regarding the status, performance and space management of the database.
• Expert knowledge in installing Oracle database server on SOLARIS, HP - UX, AIX, WINDOWS NT, LINUX and migration of Oracle server from 9i to 10g and 10g to 11g and 12c.
• Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments for high availability and load balancing.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Experienced in maintaining large Production, UAT, IST and DEV environments.
• Assisted in migrating data from Oracle RDBMS to MS SQL Server
• Used windows performance monitor to improve server performance
• 24/7 support for Production databases and responsible for round-the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior important.
• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
• Experience with various Oracle concepts/tools including RMAN, OEM Grid Control.
• Performed Installation, Configuration, troubleshooting, performance tuning, Backup and Recovery and production support of Oracle 11g, 12C databases (Single Instance and RAC) on Red Hat Linux.
• Implemented ASM on RAC and single instance databases. Managed disks and disk groups with ASM.
• Expertise in installing, configuring and maintaining Standalone and RAC databases on various platforms.
• Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DB’s.
• Planned and Implemented DR & High Availability Oracle solutions using Data Guard, Streams.
• Proficiency using Flash-Back Recovery, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM)
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK prof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Experience in cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment. General ODI development, troubleshooting
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.

TECHINICAL SKILLS:

HP: UX 10.x, 11.x, Sun Solaris 2.6,8,9,10, UNIX, AIX 5.1,5.2, Red Hat Linux 4.x, 5.x, 6.x and windows 2000/2003/2008

RDBMS: Oracle 11g/10g/9i, Oracle 11g/10g Real Application Cluster (RAC), ASM.

Tools: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, Tivoli Storage, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations.

Languages: SQL, PL/SQL, UNIX/NT Shell Scripting, KSH, BASH.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL TRACE.

PROFESSIONAL EXPERIENCE:

Confidential, Uniontown, Ohio

Sr. Oracle DBA

Responsibilities:

• Upgrade databases from 9i to 10g to 11g to 12c.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Troubleshoot performance issues using ASH, AWR and ADDM.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Implemented Various RMAN backup methods, Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Restored and recovered the databases using RMAN
• Experience working with 24x7 production support
• Configuring TNSNAMES.ORAand LISTENER.ORA for SQL*NET connectivity.
• Troubleshooting of networking issues and Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Applied one off, CPU and PSU patches.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Expertise in migrating single instance databases to multimode 10g, 11g R1, R2 and 12c RAC environments for high availability and load balancing
• Built 4 node RAC 10gr2 Standby database and set up DG Broker PerformedSQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Migrated databases to different data datacenter
• Build Data Guard for disaster recovery site. Configured Data Guard environment for setting up a physical standby in maximum performancemodeand performed Failover tests for High availability.
• Write scripts to perform database tasks like database creation, backup and recovery, Data Guard monitoring, data migration, monitor space etc.
• Experience in configuring, maintaining Data Guard Broker and performing switchover and switchback from Production to DR
• Worked on Data Migration project
• Installed and Configured Golden Gate Setup for replication.
• Installed Golden Gate for real-time uni-directional replication.
• Configured GOLDEN GATE Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
• Installed and configured GOLDEN GATE to work with OEM GOLDEN GATE Plugin.
• Configured GOLDEN GATE High Availability using Oracle DBFS and Active Data Guard.
• Monitoring and Performance tuning of GOLDEN GATE sessions at OS level, Database level and GGSCI level and investigate replication failures using ggserr.log, report files and Log Dump utility.
• Worked with Informatica team for performing GOLDEN GATE Initial loads.
• Experience in Oracle RAC DBA configuration management
• Performed Capacity Planning for RAC database.
• Worked on maintenance scripting and scheduling (including Korn Shell).
• ManagedOracle RAC Database environment on Linux/RH.
• Performing Database Change deployment through development, test, and production systems.
• Performed troubleshooting and Post-deployment performance tuning of Oracle database and SQL in production.
• Performeddatabase changes and document them in accordance with Confidential GDP and Change Management standards and guidelines.
• Reviewing work product for all changes.
• Performing restoration and Recovery where needed in development and test databases.
• Performance Tuning for the SQL queries which are running slow.
• Heavily utilized OEM for monitoring, job scheduling, Performance Tuning, and other routine DBA activities
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers.
• Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.

Environment: Oracle 11g/12c, HP-UX UNIX RHEL 4.x/5.x, ASM 11.1.0.6, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad, Informatica. Golden Gate.

Confidential, Norfolk, Virginia

Sr. Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Database on 11g and 12c
• Created User accounts, Roles and granting required access permissions and privileges to the databasebased on the applications they are accessing.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading to Oracle 12c to the latest Oracle 12c and applied patches as required.
• Installed, Configured and Administered STREAMS and good knowledge on GOLDEN GATE.
• Performed Schema as well as Table Level Replication using Oracle Streams
• Migrated databases using Golden Gate and RMAN for 2node RAC.
• Installed, configured Oracle 11gr2 RAC /non RAC databases on RHEL 6.4 VMs
• Full support of DBA activities for MAP and Content RAC databases on 10g and 11gr2 on OEL Linux2.6 .
• Performed a database upgrade of 17Tb 2-node RAC database with ASM on 10. .2.03 on OEL Linux 2.6 using the RMAN cloning of the database and performing an out-of-place upgrade to 11gr2 GRID .
• Configured and deployed 11gr2 RAC (4-node) in Dev, QA and Prod to support PEGA Applications. Fine-tuned RAC configurations and the databases as a daily activity.
• Implemented Broadcasting and Bi-directional Replication.
• Implemented and Configured Golden gatein 2 node RAC cluster for flow into EDW.
• Resolved replication issues in Golden gate.
• Automating tasks using Cron for GG restart.
• Hands-0n experience in converting integrated to classic extract and vice versa.
• Implemented 12cNew Features in Golden gate
• Upgraded Golden gate from v10 to v11.
• Architect Golden gate(10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Implemented and Monitored Data Guard on Oracle11g and 12c in maximum performance
• Implemented Dataguard and configured standby databases for critical databases using Dataguard and Export and import of database objects using EXPDP and IMPDP.
• Cloned schemas, objects and data on new server using Data pump.
• Involvement in space management, rectification of lock problems, managed quotas.
• Table partitioning to improve I/O access
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database orData Pump
• Implemented 12c RAC Clusters and created POC for failures and performance in the environment and troubleshooting using clusterware AlertLog Monitoring every day in the production environment
• Perform health checks using crsctl and managing services using srvctl
• Performance Tuning for the SQL queries which are running slow and taking more CPU cost
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Query optimizing using CBO(Cost Based Optimization) and Scheduled Oracle Jobs and Backups using CRONTAB.
• Restoration and Recovery of databases at the times of occurrence of critical failures
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN and Scripts.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM),Toad, SQL Developer and PL/SQL Developer.
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf
• Applied Security Patches from Metalink when needed and Responsible to provide 24 x 7 database administrative activities over different database servers

Environment: Oracle 11g/10g, HP-UX UNIX RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad, Informatica.

Confidential, New York

Sr. Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 11g R2 on Linux also Upgraded from Oracle 10g to 11g
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware andresponsible for high availability and load balancing.
• Installed, configured Oracle 10gand 11gR1 Streams between two geographical disparate sites for a 3-node RAC on Solaris 2.10
• Day-to-day DBA activities such as tuning , RMAN based backup/restore and recovery of production databases. ASM+ configured on each RAC node for OMF files. Generation of AWRs, PGA memory management, OEM for ONAMES and LDAP .
• Develops, interprets, and implements operational requirements for flow process and tracking of requests from CMS Recovery ( RAC ) Program , CMS Medicaid Integrity Program, CMS Prepayment Reviews as well as all other coordination, monitoring, and direction of RAC activities.
• Provides financial data and analysis for internal and external reporting . Ensures the system is prepared for RAC audits, coordinates response to audit requests, challenges questionable determination and assists in filing timely appeals.
• Prepares and perform quality audits of Medical Records to be released. Have a working knowledge of rules and regulations as they pertain to CMS RAC program and other government regulatory and enforcement agency audits for documentation and billing compliance.
• Installation, configuration and management of 2 - Node using OCFS in Oracle 10.2.0.3 on Linux ( Oracle Enterprise Linux 4.5)using NFS to provide the shared storage. Setting up of kernel
• Very good Knowledge on 11g New Features.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical andlogical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storagestructures and objects, databasebackup and recovery, monitoring and optimizing database performance.
• Installation, Configuration and Administration of Oracle 11g RAC.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Oracle streams AQ (Advance Queuing) in integrated application environments.
• Configured and implemented Oracle Streams (AQ and dequeuer) for high availability.
• Good skills in configuring and implementing down streams, Queues database.
• Very Good Knowledge on oracle streams
• Oracle streams AQ client/ server communication.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN,Hot backups, Cold backups and Logicalbackups.
• Performed automated backups and scheduling using scripting.
• Experienced in dealing with Query execution plan, SQL trace, TKprof.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases,DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(NetworkConfiguration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Working Experience with Latest TOAD having new features HealthPLSQL & SQL Script Debugger, Database Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, and Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM),
• Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operationalenvironment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & changerequests for future reference.

Environment: Oracle 11g/10g, HP-UX UNIX RHEL 5.x, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Business Objects, Toad, Informatica, VERITAS Net Backup

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 11g databases on Linux and also Upgraded Oracle databases from 10g to11g version.
• Implemented Oracle Database 11g Two nodeReal Application Cluster (RAC) using Oracle Cluster-ware andresponsible for high availability and load balancing. * Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical andlogical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storagestructures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the databasebased on the applications they are accessing.
• Renaming and Resizing the databases and Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logicalbackups.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases and Experienced in performing Point intime recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases,DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(NetworkConfiguration Assistant) for creating Client-Server environment using Listener, TNSnames etc.,
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database HealthCheckup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operationalenvironment.
• Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reportsfor the management to act in advance.

Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0, 5.x RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, Informatica, PL/SQL and Toad.

Confidential

Oracle DBA PL/SQL Developer

Responsibilities:

• Performed full and incremental Backup Using RMAN Utility for Production databases.
• Involved in Upgrading the databases using Database Upgrade Assistance(DBUA)
• Performed cloning and refresh of Database from production environment to test environment using RMANDuplicate database and Data pump import export.
• Handling service requests within Service line agreement.
• Involved in configuration files like Listener.ora,Tnsnames.ora for Client-Server environment using networkconfiguration assistant.
• Identified and fixed the logical block corruption using RMAN.
• Performed Data load on different databases from flat file using SQL*Loader.
• Performed Hot backup, cold backup and incremental backup for production database using RMAN.
• Monitored ALERT Log files to keep tracking the Oracle Errors and make necessary action to rectify them.

Environment: Oracle 9i/10g, Sun Solaris, HP-Unix, UNIX, Linux 4.0, 5.x RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, PL/SQL and Toad