SUMMARY:

• A competent professional with 9 years of experience in Oracle Core DBA
• Excellent working skills with installation, Cloning, Patching, Upgrade, Migration.
• Excellent working skills on RAC and ASM database.
• Excellent in building Standby database and Data Guard Broker.
• Excellent experience on database backup and recovery.
• Implemented and upgraded Oracle 12c Database on Redhat Linux 6.4
• Experienced in supporting and managing multiple Production, Staging, and Development and test instances.
• Professional in Using AD utilities and Performing cloning.
• Establish Database Sizing, Tablespace Management and Rollback Segment.
• Performance Tuning, Memory (SGA) Tuning, Queries etc
• Very good in communicating to the clients and end users from offshore.
• Excellent remote systems support and troubleshooting capabilities.
• Excellent skills in database administration, RMAN backup and recovery activities.
• Experience in OEM (Oracle Enterprise Monitoring)
• Experience in Oracle GoldenGate replication

TECHNICAL SKILLS:

Operating System: Windows XP/2003, Red Hat Linux, Solaris HP Unix.

RDBMS: Oracle 9i.x, 10g.x, 11g.x,12c.x

Languages: SQL, PL/SQL

Other Tools: Toad, X - Manager, VNC, OAM, SQL Loader

Ticketing System: Remedy, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Sr Software Engineer

Responsibilities:

• Installation of Oracle RAC database 10g/11g/12c, ASM and Data Gard configuring and maintenance, Cloning, Patching, Upgrade and Migration
• Have Expertise installation on Oracle Grid installation.
• Building Standby database for Disaster recovery.
• Implemented Oracle data gard broker of larger databases.
• Discovering databases in OEM and enabling monitoring.
• Cloning database using RMAN active duplication
• Configuring Database backup and recovery polices and planning backup strategies.
• Restoring database from backup proxy servers and from Tap backup.
• Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
• Troubleshooting several worker issues while patching.
• Applied RDBMS patches using Opatch on RAC database
• Managing backups of the apps instances & maintaining weekly cold backups of database of dev/test and involved in recovery of database.
• Helping users to resolve DB Connectivity issues.
• Installed Oracle Client 12c/11g installation on client machines.
• Worked with Oracle Corporation & opened TARs (SR’s) to resolve number of bugs.
• Tracking the issues that are raised by users & document them for future timely resolutions
• Given OS level support like locking and unlocking accounts, reset passwords, mount point monitoring, cron jobs monitoring
• Addition, moving data files, init parameters tuning roll back segments issues, snap shot too old issues,
• Remote database connection issue like dblink issue and JDBC connection issue from External JVM hosts.

Confidential

Sr Oracle DBA

Environment: Oracle Database 10g (10.2.0.4/10.2.0.5 ) 11g . 2.0.2/11.2.0.3/11.2.0.4 ), 12c (12.1.0.2)

Responsibilities:

• Installation 12c Grid and RDBMS Oracle Home
• Copy database using RMAN and setup DG.
• Switch database role to New standby database.
• Upgrade Database from 11.2.0.3 to 12c (12.1.0.2)
• Converting database from Single node to 2 node RAC
• Configure Data Gard broker on 12c.
• Configure backup and schedule weekly and daily backup.
• Install 12c ASM Grid and RDBMS code tree
• Copy the data from RAW volumes to ASM using RMAN duplication
• Upgrading the Oracle database from 11.2.0.3 to 12c (12.1.0.2)
• Converting database from Single node to 4 node RAC
• Enable DB data guard Broker configuration.
• Enabling Oracle GoldenGate replication.
• Oracle Database upgrade from 10g to 11g (11.2.0.3).
• Migrating Oracle 11g database from HP-Unix to Redhat Linux ( Confidential UCS box)
• Migrating data using the Transportable tablespace (XXTS ) method.
• Convert single node to 4 node RAC database.
• Building Standby database on different data center.

Chordiant

Oracle Database Administrator

Environment: Oracle Database 9i/10g/11g

Responsibilities:

• Maintenance of Production database environment d as well as DEV, TEST, UAT and Pre-PROD environments.
• Database backup and recovery using RMAN
• Part of the DBA team commissioned to execute the Consolidation Process.
• Patching the disparate Applications Instances to a common level.
• Troubleshoot and resolve various Tickets raised by Developers. Here we are using ITS tool for ticketing system.
• Interact and coordinate with other teams spread across the globe.
• Documentation.
• Cloning of the Instances as and when required.
• Working with Oracle for Sev 1 Tar.
• Managing Production and Development Instance in oracle Application.
• Administering and Maintain Sys Admin Module.
• Establish Database Sizing, Tablespace Management and undo Segment
• Responsible for all the activities related to development, implementation, maintenance and administration and backups, Performance of Oracle.
• Involved in Database Upgrading Oracle 8.1.7.4.0 to 9.2.0.6.0 and 9i to 10gR2.
• Planning for DB changes through CR creation and coordinate with application Team.
• Applying CPU patches
• Member in Standard Team to create Standards and implement the same.
• Upgradation of database from 9.2.0.1 to 10.2.0.4
• Interaction with Oracle Support Services to resolve issues
• Perform Installation and up-gradation of Oracle on Sun Servers and apply patches on server side.
• Setup new environments for Development, Production etc.
• Setup and Installed Oracle Enterprise Manager and Enterprise Backup Utility.
• Establish Database Sizing, Tablespace Management and Rollback Segment
• Perform Tuning, Memory (SGA) Tuning, Queries etc
• Deciding the backup and Disaster Recovery Criteria
• Install Physical Standby for production instances
• Involved in Loading Data using SQL Loader/Parallel loads
• Create locally managed tablespace to avoid fragmentation.
• Core DBA tasks like user management, space management.
• Cloning of applications database from development instance to UAT Instance.
• Instance management
• Responsibilities included:
• Perform installation and configuration of Oracle 9i and Oracle 10g on Sun Enterprise Servers.
• Design database in accordance to the Optimal Flexible Architecture (OFA).
• Create procedures for Media Recovery.
• Establish database security by enrolling users, creating profiles for optimal use of resources, and maintaining system security via roles and privileges.
• Use Explain Plan, TKPROF, and SQL Trace to tune database applications.
• Create and maintain the standby database to minimize damages caused by the downtime of the production database.
• Write backup scripts, and implement effective and efficient strategies for backup and recovery.