Oracle DBA

Munish Kumar Karna

Sr. Consultant (Oracle DBA) Oracle Certified Professional

Email: *********@*****.*********:*********@*****.***

Skype: munish_karna

Mob:+971*********(Dubai).

Experience Summary

Have over 6 years of work experience in IT Industry. Extensive experience in relational database development, administration, implementation, trouble shooting. Comprehensive experience as Oracle DBA proficient in Oracle 8i/9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i/8i on Unix and Windows NT platform. Have good experience in Shell scripting.

Certification Completed

No

Name of Institution

Certificate

Year of Completion

1

Oracle University

OCP DBA 10g/11g/12c.

2014

2

Oracle University

OCE Oracle RAC 11g Release 2 and Grid Infrastructure Administration.

2013

3

Oracle University

OCE Oracle 11g Performance and Tuning.

2013

4

Oracle University

OCS Oracle Golden Gate 11g Certified Implementation Specialist.

2014

5

Oracle University

OCP DBA Oracle E-Business Suite R12 Applications.

2013

Skills Profile:

Database: ORACLE 11g/10g/9i/8i on UNIX and Windows, PostgreSQL on Windows/Linux.

Languages: UNIX shell programming, PL/SQL.

Tools / Utilities: RMAN, TOAD, DB verify, Exp/Imp, expdp/impdp, Server Manager SQL * Loader,

TKPROF, Log Minor, Statpack and Oracle Enterprise Manager Grid control, SQL Developer.

Oracle DBA Experience

●Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment.

●Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole – bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)

●Worked with customer for different RAC related issue : split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on.

●Troubleshoot performance issues for the RAC instances (GC events)

●Backup and Recovery issues related (loss of OCR, Voting Disk) & also issues with corruption of individual disk data blocks, loss of net configuration files. Issues with block change tracking & also flash recovery area.

●Resolved/Diagnose Node Eviction.

●Upgrade of 10g RAC to 11g RAC and 11g RAC to 12c RAC.

●Add or Remove Node from RAC.

●Worked in 24x7 production environment and provided on-call and day-to-day support.

●Migrated Non-ASM Single Instance to ASM RAC Instance.

●Manage RAC environment for Day to Day Database administrator, Performance Tuning.

●Strong trouble shooting, problem solving, analytical and design skills.

●Expertise in Oracle Golden Gate database replication, Expertise in Oracle 12c/11g/10g/9i/8i Data Guard and standby databases and Snapshot Standby.

●Expertise in Oracle Enterprise Manager (OEM), TOAD.

●Experience in Logical and Physical Design of Databases for OLTP and Data Warehouse.

●Expertise in handling Very Large Database (VLDB) and OLTP environment.

●Experience in Migration of 9i to 10g,10g to 11g and 11g to 12c.

●Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning – Tuning Applications, Tuning Memory, Tuning Disk Usage and Tuning OS.

●Experience in Oracle 12c/11g/10g/9i– Installation, Migration and implemented new features.

●Experience in capacity planning, space management, database upgrades/migration

●Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN

●Expertise in installation and configuration of Oracle and large databases on Unix Operating System.

●Database population using SQL*Loader.

●Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using Oracle security features.

Other DBA Experience

●Installation, Configuration, Maintenance, Cloning, Patching for Oracle EBS 11i/R12.

●Deployment of Oracle RAC 11.2.0.3 on EBS R12.

●Installation, Configuration, Designing, implementing backup policy, Tuning,DR Configuration and Maintaining for MS-SQL SERVER 2000 /2005/2008/2012.

●Installation, Configuration, Designing, implementing backup policy, Tuning, DR Configuration and Maintaining for PostgreSQL 8.x, 9.x, pgpool and PostgresXC.

●Installation, Configuration, Designing, implementing backup policy, Tuning for MySQL Database.

Professional Experience

●Company: UNDP Nepal. Apr-2011 – Till Date

Role & Responsibility : Sr. Database Administrator

Designation : Regional IT Officer.

Client : Election Commission, Nepal.

Project : Electoral Support Project.

●As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases at ECN.

● Migration from Oracle 10g/11g to 12c in Test Environment.

● Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes..

● Installation Oracle on Windows/Linux Platform.

● Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via bash shell scripting.

● Mentor other DBAs in effective use of RMAN software, and my scripts.

●Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals..

●Implemented High availability using Golden Gate Replication for Database Migration.

●Efficiently writing Function, procedure, package and trigger in Oracle.

● Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.

● Experience with ‘graceful’ switchover and switchback between primary and standby databases.

● Replicated to a disaster recovery site for increased server manageability and availability.

● Create and maintain materialized views.

● Implementing and maintaining database security (create and maintain users, roles and assign privileges)

● Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

● Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible.

● Reorganized tables and indexes within databases when needed.

● Monitored the production Oracle alert logs for database errors.

● Monitored system resource availability and responded to system memory and data issues.

●Integrated Election Commission's bio-metric data at central sever around 14 million records around 4TB.

● Responsible to manager and maintain 75 Oracle Enterprise Edition and 3800 Oracle XE database.

● Migrate from MySQL to Oracle, PostgreSQL to Oracle, Db2 to Oracle and vice versa using Golden Gate 11g.

●Refreshing Schemas at DR sites with PL/SQL procedures.

● Installed, Configured, maintain and administer PostgreSQL Cluster database using Pgpool.

● Configured DR for PostgreSQL Cluster database using Hot Standby and Ward Standby technology.

●Assisting to IT Team of Election Commission of Nepal by troubleshooting Database related issues.

●Company: UNDP Nepal. Aug-2010 – Dec-2010.

Role & Responsibility : Oracle DBA Consultant.

Designation : Regional IT Consultant.

Client : Election Commission, Nepal.

Project : Electoral Support Project.

●Installation and Configuration of Oracle 10g XE/Oracle 10g PE and Oracle 10g EE..

● Managing around 1000 Oracle XE database.

●Refreshing Schemas at DR sites with PL/SQL procedures.

●Making backup policy and scripts as per company need for Oracle Databases.

●Configured DR for Oracle Database using Data Guard.

●Tuning Oracle Databases.

●Testing DR Site (Warm Standby in Postgres Plus Standard Server 4.).

●Testing and reporting backup policy in PPAS and PPSS.

●Company: Progressive Infotech Pvt. Ltd, Noida, India. July-2008 - 20 Jan-2009.

Role & Responsibility : Oracle Core DBA/Oracle Apps DBA.

Designation : Database Administrator.

Client : Emaar MGF, Gurgaon.

Project : ERP & Technical Support System.

●Maintenance and support of installed Oracle Applications Release 11.5.10.2 on IBM AIX Systems and Troubleshooting. Managing around 1000 Oracle XE database.

●Sysadmin, Installation and configuration of printers.

●Database administration of production and test instances.

●Weekly Cloning activities using Rapid clone & applying Patches on demand.

●System administration functions like creating users, creating responsibilities and menus.

●Purging the concurrent managers requests and running Gather Schemas Statistics for all implemented Apps Modules in the company, Space management, Analyzing tables and schemas.

●Managing profiles as per the requirements.

●Database administration of production and test instances.

●Daily Tape backup (hot backup), weekly cold backup.

●Implemented Physical standby & Data Guard between two Production databases.

●Coordinating with Oracle support for troubleshooting major issues.

●Worked on TAR for troubleshooting major issues with oracle support.

EDUCATION

Title of the Degree

College/University

Year of Passing

Master of Science in Information Technology.

Sikkim Maniple University, India.

2007.

Contact this candidate