SUMMARY

• 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 10g, 11g and 12c with experience within large scale database environment and mission critical large OLTP and OLAP systems on HP - UX, Sun Solaris, IBM AIX, Windows and Linux Environment.
• Expertise in migrating the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• Expertise in upgrading Oracle databases from 10G R1 to Oracle 10G R2, Oracle 11G R1 to Oracle 11G R2 for standalone databases and also RAC databases including production with standby configuration.
• Good working experience with 12c Container databases or Pluggable Databases (PDBs).
• 24*7 production database support with Support to developers & end-users.
• Installed Oracle ASM & 10g RAC software with ASM File systems.
• Experienced in Installation of high availability RAC environment (2, 3 node clusters) and upgraded standalone databases to 10g RAC environment.
• Migrated Non-ASM database to ASM database.
• Experience with High Availability features (RAC / DG/ ASM / RMAN ).
• Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experience in complete recovery, incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Good exposure to oracle technologies like AWR, ASM, Flashback, Transportable tablespace and data pump import/export.
• Experience in implementing Golden Gate 11g (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using RMAN utility, activating and Re-building physical Standby Databases using SCN based backup and recovery.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Having hands on experience in installing and configuration of Enterprise Manager Cloud Control 12c.
• Having knowledge on ORACLE EXADATA for the extreme performance of the database.
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, tuning heavy data loads, Monitoring and Performance tuning.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having good knowledge on stored procedures, functions, triggers and scheduled jobs.Worked closely with application teams for the production installs and also work on the regular maintenances for database upgrades/migrates, security patches and OS related patches.
• Supported the applications as Primary DBA and also Secondary DBA.
• Database replication using snapshots, materialized views and advanced methods.
• Experience in applying Quarterly security patches (Both CPU and PSU patches) to the databases for fixing the bugs.
• Good experience in Data Migration using data pump export/import.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Supporting DR testing using switchover/Switchback, also with Flashback technology.
• Good interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i

Oracle Products: Golden gate, Oracle (Grid Control), OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, DATA PUMP, ASM, RAC.

Programming Languages: SQL, PL/SQL, C, C++

Operating systems: OEL, RHEL, AIX, Solaris.

Other Tools: TOAD, Putty

PROFESSIONAL EXPERIENCE

Confidential, Texas

Production Support Engineer

Responsibilities:

• Worked on Oracle databases 11g.
• Perform Oracle DBA daily tasks like checking space availability, alert log errors, backup status, database availability.
• Created users and assigned/modified the privileges for users as per the requirement.
• Performed User level Datapump exports as a backup of schemas.
• Worked on switchover database to the physical standby database as part of DR testing.
• Cloned database using duplicate from active database in 11g.
• Applied one-off patches to oracle databases 11g to fix bugs.
• Performed Golden gate replication for unidirectional on oracle database 11g.
• Configured Goldengate processes Extract/datapump/Replicat for the golden gate replication.
• Used Oracle Enterprise Manager Cloud Control 12c to monitor the databases and performance.
• Performed RMAN full/incremental backups for database recovery from failures.
• Worked on tickets for user maintenance and any error messages.
• Managed schema objects, such as tables, indexes, and views.

Environment: Oracle Database Version 11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 12c, Autosys, Opatch, Shell Scripting, Goldengate.

Confidential, Ohio

Oracle Database Administrator

Responsibilities:

• Worked on Oracle 10g/11g databases on HP-UX platform.
• Resolved the block corruptions in 11gR2UAT/TEST databases by skipping the corrupt blocks.
• Performed NLS migration (to AL32UTF8 ) to be consistent with NLS setting to sync with prod systems.
• Resolved the datapump import and export issues for the 11gR2 databases with data issues while importing to get the correct data as requested.
• Installed 11gR2 Grid Infrastructure before the database upgrades.
• Performed ASM upgrades from 11.1.0.7 to 11.2.0.4 for database upgrades.
• Performed Database upgrades from 11.1.0.7 to 11.2.0.4 on both RAC and single instance databases.
• Resolved the RMAN backup scripts for timeout of shutdown database backup.
• Monitored the databases and space availability in the databases.
• Performed activities for the developer requests which need DBA tasks.
• Worked with Oracle support to resolve the database issues like invalid components after database upgrades.
• Worked on clearing the stateless alerts in the Oracle Enterprise Manager Console summary by running command on emcli.
• Worked on datapump export and import as part of developers request to refresh schema.
• Applied the PSU patches to 11g R2 Grid Infrastructure and databases instances to fix the bugs. Also updated the opatch versions as a pre-requirement for patch applications.
• Used Oracle Enterprise Manager Cloud Control 12c for monitoring the databases. Also checked for space issues specially for archivelog destination.
• Moved the SPfile from non ASM to ASM disks for facilitating RMAN autobackups.
• Worked on Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.
• Removed the ASM old disks and added new disks to the ASM disk groups as part of maintenance work.
• Installed golden gate 10g/11g and configured unidirectional replication for testing.
• Configured Goldengate processes Extract, Datapump and Replicate for Goldengate replication.
• Worked on post upgrade issues of having invalid components to validate the components.
• Used Dataguard Broker to database switchovers in dataguard configurations to check the standby database.
• Worked with 11g new features such as ADRCI, Duplicate from Active database, ASMCMD, etc.
• Used ADCRI to view the alert log file and trace files.
• Performed RMAN backups whenever required before starting upgrade of databases.
• Cloned the databases for testing the RMAN backups periodically. Created active dataguard configuration for utilizing the resources by read only access of physical database.
• Worked with the team to perform DBA tasks as per the tickets requests raised.
• Scheduled full and incremental RMAN backups for the databases using Autosys tool.
• Performed user related activities like assigning privileges and profiles to users upon approvals.
• Installed Oracle12c database and created pluggable databases for testing purpose. Users maintenance, upgrade, cloning, patching and backups
• Worked with 12c Container databases or Pluggable Databases (PDBs).
• Upgraded 11g database to 12c using direct method DBUA.

Environment: HP-UX, Oracle Database Version 10g/11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 12c, Autosys, Opatch, Shell Scripting, Goldengate.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle 10g and 11gR2.
• Upgraded databases from Oracle 10g to 11g.
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Responsible for installing, upgrading, patching and configuring the Oracle environment.
• Implemented Oracle database backup & recovery solutions using RMAN .
• Extensively used Oracle Data pump Exports/Imports utility for moving data among the servers.
• Performed SQL tuning Advisor for tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the users.
• Partitioning and re-organization of table and indexes.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written documentation for backups and cloning of database for future reference.
• Migrated databases from HP-UX to IBM AIX platforms.
• Continuously monitored database performance during batch jobs running on the database using AWR report and OEM.
• Used Data pump to take the logical backups of databases.
• Worked on ASM instances for 11g databases.
• Installed and configured 12c software and database.
• Worked on pluggable and container 12c database model.
• Performed other DBA activities including space management and performance monitoring.

Environment: HP-UX, Oracle Database Version 10g/11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager Grid Control 12c, Opatch, Shell Scripting.

Confidential

Oracle DBA/Apps DBA

Responsibilities:

• Installed 11g software and created a database on Redhat Linux for R12 testing.
• Performed Oracle Database upgrades from 10.2.0.2 to 10.2.0.3 in AIX RAC environment.
• Upgraded databases from 10.2.0.2 to 10.2.0.5 and 10.2.0.5 to 11.1.0. 6
• Applied different patches - one-off patches, CPU and PSU patches: 11.2.0.1.1 , 11.2.0.1.2
• Performed pre-upgrade and post-upgrade tasks for upgrade process of databases.
• Performed RMAN/Offline /Online backups and restored the backups to refresh the environment.
• Setup and configured 2 node Oracle 10g RAC with ASM for high availability of database at instance level.
• Used 10g OEM (Oracle Enterprise Manager) to manage and monitor databases for maintenance tasks.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Worked on operating system command line utilities like SAR, TOP, VMSTAT.
• Responsible for setting and managing user accounts, granting required privileges and roles to users.
• Worked on Managing Applications on oracle 11g / 10g RAC databases using ASM file system with server control utility (SRVCTL) and CRSCTL for high availability.
• Configuring DB Links for users located remotely to access data locally using database link.
• Management of schemas, objects, the tables & indexes.
• Created partitions to improve the query performance and manageability.
• REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
• Planned and implemented high availability solutions using Oracle 10g RAC, Standby Database using Oracle Data Guard
• Applied CPU security patches and PSU in both RAC and standalone systems in ASM environment.
• SQL Query performance tuning for optimized results using tools like Explain Plan, SQL TRACE, TKPROF, SQL Profiler
• Used shell scripts for daily administration.
• Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export.
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Installed and configured of Oracle 10g &11gRAC using Cluster ware and ASM.
• Worked on implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Recovered the database restore and recovery from RAMN backup.
• Worked on Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Applied security patches both Server side and Client side and Performed testing.
• Worked on documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Environment: Redhat Linux, HP-UX, Oracle Database Version 10g/11g, RMAN, Data guard, RAC, ASM, Oracle Enterprise Manager (10g), Opatch, Shell Scripting, TOAD, TKProf, Datapump.

Confidential

Oracle DBA

Responsibilities:

• Monitored Smiths medical client production and development databases . Checked the Blocking sessions, if the blocking session is inactive then clearing those sessions, so that other sessions waiting can continue.
• Cloned and refreshed the databases as per requirements of the development team.
• Created, altered the tables, views and PLSQL objects as per the development team requirement.
• Used 10g OEM (Oracle Enterprise Manager) to manage and monitor databases.
• Applied one off, security patches to fix the bugs.
• Collected the statistics of the database and tuning the resource consuming SQL statements.
• Applied patches on databases and 11i Oracle EBS applications.
• Created custom tops, custom responsibilities in Oracle applications.
• Used exp/imp to refresh schemas and also performed RMAN/cold/hot backups.
• Automated and implement day-to-day Oracle DBA functions using cron jobs and shell scripts.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used traditional export import to take backup of schemas whenever required as per the request.
• Gathered database statistics and rebuilt indexes if required for better sql query execution.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups as per the requests.
• Performed daily DBA support activities for the Oracle production Systems.
• Performed and tested Oracle backup and recovery policies and procedures.
• Participated directly in testing and planning to prepare for database 10g upgrades.
• Worked on Oracle Apps 11i/R12 E-Business suite systems also.