SUMMARY:

• Over 9 years of extensive experience in analysis, design, development, testing, migration and implementation of Software applications. Sound knowledge in Database administration, designing, tuning, backup, recovery and documentation using ORACLE 12c, 11g, 10g, 9i
• Expertise includes Oracle Databases (11g,10g/9i), 11g on Unix/Linux/Windows platforms in ensuring Quality, Integrity and Availability of the Company’s data within Oracle Server.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle
• Databases and Oracle Grid control 12c/11g.
• Installation and configuration and performance tuning of Oracle  9i, 10g, 11g.
• Statspack, SQL TRACE, custom scripts and wait interface.
• Troubleshooting and resolving critical production issues in complex application environment:
• SQL*net connectivity issues, locking, database hang issues, OS/network issues, concurrent manager issues.
• Golden Gate Heterogeneous replication
• GoldenGate replication solutions design
• Experience in OLTP/DSS database systems, managing large Oracle databases (VLDB).
• Creating and managing WebLogic domains and managed servers
• Backup and Recovery, Optimal Flexible Architecture (OFA).
• Experience in DATAGUARD and DISASTER RECOVERY support.
• Good experience in SQL Tuning and Query Optimization.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Logical Database Design, Backup and Recovery procedures.
• Database administration experience in Sybase ASE, Sybase IQ, Sybase Replication Server,ORACLE and Microsoft SQL Server
• Experience in interacting with Data Modeling team and knowledge in using Data Modeling tool - ERwin.
• Installation of OMS and OEM agents and Agent Configuration with proper settings( Per company Policies)
• Expertise in using ADDM, AWR, EXPLAIN PLAN, TKPROF, SQL * TRACE and WAIT INTERFACE for Performance Tuning.
• Used Oracle scheduler and Unix Cron utility for automating jobs.
• Experience in installing, configuring and managing Automatic Storage Management (ASM).
• Experience in using SQL* LOADER to load data into oracle database.
• Proficient in PL/SQL, SQL and UNIX Scripting.
• Experience in Oracle Security, Auditing and Capacity Planning.
• Perform daily monitoring of Oracle instances using Oracle Enterprise Manager, TOAD, users,
• Proficient with Oracle Standby Database, Data Guard, Replication, upgrade, refresh, cloning.
• Tuning up parameters Values for best simulation.
• Experience with Installation and maintaining Real Application Clusters.
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF
• Experience in interacting with Data Warehousing team during bulk uploading of data and other data transferring discussions.
• Working knowledge of referential integrity, triggers and stored procedures.
• Experience in using OEM grid Control, RMAN.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations, Benchmarking
• Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.
• Golden Gate Heterogeneous replication
• Over four  years of experience with RAC, Standby Database, Data Guard, Replication
• Oracle SOA Suite 11g administration on Linux
• Good Knowledge WebLogic Server design and architecture
• Experience Installing and configuring WebLogic 10.x/11.x instances

TECHNICAL SKILLS:

Operating systems: HP - UX, Sun Solaris, Redhat Linux, AIX, Windows,

Languages: SQL, PLSQL, Unix shell Programming

Databases: Oracle  12/c 11g, 10g, 9i,, MS SQL server 2008R2/2012, SYBASE ASE

Hardware/Machines: HP-UX, Intel PC, Sun Ultra Sparc, IBM - AIX

Tools & Utilities: EXP/IMP, OEM, RMAN,TKPROF, STATSPACK, AWR,ADDM, SQL LOADER, SQL NET, TOAD, SRVCTL, ORADEBUG, RACDIAG, RDA, SYBASE OPEN CLIENT

PROFESSIONAL EXPERIENCE:

Confidential, Round Rock, TX

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 11gR2.
• Upgraded  databases from Oracle 11g to 12c in non-production environments.
• 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, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Involved with installation and maintenance of ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Applied Oracle patches during scheduled tech windows.
• Implemented Oracle database backup & recovery solutions using RMAN  and manual methods.
• 24x7 Production database and applications support on an onshore/offshore model
• Performed block recovery using RMAN.
• Heavily involved in moving data between databases using Data Pump.
• 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 database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured GoldenGate for replication.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump  to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery .
• Performed Capacity Planning and Bench Marking
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Environment: Oracle 11g RAC, HP-UX, REDHAT LINUX, SUN SOLARIS, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

Confidential, Salt Lake City, UT

Sr. Oracle DBA

Responsibilities:

• Worked on package installations for custom codes into the existing and upgraded environments.
• Worked extensively on user administration along with required roles for UAT and Parallel Testing.
• Performed performance tuning on RAC and identified key wait interface
• Extensively worked on environment refreshes and replications on monthy basis after every release
• GoldenGate replication solutions design
• Golden Gate Unidirectional and bidirectional replication as a part of the product upgrade.
• Implementing Oracle 12c Grid control and Migrating Oracle Databases to 11.2.0.4.
• Deploying OEM agents on many servers and configuring the agents on OMS.
• Data guard Physical Standby database using RMAN
• RMAN Duplicate Database Cloning for multiple environments.
• Experience in taking daily/weekly hot backups and cold backups using RMAN.
• Good experience in managing the databases using the OEM grid control like Scheduling backups, performance monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
• Applied Patches includes PSU and Bug-fixes for database performance issues.
• Installed Configuration migration utility on the existing and upgraded environments and set up database links for the same.
• Installed RAC on 3, two-nodes on Sun Solaris servers
• Configured Transparent Application Failover (TAF) and  Load-balancing on RAC.
• Involved in upgrading the databases from 11gR1 to 12cR1.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose.
• Diagnose and troubleshoot Database problems and failures like instance crashes, internal errors, etc.
• Shell scripting for RMAN Backups.
• Golden Gate performance tuning/troubleshooting
• Experience in Oracle Home cloning and upgrading database on that home.
• Taking AWR reports and analyzing the statistics for performance issues and resolving them.
• Experience in using the SharePlex replication tool for Disaster Recovery, backups and routine maintenance (High Availability).
• Cloning the databases for development and testing purposes.
• Performed hot, cold, tablespace level backups.
• Created Data Models after upgrading to new 12c Databases and migrating data using ERwin Data Modeler r9
• Oracle Database and SQL tuning using AWR, EXPLAIN PLAN, TKPROF etc…
• Creating and dropping of users, granting and revoking rights as and when required.
• Management of table space growth, monitoring data files additions, extent growth.
• Good experience in SQL, PL/SQL, Shell Scripting
• Applied High priority, security patches downloaded from Oracle Support.

Environment: Oracle 11g, 10g, 9i, HpUx 11i v3, 11i v2, REHL 5 and REHL 6, 12c grid control, SQL Developer, ADDM,AWR, Toad, UltraEdit

Confidential, Eden Prairie, MN

Sr. Oracle DBA

Responsibilities:

• Data guard Physical Standby database using RMAN
• RMAN Duplicate Database Cloning for multiple environments.
• Experience in taking daily/weekly hot backups and cold backups using RMAN .
• Good experience in managing the databases using the OEM grid control like Scheduling backups, performance monitoring, alerts setting, generating reports in seconds, email notifications, Black out  instances during maintenance/down times etc.
• Applied Patches includes PSU and Bugfixes for database performance issues.
• Installed Configuration migration utility on the existing and upgraded environments and set up database links for the same.
• Worked on package installations for custom codes into the existing and upgraded environments.
• Worked extensively on user administration along with required roles for UAT and Parallel Testing .
• Performed performance tuning on RAC and identified key wait interface
• Extensively worked on environment refreshes and replications on monthy basis after every release.
• Implementing Oracle 12c Grid control and Migrating Oracle Databases to 11.2.0.4.
• Deploying OEM agents on many servers and configuring the agents on OMS.
• Diagnose and troubleshoot Database problems and failures like instance crashes, internal errors, etc.
• Shell scripting for RMAN Backups.
• Experience in Oracle Home cloning and upgrading database on that home.
• Taking AWR reports and analyzing the statistics for performance issues and resolving them.
• Cloning the databases for development and testing purposes.
• Performed hot, cold, tablespace level backups.
• Created Data Models after upgrading to new 12c Databases and migrating data using ERwin Data Modeler r9
• Oracle Database and SQL tuning using AWR, EXPLAIN PLAN, TKPROF etc…
• Creating and dropping of users, granting and revoking rights as and when required.
• Management of table space growth, monitoring data files additions, extent growth.
• Good experience in SQL, PL/SQL, Shell Scripting
• Applied High priority, security patches downloaded from Oracle Support.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Configured Transparent Application Failover (TAF) and Load balancing on RAC.
• Involved in upgrading the databases from 11gR1 to 12cR1.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose.
• Diagnose and troubleshoot Database problems and failures like instance crashes, internal errors, etc.
• Shell scripting for RMAN Backups.
• Experience in Oracle Home cloning and upgrading database on that home.
• Taking AWR reports and analyzing the statistics for performance issues and resolving them.
• Experience in using the SharePlex replication tool for Disaster Recovery, backups and routine maintenance (High Availability).

Environment: Oracle 11g, 10g, 9i, Hp-Ux 11i v3, 11i v2, REHL 5 and REHL 6, 12c grid control, SQL Developer, ADDM,AWR, Toad, ERwin, Erwin Data Modeler r9

Confidential, Pittsburgh, PA

Sr. Oracle DBA

Responsibilities:

• Implementing Oracle 12c Grid control and Migrating Oracle Databases to 11.2.0.4.
• Deploying OEM agents on many servers and configuring the agents on OMS.
• Data guard Physical Standby database using RMAN
• RMAN Duplicate Database Cloning
• Experience in taking daily/weekly hot backups and cold backups using RMAN.
• Good experience in managing the databases using the OEM grid control like Scheduling backups, performance monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.
• Applied Patches includes PSU and Bug-fixes for database performance issues.
• GoldenGate replication solutions design
• Golden Gate Unidirectional and bidirectional replication
• Installed RAC on 2, two-nodes on Sun Solaris servers
• Configured Transparent Application Failover (TAF) and            Load-balancing on RAC.
• Performed performance tuning on RAC and identified key wait interface
• Involved in upgrading the databases from 11gR1 to 11gR2.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose.
• Diagnose and troubleshoot Database problems and failures like instance crashes, internal errors, etc.
• Shell scripting for RMAN Backups.
• Golden Gate performance tuning/troubleshooting
• Experience in Oracle Home cloning and upgrading database on that home.
• Golden Gate replication production support
• Taking AWR reports and analyzing the statistics for performance issues and resolving them.
• Experience in using the SharePlex replication tool for Disaster Recovery, backups and routine maintenance (High Availability).
• Cloning the databases for development and testing purposes.
• Performed hot, cold, tablespace level backups.
• Oracle Database and SQL tuning using AWR, EXPLAIN PLAN, TKPROF etc…
• Creating and dropping of users, granting and revoking rights as and when required.
• Management of table space growth, monitoring data files additions, extent growth.
• Good experience in SQL, PL/SQL, Shell Scripting.
• Installation, configuration and creating new test databases for production and development databases.
• Applied High priority, security patches downloaded from Oracle Support.

Environment: Oracle 11g, 10g, 9i, Hp-Ux 11i v3, 11i v2, REHL 5 and REHL 6, 12c grid control, SQL Developer, ADDM, AWR

Confidential, HERNDON, VA

Sr. Oracle DBA

Responsibilities:

• The work involves overall maintenance of ORACLE database, performance issues, tuning, backup, recoveries and other database related activities.
• Sybase installation, configuration, tuning, backup and recovery
• The work also involves system administrator tasks like creation of users, file systems, volume groups, and Logical volumes, etc.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Using grid control to monitor the performance of database.
• Day to day performance monitoring and tuning of database.
• Add and Configure Sybase Servers.
• Monitoring of database objects like rollback segments, temp segments and tablespaces.
• Diagnose and troubleshoot Database problems and failures.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases.
• Experience in using Grid control to monitor target databases.
• Preparing Backup and Recovery plan.
• Involved in administering Oracle database running on Unix and Windows Machines to support Oracle database.
• Involved in the installation of Oracle 9i on Windows NT and Linux.
• Creation and maintenance of database.
• Handling day-to-day activities.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and
• Viewing Alert log files & Trace files.
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Windows platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance.
• Creating logical standby database from hot backup of primary database
• Installed and Configured Oracle Data guard for Oracle 11g &10g  for the maintenance of Stand by database.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Setting up Data guard using switchover and failover with RMAN backup.
• Monitoring Database for fragmentation and correcting them.
• Creating and implementing backup and recovery strategies.
• Setting up and maintaining user accounts and profiles.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments).

Environment: Oracle 11g, 10g with RAC, Oracle 9i, Solaris, Linux

Confidential, Ashburn, VA

Sr. Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administration including Oracle 10g RAC.
• Installed, configured and maintained Oracle Databases.
• Installation, Configuration and Administration of Oracle 8i, 9i, 10g and structures.     
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database for development and testing purpose.  
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.  
• Standby Database (Data Guard) setup and configuration.
• Working alongside programmers and contributing to the development process; Enabling and analyzing Trace files.
• Performing monitoring and performance tuning
• Planning and recommendations for optimum performance.
• Defining and Setting backup and recovery procedures. Configuration of backup.  
• Includes table/index/etc. maintenance in QA and production
• Support for test and/or development environments.
• Tuning the database using Statspack and custom scripts.      
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and tablespace i/o statistics.  
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Responsible for Sybase installation and performance tuning.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in tablespace by avoiding fragmentation.
• Working knowledge of referential integrity, triggers and stored procedures.
• Cloning and auto patching by Grid control.
• Usage of Partitions to improve the query performance and manageability.
• Installation of Oracle RDBMS server software and version upgrades.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc).
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally,
• Recovering data files, Recovering from Block Corruption).
• SQL and PL/SQL Programming.
• Installation and configuration of Oracle Client software and Tools.
• Analyzed the user requirements and Designed partitioned tables for improving performance of Data marts.
• Analyzed the user requirements and Designed views using STAR schema for improving performance of Data marts.
• Performed partition maintenance and automated the process of creating new partitions as and when required.Automated the process of analyzing tables every night.

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, HP UX, AIX

Confidential

DBA                                  

Responsibilities:

• 24x7 Production Database Administration and support
• Work involves overall maintenance of ORACLE database, performance, tuning, backup, recoveries and other database related activities.
• System administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviours
• Monitoring database objects like rollback segments, temp segments and tablespaces
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, Solaris, Linux

Confidential

DBA                                  

Responsibilities:

• 24 X 7 Production Oracle database support and administration for multiple customers.
• Provided DBA support for Exide Industries Ltd., ESSAE TEROKA LTD., Geojit Financial Services Limited.
• Load data from OLTP systems into data warehouse databases.
• Installed and configured Oracle and Oracle Products on UNIX, Linux and Windows Environments.
• Monitored & tuned the performance of database and SQL statements.
• Monitored for unusual conditions in database against contention, load throughput and cache utilization.
• Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using Export.
• Testing of Backup’s and Documenting backup strategies.
• Created scripts for automating online daily backup for eight databases and for automating data loading from flat files.
• Monitored regularly whether primary and standby databases are in sync and clearing the backed up Archive log files after confirming that they are applied on the standby database.  
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces andtaking remedial steps.
• Starting the reporting database using the standby database data files and standby control file.   
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.  
• Collecting the statistics using Explain Plan and tkprof, studying the report.txt during performance slowdowns. Collecting the statistics of tables and indexes by analyzing for cost based optimizer mode.
• Used SQL LOADER for dumping data into database from Legacy Systems and Flat files.
• Good experience in SQL, PL/SQL, Shell Scripting.
• Worked with DW team for loading data to warehouse databases.
• Performed Table space Management and Rollback table space Management.
• Transaction Management and Security Management. De-fragmentation of database objects
• Involved in migration of the databases from Oracle 9i to Oracle 10g.
• Upgraded Oracle 9i RAC to Oracle 10g RAC.
• Cloned environments to create patch test, development and QA environments.
• Involved in oracle 10g database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Monitor and tune Database, SQL statements performance using OEM, STATSPACK, TKPROF, EXPLAIN PLAN.
• Checking and alerting for availability of next extent size, scheduling to analyze database using estimate for small tables and compute 10% for table of size greater than 1g etc.
• Shell scripting for monitoring health of database and sending email for any errors logged in alert log  file,Monitoring file system space availability.