SUMMARY

• Over 8 years of experience in IT Industry as an Oracle Database Administrator on different flavors of Unix (RedHat Linux, HP - UX, Sun Solaris, IBM AIX) environments
• Experience in installing, configuring, administering and managing oracle databases and implementing solutions such as High availability (HA), Disaster & Recovery, Cloning, and Database security
• Very good experience as Oracle DBA in production, development and test environments
• Performed migration and upgrade of databases to 10g,11g and 12c
• Having good experience in implementing RAC 10G/11G/12c in different Unix platforms
• Knowledge of RAC 12c and 12c Databases, In-memory and Pluggable databases.
• Expertise and implemented Oracle ASM ( Automated Storage Management Grid Infrastructure )
• Installed and configured Oracle 10g/ 11g/ 12c grid control and maintained in large environments
• Implemented and configured replication technology using Data guard and Oracle Golden Gate installation, configuration and troubleshooting on Linux and Unix Platforms
• Migrated oracle databases with minimal downtime from 10g/ 11g AIX and Solaris to Linux
• Construction of Catalog Databases and developed scripts to perform Backups of Large Databases to fit teh backup window using RMAN
• Implemented RMAN backup (Full, incremental and cumulative) and recovery and disaster recovery using Standby database or Data Guard
• Performance tuning of teh database - SQL Tuning, Used Tuning utilities such as Statspack, TKPROF, Explain Plan, AWR, ADDM and Tuning of SGA, Distribution of disk me/O, Sizing of tables and indexes. Identifying bottlenecks with memory and disk contentions
• Have good experience in creating databases and database objects such as table, index, table space, rollback/undo segments and views and analyzed relevant objects to collect statistics to tune system performance
• Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
• Database replication using snapshots, materialized views, import/export and advanced replication methods
• Have noledge on AIX/Linux/ Solaris administration on OS installations
• Experienced in database reorganization regularly for removing row migrations and fragmentation using export and import utilities. Taking care of table space related issues such as increasing teh storage parameter values, resizing teh data files, and adding new data files
• Clear documentation for all teh processes such as program specification, bugs fixing logs and change requests for future reference
• Interacting with teh Oracle support on Service Requests and implementing teh solutions provided for successful completion of teh tasks

TECHNICAL SKILLS

Operating systems: UNIX, LINUX, Solaris, AIX,HP-UX and WINDOWS NT/2000,XP,2003

DBMS Packages: ORACLE 12c/11g/10.x/9.x/8.x/7.x, Informix Dynamic Server 9.40.UC6 (IDS) and SQL Server 2008/2005.

Oracle Tools: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACK, AWR, ADDM, OEM, ODM, ERWIN

Backup Tools: VERITAS Netback up 5.3/6.0, BCV Snapshots, Legato

Version Control Tool: MKS, PVCS

Languages: C, C++, Core Java, J2EE, VisualForce, HTML, CSS, Javascript, SQL/PLSQL

Web Servers: Oracle Application Server, WebLogic, IBM WAS 6.0/7.0, JBoss, Tomcat 4.0/5.0

Other tools: Microsoft CRM3.0 / 4.0, Winscp, Putty, CoreFTP

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr. Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases 11g Release 1(11.1,11.2) & 11gR2 upgrades on all teh environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like building parallel environments and also working on proof of concept for Oracle 12c upgrades.
• Implementing Physical and Logical Standby setups Data guard Configurations.
• Installation, configuration and support of Oracle 11g & 12c RAC.
• Worked on using teh Materialized views for large Data Replication between 2 production databases.
• Production Support for Critical Application Databases, work closely with Application Team in identifying issues and provide solutions for various issues, incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4).Used IBM MangeNow.
• Implemented Oracle Patches (CPU, PSU) on teh Compliance databases Device a plan to patch them quarterly so dat we can cover all teh 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.
• Implemented backup policy using oracle RMAN. Prepared test environments for backup/recovery using RMAN. And NETBACKUP TAPE backup management.
• Upgrade and character set conversion of RAC databases with teh aid of Oracle Golden Gate utility.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab (UNIX), Scheduled Tasks (Windows) and Maestro 7.0 (Job Scheduling Tool).
• Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
• 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.
• Involved with enterprise-wide database security implementation and enforced many checks and balances to improve auditing, security and password protection. Also did Capacity Planning.
• Responsible for purging and archiving teh production databases.
• Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.
• Providing support to clients/developers regarding SQL queries, applications errors, database errors Prepared and managed system for Data replication. Loading flat file data into tables using SQL Loader.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed teh trace files Using TKPROF utility.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues—halping to transform business requirements into environment specific databases
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Contacting Application Team and clients to gather teh information for migration. Reviewed architecture.

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, WebSphere,Solaris5.9,TOAD,SQL Developer.

Confidential, NY

Sr. Oracle DBA

Responsibilities:

• Installing Oracle DB 10g, 11g RDBMS, RAC on ASM, applying Oracle critical patch updates, implementing and managing Data Guard, Replication, Backup and Recovery support and performance tuning
• Installing Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control 11g Installation
• Experienced in installing OEM agent and hooking up to teh grid
• Working on OEM 12C grid for monitoring teh Listeners present in teh oracle environment
• Troubleshooting RAC and implemented ASM features
• Applying necessary patches during installation and also in upgrade of databases
• Extensively working in setting up Oracle physical standby database using Data guard
• Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases
• Handy in utilizing data pump tool for exporting and importing teh data between databases
• Participating and upgrading databases from 10g to 11g
• Installing and configuring of Golden Gate on 11g database for teh replication
• Resolving teh issues in conflicts between teh target and source database in golden gate
• Implementing Bi-Directional replication in golden gate
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to teh Query
• Supporting development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan
• Well experienced in taking Cold, Hot & Logical RMAN backup for very huge Databases
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and performing database refresh activities for business requirement and tuning purposes
• Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import
• Having good exposure in user management, Table space Management, Session Management, undo Management issues
• Experienced in managing space issues in teh Database Level for table space and Regular file system cleanup at UNIX level
• Experience with peregrine ticketing tools for resolving teh tickets

Environment: Linux, Solaris 10, HP-Unix, Oracle 9i/ 10g/ 11g, OEM, SQL*Plus, XMing, Putty, ASM, Data Guard, TSM, Golden Gate

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Involved in 24x7 Oracle Production Database Administration.
• Involved in installation, configuration and support of Oracle 11g RAC.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrade/Migration of teh 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 teh 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.
• Write monitoring/health check scripts to alert team of database uptime/downtime status and sizing issues.
• 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.
• Experience with Oracle Golden Gate software.
• Proficiency using Oracle Golden Gate and csscan utility.
• Knowledge of teh Oracle Golden Gate installation, configuration, troubleshooting GG issues
• Performing Backup/Recovery of all teh Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Reading Alert Logs and User trace Files and Diagnosing teh Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to teh 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 teh database and teh software.
• Automation of Backups.
• Interfacing with Oracle Corporation for technical support.

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, Boston, MA

Oracle DBA

Responsibilities:

• Provided 24*7 support and On-Call rotation when needed for very large databases
• Installed Oracle 11g on Linux and Worked on RAC 10g and worked on ASM feature
• Estimated teh size of teh database and its objects (in large database of 1 to 2 Terabyte)
• Installation and configuration of Oracle 11g RAC 2 node on Linux
• Applied CPU security patches in both RAC and standalone systems in ASM environment
• Experience with Oracle 10g/11g grid control
• Responsible for maintaining Oracle 11g/10g standby databases in Solaris and Linux
• Performed upgrade from 10g to 11g and applied patches when required
• Configured 11g new feature Active Data guard on 11g and maintained standby databases
• For teh improvement of database performance implemented database tuning and its requirements and reviewed it
• Participated in Database and Transaction log Backups and Restoration, backup strategies, scheduling teh backups. Backing up system and user databases and restoring them as required and Create Database users and roles and implement appropriate user security
• Experienced with Oracle 10g/ 11g ASM feature
• Migrated Non-ASM databases to ASM environment for high availability on 11g
• Implemented active-active configurations usually require data conflicts to be managed by teh application, suitable for custom applications
• Implemented Oracle Replication through materialized view
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for teh same
• Experience with database partitioning and responsible for daily loads
• Experience with DDL and DML operations and having sound noledge
• Good experience with Oracle performance issues in both application tuning and memory tuning
• Troubleshooting of various database performances by proper diagnosis at all levels such as SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls
• Writing Unix shell scripts to manage Oracle environment and application processes

Environment: RHEL 5, Sun Solaris 9, Oracle 9i/ 10g/ 11g, 10g/ 11g RAC, Toad, 10g Grid, OEM, ASM Oracle Streams, ERwin, Oracle Gateway, SQL*Plus, Shell Scripting