Oracle Production support DBA Core/E-Business/cloud

Over 10 years of experience as Oracle Production DBA including Core and Oracle Applications environment with 15 years of IT experience. At present working as Lead production DBA in a very high SLA with 100 uptime environment. Proven track of being a Production support DBA in very high Demanding Environment like Cerner Corp, Johnson Controls, Cisco Systems to name a few. Proactive Database Monitoring, Incident RCA, 24x7 on call support, Large Database Platform Migration, Real time Replications for Mission Critical DR systems are the few key strengths among many others.

Technical Highlights

• Database : 12c Rel 1 12.1.0.2.0 , 11gR2 11.2.0.x . 10.x, 9.x, 8.x, 7.x
• Golden Gate : 12c 12.1.2.1.0 , 11g 11.1.1.1.1 ,
• ERP/E-Business Suite : R12 Ver. 12.1.3 , 11i Ver. 11.5.10.2 , 10.7
• Database Monitoring/Management : OEM 12c, OEM 11g, Sql Developer, Toad, Sql Navigator
• My SQL : Enterprise Edition Ver 5.6.20
• Hyperion : EPM ver. 11.1.2.2.0, Ver. 11.2.2.3.0 for Linux x86 64
• Fusion Middleware : OID, SSO, WebLogic, BPEL, BAM, B2B All integrated
• with R12 Environment
• Virtualization : VMWARE ESX, Workstation, Virtual Box, AIX VM
• Storage : Emc Clarion
• Scripting : ksh, bash, perl
• Hardware : Cisco UCS, Dell Blade, AIX P series, HP Superdome
• Audit/Standards : SOX, PCI.

Experience

Confidential

Lead Oracle Production DBA E-commerce

Environment

Database :

• 12c Rel 1 12.1.0.2.0 , 11.2.0.3.0 PSU 9, 11.2.0.2 PSU 11, 11.2.0.4
• GoldenGate : 11g Ver 11.1.1.1.1
• Enterprise Manager : OEM 12c Ver 12.1.0.3.0
• OS : OEL 5.6, OEL 6.x
• Hardware : Dell Blade Server for Linux x86
• Deployment : Sales Force
• MySQL : Ver 5.6.20

Job Duty

• New DB Environment builds Install Oracle CRS, Configure ASM Disk groups, Install 11gR2 database.
• Proactive monitoring of production system using OEM top activity for high load SQL.
• Review Explain plan for the SQL causing high load, identify the cause, suggest appropriate index and implement from non-prod to prod.
• Monitor GoldenGate replication Prod, Backup and DR database, Identify GoldenGate Lags after PSU patch implementations Flush out the old execution plan and generate new plans, Identify tables with no primary/unique key and implement the keys to improve replication performance,
• Setup GoldenGate Veridata for Weekly Comparison between Production, Backup and DR Replication sites. Identify the Out of sync tables and fix the issue.
• Apply Database PSU patches quarterly in DR, Backup and Production Database.
• Partition Tables Backup of Six months old partitions for log tables using expdp, truncate and drop partitions six months old partitions to free up spaces for new partitions.
• Build DR Environment Build all schema from production using Expdp, Database Re-org of tablespaces, Implementation of Partition tables for large tables, Rebuild materialized views.
• Rebuild materialized view logs to avoid refresh performance slowness.
• Install OEM 12c, Build Standby OMS server, Build Physical Standby Database for OEM Repository for failover, Define Monitoring Templates, Migrate Monitoring templates from Existing OEM Repository, Install GoldenGate Plugins for OEM.
• Evaluate Oracle 12c multitenant Feature for implementation of GoldenGate Replication in Multitenant Environment, Migration of 11gR2 Database to 12c Multitenant PDB.
• Administer All Database Backups maintain by 3rd Party Datacenter.
• Administer MYSQL database.
• Work with PCI auditor and implement audit compliancy requirement in Database for Data Protection and Security Vulnerabilities.

Confidential

L3 DBA - Production

Environment - Oracle Application Version 12.1.3, 11.5.10.2, OEM 10g/12c, Oracle SSO 10.1.2 , Oracle Identity Management 10.1.4 , BPEL 10.1.3.4 . Golden Gate , Database 11.x/10.x/9i, Cisco Linux UCS x86-64 .

Job Duty:

• As a L3 DBA primary responsibilities to do Root Cause Analysis RCA for every P1 incident related to Application/Database occurred and work with Oracle/System Administration team to resolve the issue and put the fixes in place.
• Daily task also includes Review and address all trouble tickets JIRA and resolve the cases with appropriate fixes,
• Review all upcoming change requests pertain to the supported databases and approve the same, Monitor SOX alerts and resolves the issues.
• Monitor Daily backup reports and address the failed backup for the supported database.
• Ensure all production EM targets are up and remove the blackouts.
• Monitor all cron jobs and make sure all missing cron jobs are in place. 11.2.0.2 Database upgrade to 11.2.0.3.
• PSU patching for database in ERP environments.
• Application patching.
• Address all users who are having issues with Single-Sign on by updating the GUID.
• OID de-registration/registration for missing environments.

Confidential

Application DBA - Production

Production support

Environment - Oracle Application Version 12.0.6, SOA 10g, B2B 10g, Demantra 7.2, OTM 5.6, OEM 10g, EMC Clarion Disk Array, EMC RPA, EMC Unishpere, Replication Manager, AIX 5.3, VM Ware ESX Server 4.0, AIX Virtual I/O Server VIO , VM Ware Guest OS Red Hat Linux 4.x, 5.x. , IBM-TSM backup.

• Tasks - Support of 3 Instances Prod, QA and Dev of Ebusiness, SOA, B2B, Demantra and OTM. Monitor instance activity through OEM, Monitor all concurrent Jobs, Month End processing monitoring and management for job distributions to appropriate service nodes, Change mangement and code migrations, Backup monitoring and fixing of failed backups, Patch application, Startup/Shutdown of different instances including E Business, SOA, Workflow Queue monitoring and bouncing of Deferred Agent listeners when queue has large number of request pending.
• Instance refresh support - Database cloning using EMC disks replications/replication manager. Re-create the control files. Database startup. Application file system refresh using SCP. Autoconfig execution. RMAN duplicate using TSM recovery, manually redirecting TSM server from prod to QA, TSM backup export/import across prod and non-prod network.
• Project Support - DR Activity - Monitoring of RPA replications from PROD to DR site, Shutdown of RPA replication for Image Access, Snap cloning of DR luns to target non-prod luns for database refresh, fracture of luns after snap-clone process completion, Adding of new luns to Production luns from storage pools.
• E-Business Database upgrade from 10g to 11gR2 - Up gradation of E-Business 12.0.6 instance 10g database to 11g R2 database, Forms/Application server upgrade. SOA repository database upgrade from 10g to 11gR2, Siebel, OTM and B2B database upgrade from 10g to 11gR2. Creation of SOA repository metadata database.

Confidential

Application DBA - Production

• Oracle Financial production support Supporting 11.5.10.2 Oracle Financial database for Production, Test and Development environments with 6 instances. Application and Database cloning using Rapid Clone and manual database cloning, Production database backup using BCV and IBM-Tivoli, Development and Test
• Database using RMAN. Database Statistics collection using custom process COE stats, seeded FND Stats jobs. Database statistics export/import between production and cloned environments for performance benchmarking, Monitoring Daily and Monthly jobs and identify long running processes, extract the potential poor performing sql's, Generation of SQLTXPLAIN reports using sqltxplain xtract method, concurrent manager jobs tracing from database server and generation of TKprof report for the concern trace files. Installation of SQLTXPLAIN, RDA agent, TRCANLZR and OSwatcher tools for performance data collection and metrics. Oracle application patching using adpatch. Analysis of current patch level and determining the candidate patches to maintain compliancy with Oracle support, Troubleshooting of Messaging Gateway for 11i environment, Materialized View Replication, Installations of Oracle Configuration Manager for 11i environment, Storage estimations for Quarterly Database Growth.
• IBS Application production database support 3 node RAC with ASM and Oracle Database 10.2.0.3 database, CRS and ASM upgrade, change management, RMAN backup recovery scheduling, monitoring and troubleshooting, Shell scripting for Database monitoring and backup,
• Archive and Purge project support Installation of Applimation metadata for Archive/Purge Database, Export/Import of Applimation metadata from test to prod, Application of Informatica patches for E-Business integration, Creation of DB Links for History databases, Customization of Grant Scripts to enhance the admin option, Identify invalid views with history and combination schemas and apply manual fixes, Troubleshooting of Applimation web tier to troubleshoot the connection issues, Monitor Informatica Archive jobs for Standard Oracle Modules.
• Release 12 upgrade project support Oracle Advance Queue and Messaging Gateway setup, R12 cloning using Rapid Clone for RAC and Non-RAC environments, Database Cloning, Scheduling of Database and Application Tier backups using Cron jobs, Oracle BI scheduling configuration, OBIEE presentation screen configuration, export/import of schemas using Data pump, creation of DB links, User, Roles and Tablespaces, ASM Disk group management, New instance setup including installations of CRS Application Cloning and Load Balancer Setup, LAD Patching, Localization for Brazil china, WebSphere upgrade for OBIEE, Instance Decommissioning, Parallel Concurrent Manager configuration,

Environment: Oracle E-business 11.5.10.2, 12.0.4 , Oracle Database 10.2.0.3, 11.2, HP-UX 11.23, IBM-TSM Ver 5 Rel 5 , CRS , Symmetrix BCV, Informatica/Applmation Ver 5.3 For Oracle E-Business, RMAN, OSWatcher, RDA, SQLTXPLAIN, TRCANLZR, Tkprof, Unix Shell Csh and Korn , OEM Ver 10.2.0.5.0 , TOAD Ver 10.6.0.42 , DB Artisan Ver 8.7.3 , SQL Developer Ver 2.1.1.64 .

Confidential

Application DBA - Production

• Production Support of Monsanto's 80 Oracle Database Monitoring trouble ticketing system Magic and Team Track and Address On-Call pager support new issues log into the system. User and Password maintenance. Database and Schema refresh using Data Pump and Export/Import. Address all Grid Control including Space alerts, ORA-0600 error Alerts, Max process alerts. Address all RMAN backup failure issues for nightly backup jobs including full, incremental and archive log backups. Address all Database performance issues including SQL Slow response's creating lock in the database, Application freezing issues, Identical SQL spawned multiple times causing high CPU usage. Log metalink Service Request for Oracle Database issues and Follow up with oracle for existing service requests Magic and Team Track queue maintenance and assignments of tickets to offshore team every day. Database Patching, Cloning, Upgrade.
• Build Altiris package for automated deployment of Oracle Client for Windows Server and Workstation. Bi-yearly production release for all database related deployment. Reviewing all Grid Control and ITO alerts and prioritizing alerts based on the criticality. GoldenGate replication implementation for multiple site replication process.

Environment: Oracle 11g RAC /10g 10g RAC /9i/8i,ASM, SQL, PL/SQL, RMAN, AWR, Statspack, ADDM, IBM-AIX 5.x, RedHat AS 4.5, Enterprise Manager, Toad, Symantec I3, Altiris. GoldenGate. Unix Shell Script.

Confidential

Oracle DBA Platform Migration

• Database Migration from OpenVMS Oracle 9i to HP-UX/AIX/Redhat Linux Oracle 10.2.0.3 Linux Setup for Oracle 10gR2 RAC environment including Verify Packages for Oracle 10g compatibility, Update Kernel Parameters for Oracle 10g ,Verify /etc/hosts, Create Linux Groups/Users, Setup SSH for the Oracle/Users, Setup SSH for Root Users, Verify Hostname and Gateway, Setup BONDING in /etc/modprobe.conf ,Public Networking Configuration, Private Networking Configuration, NTP Setup, Hang check-Timer, Sun JDK Installation Option, HP PSP Installation, Verify SELinux is Turned OFF ,DM-Multipath Failover, QLogic Failover, Install ASMLib, Determine LUN UUID Mapping to Linux Devices, Create Oracle Volume Group, Ceate Raw Devices for Cluster Files and ASM Spfile. Partition LUN with fdisk, UDEV Setup, RAW Device Setup, Partition Hard Drives for ASMLIB, Linux File system Management including Increase size of existing file system online, Create new file systems.
• Create Stating area for Oracle 10gR2 CDS, Install CRS using the silent installation scripts as well install manually, Install RPM for cvuqdisk, ROOTPRE.SH - Prerequisite checks by oracle, Install CRS, Manually Run VIPCA, Install 10.2.0.3 Patchset for CRS, Pre RDBMS Install Check, Install 10.2.0.3 RDBMS for DB Kernel, Install 10.2.0.3 RDBMS for ASM Kernel, Oracle Network Configuration, Install OPatch 10.2.0.3.3, Create patches directory, Install one-off patches, Install critical patch updates, Install patchsets, Setup HugePages for Oracle SGA, RAC Failover Testing, CRS Management, Database Start/Stop using srvctl, ASM Start/Stop using srvctl, CRS monitoring using crsctl.
• Create Tablespace, Adding Data Files to Existing Tablespace, ASM and File system environment, Adding Tempfiles to TEMP tablespace, SPFILE Create, Dump and Change parameters, 10g Database standadization including initialization parameters, Golden Gate Replication setup, RMAN duplicate,including point-in-time recovery, Database export/import using Pipe and dump files, Standby database with RMAN duplicate., DBA Toolkit setups using Crontab, Performance monitoring using Enterprise manager, Monitor Buffer cache, Monitor SQL for Highest CPU, Disk Usage and Locking, Identify bad sql and tuning with application team., Database Administrations using TOAD including, Schema Refresh, Schema comparison and differences, User maintenance Scheduled job maintenance, Database monitoring, Cross platform database migration using Golden Gate and, Export/Import from Open VMS to RedHat Linux, AIX and HP-UX, - SQL Tuning Using 11g Plan Management Framework, Explain Plan, Database Character set conversion.

Environment: Oracle 10g 10g RAC /9i, RedHat Linux AS 4.5 and 5.0, Open VMS 7.x, Golden Gate, PL/SQL, RMAN, AWR, Statspack, ADDM, ASM, HP-UX 11.x, IBM-AIX 5.x.

Confidential

Oracle Application DBA - Production

Installations of Oracle Databases and clients, On call support 24x7, Upgrade 9.2.0.6 to 9.2.0.8, Creation of the Development, Test and Production Oracle 9i/10g databases, Cloning of production database to the test environment using Recovery Manager RMAN , Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc, Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup, Monitoring Enterprise Manager Alert Logs for taking corrective actions including tablespace sizing, Production support on Windows Based 2-node RAC systems.

Environment: Oracle 10g/9i 9i RAC /8i, RHEL 4.5 AS, Enterprise Manager, SQL PLUS, PL/SQL, RMAN, AWR, Statspack, ADDM, VNC, SQL Plus, TOAD, MS SQL Server 2005.

Confidential

Database Application Administration

• Create target Database in 10g utilizing HP-UX platform. Identify Database objects require migration. Identify each object with sizing criteria including large, medium and small. Sizing estimations and create appropriate tablespaces. Create Import/Export scripts.Migration of large tables Over 2GB of size using Unix pipe features and Oracle TWO TASK.Configuring Database to schedule Database monitoring scripts. Configuring Database to make ready for Hot Backup using Veritas NetBackup and Oracle RMAN. Identify potential failures of Export/Import Jobs and resolution of the problem including resizing the tablespaces. Generate migration scripts using SQL-TOADS for migration of Views/Indexes and other objects. Create Database users and roles and implement appropriate user security. Setting up enterprise wide RAC implementation strategies for SunTrust.
• Support of 4 Oracle Application instances Ver 11..5.8 , Periodic cloning of production systems to create Pre-production/Quality and Test environment, Upgrade of Oracle Projects module from 11.5.8 to 11.5.9, Patching using Autopatch, Oracle Application security including responsibility, menu and user maintenance, start/stop concurrent manager jobs.

Environment: Oracle 10g 10g RAC /9i/8i, RHEL 4.5 AS, HP-UX IBM-AIX 5.x,Enterprise Manager, SQL PLUS, PL/SQL, RMAN, AWR, Statspack, ADDM, Ebusiness 11i, SQL Server 2005.

Confidential

Oracle Financial DBA Support Manager

• Track and Monitor bug logging system. New ticket requirement analysis and effort estimations. Requirement gathering from business users. Evolve implementation strategies working with offshore development team and business users. Knowledge transfer to offshore development team. Track, monitor and review offshore development work. Testing of each component before user acceptance test. Address all performance issues and solution development with System Administrator and Database Administrators. Working with business users and scheduling system outages for regular system and Database maintenance work. Plan and Schedule regular Database maintenance activities including export/import and chain row removal process. During system outages constant review with Database Administrators and system administrators and provide status updates to key business users/leaders.
• DBA suppport of 6 Oracle Application instances for Genworth and Gelife Version 11.0.3 and 11i including security administration, patching using autopatch, tuning of long running concurrent request, Manual cloning of 11.0.3 production instances to stage and test instances, installation of 11.0.3 on multiple nodes, Quarterly index rebuilding for GL BALANCES table Size 120GB , Concurrent program migration to different instances, Job scheduling using Appworx, troubleshooting failure jobs in Appworx.

Environment: Oracle Ebusiness 11i 11.5.10.1 , Oracle 9i/8i, IBM-AIX 5.x, HP-UX 10.x, Enterprise Manager, SQL PLUS, PL/SQL, Appworx

Confidential

Onsite Project Manager

Study existing system by application areas. Analyze current resource distribution with loading factors. Identify each resource by skill and prepare skill matrix for complete application support. Prepare resource distribution list by skill for each application. Propose new team structure with reduced cost and increase turn around time for support calls. Prepare offshore support methodology. Present project plan to customer and negotiate the new support team structure.

Environment: Oracle 9i/8i, Oracle Developer 6i, SQL Plus, PL/SQl, Microsoft Project, Microsoft Excel.

Confidential

Onsite Project Manager

Overall delivery management including onsite and offshore. Customer interaction and communications. Identify, Track and monitor all offshore components. Create and maintain project plan for RICE Reports/Interfaces/Conversion/Extension Development team. Create and maintain effort estimations for RICE Development. Define development standards deriving from Oracle AIM methodology templates. Review and approve all functional MD60 before development. Review and approve all technical design MD70 before delivering to customer. Functional testing of components being delivered by offshore team. Configuration management including object migration to instances using Kintana.

Environment: Oracle Ebusiness 11i 11.5.10.1 , Oracle 9i/8i, IBM-AIX 5.x, HP-UX 10.x, Enterprise Manager, SQL PLUS, PL/SQL.

Confidential

Onsite Project Manager

Requirement and Feasibility study for customizations work by going through the end users wish list. Facilitate the user sessions with the requirement gathering team and identify the technical solutions for the proposed customizations for each object. Effort estimations for the feasible and approved customizations. Resource identifications and team formations. Project Plan and Tracking of due deliverables. Review and approve all functional designs delivered by functional team for development. Review and approve all technical designs delivered by technical team. System and Integration testing of each new object being developed.

Confidential

Senior Systems Engineer

• Accelio Corporation is formerly known as Jetform is the leader in designing Generic application UI
• using front end technologies like Visual Basic and HTML. The forms utilizes ERP application like
• Ebusiness and SAP for capturing and generating user specific custom forms like invoices
• SAP Output PAK utilizes SAP RDI datafile and generate user defined invoices. Maintenance of SAP output PAK.

Environment: MS Windows and Visual C/C .

Confidential

Oracle DBA MASP Development Team

Oracle Database installations NT 4.0 and Solaris 5.8 , configuration for integration with other products. Development of triggers, stored procedures and packages. Troubleshooting and bug-fixing for MASP configuration during deployment Management of uptime of MASP Databases deployed within Nortel network's customer sites. Database performance tuning and optimization for slow Database response times SQL performance diagnostic activity for slow performing applications including Explain Plan generation, Tracing of User and Database sessions and output generation using TKPROF.SQL Tuning activity restructuring of SQL statements after Explain plan review, controlling access paths using SQL hints, restructuring indexes, restructuring physical model using table partitioning.

Confidential

Oracle Data Architect

• Interface procedure development using Oracle PL/SQL and Unix Shell Scripts.
• Development of data movement scripts using Decision-based Mapper.
• Development of triggers, stored procedures and packages
• SQL performance diagnostic activity for slow performing applications including Explain Plan generation, Tracing of User and Database sessions and output generation using TKPROF
• SQL Tuning activity restructuring of SQL statements after Explain plan review, controlling access paths using SQL hints, restructuring indexes, restructuring physical model using table partitioning

Confidential

Remedy Developer

OSS Development using Remedy 4.0

Confidential

DBA Team Lead

• Migration of Database from 7.3.1 to 7.3.3 for 37 OPEDS sites, migration of Informix Database from 5.1 to 5.8.
• Production Database support for OPEDS application.
• DBA activities involving Database maintenance, space monitoring and management, disaster recovery management, DB export / import, etc
• Data clean-ups for pre-migration process, data migration scheduling and DBA resource allocations SQL performance diagnostic activity for slow performing applications including Explain Plan generation, Tracing of User and Database sessions and output generation using TKPROF SQL Tuning activity restructuring of SQL statements after Explain plan review, controlling access paths using SQL hints, restructuring indexes, restructuring physical model using table partitioning.

Recent Trainings

• Install, Patch and Maintain Oracle Applications.
• Oracle 11g training New Features.
• Six-Sigma Green Belt conducted by Satyam Computer Services Ltd., Hyderabad
• Oracle Apps 11i conducted by Genesis Software Ltd., Hyderabad.
• Project Management Body of Knowledge conducted by Satyam Computer Services Ltd., Hyderabad
• Docs Open conducted by Documents, Ottawa Canada .
• BEA-Tuxedo Admin by Nortel Networks, Ottawa Canada
• Action Request Admin by Remedy Corporation, USA
• Corba / C conducted by Iona Tech., USA
• ISO 9000 conducted by Birla Consultancy, Mumbai