TECHNICAL SUMMARY

• Oracle DBA 25 yrs. , Production Support 13 yrs. , Performance Tuning 10 yrs. , Oracle 11G 5 yrs. , Oracle 10 g 4 yrs. , RAC 3 1/2 yrs. , Sybase 2 yrs. , Solaris 8 yrs. on off , Dataguard 3 yrs. , DB Artisan 1 yr.

TECHNICAL SKILLS

Software: Oracle 11G/10g/9i/8i/8.x/7.x, Oracle 9iAS, PL/SQL, Sybase 4.9, DB-LIB , CCP/RT Tuxedo , Ingres QUEL, SQL , NMAKE, SCCS, C, C , KSH, Perl, CSH, AWK, Turbo Pascal, 8086, Assembly, Fortran 77

O/S: Sun Solaris, Sun OS, HP UX, UNIX System V, BSD 4.3, Windows

PROFESSIONAL EXPERIENCE

Confidential

Oracle Performance DBA

• Experience in X3-8 Exadata frame with two node cluster and active data guard.
• Monitor Oracle 11g Performance and fixing queries which taking long time.
• Used SQL performance analyzer for performance comparison after upgrade.
• Generate AWR baseline and compare performance.
• And recommend proper indexes to tune long running queries.
• Generate 10046 trace and Explain plan using dbms xplan. Review execution plan Predicate Information
• Generating 10053 trace and evaluate why not proper index being used.
• Fine tuned ODI Mapping queries by generating 10053 trace and execution plan.
• Fine tune row level locks, ITIL locks and library cache locks.
• Generate Exacheck reports for I/O related performance evaluation.

Confidential

Oracle DBA

• Install 11gR2 Software create Databases.
• Set up DataGuard for 11gR2 Databases
• Install 12C Monitoring Agents and configure in OMS.
• Find Tune adhoc Queries Coming from COTS Application.
• Install PSU and CPU patches regularly.
• Debug ORA- Errors and resolve by installing one-off patch or setting event in the Databases.
• Resolve RMAN backup performance issue.
• Extensive knowledge of AGILE Development practice, like requirement and design changes
• and continuously developing and deploying.
• Extensive knowledge of SCRUM Methodology by quickly delivering product in changing

Environment.

• Extensive PL/SQL development experience using Packages and handling errors properly using

Confidential

Oracle DBA

• Upgrade 11g Grid Control to 12g Cloud control.
• Install and Maintain Three Node 11gR2 RAC Databases with ASM.
• Debugging ASM disk using kfed and kfod.
• Set up Three Node RAC replication to single node Data Guard Database.
• Wrote autosys job to monitor Data Guard replication using SQL and Ksh script.
• Fine tuning adhoc queries and recommending changes to queries and database parameter changes.
• Refreshing 11gR2 Databases using Duplicate Active Databases Rac and Non-Rac
• Configuring RMAN Backup from StandBy Database using NetBackup MML to Tape Library.
• Debugging Performance issue using strace , ltrace, pstack , lsof and truss, gdb
• Find tuning I/O path using iostat Finding service time as well as HBA Queue Wait
• Configuring VMWARE Rac and Non-Rac oracle template for Private cloud
• Thorough understanding of TCP/IP stack and debugging network performance using netstat, ifconfig .
• Thorough understanding of process structure using /proc filesystem , shared memory, semaphores.
• Debugging performance using top down approach starting from client to server process.
• CPU consumption in user process dump process stack and debugging I/O path .
• and firewall Ports settings.
• Participated in proof of concept for hosting Oracle Database in AWS Cloud. Familiar with EC2, EBS and VPC

Extensive PL/SQL development experience using Packages and handling errors properly using

Confidential

Oracle DBA

• Diagnosis performance issue with truss tusc,strace , lsof, pstack.
• Tuned adhoc queries using 10046 trace and AWR reports.
• Migrated few oracle 9i databases to 10.2.0.4 and set up grid as well as OMS agent for PROD databases.
• Databases, running on Linux/Solaris environment.
• Supporting complex back office environment consisting of 50 plus Production and 200 plus non-production
• Setup ASM 10g database instance on Sun M5000 machine running with Solaris 10.
• Install and configure RAC Instances on Linux OS.
• Fine tune RAC performance using strace and OEM.
• Support RCA databases running on Linux.
• Familiar with OS utilities like truss, dtrace, sed, nawk etc
• Supported DR testing for 20 plus Production databases.
• Extensive PL/SQL development experience using Packages and handling errors properly using

Confidential

Oracle DBA

• Supporting Trading system which is being used by 3000 plus users on Sun Server running on 9.2.07 Database.
• Wrote monitoring scripts which lists 20 top CPU consuming queries using OS utility and Data Dictionary views.
• Wrote scripts to generate reports for top Consuming resources using perfstat tables.
• Tune batch as well as adhoc queries using 10046 and 10053 events.
• Created standby and used standby to refresh QA and UAT systems.
• Restricted rows level access by setting VPD to few critical tables.
• Tuned rman backup so that backup time reduced by 50 of backup time.
• Tested upgrade process from 9i to 10g Database.
• Configured grid environment for 10g Databases.

Confidential

Oracle DBA

• Modified rman script so that backup is taken directly to TAPE Library instead of Disk.
• Setti
• Supporting 12 Terabytes of production 9.2.0.6 Oracle Database on HP-UX superdome machine.
• ng up OEM 10.2.1.0 catalog Database to monitor 9i and 10G Databases. This involved setting up
• Upgrade 9i Oracle Database to 10g Release 2 Database using dbua utility.
• Applied Oracle security Patches in Development, Test and Production environment.
• Maintaining partitioned tables, creating new partition, rebuilding global and local indexes.

Confidential

Oracle DBA

• Installed 10G Release 2 Software on HP-UX and Solaris Servers.
• Upgraded 9i Databases to 10G release 2 Databases.
• Implemented RESUMABLE TIMEOUT at database level.
• Installed Oracle 9i Application server and configured Apache web and Forms Server, IFS, ifs mgr etc.
• Installed Oracle 9i Database Server, created transactional as well as Data Warehouse Database.
• Created a snapshot from Transactional Database to Data Warehouse Database.
• Automated refresh from PROD to DEVP Database.
• Responsible for setting up development, patching and QA environment.
• Responsible for setting up Web server and form server on application box.
• Upgraded Oracle from 7.3.4.2 to 8.0.6.3 and 11.0.3 Oracle financials.
• Wrote 9i Database Backup scripts for 7/24 system Using RMAN, this involves installing MML for EDM, creating Catalog database, Registering Database in EDM as well as in Catalog and writing Shell script which reads from RMAN configured file and accordingly backup hot, cold to EDM tape using multiple Channels.
• Refreshed database from production to development and patching environment using EMC BCV sync/split.
• Refreshed APPL TOP and CUSTOM TOP, re-linking APPL TOP for the development environment.
• Applied patches on PATCH and production instances.
• Unsecured, Generated DBC files and setting the profile for the development environment
• Wrote monitored scripts, Reorg of database objects etc.
• Involved in installing and setting Matrix Server for load balancing.
• Configured shareplex for reporting Instance, Activate configuring, Monitoring Sync and created appropriate Indexes for the performance.
• Familiar with ad patch, ad admin and ad relink.
• Configured Ariba application for four business units and wrote scripts to automatically sync to DEBUG server and start application.
• Set up Oracle Dataguard as asynchronous mechanism. This was implemented to replicate OEM Catalog database.
• Responsible for performance Monitoring using Quest Central 4.0 and homegrown scripts to monitor each session and SGA.
• Used TUSC truss to monitor UNIX process whenever any performance issue.

Environment: Oracle 10g/9i/8i/7.x, Oracle Financials 11.0.3, Oracle 9iAS, RMAN, Shell Script, Sun Solaris 12K Server , HP UX

Confidential

Oracle DBA

• Responsible for setting up stand by environment for the PeopleSoft 7.0 running on HP-UX 10.20 with Oracle 7.3.4.4. Test standby switch over by changing machine name and IP address.
• Migrated Oracle and PeopleSoft from T600 to K570 HP Box with EMC Symmetric.
• Wrote Hot Backup script and Alert Script for space management.
• Tuned PeopleSoft application queries.
• Created snapshots to replicate tables from production database to data warehouse instance.
• Installed and configures EBU with omni back for backup and recovery.

Environment: Oracle 7.3, PeopleSoft 7.0, HP-UNIX 10.20

Confidential

Oracle DBA

• Upgraded Oracle financial from 10.5 to 10.7 smart clients.
• Responsible for setting up concurrent manager and queues. Installed noetix 1.5 views on 10.7 applications.
• Installed Oracle Express 6.2 and CASE repository for Oracle application.
• Installed 10.7 NCA along with 3.0 Oracle application web server and forms server Developer 1.61 .
• Configured WEB Server, FORM Server for 10.7 NCA environments to run custom forms.

Environment: Oracle Financial 10.5/10.7, Oracle Express 6.2, Forms, Noetix 1.5, Oracle Web Servers, Sun Solaris

Confidential

Oracle DBA

• Installed Oracle 8.0.3 on HP-UX 10.20 and later upgraded to 8.0.4.1.
• Created Database following Oracle OFA architecture.
• Ported data from Sybase database to Oracle Database using BCP and SQLLDR.
• Designed and implemented Backup and recovery mechanism.
• Wrote Cron jobs using shell and SQL Plus /PL/SQL to upload data.
• Tuned for data warehousing application by applying star schema and multiple I/O read count and bitmapped index.
• Involved in writing stored procedures, triggers and applying constraints.

Environment: Oracle 8.0.3/ 8.0.4.1, Sybase, SQL Plus, PL/SQL, HPUX

Confidential

Oracle DBA

• Installed Oracle 7.3 on IBM RS/600 running AIX 4.2.
• Created logical model for the database using Erwin.
• Implemented Physical and logical designing of the Data Warehousing Database.
• Responsible for primary production and development DBA for three distributed Oracle databases on AIX 4.2 O/S using IBM RS/6000 platform , with 100 concurrent users.
• Implemented and tested new backup and up-to-minute disaster recovery plan, performance tuned SQL, SGA and I/O e.g. usage of asynchronous I/O and UNIX-level I/O operations.
• Developed administrative UNIX and Oracle scripts to provide for automated, proactive database monitoring and maintenance.
• Responsible for setting up an Oracle WEB server and CGI script to create web page for viewing status of Backup procedure.
• Created Clusters, Packages, stored procedure, triggers and snap shots etc.
• Wrote Hot and Cold Database backup scripts.
• Monitored SGA and Tuned SGA.

Environment: Oracle 7.3, PL/SQL, SQL, Erwin, Web Servers, CGI Scripts, AIX 4.2, IBM RS/6000

Confidential

Oracle DBA

• Upgraded Oracleback segments, archive logs, Oracle parameters, etc.
• Designed an 7.0 to 7.2.1 Database and designed the logical and physical database.
• Tuned Rolld implemented backup and recovery procedures using Korn and shell scripts.
• Installed 7.3 on SUN server.

Environment: Oracle 7.x, Korn Shell Script, Sun Solaris, Sun Server

Confidential

Oracle DBA

• Responsible for installation of Oracle on HP-UX/9000 Machine.
• Created initial database and designed physical database layout.
• Estimated database size and loaded legacy data to Oracle tables using SQL Loader.
• Installed SQL NET 2.0 and set up configuration files for SQL Net.
• Replicated application tables to seven region machines using Oracle snapshots.
• Tuned Rollback segments, archive logs, oracle parameters, application queries etc.
• Designed and implemented backup and recovery procedures.
• Wrote several DBA utility tools using, SQL PLUS and UNIX SHELL.
• Wrote stored procedures and Database triggers using PL SQL for and USF application.
• Tuned views and SQL queries.

Environment: Oracle, PL/SQL, SQL Loader, SQL Plus, SQL Net 2.0, SQL Queries, UNIX Shell, HP-UX/9000

Confidential

• Involved in the design, development and testing of Portfolio Management System PMS which receives different format portfolio files from different clients and according to format defined for that client.
• Normalized portfolio database in DLJ format using Pro C.
• Generated different kind of reports using INFOMAKER.
• Responsible for the installation, initial tuning and performance tuning of ORACLE 7.0.
• Estimated the database size for initial production database.
• Designed database security, user management, and backup procedures for recovery.
• Responsible for setting up parameters for rollback segments, log files, and SGA.

Environment: Oracle 7.x, Pro C, PowerBuilder 4.0, INFOMAKER

Confidential

Oracle DBA

• Responsible for the installation, initial tuning and performance tuning of Oracle 7.0.
• Estimated the database size for initial production database.
• Designed database security, user management, and backup procedures for recovery.
• Responsible for setting up parameters for rollback segments, log files, and SGA.
• Developed stored procedures, functions, packages and triggers for database integrity.
• Helped developers to tune SQL statements in their application.
• Also responsible for Unix System Administration activities such as: installing UNIX, setting up for network connectivity, setting up NIS setting up master NIS server and client, NIS maps etc , setting up NFS mounting File systems, setting up DAEMONS etc , adding disks, configuring kernel, backup and restore tapes, adding remote as well as local printers, monitoring system etc.

Environment: Oracle 7.0, SQL, UNIX/NCR 3450, UNIX

Confidential

Oracle Developer/DBA

• Involved in the design, development and testing of DACS-VI Digital Access Cross-connect System software which allows to provision network element DACS-VI using Base works CCP/RT, Tuxedo, LOGDEAMON, and LIBFT , Oracle database and PRO C.
• Responsible for maintaining and installing Oracle database for the development and test environments.
• Involved in porting of DACSscan software from 3B2 machine to HP-9000 series workstations.
• Used X-Runner to write X-window test script to automate testing of DACScan software on HP-9000 series workstation.

Environment: Oracle, Pro C, CCP/RT, Tuxedo, LOGDEAMON, LIBFT, X-Runner, SunOS 4.1, Sun Sparc, HP-9000 Series

Confidential

• Involved in the design, development and testing of the Service Agency Mechanization System SAMS , which replaced the manual system for the AT T consumer center. This system involves communication between laptop and central processor AT T 486 , which kept track of Inventory, Order processing, Compensation processing and Report generation.
• Wrote a incremental database backup restore shell scripts, which allows to automatically backup database daily without changing the cartridge tape on 320meg or 1.3geg tape drive and restore back the database from the tape.

Environment: Sybase, DB-LIB, ISQL, Shell Script, UNIX

Confidential

• Involved in the design and implementation of a DAEMON FTFI process using IPC messages which takes request from different processes and depending on message type it does different functions like table copy, update, delete, file transfer to another machine, table copy update, delete to remote machine.

Environment: Sybase 4.9, AT T Unix