INTEKHAB Panchbhaiya

 Hand-on of migration Database and Applications, the largest project, where the whole database is migrating from Oracle 11gr2 windows to 12c Release 2 (12.2.0.1.0) on Linux X86-64.
 24x7 Production database and applications support WebLogic, Forms and Reports 11g.
 Installed, configured, and maintained Oracle 10g and 11gR2, 12.2.
 Upgraded databases from 10g to 11g also upgrade and test the from 11g to 12c, Migrate platform from Windows to Oracle Linux-6.
 Involved with installation and maintenance of ORACLE 10g RAC/11g RAC/12c RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose, (RAC on DR side).
 Restoration and Recovery of databases at the times of occurrence of critical failures.
 Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Hands on as On-Call 24x7 production Database, application/development Database, Apps support.
• Extensive knowledge on database administration for Oracle 10g, 11g, and 12c, with hands-on experience in the very large-scale database environment and mission-critical large OLTP and OLAP systems.
• Involved with installation and maintenance of ORACLE 11g/12c RAC and standby database for High Availability and Disaster Recovery purposes. (RAC on DR side - Active/Passive)
• Experience in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands-on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware Administration, Configuration, and Patching.
• Extensive experience in Data Guard configuration, implementing and maintaining standby databases.
• Experience in Performance Tuning using EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK, AWR, and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) / OEM 12c/13c for database monitoring/performance/diagnostics.
Environment: Oracle 10g/11g/12c RAC, HP-UX, REDHAT LINUX, ASM, OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump

 Installed, configured, and maintained Oracle 10g and 11gR2.
 Upgraded databases from Oracle 10g to 11g.
 Involved with the installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle Data Guard) for High Availability and Disaster Recovery purposes.
 Responsible for installing, upgrading, patching and configuring the Oracle environment.
 Implemented Oracle database backup & recovery solutions using RMAN.
 Extensive uses of Oracle Data Pump Exports/Imports utility for moving data among the servers.
 Responsible for configuring and backing up the database using RMAN, Hot backups, Cold backups, and Logical backups.
 Written scripts for the automation of backups and cloning
 Migrated databases from HP-UX to IBM AIX.
 Written PL/SQL Stored Procedures, Packages, Functions, and Triggers.
 used a Data pump to take the logical backups of databases.

 Installed, configured, and maintained Oracle 10g and 11gR2.
 Upgraded databases from Oracle 10g to 11g.
 Involved with the installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle Data Guard) for High Availability and Disaster Recovery purposes.
 Responsible for installing, upgrading, patching and configuring the Oracle environment.
 Implemented Oracle database backup & recovery solutions using RMAN.
 Extensive uses of Oracle Data Pump Exports/Imports utility for moving data among the servers.
 Responsible for configuring and backing up the database using RMAN, Hot backups, Cold backups, and Logical backups.
 Written scripts for the automation of backups and cloning
 Migrated databases from HP-UX to IBM AIX.
 Written PL/SQL Stored Procedures, Packages, Functions, and Triggers.
 used a Data pump to take the logical backups of databases.

 Maintenance of Oracle Production, Development, Testing, and QA databases.
 Installation and configuration of Oracle 10g, 11g databases.
 End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
 Worked with developers to provide queries and tuning the queries for better performance.
 Issues related to Space Management, Locks, Database Hit Ratios, Backup failures, and On-Call alerts.
 Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Tablespaces.
 Database backup & Recovery.
 Creation of Database using various methods (Manual, DBCA).
 Monitoring Tablespaces and data files, Managing Database Users.
 Assigning Roles, Managing Tablespaces.
 Refreshing the database
 Administration, maintenance and support for production & development databases.
 Upgraded database from 10g to 11g
 Perform database cloning, patching.

 Installation & Configuration of Oracle database/SQL Server and products
 Performing all the SYSADMIN activities.
 Analyzes and writes test standards and procedures
 Creating users and assigning the Responsibilities using the System Administration module of Applications.
 Research and document bug reports following agreed-upon processes immediately upon discovery of a quality problem
 Configured Hot and Cold Backup of database
 Cloning of Database and Application.
 Applied patches on the Oracle Application.
 Managing concurrent managers
 Monitoring, Checking and killing Locks on the database.
 Taking export and import of tables, schemas.
 Checking the backups of Oracle database and mount points at os level.
 Coordinating with Oracle support for troubleshooting major issues.
 Check the space availability on development, test and production server.
 System administration functions like creating users, creating responsibilities and menus.
 Managing Users, Password Security, Roles, Privileges, and Resources

 Developed search queries and strings to filter and sort the data from the centralized server
 Defined sections and sub-sections for the reports
 Created a combination component to combine data extracted from different database servers and in different formats
 Installed search and store functions in the existing applications to save search query keywords and results for future reference
 Provided maintenance and resolved technical errors arising in the application
 Responsible for developing and managing the report of Budget Management Information System of Mudra Advertising Pvt. Ltd.
 Performed manual testing of a web-based application
 Interact with a software developer for bug reviews and participate in meetings
 Working in the development environment with frequently changes requirements and features