SKILLS PROFILE

Operating Systems:

OEL 5.x, HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9

RDBMS:

Oracle 9i/10g/11g, Oracle 11gR1/11gR2 Clusterware and Real Application Clusters (RAC).

Languages:

SQL, PL/SQL, Shell Scripting

Software and Applications:

OEM, DATAGUARD, Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, Oracle Clusterware, VERITAS Backup, Netapp Storage

Ticketing Systems:

Service Now, Support Central and HPSD

PROFESSIONAL EXPERIENCE

Sr. Oracle DBA
ERICSSON, Dallas TX 

     08/15 – Present

·         Assist the Database team with various ongoing tasks, including but not limited to database installation, configuration, backup validation, performance tuning, replication setup, and general database monitoring, as well as recommend best practices and procedures;

·         Install, upgrade, maintain Oracle 11g and 12c databases on AIX, and backup and recovery.

·         Upgrade databases from 10.2.0.5 to 11.2.0.3 and 11.2.0.3 to 12.1.0.2.

·         Datacenter migration from OPWDD to CNSE.

·         Integrating Database schemas using db links, materialized views 

·         Migration of databases from JFS2 file system to Automatic Storage Management (ASM).

·         Building and Maintenance of 12c Data warehouse Databases for OBIEE Application.

·         Installation and Upgrade of Oracle 12c Grid Infrastructure binaries for RAC Databases.

·         Migration of non-RAC Databases to RAC.

·         Implement 12c Features like Multi-tenant Pluggable and container databases.

·         Implement 12c FLEX ASM Feature.

·         Implemented Golden gate bi directional replication to ensure zero data loss.

·         Character set migration of Internet Java Application databases from WE8MSWIN1252 to (AL32) UTF8 Unicode Character Set using CSSCAN, CSALTER and export/import.

·         Tuning Long running queries of Siebel and OBIEE applications using explain plans, AWR, ADDM, SQL Tuning Advisor.

·         Creating Data guard setup where in a production RAC database has a physical standby RAC database for disaster recovery.

·         Performing failovers and switchovers between production and standby databases.

·         Resolve archive log gaps between source and standby using incremental backups and copying archives

·         Encrypting Tablespaces with AES256 to secure the data using Oracle Advance Security including TDE, Oracle Wallet and remote authentication;

·         Establishing Connection Pools for applications in Web logic application servers for optimal resource usage.

·         Cloning PROD and UAT databases to DEV and Sandbox using RMAN restore/recovery and duplicate methods.

·         Applying Latest PSU and Bug fixes for Oracle RAC Database and Grid Infrastructure (Clusterware) Home Binaries.

·         Working actively with Oracle Support to resolve bugs and fix issues.

·         Manage Enterprise Manager 12c and Deploying agents on new targets to monitor databases.

·         Allocating storage and planning future storage requirements for the database system;

·         Work with application programmers, system architects to create solutions business goals

·         Perform off-hours (evening or weekend work) as needed for emergency or maintenance tasks that are performed during the agency established maintenance windows

·         Provide support for internal users and external data exchange partners

·         Perform optimization and tuning activities, including capacity planning, tracking historical usage, trending future resource needs, and modifying resource allocations as needed.

·         Provide recommendations on technical architecture.

·         Provide hands-on training and mentoring for other database administrative staff. 

Environment

Oracle 9i/10g/11g/12c, AIX, Oracle Advance Security, WebLogic, PL/SQL, SQL, shell scripting

Sr. Oracle DBA
Brocade Communication San Jose, CA

04/13 – 08/15

·         Install, configure and maintain Oracle 11gR2 Clusterware on 2 and 4 node Clusters for High Availability.

·         Install, configure and maintain Oracle 10g/11g databases on Linux Platforms.

·         Install and configure OEM 12c cloud control OMS for monitoring Oracle databases.

·         Upgrade of OEM 12c Cloud Control from 12.1.0.2 to 12.1.0.3.

·         Troubleshooting Infiniband/RDS performance issues on Exadata.

·         Configuring IORM/DBRM and Implementing Oracle Exadata best Practices.

·          Migrating databases to Exadata.

·         Setting and Monitoring Exadata using EM12c.

·         Maintain and Troubleshoot Exadata Cell/Storage and DB/Compute node performance issues.

·         Addition of a second Oracle Management Service for load balancing.

·         Conversion of multiple single instance databases to 2 and 4 node RAC databases.

·         Install and configure ASM disk groups and ASM instances for single as well as RAC instances.

·         Migration of multiple NON-ASM databases to ASM file system and disk groups.

·         Application of one off, CPU/PSU patches to various database versions including 10g and 11g. Applied 11.2.0.4 patch set on multiple databases.

·         Upgrade database 10.2.0.5 to 11.2.0.3 and 11.2.0.3 to 12.1.0.1.0 using DBUA manual methods.

·         Set up Data Guard for production databases and resolved archive log gap issues and performed switchover and failovers.

·         Planned and performed daily, weekly and monthly backups. Tested and implemented various restore and recovery scenarios using RMAN.

·         Experienced in EBS11i, R12.1 R12.2 installation, configuration and cloning.

·         Experience in Patching Oracle EBS Suite 11i/R12.1/R12.2 Versions.

·         Experience in concurrent manager and work flow administration in Oracle EBS.

·         24X7 production support and on call rotation.

·         Installing and Patching OEM 11g and 12c Oracle Management Servers and Repositories.

·         Installing/Deploying Agents on the servers, Discover and Add Targets, creating blackouts.

·         Character set conversion from WE8ISO8859P1/ WE8ISO8859P15 or WE8MSWIN1252 to (AL32) UTF8 Unicode Character Set using CSSCAN, CSALTER and export/import.

·         Set up both database and OS- level security policies for data protection using Oracle security features such as Oracle Wallet, Transparent Data Encryption, Oracle Database Vault, Oracle Audit, Single Sign on, SSL and Oracle Identity Management.

·         Experienced in generating and analyzing AWR, ADDM and STATSPACK reports to detect and diagnose production system performance problems such as wait events, tuned Oracle SGA, resolved Latch Contention and Physical and Logical I/O Contention.

·         Performed SQL tuning and SQL optimization by gathering optimizer statistics to prevent stale statistics from ruining the execution plan and by using EXPLAIN PLAN, SQL Trace and Oracle trace, hints, TKPROF and Oracle dynamic performance views and by rebuilding indexes online and partitioning tables and indexes.

·         Experienced in database and table reorganization using methods such as online table reorganization, coalesce, deallocate and shrink space.

·         Resolved connectivity issues for applications and users.

Environment

Oracle 11G, OEM 12c Cloud Control, RMAN, RAC, ASM, Data Guard, EBS11 and R12, AIX OS 6.1/7.1, Linux (RHEL 4.x, 5.x), Sun OS 5.8/5.9/5.10, Toad, Golden Gate

Sr. Oracle and EBS DBA
Bank of America, Dallas TX, Sigmasoft, India

06/11 – 04/13

·         Monitor 11g grid control to error notification adding new targets to grid control Environment

·         Create new instances, refreshing databases, and cloning databases using RMAN and User Managed Techniques.

·         Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing.

·         Providing production support for Oracle databases.

·         Work on adpatch, adadmin, adctrl, adrelink, adident, admerge, adconfig on EBS R12.

·         Keep Oracle environments up-to-date by applying CPU/PSU and one off patches.

·         Backing up and recovering databases, improving disaster recovery strategy.

·         Configured high availability solutions such as ASM, Data Guard and RAC.

·         Maintaining user accounts, Profiles and ensuring proper database security.

·         Developed UNIX Shell scripts to automate database operation and monitoring.

·         Configured online and offline Database Backups using RMAN.

·         Upgrading database from Oracle version 10gR2 to 11gR1and migration of data.

·         Responsible for tuning and Optimizing slow running SQL.

·         Created and managed database objects Partitioning when implementing Oracle VLDB.

·         Developed and modified Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and perform recovery.

·         Applying CPU and interim patches on RAC and Grid Infrastructure binaries.

·         Worked with oracle support 24x7 to expedite the process in resolving an issue.

·         Administering production databases as large as 2.5 TB on a 4 node RAC installation.

·         Administer and maintain Production Apps 11i and R12 instances, 24X7 Production Database Support and maintenance.

·         Protecting the integrity of the data by enabling and maintaining primary/unique/foreign key constraints.

·         Installed E-Business suite on both single and multi-nodes on Linux platforms.

·         Performed EBS upgrades from 12.1.1 to 12.1.3.

·         Performed database upgrades from 10.2.0.5 to 11.1.0.6 and 11.2.0.1 to 11.2.0.3

·         Cloning of 11i/R12 Oracle Applications using Rapid Clone.

·         Installation of 11gR2 Grid Infrastructure for RAC Environments.

·         Migration of Databases from Non-RAC to RAC.

·         Cloning the database using RMAN Duplicate Feature and active Duplication Feature.

·         Installation and Database creation on 11gr2.

·         Configured SCAN on 11gr2 Cluster.

·         Well versed in Rapid Install, AD utilities for Oracle Applications.

·         Creating and Maintaining Physical Standby databases and resolving the archive gap.

·         Applying Rolling patches for RAC Databases.

·         Database and schema Refresh using Data pump utility

·         Performed Patch analysis of one-off patches, mini packs, family packs and RUP patches for family packs and applied Application Patches.

·         Excellent Knowledge on AD Utilities and their usage.

·         Starting and shutting down of workflow components through OAM.

·         Knowledge in parallel concurrent processing.

·         Troubleshooting forms server, Apache server issues

·         Troubleshooting concurrent manager issues.

·         Compiling JSP’s using ojspcompile.

Environment

 Oracle 11gR1/11gR2, SQL, PL/SQL, EnterpriseLinux5.4, EBS11i, IBM AIX6.1, SUNOS 5.9, Windows Server 2003, Toad, UNIX

Oracle DBA
State Farm Insurance, (csc),  India

10/08 – 06/11

·         Created and maintained 30+ Oracle 10g/11g databases. Some configurations use Oracle Data Guard for the DR/Standby solution and RAC using SAN Storage. Use RMAN for backup and recovery; use oracle tool AWR/ADDM to diagnose database problems. 

·         Create and maintain databases required for development, testing, education and production.

·         Performing the capacity planning required to create and maintain the databases.

·         Production support for mission critical Oracle databases.

·         Review of Database logical and Physical design.

·         Creation and maintenance of Table spaces, Data files, Indexes, Undo/Rollback Segments.

·         Install, Upgrade and maintain Oracle 10g, 9i on Sun Solaris, Redhat4 Installation.

·         Implementing Database Security, Management of role-based security.

·         Write and modify UNIX shell scripts to manage Oracle environment such as archive log and audit log files rotation, and for taking RMAN Full and Incremental Backups.

·         <span style="f