SUMMARY

• Oracle certified associate with over 9 years of experience in Database Administration tasks like installation, configuration, monitoring, performance tuning and maintaining Oracle 9i/10g/11gR1/11gR2/12cR1/12cR2 databases on different platforms Sun Solaris, RHEL and Windows
• Over 5 years of experience in administering Oracle E - business Suite R12.1.3 which includes installation, cloning, patching and performance tuning.
• Expertise in supporting Production (24X7), Staging, testing and Development environment databases
• Expertise in designing and implementing backup and recovery strategies using archived logs, RMAN with VERITAS Netbackup.
• Proficient in cloning databases and lower environments through rman duplicate, SAN disk snapshots, Original rman restore or datapump
• Hands on Experience in restoring 30TB databases directly from tapes.
• Proficient in troubleshooting performance issues and performance tuning databases using tools like OEM, ADDM, Explain Plan and TKPROF
• Experience in Migration from 9i to 10g, from 10g to 11g, 11gR1 to 11gR2, 11g to 12c in VCS and RAC environments through Datapump and RMAN transportable tablespaces.
• Experience in installing, configuring, managing Oracle 10g and 11gR1,R2 RAC with ASM and SAN storage systems
• Experience in Logical backup using full/partial export/import and Data Pump and worked with sqldeveloper in migrating from sql-oracle
• Experience in Transportable Tablespace, Data Guard, and Oracle Streams Replication
• Successfully Installed and actively setup goldengate 12.2 replication to Apache Kafka
• Expertise in routine DBA functions like space management, Rollback segments, Undo segments and Invalid objects.
• Proficient in creation and maintaining of schema objects like tables and indexes, triggers, procedure, function, synonyms and sequence.
• Experience in disaster recovery planning and implementation procedures. Detailed out the processes and procedures of implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN.
• Strong knowledge of Oracle Internals and Optimizer.
• Experience with SQL, PL/SQL and UNIX Shell scripting.
• Good knowledge on Unix shell scripting and involved in debugging existing scripts
• Proficient with Sqldeveloper, OEM 10/11/12c Grid control.
• Experience in interacting with Oracle support to resolve issues
• Supported various production deployments and provided 24/7 support for the various databases
• Excellent communication skills in explaining technical issues to management and self-motivated team player.

TECHNICAL SKILLS

Database: ORACLE 12.1/12.2/11 g(R1 and R2) 10g, 9i, 8i and Oracle E-buisness suite R12.1.3

Oracle Technologies: RMAN, Export/Import, OEM, Data Guard, Oracle Clusterware, Data Pump, SQL*Loader, Statspack, Opatch, RAC, VMWare, Replication, Streams, Grid control

Tools: & Utilities: SQL *Plus, TOAD, Putty, MS Visio, Rational Rose98, VERITAS Net Backup, SAN, Winscp, Humming Bird (Exceed), VNC, ERWIN, XMing,CYGWIN,Qualyss,Perforce

Operating System: Red Hat Enterprise Linux, Sun Solaris, Microsoft Windows

Programming Languages: C, Java, SQL, PL/SQL, Unix Shell Scripts, HTML

PROFESSIONAL EXPERIENCE

Technology Lead

Confidential

Responsibilities:

• Working as an Techonology lead for database management team across Raleigh and Offshore.
• A subject Matter Expert in all oracle 9i/10g/11gR1/11gR2/12.1/12.2 databases on RHEL 7 and AIX platforms
• Active Key member in all the application-cloud-Database workshops determining the Oracle support pricing, ULA and other aspects in terms of oracle supporting the migration to cloud
• Key member involved in determining the strategic decisions of databases
• Implemented intensive Oracle clusterware upgrade and database upgrade from 11g to 12c, 10g to 12c and 12.1 to 12.2
• Actively installed golden gate replication from oracle database to Apache Kafka
• Migrated the 2 TB database across servers using rman duplicate from TSM
• Migrated OEM 12c to OEM 13c and completely setup OEM 13c metrics, templates and metric extensions
• Extensively worked on re-active and pro-active performance troubleshooting and enhancements
• Did Setup Proactive monitoring of the database and OS (CPU and other OS metrics) through unix shell scripts for huge database servers
• Expert in installing/upgrading and patching Oracle Clusterware 11g/12c for High availability
• Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
• Optimization and tuning SQL queries by checking statistics, history plans, SQL tuning advisor, forcing hints.
• Active member in updating Knowledge base documents for the team.

Softwares: ORACLE 12.2/12.1/11 gR1/R2/10g/9i, RHEL5/6/7,AIX, OEM 13c/12c, ASM,Disk Snapshot, TSM,Goldengate

Lead Oracle Database administrator

Confidential

Responsibilities:

• Working as an Oracle Lead DBA for 9i/10g/11gR1/11gR2/12c databases on RHEL5.6 and Solaris and Supporting Oracle E-Business Suite applications R12.1.3
• Implemented intensive Oracle clusterware upgrade and database upgrade from 11g to 12c
• Performed a cross-platform migration of the databases from 11g to 12c through RMAN in both EBS and non-EBS environments
• Performed infrastructure upgrades as like PSUs, one-patches and CPU’s for both oracle E-business applications and oracle databases every quarter
• Scheduled EBS and Non-EBS Database refreshes of lower environments daily through datapump and RMAN
• Expert in implementing various database cloning techniques using RMAN duplicate
• Did Setup Proactive monitoring of the database and OS (CPU and other OS metrics) through unix shell scripts for huge database servers
• Efficient in using Oracle Enterprise manager 12c and 11g both for administration and performance monitoring
• Maintained and expanded ACFS filesystem whenever needed
• Responsible for Oracle Grid Control setup, upgrades, troubleshooting and administration.
• Upgraded Oracle enterpriser manager from 12c to 13c and redeployed all the agents
• Expert in installing/upgrading and patching Oracle Clusterware 11g/12c for High availability
• Worked on setting up and maintaining Oracle dataguard in maximum performance mode and implemented DR drill twice a year.
• Worked with client, application team and team members to understand the requirements in designing a new application
• Participated in project gatherings, review meetings for new & enhancement projects
• Performed the activities like space management, user and roles administration, schema management, performance tuning and back up procedures on all the databases.
• Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
• Optimization and tuning SQL queries by checking statistics, history plans, SQL tuning advisor, forcing hints.
• Made recommendations and enforced standards during project review meetings.

Softwares: ORACLE 12c/11gR1/R2/10g/9i, RHEL4/5, OEM 12c, ASM,ACFS, Oracle r12 EBS

Lead Oracle Database Administrator

Confidential

Responsibilities:

• Worked as an Oracle L3 DBA for 10g/11gR1/11gR2 RAC and NON RAC on RHEL5.6 and Solaris in financials and fast based environment
• Lead on supporting 24 *7 36TB of RAC data warehouse applications
• Worked with Off-shore team at various shifts to manage mission critical databases and lead the production support team of 8 members.
• Expert in dealing and fixing performance issues by reviewing with stats, indexing, bad plans and many more
• Prioritized and Automated daily datapump refreshes with Unix shell scripts
• Designed and implemented the restore of 26TB of RAC database from tape as per company’s regulatory requirement
• Hands on experience in implementing BCV for Database backups
• Expert in implementing various database cloning techniques using RMAN duplicate, storage based replication and many more
• Setup Proactive monitoring for CPU and other OS metrics by writing unix shell scripts for huge database servers
• Efficient in setting up and monitoring Oracle streams and dataguard for replication
• Efficient in using Oracle Enterprise manager both for administration and performance monitoring
• Worked in upgrading the databases from 10g - 11g using RMAN transportable tablespace
• Performed infrastructure upgrades as like PSUs, one-patches and CPU’s.
• Participated in project gatherings, review meetings for new & enhancement projects
• Performed the activities like space management, user and roles administration, schema management, performance tuning and back up procedures on all the databases.
• Worked with environments using VERITAS Cluster Server (VCS) high availability.
• Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
• Optimization and tuning SQL queries by checking statistics, history plans, SQL tuning advisor, forcing hints.
• Active member in updating I2ms and edom (Database inventory)
• Provided Oracle database knowledge transfer to the Manager of Application Development and the team continually.

Softwares: ORACLE 11gR1/R2/10g/9i, RHEL4/5, RAC, SAN, VERITAS Cluster Server, OEM, ASM,BCV

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Working as an Oracle DBA for 9i/10g/11gR1/11gR2 on RHEL5.6 and solaris
• Worked in upgrading the databases from 11gR1 to 11g R2 in VCS clusters
• Worked in upgrading the databases from 10g-11g R1 and R2 on RAC
• Participated in project gatherings, review meetings for new & enhancement projects
• Worked in setting up HugePages on the servers
• Performed the activities like space management, user and roles administration, schema management, performance tuning and back up procedures on all the databases.
• Performed various database migrations from solaris to linux in RAC and non-RAC environments and also involved in SQL - oracle migrations
• Worked with the Recovery Manager RMAN and Used Oracle Enterprise Manager OEM for continuously monitoring the database.
• Worked on 11.1 and 11.2 ASM and clusterware installations on brand new servers
• Built Dataguard for RAC and non-RAC databases through DataGuard Broker and performed Switchovers frequently
• Been an Active member in troubleshooting RAC Node Evictions
• Built various databases on oracle 11gR2,11gR1,10g version in VCS and RAC environments
• Worked with environments using VERITAS Cluster Server (VCS) high availability.
• Involved in debugging the existing scripts and have good knowledge in Unix shell scripting
• Refreshing of database from Production to Testing and Development environments.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN and monitored the databases through IGNITE tool.
• Active member in updating SITS(Database inventory) and updating the documents for the team

Softwares: ORACLE 11gR1/R2/10g/9i, RHEL4/5, RAC, SAN, VERITAS Cluster Server, OEM, ASM,IGNITEDatabase Administrator