Oracle Data
Resume:
Obj***
Kul Bhushan
Ph 630-***-****
kul.ru
*******@*****.***
SUMMARY:
Total 7+ years of experience in IT Industry as an Oracle Administration in p lanning, installation,
configuration and upgrades of Oracle 11g and 10g databases including applying patches under Linux,
HP Unix, IBM AIX, Sun Solaris platforms. Experience includes managing Oracle 10g and 11gR1,
11gR2 environments using the Control tools. Experience includes using Data guard to support data
High availability in the Oracle database environment. Experience includes Oracle Utilities Data
Guard, Data Pump and RMAN, SQL, DBCA, DBUA, DGMGRL, NETCA.
Good experience of setup & configuration, implementation of Oracle 11g, 10g on Linux IBM
•
AIX
Proficient in Oracle Database Administration activities such as Upgrades, Patches, Migration
•
support.
Cloning, Backup and Recovery, Performance Tuning, capacity planning.
•
Migrating and Upgrading the Databases between different environments and versions.
•
Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert
•
experience in Hot and Cold Backup of databases. Good knowledge in creating RMAN Duplicate
Databases and recovery concepts.
Design, document, implement, and maintain all backup, recovery including disaster recovery.
•
Procedures using RMAN, Flash Backup. Worked with EXP/IMP, EXPDP/IMPDP to refresh
•
the schemas and to restore the Development, Test databases.
Strong Exposure on High Availability Concepts of Standby, Database Cloning, Database
•
Migration, Patching
Good experience in applying Critical Patch Update (CPU Patches) on Databases.
•
Obj100
Recommend changes to increase efficiency, minimize operating expense or improve accuracy and
•
timeliness of application systems.
Proactive monitoring, identifying areas that need to be improved in the application and database
•
using EXPLAIN PLAN, SQL TRACE, AWR, ADDM, and 10g,11g memory utilization
Monitoring.
Experienced in setting up/installation and configuration of release 11g & 10g.
•
Automated many common tasks using Crontab including: Backups, exports and imports, archiving
•
old records and verification of such processes.
Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory
•
Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Networking,
Troubleshooting.
Good experience in applying interim level & (CPU Patches) on Databases.
•
Performance Tuning for Optimized results using Explain Plan, SOL Trace, AWR, ADDM
•
reports.
Proven ability of providing production support for 24X7 on multiple databases.
•
TECHNICAL SKILLS:
Operating System UNIX, LINUX, Solaris, AIX, HP UX and XP,
RDBMS ORACLE 11g/10g, SQL Server 2008
Oracle Tools/Utilities RMAN, EXP/IMP, EXPDP/IMPDP, DBVERIFY, AWR, ADDM, OEM.DBCA,
DBUA, DGMGRL,
Languages SQL, PL/SQL/C
EDUCATION: Master of Computer Application (Pune University, India)
CERTIFICATIONS:
• Oracle Fundamental SQL certified
• Oracle Certified Associate
• Hadoop & Bigdata on job training Certification
Obj100
WORK EXPERIENCE:
Client: Orbees Inc., CA
Oracle DBA
July 2014 Present
Responsibilities:
• Installed, configured & maintained Oracle 10g and 11g on Linux and AIX platform.
Upgraded database from Oracle 10.2.0.3 to Oracle 11.2.0.4
•
Performed space management, capacity planning and overall maintenance of the databases.
•
Performed Disaster Recovery as well as DR drill for avoid future failure.
•
Refresh/Cloning of Database and applications for development and testing purpose.
•
Involved in backup and recovery using RMAN.
•
Restored RMAN backup from tape device as well as Disk.
•
Performed Logical backup using Datapump (Import/Export).
•
Performed migration of the oracle database using Expdp/Impdp.
•
Implementing Physical Standby setups Data guard Configurations.
•
Familiar with Active Data guard feature.
•
Implemented Oracle Patches using Opatch Utility.
•
Data refreshes from Production to Non Production environment, Creation Duplicate Databases
•
using RMAN Backups.
Performance Tuning for Optimized results using Explain Plan, SQL Trace, reports and AWR
•
Reports. Provided recommendations using ADDM reports.
Involved in Production Support for Critical Application Databases when needed.
•
Working closely with clients, business analysts, server administrators and application developers to
•
define and resolve I issues.
Obj100
Closely Worked with Oracle support in identifying some long standing issues.
•
Index rebuilding on Monthly basis
•
Deleting expired, obsolete backup set using RMAN
•
Maintaining Archive data on Tape
•
User creation & assigning different roles to users
•
Monitoring regular production activity.
•
Environment: Oracle 10g & 11g, Sun Solaris, HP Unix, Linux, IBM AIX 7.1, DBCA, DBUA, Datapump,
DataGuard, RMAN, DGMGRL, NETCA, NETMGR.
DASZI Systems Inc., CA
Oracle DBA
Jan 2012 – July 2014
Responsibilities:
Implementing Physical Standby setups for Data guard Configurations.
•
Performed Logical backup using Datapump.
•
Involved in installation, configuration and support for Oracle databases.
•
Experience on Monitoring growth of Database Objects.
Monitored database performance using Explain Plan, SQL Trace, and AWR & ADDM Reports.
•
Production Support for Critical production Databases, work closely with Application Team in
•
identifying issues and provide solutions for various issues.
Implemented Oracle Patches on production database using Opatch utility.
•
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.
Recovering Databases when there is any Physical or Logical Corruption.
•
Responsible for purging and archiving the production databases.
•
Setting kernel parameter on Linux.
•
Maintaining Archive data on Tape
•
User creation & assigning different roles to users
•
Index rebuilding on Monthly basis
•
Deleting expired, obsolete backup set using RMAN
•
Experienced Data file Addition, Resize and Data file Movement,
•
Obj100
Analyze table on weekly/monthly basis for better performance.
•
Detected locks and resolving in doubt transactions manually. Tuned oracle SQL statement by
•
tracing.
Tuned database servers by using new 10g & 11g features.
•
Providing support to clients/developers regarding SQL queries, applications errors, database errors
•
Prepared and managed system for Data replication. Loading data into tables using Datapump.
Backup Job using Crontab scheduling base on requirement.
•
Environment: Oracle 10gR2 and 11gR2, Linux 5.5, IBM AIX 6.3, DBCA, DBUA, Datapump,
DataGuard, RMAN, DGMGRL, NETCA, NETMGR.
CBS Corporation, CA
Oracle DBA
Mar 2011 – Dec 2011
Responsibilities:
Performed Installation and configuration of Oracle 11g & 10g database on Linux, AIX Platform.
•
Implementing Physical Standby setups for Data guard Configurations.
•
Involved in installation, configuration and support for Oracle databases.
•
Worked Database Objects of production databases.
•
Implemented Oracle Patches on production database using Opatch utility.
•
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.
•
Recovering Databases when there is any Physical or Logical Corruption.
•
Responsible for purging and archiving the production databases.
•
Setting kernel parameter on Linux.
•
Maintaining Archive data on Tape
•
User creation & assigning different roles to users
•
Index rebuilding on Monthly basis
•
Deleting expired, obsolete backup set using RMAN
•
Experienced Data file Addition, Resize and Data file Movement,
•
Analyze table on weekly/monthly basis for better performance.
•
Detected locks and resolving in doubt transactions manually. Tuned oracle SQL statement by
•
tracing.
Tuned database servers by using new 10g & 11g features.
•
Providing support to clients/developers regarding SQL queries, applications errors, database errors
•
Prepared and managed system for Data replication. Loading data into tables using Datapump.
Scheduling Crontab jobs
•
Closely Worked with Oracle support in identifying some long standing issues.
•
Obj100
Environment: Oracle 11g & 10g, Linux, HP UX, AIX, DBCA, DBUA, Datapump, DataGuard, RMAN,
DGMGRL, NETCA, NETMGR.
Client: Farmers Insurance, India
Jan 2010 – Feb 2011
Oracle DBA
Responsibilities:
Design, Create, and manage all databases Implementation for multiple entities including for OLTP
•
& developer’s processing approvals.
Involved in installation, configuration and support for Oracle databases.
•
Worked Database Objects of production databases.
•
Production Support for Critical production Databases, work closely with Application Team in
•
identifying issues and provide solutions for various issues.
Implemented Oracle Patches on production database using Opatch utility.
•
Checking Databases Backup and Restore validity periodically, and Data refreshes from Production
•
to Non Production environment, Creation Duplicate Databases using RMAN Backups.
Prepared test environments for backup/recovery using RMAN for testing purpose.
•
Recovering Databases when there is any Physical or Logical Corruption.
•
Responsible for purging and archiving the production databases.
•
Maintaining Archive data on Tape
•
User creation & assigning different roles to users
•
Index rebuilding on Monthly basis
•
Generated AWR & ADDM report according to performance issue.
•
Deleting expired, obsolete backup set using RMAN
•
Experienced Data file Addition, Resize and Data file Movement,
•
Analyze table on weekly/monthly basis for better performance.
•
Detected locks and resolving in doubt transactions manually. Tuned oracle SQL statement by
•
tracing.
Tuned database servers by using new 10g & 11g features.
•
Providing support to clients as per requirements.
•
Experience on database Incremental level backups.
•
Closely Worked with Client, Application developers, Server Administrators, System Admin.
•
Environment: Oracle 10g & 11g, IBM AIX, Linux, Sun Solaris, Datapump, DataGuard, RMAN, SQL,
PL/SQL, NETCA, DGMGRL, DBCA, DBUA,
Client: ING Investment Management, India
Obj100
July 2009 – Dec 2009
Oracle DBA
Responsibilities:
Involved in 24x7 Oracle Production Database Administration.
•
Involved in installation, configuration and support of Oracle 11g & 10g databases.
•
Refresh/Cloning of Database and applications for development and testing purpose.
•
Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g.
•
Performance tuning for optimized results using Explain Plan, SQL Trace and by rebuilding Indexes.
•
Experience on Analyze tables, Stat gather on (Table & schema level)s
•
Familiar with memory structures such as SGA & PGA memory configuration.
•
Design, document, implement, and maintain all backup, recovery including disaster recovery
•
procedures.
Implementation of High Availability solutions with Standby Database Data Guard.
•
Created physical standby database (for disaster recovery) from hot backup of primary database.
•
Resolved gaps between primary and standby databases (Gap Resolution).
•
Monitoring to alert log & monitoring on database uptime/downtime status, sizing issues.
•
Creating Tables, indexes, and database objects.
•
Refresh/Cloning of Database and applications for development and testing purpose. .
•
Performing Backup/Recovery of all the Oracle databases using RMAN.
•
Reading Alert Logs and User trace Files and Diagnosing the Problem.
•
Scheduling backup as per need through Crontab.
•
OS level activities like space monitoring of Mount points checking
•
Scripts for Analyzing of Tables and Rebuilding of Indexes.
•
Experienced on HOT & COLD backup of the database.
•
Familiar with Flash Backup or Mount point Backup.
•
Interfacing with Oracle Corporation for technical support.
•
Environment: Oracle 10g & 11g, IBM AIX, Linux, Sun Solaris, Datapump, DataGuard, RMAN, DBCA
Client: Hyundai, India
Aug 2008 – July 2009
Oracle DBA
Responsibilities:
Database creation and SGA, PGA memory configuration.
•
Tuning the Database and various database component
•
Obj100
Recovery Manager (RMAN) Implementation and planning.
•
Database component altered as per recommendation.
•
Jobs Scheduling, Exports/ Imports, Space Management.
•
Hot and Cold Database Backups and recovery, Restoration and Tuning Memory.
•
Managing the network and service changes on the network of the databases.
•
Planning and implementation of Backup and recovery procedures and Maintenance of Database
•
Installed and configured Oracle 10g & 11g.
•
Performed Incremental Backup of databases.
•
Database Objects creation (Table, Index, Views)
•
Storage and space management including table spaces and data files.
•
Monitoring Database for fragmentation and correcting them.
•
Database performance tuning using SQL Trace & Explain Plan.
•
Monitoring and Management of table space growth, extent growth.
•
Analyzing of Tables and Rebuilding of Indexes.
•
Interfacing with Oracle Corporation for technical support.
•
Exported (Table & Schema) Level logical backups for testing.
•
Environment: Oracle 10g & 11g, Linux, Datapump, DataGuard, RMAN, SQL, PL/SQL.
Client: Suzlon Energy, India
Jun 2007 – Aug 2008
Oracle DBA
Responsibilities:
Alert log Monitoring & Memory Utilization Monitoring
•
Obj100
Database Backup & Recovery.
•
Familiar with RMAN parameters and its requirement.
•
Altered the Database objects and files during maintenance.
•
Exports/ Imports, Space Management.
•
Hot and Cold Database Backups and recovery, Restoration and Tuning Memory.
•
Managing the network and service changes on the network of the databases.
•
Monitored Production Databases, added data files, resized segments, and table spaces.
•
Installed and configured Oracle 10g & 11g.
•
Storage and space management including table spaces and data files.
•
Monitoring on users concurrent connections.
•
Database performance tuning using SQL Trace & Explain Plan.
•
Monitoring and Management of table space growth, extent growth.
•
Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
•
Analyzing of Tables and Rebuilding of Indexes.
•
Environment: Oracle 10g & 11g, Linux, Datapump, RMAN, DBCA, NETCA, SQL
Contact this candidate