Manager Oracle

Professional Summary:

* **** ***** ** ********** 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 very large scale database environment and mission critical large OLTP and OLAP systems on HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.

Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.

Good working experience with Container databases or Pluggable Databases (PDBs).

24*7 production database support with Support to developers & end-users.

Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.

Migrated Non-ASM Single Instance to ASM RAC Instance.

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.

Expert in implementing ORACLE STREAMS and Golden Gate 11x (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.

Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.

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 12

Having hands on experience in management and database administration of Oracle applications 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 programming experience in stored procedures, functions, triggers and scheduled jobs.

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.

Database replication using snapshots, materialized views and advanced methods.

Experience in applying security patches to the databases.

Good experience in Data Migration using data pump export/import.

Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.

Excellent 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.

Certifications:

Oracle Certified Professional (OCP) in Oracle 10g Database Administration.

Technical Skills:

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

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

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

Operating systems : OEL, RHEL, AIX, Solaris.

Other Tools :VERITAS Cluster Manager v3.5, TOAD, Erwin, Putty

PROFESSIONAL EXPERIENCE:

JP Morgan Chase, Ohio/TX October 2016 – Till Date

Senior Oracle Database Administrator

Responsibilities:

As a Sr. Oracle Database Administrator, I am responsible for providing production and development support for Oracle 10g/11g databases on HP-UX platform.

Resolved the block corruptions in a 11gR2UAT/TEST databases.

Performed NLS migration ( toAL32UTF8 ) to be consistent with NLS setting same as in prod systems.

Resolved the import and export issues for the 11gR2 databases.

Applied the PSU patches to 11g R2 Grid Infrastructure and databases instances. Also updated the opatchversions.

Performed Database upgrades from 11.1.0.7 to 11.2.0.4 on both RAC and single instance databases.

Performed ASM upgrades from 11.1.0.7 to 11.2.0.4.

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 involved.

Worked with Oracle support to resolve the database issues.

Worked on clearing the alerts in the Oracle Enterprise Manager console summary.

Worked on datapump export and import as part of developers request to refresh schema.

Used Oracle Enterprise Manager Cloud Control 12c for monitoring the databases.

Moved the SPfile from non ASM to ASM disks.

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.

Worked on post upgrade issues of having invalid components to validate the components.

Cloned the databases for testing the RMAN backups periodically.

Scheduled full and incremental RMAN backups for the databases using autosys tool.

Worked with the team in ticketing system to perform dba tasks.

Performed user related activities like assigning privileges and profiles to users upon approvals.

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

State Street Bank, Boston, MA Jun 15 – Oct 16

Senior Oracle Database Administrator

Responsibilities:

As a Sr. Oracle Database Administrator, I am responsible for providing 24X7 production support for critical connectivity applications’ Oracle 10g/11g/12c databases on Solaris and RHEL.

Installed Oracle 10g/11g/12c stand-alone and RAC systems (also OEM) in HA environment on different O.S platforms (AIX, Linux, Solaris, RHEL and VMware).

Configured 11.2.0.4 RAC on 3 node cluster.

Worked on upgrading RAC database from 11.2.0.4 to 12.1.0.2

Worked with Container databases or Pluggable Databases (PDBs).

Migrated Non-ASM Single Instance to ASM RAC Instance.

Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.

Improved performance of REPLICAT process using Range functions in Golden Gate and used some Macros and Tokens in GG.

Worked on handling large database up to 14TB in size with 4 nodes cluster on various flavors of UNIX.

Resolved Replicate/extract/pump issues and upgraded classic EXTRACT to Integrated capture to overcome the compression table’s issue.

Worked on troubleshooting RAC node eviction problems by reviewing cluster logs and system log messages

Worked on Managing Applications on oracle 11g / 10g RAC databases using ASM file system with server control utility (SRVCTL) and CRSCTL for high availability.

Configured high availability services TAF, load balancing and SCAN features for clustered databases.

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.

Worked with 11g new features such as ADRCI, Duplicate from Active database, ASMCMD, Memory parameters, Incidents,etc.

Implemented various backup strategies for big / med and small databases using RMAN.

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

Worked on Oracle Enterprise Manager, working with ASH, AWR reports, ADDM, STATSPACK and gathering statistics.

Developed shell scripts for daily administration.

Configured and managed Data Guard extensively for Production databases of sizes ranging from 50 GB to 5 TB.

Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.

Environment: Solaris 10, RHEL, Oracle Database Version 10g/11g/12c, RMAN, Data guard, RAC, Streams, Golden gate, ASM, ACFS, Oracle Enterprise Manager Grid Control 12c.

PWC, FL Jan 2013– May 2015

Oracle DBA

Responsibilities:

Installed, configured and maintained Oracle 11g and 10g on Red hat 5.0.

Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on IBM-AIX nodes.

Configured 11.2.0.3 RAC on 3 node cluster and worked on upgrading RAC database from 11.2.0.3 to 11.2.0.4.

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.

Converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.

Used SQL*Loader to move data from flat files into an Oracle database.

Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.

Implemented Streams replication between RAC and non RAC database environments.

Worked on cloning RAC databases using RMAN tool.

Worked on Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.

Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for the Production databases.

Wrote and modifiedUNIX shell scripts manage Oracle environments and for Backend Oracle Processes.

Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.

Tuned SQLqueriesand alsoDatabase based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM, ASH and monitor the database performance on daily basis.

Automated the nightly RMAN backups for the Production and Test Databases in Crontab.

Cloned&duplicated databases using scripts as well as RMAN.

Recovered the database and performed complete recovery, data file recovery, incomplete recovery.

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.

Check the centralized error logs if any.

Check for the failed jobs, investigate the route cause and resolve the issue. Native SQL notification alert sends a mail to DBA

24x7 remote support and on call Database support for Database developers & end-users.

Environment:Red Hat Linux 5.0, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, ASM, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Oracle Corporation, India Aug 10 – Nov 12

Oracle DBA/Apps DBA

Responsibilities:

Worked on upgrading 10g/11g databases for R12 release testing.

Upgraded databases from 10.2.0.2 to 10.2.0.5 and 10.2.0.5 to 11.1.0.6

Worked on R12 release projects in testing the installation and upgradation of R12.0.6, R12.1.1, R12.1.2, R12.1.3 release.

Applied different patches - one-off patches, CPU and PSU patches: 11.2.0.1.1, 11.2.0.1.2

Gathered database statistics and rebuilt indexes if required for better database performance.

Performed pre-upgrade and post-upgrade tasks for preparing the environments before upgrade process.

Performed cloning environments to provide the databases to development and testing teams.

Validated the invalid objects after the maintenance tasks like applying a patch or upgrading the database.

Performed RMAN/Offline /Online backups using automated scripts and restored the backups to refresh the environment.

Used 10g OEM (Oracle Enterprise Manager) to manage and monitor databases.

Applied security patches both Server side and Client side and Performed testing.

Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.

Worked with Support team on service requests on critical issues.

Worked on Oracle Apps 11i/R12 E-Business suite systems also.

-> Installation, configuration and upgradation.

-> Cloning and Autoconfig.

-> Patching (ADPATCH).

-> Concurrent managers.

-> User management.

Environment: R12, R12.1, Oracle database 10g (10.1.0.5 to 10.2.0.4), 9i (9.2.0.8), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, ASM, OEM 10g, ASM, RMAN, SQL*Plus, SQL*Loader.

Apps Associates, India Jun 07 – Jul 10

Oracle DBA

Responsibilities:

Cloned and refreshed the databases as per requirements of the development team. Optimize and tune all aspects of the Oracle architecture.

MonitoredSmiths medical client production and development databases. Checking the Blocking sessions, if the blocking session is inactive then clearing those sessions.

Created, altered the tables, views and PLSQL objects as per the development team requirement.

Collected the statistics of the database and tuning the resource consuming SQL statements.

Applied patches on databases and applications.

Used exp/imp to refresh schemas and also performed RMAN/cold/hot backups.

Automated and implement day-to-day Oracle DBA functions.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Performed daily DBA support activities for the Oracle production Systems.

Performed and test Oracle backup and recovery policies and procedures.

Maintained oracle security and auditing policies and procedures.

Participated directly in testing and planning to prepare for system upgrades.

24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.

Environment: Oracle 9i, HP-UX, Solaris, RHEL, AIX, Windows 2000,Database Tools/Utilities, Shell Scripting.

Education: Master’s in Computer Science from Kakatiya University, India

Contact this candidate