SUMMARY:

• 20 yrs IT experience (16 yrs Oracle core DBA on IBM AIX OS, Solaris, HP UX, Red Hat Linux and Windows, 4 Yrs Oracle apps DBA ) in the following industries:
• Petroleum industry
• Health and Human Service sector
• Retail industry - Department stores
• Tele-communication
• Automotive
• Manufacturing (Computer/Heavy engineering)
• Food processing
• Physical and logical DBA support for very large terabyte sized OLTP databases
• Hands-on experience in automating installing Oracle 12c binary in silent mode using shell scripts, upgrading databases from lower versions to Oracle 11g / 12c
• Knowledge of Oracle 12c concepts and implementation strategy
• Hands-on experience in backup and recovery of databases using RMAN interfaced with third party tools such as DD Boost, SQL-Backtrack, VERITAS Net-backup
• Experience in setting up and configuring Oracle EM cloud12c, deploying agents on multiple hosts, configuring databases, setting up backups, monitoring alerts, creating library job templates
• Hands-on experience in troubleshooting and resolving EM cloud12c host agent and OMS related issues
• Experience in Data Encryption at tablespace level
• Experience in setting up and support of 10gR2 RAC on three node cluster
• Standardizing Oracle 10g database service option to manage application workloads
• Developing better archival process to reduce storage footprint and increase performance
• Setting up and configuring physical and standby databases using DataGuard in Oracle 11gR2
• Performing root cause analysis of database related issues
• Extending DBA support to implement database changes as part of periodic release management
• Implementing database tuning for Data Warehouse database
• Implementing SQL tuning using SQL Profile option
• Refresh non-production databases at schema and database levels
• Configure databases on file systems and raw devices
• Applying patches such as spu and psu
• Oracle DBA support on Windows servers
• Configuring databases on SAN, Netapp Filer storages
• Setting up and testing of Oracle database disaster recovery.
• Oracle 11i cloning
• Skills in applying Oracle apps patches
• Trouble shooting performance related issues concerning concurrent manager
• Skill to implement the business logic and process requirement of clients conforming to standards.
• Implement evolutionary methodologies such as agile in logical database management as part of SLDC
• Organize and participate in technical update on new DBA forums and technology awareness.
• Conduct capacity planning and sizing of database systems as per business needs.
• DBA support experience to interface with middleware products such as IBM WebSphere portal server, BEA weblogic on JVM memory and connection pool size configuration related investigation
• Configure Oracle database and associated resources on VCS cluster with Solaris operating system as part of database failover for high availability.

TECHNICAL SKILLS:

Databases: Oracle 10gR2 with 3 Node RAC, Oracle 11gR2, Oracle12c

Operating Systems: IBM AIX,Linux, Sun Solaris 9, AIX, HP UX and Windows

Storage: NAS, EMC, Net App Filer

ERP: Oracle apps 11.5.10

DBA Tools: DB Artesian V7.0, SQL Navigator, TOAD, EM Database control, EM Grid control and Quest central, Statspack, AWR, Pl/SQL Developer, Precise (I3),Cygwin, Oracle EM Cloud12c

Apps DBA: Modules GL, OM, INV, AR and AP, HRMS Release 11.5.3, 11.5.8, 11.5.9,11.5.10,CRM Release11.5.4

ETL: Ardent Datastage

Data Modeling: Platinum ERWin3.5

Backup Tools: SQL Backtrack 5.0, HP Data Protector, Verities Net backup, RMAN, BCV, EMC Clone, EMC Data Domain Boost for RMAN

Report: Brio, Crystal reports

Development Tools: Developer 2000, All Fusion Harvest CM 5.1.1Work Bench

Scripts: UNIX shell scripting, Oracle Pl/Sql

HA Solution: Oracle Data Guard, VCS, Oracle 10g RAC

PROFESSIONAL EXPERIENCE:

Confidential - Bartlesville, Oklahoma

Senior DBA

Responsibilities:

• Performed in-place as well as out of place upgrades of databases from lower versions to 11g in dev/test and prod on AIX and Linux servers.
• Performed upgrades of databases set up as part of Oracle EM cloud12c DataGuard with multiple physical standbys
• Performed installation of Oracle 12c software in silent mode to multiple hosts through automated shell scripting.
• Performed CPU/PSU patch updates to Oracle 11g ( 11.2.0.3) dev/test and prod databases
• Developed, tested and deployed Unix shell scripts for performing certain database activity such stopping EM agent, database, patrol services during Unix server maintenance or OS level patching activity.
• Implemented data encryption at tablespace level
• Performed trouble shooting and resolved performance issues related application SQL tuning and database backup slowness.
• Performed extensive schema level refreshes using Oracle datapump.
• Performed full database refreshes using RAMAN duplicate backup based and active database based methods.
• Suggested best practice approach to troubleshoot and resolve database issues

Confidential - Bartlesville, Oklahoma

Senior DBA

Responsibilities:

• Migrated several hundreds of test/dev/prod Oracle 10g/11g databases as part of UpStream to Confidential split support using RMAN clone method on AIX/Sun Solaris/Linux OS platforms with Data Domain EMC storage.
• Installed Oracle EM grid control agents, BMC patrol agent, Oracle 10g/11g binaries on several Unix servers as part of new server deployment setup for migration from UpStream to Confidential .
• Setup, scheduled and optimized database backups using EM Grid control Release 5 for the migrated databases.
• Setup and configured primary and standby databases as part of DataGuard setup for several production 10g/11g production systems using Oracle EM Grid control.

Confidential - State of Texas - Austin

Senior DBA

Responsibilities:

• Extended DBA support to implement database changes as part of periodic release management
• As a core DBA evaluated index usage as part of database tuning initiative to improve performance of large OLTP systems of Confidential, State of Texas, Austin.
• Automated Oracle performance data (AWR) save process.. Developed process to save Oracle 10g performance data for trending analysis
• Participate in various performance initiatives through co-ordinated load and stress tests of Texas State portal, Texas integrated eligibility redesign system databases
• Conduct regular schema and database level refreshes of full size environments
• Customized DBA monitoring scripts as part of best practices to identify wait-events and wait time of long running queries on system slowness during online window
• Responsible for managing 3 Node RAC clusters on Sun Solaris 10 of Production and non-production Oracle databases of sizes upto 4.5 TB
• Extend knowledge transfer to DBA team members to handle issues during crisis.
• Extend DBA support to conduct capacity planning and database growth forecast analysis
• Involve in Data Modelling using Erwin to implement schema design changes as per functional and business needs
• Participate in code review and suggest tuning options to save significant time during production code drop
• Involved in Oracle 11g test upgrade

Confidential - Georgia

Senior DBA

Responsibilities:

• As part of Confidential ’s division consolidation, took part in providing primary DBA support to project production database growth and allocate necessary space for merging employee records from multiple production databases to a single large database before consolidation implementation, provided best practices from tuning perspective for better execution of PeopleSoft payroll scheduler jobs.
• Extended 24X7 DBA support
• Upgraded Oracle 9i to Oracle 10gR2 in Solaris 9
• Installed, configured and administered oracle 10g iAS
• Configured and maintained logical standby database using Oracle Data Guard
• Installed and configured Oracle down Streams between local and remote databases on AIX
• Configured RMAN backup to tape for all the oracle10g databases on Unix
• Involved in managing a two node oracle 10R2 production RAC clusters on IBM AIX OS
• Configured a test database for KRONOS time management application conforming to vendor provided documentation from Oracle DBA perspective.
• Implemented an alternate work around to create oracle materialized views from Oracle 10g database to Oracle 9i database as there is a bug in oracle to use ANSI JOINS in 10g database pointing to 9i database using database links.
• Implemented DBA best practices to overcome excessive wait events from tuning and monitoring perspective
• Involve in regular schema level refresh from production to development database environments
• Implemented Oracle 10g key features such as Flash recovery area, Flash back, Data pump in Oracle 10R2 based databases
• Applied Jan 2008 CPU security patch on oracle 10.2.0.2 databases
• Migrated Oracle databases from HP unix to Linux OS using export method

Confidential - Atlanta

Senior DBA

Responsibilities:

• Configured two node Oracle 10g release 2 RAC cluster with ASM on Red Hat Linux and AIX V5.3 OS.
• Configured database and archive log backups using EM database control.
• Tuned redo logs and performed trouble shooting of RAC database related issues.
• Applied DST (Day light savings) patch using Opatch on Oracle 10g databases.
• Applied CPU (Critical patch update) using Opatch on Oracle 10g databases.
• Installed Oracle 10g release 2 and upgraded it to latest 10g patch set on Solaris 9
• Documented procedures as part of DBA support.
• Re-located database flash recovery area from one file system mount point to another.
• Configured export backup using data pump.
• Installed, configured and administered oracle 10g iAS
• Extended 24X7 DBA support for oracle databases on Windows 2003 servers.

Confidential - Atlanta

Senior DBA

Responsibilities:

• Upgraded 9.2.0.6 Oracle development database to 10gR2 on AIX 5.3 system.
• Configured and supported oracle databases on Solaris Unix
• Provided 24X7 production DBA support for Oracle apps 11.5.10
• Involved in resolving concurrent manager issues in Oracle apps databases
• Involved in setting up test and development oracle apps instances
• Hands-on experience in applying oracle apps patches
• Configured VCS cluster for Oracle 9i development, test and production databases.
• Implemented full phase of development, test, pre-prod and prod oracle 9i databases on AIX system.
• Estimated capacity planning for 2 years of database growth taking into account details of LUN’s and required Meta volumes for production database.
• Installed and configured SQL Backtrack to schedule database backups.
• Implemented regular database refresh using SQL-Backtrack.
• Implemented Oracle Data guard in 9i.
• Implemented a detailed monitoring script to capture critical and non-critical alerts such as table space utilization, file system utilization, active sessions, invalid objects, backup failures and OS stats etc., in frequent intervals for any abnormality in the system.
• Implemented Oracle Plan Stability with good tuning methodology to significantly improve application query performance wherever the SQL code could not be enforced with hints in the application side. Used Quest central software to monitor databases.

Confidential - Boston

Oracle Core and apps DBA

Responsibilities:

• Provided 24X7 production database support for Oracle apps HRMS module release 11.5.10
• Performed two node disaster recovery of 11.5.10 Oracle application at disaster recovery site Billerica, USA for Confidential, Boston.
• Performed regular refresh of 11i production database to development instances as part of apps cloning using hot backup.
• Generated monthly database health check reports for oracle apps production instances.
• Cloned two node apps 11i system.
• Installed and administered Oracle 10g on HP UX 11i,Solaris and AIX
• Refresh of 10.7 OE/AR character based production instance to development system.
• Hands-on experience in resolving concurrent manager issues in Oracle apps
• Patching in test and production instances using admerge utility wherever appropriate.

Confidential

Oracle Core and apps DBA

Responsibilities:

• Performed regular database production support
• Estimated capacity plan and carried out installation and configuration of Oracle 8.1.5 Test and production databases of size 64 GB each on HP UNIX 11.10 for electronic products solution group of Confidential, Malaysia.
• Implemented two node disaster recovery of database and ERP application at remote site.
• Tuned application specific PL/Sql queries.
• Installed 2 node oracle apps 11.5.10 test servers
• Installed and administered Oracle 10g
• Set up a standby database as part of disaster recovery plan for production database.
• Carried out database migration from Oracle 8.0.5 to Oracle8i in development Environment.
• Organized good check list and documentation on DBA activities for 24X7 DBA support.
• Performed cloning of two node non-autoconfig enabled Oracle application
• Conducted methodological troubleshooting procedure to resolve issues during and after cloning at client site
• Resolved the major issue of applet yellow warning bar after cloning by applying specific patch and re-generating JAR files recommended by Oracle metalink forum
• Performed general apps user administration such as user profile and role set up
• Performed regular purging of historical data on modules GL and OM for controlling the growth of database through concurrent program schedule
• Performed regular monitoring of active con-current users of oracle apps and resolved the issue of system performance and concurrent manager job failures on regular basis

Confidential

DBA

Responsibilities:

• Estimated capacity plan requirements for Confidential data warehouse
• Created development and test Oracle databases
• Performed all database administration tasks
• Analyzed data flow diagram (DFD) of manufacturing system application namely Workstream and legacy system namely HP 3K from where the manufacturing data is Extracted and loaded to oracle production database.
• Created data model using star schema with Platinum Erwin 3.5.2 as tool.
• Developed coding using PL/SQL functions and Procedures to load flat file data from Informix system into Oracle database.
• Automated the data loading process through HP UNIX shell scripting..
• Conducted database migration from oracle 8.0.5 to oracle 8i in development environment.

Confidential

DBA

Responsibilities:

• Oracle database administration, which includes health checkups of databases, regular cold and logical backups of production database.
• Performed regular monitoring of logical segments such as rollback segments, Table spaces
• Established user security policies.
• Created and maintaining stand-by database as part of disaster recovery plan.

Confidential

Application Developer & DBA

Responsibilities:

• Developed form based loan accounting system to include the following features namely maintenance, loan details maintenance, monitoring receipts from member etc.
• Performed Oracle core DBA activities on development project.

Confidential

Systems Engineer (Software support and development)

Responsibilities:

• To develop and maintain front-end based applications using Oracle 7 and Pro*C primarily to have constant stock of raw materials during entire product cycle of hot rolled flat steel products.
• Designed menu driven interface for reporting like ABC analysis, list of non-moving items, report on pilferage etc.

Confidential

Executive Engineer

Responsibilities:

• Application programming using C language for active process control ofaluminum smelting operation at INDAL, Hirakud (India).
• Developed user interface using C language for active process control duringaluminum smelting operation.