SUMMARY

• 12 years of IT experience in Oracle Database Administration.
• Worked on various OS platforms like HP - UX, Linux, Sun Solaris and Windows.
• Expertise in Installation, Configuration of Oracle 9i,10g & 11g,12c databases.
• Experience in Configuration of 10g, 11g/12c Data guard and performed Disaster recovery activities.
• Standby Database Rebuild using RMAN (Incremental backup) and complete rebuild using active database.
• Expertise in Cloning of oracle software and database refresh using RMAN Duplicate method.
• Good Experience wif database Backup and Recovery procedures using RMAN.
• Upgraded many oracle databases from oracle 11.2.0.3 to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2,12.1.0.2 to 12.2.0.1.
• Migrated 100+ databases from one data center to other data center using RMAN restore method.
• Applied several Oracle provided SBP, CPU, PSU and one-off Patches.
• Worked as an operational data store (ODS) DBA and successfully upgraded ODS applications from version 8.5 to 9.0.
• Expertise in installation of oracle data integrator (ODI) 12.2.1.3.0 , 12.2.1.2.6 and migrated OWB mappings in to ODI mappings during ODS 9.0 upgrade
• Configured RMAN backups for teh databases and performed restore (complete, incomplete recovery) based on teh business requirements.
• Performed database migration from Linux to HP-UX using Data Pump across different servers.
• Experience in UNIX shell scripting and prepared many shell scripts like database backup status, stats collection and file system threshold scripts etc...
• Developed Data scrambling script using oracle translate function.
• Installing & configuring Oracle cluster ware & Database Software (handling common issues that arise during integration of teh whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of cluster ware).
• Handling Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues wif corruption of individual disk data blocks, loss of OS configuration files.
• Installed 2 node RAC setup on 10g, 11g.
• Add or Remove Node from RAC.
• Having knowledge in teh Oracle Gloden Gate technology
• Experience in manage teh Database user’s and Oracle Security Features.
• Experience in TOAD and space manager wif Live Reorg tool.
• Good exposure towards handling very large databases more than 5 TB.
• Experience in installing and managing Oracle Enterprise Manager Grid Control.
• Extensively used Oracle utilities like Export / Import, Data pump.
• Monitoring and optimizing teh Database Performances through AWR, ADDM.
• Good Experience in Space management using SAP tool BRTOOLS.
• Experience in supporting and managing SQL server databases.
• Capacity planning for all teh Oracle databases and co-ordinate across several teams for maintenance activities.
• Good Experience of Incident Change and Problem management processes in Service Now, ITSM and Maximo.
• Strong interpersonal skills, ability to interact wif people at all levels.
• Supporting 24/7 production environment.
• Experience in leading and managing teams. Handled multiple roles - Onsite Team Lead, Offshore team lead.
• Executed software projects for Electronics, Pharmaceutical and Power sector industry.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix Shell scripting.

Operating systems: HP-UX, LINUX, Sun Solaris, Windows 2000/2003/2007 Server

Tools: RMAN, ASM, OEM, EXP, IMP, ODI, Data Pump (Expdp, Impdp), Sql loaderQuest tools like Toad, Brtools, SQL server management studioSpace manager wif live reorg, Citrix, Autosys, IAadmin.

Database: Oracle 9i, 10g, 11g, 12c, Sql server 2008,2012,2017 DB2.

PROFESSIONAL EXPERIENCE

Confidential

System Engineer (Oracle DBA)

Responsibilities:

• Verify all instances are up & working.
• Installation of Oracle Server Software and related products.
• Apply PSU patches for all USC oracle databases.
• Upgrade databases from 11.2.0.4 to 12.1.0.2 and 12.1.0.2 to 12.2.0.1
• Database refresh from teh production environment to quality, development, test environment using commvault.
• Working on database, security related tickets which are raised by user
• Upgrade ODS applications from version 8.5 to 9.0. installation of oracle data integrator (ODI) 12.2.1.3.0 , 12.2.1.2.6 and migrate OWB mappings in to ODI mappings during ODS 9.0 upgrade
• Database performance optimization by adding indexes and fine tuning.
• Database recovery in case of crash using RMAN.
• Recover single table from rman backup in oracle 12c.
• Restore and clone SQL server databases as per user requirements.
• Configuring Oracle Enterprise Manager (OEM) alerts for all targets and monitor teh databases.
• Migration of databases from one Linux server to other using rman restore method.
• Configure oracle streams for ODS, Banner databases and monitor for streams apply errors.
• Deploy Banner 9 upgrades, patches, mod center updates using ESM.
• Applying banner8 Application upgrades, patches, code promotions.
• Applying ODS code promotions.
• Configure Database backup strategy.
• Monitoring and checking teh Database backup and recovery process.
• Setting up standby and test Database if required.
• Implementing Database security.
• Enabling auditing features wherever required.
• Working on Table space management.

Environment: Oracle 11g release 2,12c release 1,2, LINUX-X86-64, Windows server-2007, Sql server 2005,2008,2012.

Confidential

Onsite Team lead (Oracle DBA)

Responsibilities:

• Working on database related tickets which are raised by user.
• Handling Database activities for almost 125+ instances including SAP and non-SAP databases.
• Database refresh from teh production environment to test environment using RMAN duplicate method.
• Database monitoring and verifying completion of Scheduled jobs.
• Apply SBP patch for all most 90+ SAP oracle Databases and PSU patch for 30+ non SAP oracle databases.
• Troubleshooting database related issues and providing support to development and production support teams.
• Configuring and managing teh data guard for critical production databases.
• Upgrade databases from 11.2.0.3 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2.
• Migration of databases from one datacenter to another datacenter using RMAN restore method.
• Perform SQL query tuning using index creation.
• Repair corrupt databases using table reorg, rebuild, logical exports and imports and block recover from RMAN.
• Restore databases as per user requirement using complete and incomplete recovery.
• Prepare shell scripts to automate various kinds of reports like database backup status, stats collection and file system threshold scripts etc...
• Install Oracle Enterprise Manager (OEM) for database maintenance activities.
• Data scrambling activities for databases which are refreshed from production.
• Configure and build SQL server standby database and monitor log shipping on daily basis.
• Implements security parameters for all of teh Oracle Databases.
• Participating in teh DR exercise for all teh production databases.
• Database Maintenance using BRTOOLS.
• Provide database support for TAS and DB moto project and prepare scripts to automate archive log retention.
• Participate in database Security Auditing using (SOX).
• Capacity Planning and performing teh table reorg for teh 2 TB tables in teh critical production databases.
• Configure Flashback.
• Performance tuning for optimized results using tools like Explain plan, SQL*Trace, TKPROF, AWR, ADDM reports.
• Define database policies as per SAP standard.
• Decommission of teh Oracle databases based on teh business requirement.

Environment: Oracle 11g release 2,12c, HP-UNIX, Linux, Windows server-2007, Sql server 2008.

Confidential

Responsibilities:

• Checking alert logs on daily basis and resolving problems.
• Creating users and granting/revoking privileges to users.
• Configure RMAN backups and create stored scripts for teh databases and performed restore based on teh business requirements.
• Helping teh Development team by performing necessary bounce on non-prod instances.
• Prepare shell scripts to retain archive logs for 48 hrs as part of project work.
• Cloning of oracle software and database.
• Implemented 10.2.0.4 Physical Standby Datagaurd setup.
• Scheduled critical tasks using Cron jobs.
• Installation and maintenance of RAC databases wif Automatic storage management.
• Installed 2 node RAC setup on 11G (11.2.0.4) in Linux.
• Handling Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware.
• Configuring & Implementation of Automatic Storage Management (ASM).
• Monitoring and performing daily incremental backups, weekly backups using RMAN.
• Involved in PeopleSoft application oracle database year end activities like stats collection.
• Reorg tables using space manager wif Live Reorg tool.
• Supported Next linx database monthly activities using expdp and impdp.
• Taking care of all other daily routine DBA tasks like creating users, roles, table spaces alerts.
• Troubleshooting server configuration files such as tnsnames.ora and Listener.ora.
• Detect and resolve database locks.
• Planning and Maintaining Database Backups.
• Monitor teh growth of table spaces and file system regular basis.
• Involved in Application tuning Using EXPLAIN PLAN & TKPROF utility.
• Supporting 24/7 production environment.

Environment: Oracle 10g, 11g release 2, RAC, LINUX, Sun Solaris, Windows server-2003

Oracle DBA

Confidential

Responsibilities:

• Special Technical support given to DVVNL Agra, on Month End Accounting in addition to teh Database Administrator (DBA) activities.
• Providing monthly Data and database related reports to client and Redesign of various reports.
• Installation of Oracle 10g and 9i software on LINUX and WINDOWS environment.
• Performing Installation of oracle 10g and database creation using Database Configuration Assistant.
• Support and maintain Oracle Data Base including development and testing instances.
• Creating teh database, users, data objects and granting privileges.
• Table space Management and Rollback and UNDO Table Space Management.
• Database Sizing by adding or dropping table spaces.
• Maintaining data integrity also managing profiles, resources and password security.
• Password change quarterly for sys and system users as part of database security.
• Extensively Performing Data base backups and recovery using RMAN, Hot/cold backups,
• Restore databases using RMAN backup.
• Performance tuning for optimized results using tools like Explain plan, TKPROF, AWR reports, ASH reports
• Create scripts to load teh data in to tables using SQL Loader
• Proficient in performing Oracle 10g Data Pump Import and export utility.

Environment: Oracle 10g release 2, Oracle 9i, LINUX, Windows server-2003.Team Size: 4