SUMMARY

• Around 9 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security etc.in production as well as development databases on different platforms.
• Excelling experience in Installation, Setup and configuration of Oracle 10g, 11g, 12c in HP - UX, SUN SOLARIS, UNIX/LINUX and Windows environment
• Installing and configuring and performance tuning of Oracle RAC 3+ nodes.
• Good Knowledge and hands on experience with Oracle Enterprise Manager 12c
• Setup Physical data guard replication for high availability.
• Performance Monitoring and Tuning of Database using Grid Control & Diagnostic pack (AWR, ASH ADDM etc.)
• Experience using enhanced features in 12c like - Real Application Testing(RAT), Table and partition recovery using RMAN, Invisible columns, DDL Logging
• Worked with customer for different RAC related issue: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on
• Good Knowledge and hands on experience on Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Extensive experience with implementation of Oracle Advance security Wallet Manager.
• Design and implement backup and recovery including disaster recovery structures.
• Worked with Oracle to resolve Ora-00600, Ora-07445 issues and resolutions
• Good working knowledge with XML files, Loading and unloading
• Patches, keeping applications software bug free and improving data integrity.
• Upgrades, troubleshooting database issues, critical security updates and User Issues using Meta link.
• Expertise in Oracle performance tuning using STATSPACK, TKPROF, Explain plan.
• Management of 400+ databases with sizes ranging from 20GB to 20TB and a mix of single instance/RAC Environments
• Experience in Data Migration using Data pump utility.
• Proficient in Oracle 12c, 11g R1, 11g R2, Oracle 10g R2, 10.1.0.x, Oracle 9.2.0.x, Oracle 8.1.7.x
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured Listener for external procedure calls.
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables.
• Proficient in Database administration activities such as user management, space management, monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.
• Experience in UNIX shell programming.
• Hands on experience working on High Availability Environments.
• Responsible for 24x7 on-call support and monitoring and production deployments.
• Goal Oriented, Good Co-ordination and Co-operation with the Team and Management. Adept at learning and adaptable to complex work environment

TECHNICAL SKILLS

Hardware: Sun E15K, Sun Ultra Sparc, Sun SparcStation-10, Digital, Hp XP256/XP512, IBM X series

Operating System: Solaris 7,8,9, Digital Unix, Windows 95/98/NT/2000/XP, HP-UX 10.x/11.x, AIX 7.1,6.1,5.3, RHEL

Software: Oracle 8i/9i/10g/11g/12c, Oracle 9iAS

Languages/Front End: C, C++, Shell Scripting, SQL, PL/SQL.

RDBMS: Oracle (8.x, 9.x, 10.1.0.2, 10.2.0.3 - 10 g), 11g (11.1.0.6, 11.0.1.7, 11.2.0.3, 11.2.0.4), 12c.

Tools: / Utilities: OEM, Oracle Data guard, Toad, Export/Import, Data Pump, AWR, ADDM, stats pack, TKPROF, Spot light, VERITAS Cluster / Net backup, Simpana Commvault RMAN, SQL expert, RAC, Real Application Testing(RAT).

PROFESSIONAL EXPERIENCE

Confidential, Albany NY

Sr. Oracle Database Administrator

Responsibilities:

• Implementation of High Availability solutions with Oracle 12c,11g RAC,10g RAC, StandbyDatabase(Active Data Guard), Replication.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling
• Performs ongoing database performance tuning, including review & tune complex SQL statements
• Run AWR and statspack reports to identify sql with large buffergets and physical reads per execution.
• Created Physical Standby database usingOracleData Guard at local and remote sites and performed managed recovery of Physical Standby Database and monitored Standby Database.
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Implemented multiplexing control files and redo log file.
• Identifying and removing Fragmentation, row migration/chaining ofdatabaseobjects
• IdentifySQLexecution plan changes and performance regressions through SQL Performance Analyzer with RAT.
• Loaded data using EXTRACT and REPLICAT process in Oracle Golden Gate tool.
• Setting up Golden Gate replication to heterogeneous environments for OS and Databases.
• Capture, analyze and replay database transactions by using RAT.
• Experience in upgrading 11g OEM to OEM 12c Cloud Control with a Two system approach method having zero downtime
• Implemented oracle 12c flexi asm for pre-prod environment.
• Installed, Configured Oracle 12c Golden gate on Oracle 12c Database.
• Extensively worked on Golden gate. Configured cascading and bi-directional setups to accommodate the business requirements.
• Performed conversion of SingleNodeInstance to MultiNodeRAC with ASM, and adding instance to existing RAC.
• Applied patches and Migrated Databases and maintain an updated platform matrix and also Cloned/Refreshed Databases from Production Database using RMAN and Hot Backups.
• Resolved Oracle errors and bugs by working with Oracle Support.
• Providing production support for 24X7 database availability forOracleDatabase

Environment: Oracle 12c, 11g R2 RAC, SQL Server, Solaris, HP-UX,AIX, Red Hat Enterprise Linux 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, Spotlight, PL/SQL, Shell scripting..

Confidential, Pittsburgh, PA

Sr. Oracle Database Administrator

Responsibilities:

• Install and Configure Oracle 11g RAC with Grid Infrastructure (GI) on 4 nodes on Red Hat Enterprise Linux 5.7
• Upgrade production databases from 10.2.0.2 to 10.2.0.4 and 10.2.0.4 to 11.2.0.2 on RHEL 5.7/5.9 and applied quarterly Critical Patch Updates and Patch Set Updates as needed
• Provide 24X7 on-call support on a rotation basis and developed ad hoc shell scripts to provide temporary work-around for issues in production databases
• Performed capacity planning for the Database and added nodes to the RAC Database to make the 2 node RAC Database a 4 node RAC Database in order to accommodate growing needs
• Performed database Audits/Fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular basis on user operations involving sensitive database objects
• 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.
• Setting up Physical Standby Database Data Guard for Disaster recovery and implemented failover and switchover mechanisms.
• Migrated Non ASM file system to ASM File system for better space management.
• Implemented Real Application Testing (RAT) for upgrades and migration.
• Experience using 12c pluggable and container databases (PDBs and CDBs).
• Data Refresh from Test to Production and Development environments using RMAN Duplicate Database.
• Experience with Oracle Very Large Databases (VLDB) of 1TB to 8TB.
• Implemented security features like Auditing and user management in Oracle 11gR2 and SQL Server 2000/2005/2008 Databases.
• Working with VERITAS, SAN and EMC Net Backup Technology to take the hot and cold backups.
• Done performance tuning using SQL application tuning using TKPROF, SQL TRACE for session, STATSPACK, Explain plan
• Managed the Very Large tablespaces and tables in 12 TB size of Database.
• Configured the Oracle Golden Gate on Red Hat Enterprise Linux 6 and performed data replication.
• Configured initial and incremental load using golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate with zero downtime.
• Developed the database application with java like Installing Java DB, connecting to the Java DB Database and Deploying the application.
• Extensively worked on Golden gate. Configured cascading and bi-directional setups to accommodate the business requirements.
• Implemented oracle 12c active standby database for test database environment.
• Identified bugs and applied required patches like CPU, PSU Patches as per the oracle recommendations.
• Developed shell-Scripts for RMAN, Hot and Cold backups.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring, Alert Log monitoring and backup monitoring.
• Provided on-call support for production-related database problems.

Environment: Oracle 12c, 11g R2 RAC, SQL Server, Solaris, HP-UX,AIX, Red Hat Enterprise Linux 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, Spotlight, PL/SQL, Shell scripting..

Confidential, Seattle, WA

Sr. Oracle Database Administrator

Responsibilities:

• Supported 50+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases.
• 24 X 7 Production Oracle database support, administration and on call rotation.
• Installation and configuration of oracle 10g and 11gR2RACdatabases.
• Upgrading databases from 10g to 11.2.0.3.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
• Responsible for setup and implementation of 2 Node RAC on IBM-AIX in 10g and 11g R2 using Veritas Cluster Server.
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Run stats pack every day to get the statistics of the production databases
• Upgraded OWB repository from 10g to 11.2.0.3.
• Maintained and upgraded databases and software.
• Worked on rolling patch apply throughout the environment with no downtime.
• Monitored system resources and takes action to keep the system at optimal performance using Grid Control.
• Worked on SQL explain plans and query performance, session tracing.
• Application Tuning: Identifying the sql’s causing I/O bottlenecks, sql’s of high cost and giving recommendations to the development teams accordingly.
• Configured Oracle grid control to manage the entire database in single centralized location.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Implemented oracle high availability solution using Oracle Physical & Logical Standby.
• Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance.
• Worked on schemas creation and maintaining large partitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Monitoring space requirement for production databases.
• Database backup & Recovery with export and import for non-archive and archive database with RMAN commands
• Developed Scripts for transferring data from production server to testing/development servers.
• Diagnosed and troubleshooted typical SQL Tuning issues using SQLTXPLAIN.SQL
• Shell scripting and PL/SQL programming to resolve business problems of various nature.
• Developed and maintained the applications by utilizing ASP.NET.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 10g/Oracle 11g/RAC, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard.

Confidential, NC

Sr. Oracle DBA

Responsibilities:

• Involved in installation, configuration and support of Oracle 11g RAC.
• Involved in 24x7 Oracle Production Database Administration.
• 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.
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• 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.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Creating Tables, indexes, & triggers to assist developers.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Was involved in developing a disaster recovery (DR) plan.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2 using Veritas Cluster Serve
• Configured and maintained Oracle Clusterware.
• Used to Perform Cold/Hot Backups.
• Used to perform back up and recovery using Veritas NetBackupintegrated intoRMAN.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Daily Health Check Up of the Database using AWR, ADDM.
• Implemented Data Guard on production database.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Taking periodic backup of the database and the software.
• Automation of Backups.
• Interfacing with Oracle Corporation for technical support.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

Environment: Oracle 9i,10.2.0.2,11.1.0.7,Maestro 7.0,HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3,WebSphere,Solaris5.9,Informatica Power center 8.1x and 8.6.

Confidential

Oracle DBA

Responsibilities:

• Proactive database monitoring using automated scripts based on v$views.
• Developer Environments setup using database cloning
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Volume management using Verities Volume manager to configure Disk group.
• Implementation of RAC, ASM, DATAPUMP,FLASH BACK Recovery
• Monitoring Standby Database whether all the logs transferred to Standby site and applied properly.
• Checking the Alert Logs of production Databases for any errors reported by Oracle.
• 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
• Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database)
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Functionality testing has been performed against the identified modules.

Environment: Oracle 10g/9i/8i, Redhat Linux 4.x., WebSphere, data Stage, Remedy, clear quest, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts, Maestro,ERWin4.0, Informatica Power Center, SQL Navigator, TOAD.

Confidential

Oracle DBA

Responsibilities:

• Improved backup processes resulting in one-minute (downtime) cold backups
• Rebuilt, reorganized and simplified databases, enhancing development, maintenance and performance
• Documented most critical procedures and trained backup staff to run them
• Improved success rate of deployed tasks per test failure by more than 150% as part of development team
• Drastically reduced unscheduled downtime and improved performance
• Gathering of cost-based optimizer (CBO) statistics for tables with stale statistics
• Perform physical database design, database space needs and growth analysis, and future disk need analysis.
• Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions tracing.
• Altering the Database objects and files during maintenance.
• Implementation of RAC Technology.
• Database Maintenance, Data warehousing. Data Modeling using Erwin.
• Database (SQL) design, E-R Modeling, Design and Development Of database design.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.
• Implement backup and recovery strategies for archiving and non-archiving databases.
• Participate in planning and implementation of off-site Disaster Recovery planning and testing. Monitor databases for performance and tune accordingly.
• Coding PL/SQL & Shell Scripts, Design/Code reviews.
• Writing Stored Procedures, functions, packages, triggers.