Summary
Oracle Database Administrator over 7+ years experience Mid-Range UNIX HP-UX, AIX, Solaris and Windows
Platforms. Have production support DBA experience providing 24/7 support from 10 to 55+ Oracle Databases
250+ Databases inside the 5 dba team during off hour support. Extensive knowledge in all aspects of database administration but not limited to installation and configuration of Oracle 8i, 9i and 10g, troubleshooting, patching, upgrading, security, backup and recovery, performance monitoring and tuning, created/managed databases on IBM HACMP and SUN VCS cluster servers, installing and maintaining 9i Dataguard environment, executing Physical with DR datacenter and Sungard servers and tabletop disaster recovery exercises.
I will travel to any part of the country at my own expense and relocate if required at my own expense.

Employment

June, 2008 -  June, 2009
Senior Database Administrator

Primary responsibility to support several production, test and development databases on HP-UX 11.11 platform, running off the shelf Ellipse, Allegro, Equity edge, Tripwire, Numara and homegrown applications RMS, LMS, RCMS, Warehouse
Support Oracle application server installs on dev, test and production environment 10.1.2.0.2 running forms and discoverer. Patched 10g application server and discoverer environment from 10.1.2.0 to 10.1.2.3 using metalink and oracle documentation in sandbox and test environments. Create users and grant permissions sharing workbooks, grant privileges under EUL, etc. using discoverer administrator. Troubleshoot Oracle Application Server environment using metalink support documents and documentation from Tahiti. oracle.com. Edit and configure formsweb. cfg and default. env files for new forms based applications
Recovered database on Sungard servers for Disaster Recovery exercise using RMAN hot backups

Installed and created 10g databases Dev, Test, prod, configured the database for Warehouse implementation. Cloned schemas and databases using rman duplicate, exp/imp from Prod to Dev and and Test. Modified procedures, deployed profile, etc for generating audit report to comply with SOX and audit requirements. Applied periodic PSU/CPU Security patches to 21+ oracle databases in dev 6, test 9 and prod 6 database environments.

Upgraded Ellipse and other apps databases from oracle 9i to 10g using metalink document on manual upgrade process and applied cpu patch on the upgraded database. Create and drop uses as requested and grant/revoke permissions as per their roles. Patched databases from 10.2.0.3 to 10.2.0.4 for cpu patching to comply with sox and other policies.

Deployed profiles, password functions and lockdown process to database accounts and environment to comply with enhanced security standards/policies baseline control standards, audit vendor standards, etc.

Troubleshoot database connectivity and performance problems as required, install and configure oracle client for off the shelf apps on user desktops. Work with application vendor in troubleshooting problems.
Run AWR and statspack reports to identify sql with large buffergets and physical reads per execution. Run sql tuning set s exercise to identify any index recommendations to be implemented. Created/rebuilt indexes and computed stats to decrease physical and logical i/o on the sql executions used v$ views and top to identify the problem sessions. Assist developers in troubleshooting sql execution_plan/performance using event 10046 setting at the session level to decrease the execution time for sqlcode, procedures, etc..
Assist functional administrators to troubleshoot connectivity odbc, sqlnet and sql plan tuning exercises. Grant permissions and setup database environment for off-the-shelf software/packages. Troubleshoot and patch Grid and database environment with oracle SR/TAR request process using RDA utility and tracing for agent and oms.
Upgrade Emagent for 10g grid control to resolve errors appearing under emagent. trc, emagent. log, emoms. trc files with assistance from metalink documents and documentation. Rediscover new components created on the database servers for monitoring. Deployed apex development tools in a sandbox environment

COMPUTER TOOLS
Databases : Oracle 8i, Oracle 9i 9.2.0.8, Oracle 10g 10.1.0.4 - 10.2.0.4
Operating Systems : UNIX HP-UX, Win 200x

TOAD 8.x, ER-Studio, SQL*PLUS, OEM Administrator Tool DBA Studio, 10g OEM Grid control tools
Sql_trace/tkprof, Putty, MS-OFFICE 200x top, vmstat, Oracle Application Server 10.1.2.3

August, 2007 -  August, 2008
Senior DBA

Primary responsibility to support several production, test and development databases on Solaris and Windows 2003, Oracle 8.1 .x thru 9.2.0.7 stand alone, homegrown replication.

Cloned database using hotbackup and backup controlfile option on Solaris, rehosted databases across servers, created and configured database environment for Ingrain, Protegrity, Voltage encryption dbtool, configured extproc listener and settings for encryption application testing, assisted developers and vendors for table level data changes and testing using event 10046 and tkprof. Assisted in deploying Protegrity s VPDISK encryption tool on oltp and warehouse test databases as part of pilot project. Was given SPOT award for participating, assisting and evaluating different encryption tools.

Co-ordinate tasks with offshore dba s for database work running audit scripts, tasks assigned directly by clients etc on Solaris and Windows 2003 Platforms.
Setup/configure Rman backup scripts for full backup and archivelog backup. Troubleshoot and loaded data for character set conversion from usascii 7 to utf8. Upgraded database from 9i to 10g for Lawson application.

Tuned database using statspack reports, creating new indexes, computing stats on tables - to decrease the physical i/o 3k/sec to < 100/sec and logical i/o 8k down to 3k per second on sql statement executions and inturn reclaiming cpu usage using event 10046 trace and tkprof. Assisting other dba s in the team troubleshooting performance using v$session, v$session_wait, x$bh, v$sql_plan, etc. views, connectivity and database problems.

Assisted other dba s in troubleshooting their database performance using sqltrace/tkprof and v$ views

COMPUTER TOOLS
Databases : Oracle 8i, Oracle 9i 9.2.0.2 - 9.2.0.7, Oracle 10g 10.2.0.4
Operating Systems : UNIX Solaris 8 - 10, WIN200x

TOAD 8.x, Precise-Indepth, SQL*PLUS, OEM Administrator Tool DBA Studio, Sql_trace/tkprof, Putty, MS-OFFICE 200x lotus-notes/email, top, topas, vmstat, prstat

January, 2006 -  January, 2007
Senior Database Administrator

Primary responsibility to administer and support oracle databases running Cerner, Lawson and other applications on AIX and oracle 9.2.0 .x, 10.1 .x, 10.2.0 With Standalone, Physical Standby and Dataguard sizes upto 1.4TB on RAW and JFS2 file systems

Secondary responsibility to administer and support MHP-subsidiary oracle databases 8i, 9i 10.2 running on AIX and Window 200x platforms used by homegrown and vendor products. Oversaw tasks of 2 other dba s for MHP databases 8i, 9i, 10g. Tracked and worked on issues, tickets and resolve performance/database issues/problems.
Performed required tasks create users, grant permissions, run scripts, clone schemas as per work-order tickets as requested by end users, QA-Analysts, Vendor engineers and developers. Resolved database connectivity problems under sqlnet, ldap, odbc, oledb drivers, Lawson/pactrac interface setup.
Cloned databases using a RMAN duplicate using TSM TDPO, b hot disk backups, c export/import across hosts. Configured TDPO settings for RMAN backup using tdpoconf utility and dsm. opt/dsm. System files. Deployed backup RMAN, tsm/tdpo and monitoring scripts for test and production databases.

Recovered databases on Windows and AIX platforms due to disk and hardware problems. Trained other dbas 1on1 on database maintenance and installation/configuration activities. Installed and created 10.2 database on Linux REL 4 for TADDM application for proof of concept process.
Restored production databases for DR Disaster recovery exercise on Sungard servers using previous hot backups and RMAN scripts. This included planning and execution of recovery with assistance from System Administrator and TSM administrators.
Recovered and troubleshoot of Tecsys Production/warehouse database, created standby database under 8.1.7.4 for DR/HA and Reporting.

Tuned database environments using statspack, sql scripts, OEM tools Sql Analyze, Sql Expert, coalesce DMT s, Computing stats, sqltrace/tkprof analysis. Troubleshot database problems using oracle OEM and querying v$session, v$sql, v$sql_plan, v$session_wait, UNIX topas, sar and Win 200x process monitor, performance monitor, counters and other utilities by sysinternals.com tools.
Worked with System admins, storage and backup admins to setup the oracle environment, backup process using RMAN under TSM and Legato/Networker MML. Created and maintained RMAN catalog on production environment.
Provided on-call off hours Monday thru Monday dba support for all of the production databases across Mercy IS on pager rotation in the dba team.
Prepared and Presented on Oracle High Availability for Lunch and Learn session for DBA group. Topics covered were RAC, Hardware Clustering. Wrote draft Policy documents on Oracle Binary installation and Support and Database Tuning. Developed a requirement document for RAC deployment to be used for TIBCO application.
Developed Trigger and 2 Packages with few small procedures for PHR application for inserting, updating tables as per application requirements.
Provided database support and cloned production databases for Cernerworks Remote Hosting support. Used Rman to create the standby clone on the Snap Drive.
Installed and configured 10g agent on existing server and troubleshoot 10g GRID installation using Metalink and oracle documents. Monitored database performance using AWR snapshot reports, sql tuning tasks, ADDM reports. Monitored and troubleshoot IAS, OID and GRID infrastructure using metalink and oracle documentation.

Was awarded Geek of the Week award for working with technical teams, vendor and recovering the production database.

COMPUTER TOOLS
Databases : Oracle 8i, Oracle 9i 9.2.04 - 9.2.0.7, Oracle 10G 10.1 10.2
Operating Systems : UNIX AIX 4.3 - 5.3, LINUX, WIN200x

9i SQL Analyze, TOP Sql, Oracle OEM Administrator Tools DBA Studio, Index tuning wizard, Oracle expert, 10.1 Grid ADDM, SQL Tuning task, snapshot reports, etc.., DBArtisan, Raptor, tkprof, View-now, Putty, MS-OFFICE 200x Perigrine, CYGWIN/X, PL/SQL, top, topas, vmstat, truss

December, 2001 -  December, 2005
Production/Physical DBA

Installed binaries and Created/Supported 55+ Oracle 8i and 9i databases on Midrange Solaris, AIX, HP-UX servers standalone and HACMP/VCS Clusters. Recovered, migrated and monitored databases with different
Backup solutions TSM and Netbackup Disk, RMAN with catalog Database, managed databases up to 350+GB in size
Configured monitoring, startup/shutdown and Backup scripts, BMC-Patrol KM for monitoring production databases. Recovered databases as required point in time, backup control file, hot and cold backups, full and partial exports, RMAN.
Upgraded and patched databases TO 8.1.7 .x, 9.2.0 .x on Production, Test and Development boxes. Compiled packages and procedures during migrations and upgrades using utlrp, scripts and command line
Installed and configured Physical Standby Data guard databases for Micromuse-PrecisionTN application.
To provide High Availability inside same data center with 15 minute delay between primary and standby Database s.
Recovered Standby database for unit/acceptance test activity. Patched standby database pairs from 9.2.0.3 to
9.2.0.5
Troubleshoot cluster environment during Outages due to hardware/software problems. Provided 7x24 on-call support under pager rotation inside the 5 dbas team.
Migrated and re-hosted several databases across different OS platforms Solaris to AIX, NT to Solaris, AIX to AIX servers. Supported databases which ran different kinds of OLTP and DSS applications Billing, Shopping-cart, Content manager app, websphere-portal, Optical Network surveillance management, Outside plant management, CNM app for ATM and Frame-Relay. Created tables, indexes, views for new and 3 rd party applications. Migrated tables, packages and procedures from development to Test and Production environments using export/import utility.

Migrated data using export/import and loaded delimited flat file data using sql loader. Assisted application dba s for database security setups and other application related work creating roles and create and run scripts for granting select, insert, update by querying v$ views, dblinks, migrating schemas, advanced queue configuration.
Ran statspack report periodically to monitor performance and tune initsid. ora parameters. Used OEM dbastudio, sqlanalyze, topsessions and command Line tools sqltrace, tkprof, autotrace, v$session_wait, x$bh to tune sql and re-org database objects hot blocks. Collected schema level statistics CBO on tables/indexes, created indexes to resolve response time on SQL queries. Worked with internal oracle support to tune sql queries. Tuned environment to increase CPU idle time upto 85+% on 1 of the servers and reduced outages during heavy load on several databases.
Troubleshot and debug database connectivity problems using sqlnet tracing client/server, listener tracing, tracing UNIX system calls and errors using truss utility. Debug JDBC connectivity problems using java test scripts and jdbc system call tracing.

Monitored and assisted application groups and testers during unit testing, load testing and failover testing activities of application environment or footprint.
Assisted in Migrating SQL server and Informix database to Oracle using Oracle Migration Workbench for test and production environment. Provided feedback on Annual Capacity Planning for disk storage, by monitoring disk/tablespace usage for data and backups.

Collected and provided project requirements on database implementation calls, for file system layout design, security, monitoring, kernel settings on OS. Worked with other SME s System Admins, Backup, Storage Administrator during deployment of database for application group use. Provided disk storage and implementation time estimates for deploying oracle databases on New solution Projects and enhancement Projects.
Created oracle filesystems layouts on Hitachi Storage Array using LUN information output from xpinfo utility. Also created oracle filesystem layout from EMC disk/LUN information. This was done provide physical separation of data and backup file systems as per Oracle OFA recommendations.
Used Change Management tool Vantive and change management Processes for database related changes and problems. Assisted new team members on processes, installations and OS environment.

COMPUTER TOOLS
Databases : Oracle 8i, Oracle 9i, Oracle 10G
Operating Systems : UNIX HP-UX11 and 11i, AIX 4.3 - 5.1, Solaris 2.8
Hardware Technical Knowledge : EMC Symmetric 8730/8430 Storage Arrays, Hitachi/HP Arrays

SQL Analyze, TOP Sql, Oracle OEM Administrator Tools Index tuning wizard, Oracle expert, Migration Workbench, truss, tkprof, TOAD, Exceed, View-now, MS-OFFICE 2000, PowerPoint, Vantive, Panagon, PL/SQL

July, 2000 -  July, 2001
Application DBA

SBC/AT and T Services, Inc St.Louis, MO worked on the Budget and deployment plans for the Project Mainly on EMC data storage, network Planning, HP midrange servers. Actively worked in a team defining requirements for high availability computing for the Telcordia applications server layouts, storage layouts, backup assurance, high level DR hardware design, with business requirement of < 30 minutes data loss and < 1hr failover of application to DR site worked on the Failover Testing Team for Server failover using M/C service guard Included business requirements, technical requirements, solution plan, analysis. Extensively worked on the hardware sizing, EMC storage price estimates, disk sizing, Fibre channel counts, BCV's, SRDF, backup and recovery assurance for databases
Created and configured Oracle 8i databases for various Telcorida Apps Delivery, Surveillance Manager as per SBC standards. Acquired technical knowledge on TNM, CNM, ATM-Forum architectures and concepts thru self study OO Model of NE, EMS, Provisioning/Inventory, Configuration management-CM, Surveillance management-SM, Fault Management-FM, North/South bound interfaces, PTP/CTP/link concepts, FCIF, NDD, SNMP, MIB/TL1/CORBA, ATM cloud, DSLAM, RT, for the lower transport/network/datalink/physical layers under 7 layer OSI Model.

Installed and configured Oracle 8i and MS-SQL server binaries on the WINNT 4.0 server for internal use. Created a development database on the same server. Installed and configured Middleware Visiborker ORB 3.3, TOPCOM, BBCS, SysPilot and Oracle database for prep work on the HP Boxes for Acceptance Testing. Actively worked with installers on debugging UNIX OS related issues IPC, deamon process settings, network communication issues, Permissions

Installed and implemented Echangeman SCM Tool from Serena, PVCS-Tracker, tools for the team using Oracle, MS-SQL Server DB's. For Work Tracking, Release management, Change management Processes.
Migrated Oracle database schema from NT to UNIX environment through Oracle logical Export and Import utilities
Migrated Access data to Oracle schema for PMTS application, this included, Creating Database tables, constraints. Used ODBC pipe to load data into Oracle and PL/SQL scripts to populate the tables

COMPUTER TOOLS
Databases : Oracle 8i, SQL Server 7.x, Access
Operating Systems : UNIX HP-UX, NT 4.0
Hardware Technical Knowledge : Midrange Servers HP, SUN, RS6000, EMC Symmetric 8730/8430 Storage Arrays, Hitachi/HP Arrays

Oracle OEM Administrator Tools, Exceed, View-now, NCR Queryman, MS-OFFICE, PowerPoint, Vantive, PVCS-Tracker, E-changeman, PL/SQL

September, 1993 -  September, 2000
IT Administrator

Installed and upgraded Progress 4GL Database on server and clients. Designed and created custom modules for sales Database app. Tuned Database parameters for performance. Installed and Configured SCO UNIX ver's, configured serial interfaces and network clients for login and Intermec data-collection equipment. Tuned KERNEL parameters for resource usage and system stability.
Installed and configured NT server OS, performed user Administrator on various shared resources on the file server. Installed, upgraded various client OS's Win95, Win 98, NT 4.0 Workstation
Installed and implemented Post. Office SMPT email server POP 3 from Software.Com on NT. Worked with local ISP in setting up MX records, Registering domain name for the company on Internic. User Administrator and security Administrator on the mail server. Installed and implemented Microsoft IIS server. Installed and configured Proxy server WINPROXY2.0 for internet access on a HDSL pipe
Installed and configured Network nodes and remote nodes on a WAN-T1 to the network, with corresponding updates to the UNIX and NT database files. Installed and configured N/W hardware Switch, Hubs, Routers, Multiplexer, for data and voice communication and HP Jetdirect print servers. Installed Network Backup solution of all the Servers and clients using CA-ArcServer and Sony AIT network tape drive
Installed and upgraded SYMIX ERP software, Administered users on various Modules permissions, menus, etc.. Assisted and Trained Users on the ERP modules and Business Flows. Setup and audited parameters on various modules Account codes, unit codes, depts, product codes, calendars, etc. Installed and configured data-collection module for Time and Attendance. Closely worked with vendor for problem resolution and patch upgrades.

Education

Training
Enterprise DBA System Architecture and Administration from Oracle yr 2000
Backup And Recovery Workshop from Oracle yr 2000
Performance and Tuning Workshop from Oracle yr 2001
SQL Tuning Workshop from Oracle yr 2001
Introduction to PL/SQL from Oracle yr 2001
Developing PL/SQL Program Units from Oracle yr 2001
Oracle 9i For Administrators from Oracle yr 2002
Oracle 9i Real Application Cluster from oracle yr 2005

Oracle 10G Real Application Cluster Refresher course from Oracle on-site yr 2008
Concepts on Customer Service for Information Technology personal yr 2008
Oracle seminars on High Availability Computing Environment , Intro to OEM , Oracle SQL Tuning
Project management concepts yr 2008
Patrol Administration and Configuration Training
Object Oriented Analysis and Design Using UML From Barker Pacific Group
Workshop on using Panagon for document storage
Basic Telephony overview by SBC Center for Learning
Basic Data Communications and Networking by SBC
Understanding ATM in Corporate Networks by SBC
Manager's camp for individual contributors by SBC CFL Project Management related
Capability Maturity Model Overview
IT Quality System Overview Project Life Cycle Related
Acquired SYMIX System Administration , SYMIX System Customization and Progress
Language Application Certificates from SYMIX Computer corporation Front Step 1993
Meractor data mapping and Administrator from TSI corp or Mercator Corp
Seminars on Managing an IS project , Advanced Excel , Understanding Financial statements from Dun and Bradstreet 1995
Lava Kumar

Miscellaneous
Installed and configured standalone EDI software, setup profiles for various customers Wal-Mart, K-Mart, BB and B, OfficeMax - ANSI X. 12 - 850 855 864 810 856 Debug and monitored EDI transmissions with various VANS and SYMIX ERP pkg. Integrated RPS Multiship application with ERP, for small package shipping using 3'rd party software TracerX, vendor scripts and sql statements using ODBC for shipment tracking, this eliminated duplicate data entry and enabled online shipment tracking.
Upgraded SYMIX Ver 2.7 to Syteline 2.x ERP from host based to client server configuration. Collected requirements for the upgrade hardware/software/licensing costs, Budgeted expenses Timeline and Schedule for upgrade and training. Coordinated with Vendor consultant for training and implementation
The project was completed in the $100K allocated budget and timeframe used MS-Project and excel for the project related tasks.
Migrated historic sales data from IBM System38 into Progress Database : extract data from IBM system, load data into Progress 4GL Database, massage and populate data for sales tracking
Designed and Developed Sales Tracking and forecasting Application data warehouse and Employee Incentive pay applications - Collected requirements from sales managers, production managers, shop floor schedulers and employee contract documentation. Developed database logical/physical design with 15 - 20 entities spread across 20 tables using MS-Office tools. Developed data entry screens, stored procedures, menus, using Provision. Developed backend scripts progress - sql and shell scripts to run under cron to collect and update sales information under monthly buckets from ERP software. Developed utilities to massage and update the product forecast information into the MRP engine and incentive pay information into payroll tables.
Negotiated and implemented long distance carrier for company wide phone system from MCI to Sprint, Negotiated and implemented Voicemail into the existing DBS phone system total budget of $20K, installed and configured additional extensions to the existing phone system.
Upgraded and installed hardware and software for Y2K compliance on ERP software and Intel based servers and PC clients, responsible to investigate vendor Y2K compliance
Installed and implemented Barcode solution for printing SCC14, UPC and SCC18 barcodes for Retail line of products. Integrated Barcode application with ERP software using ODBC pipe for online label printing and tracking for Retail and OEM line of products. Extensively developed reports and tracked product sales on Wal*Mart Retail-Link DSS App. Extensively used Monarch for developing custom reports for auditors, year-end procedures and Sales and Account Depts
COMPUTER TOOLS
Languages : SQL, Progress 4GL
Databases : Access, Progress 6.2 Thru 8.x
SDK's : Provision 7.x,8.x,
Operating Systems : UNIX SCO OPEN Server, Linux, MS-DOS, NT 4.0, WIN. xx
Hardware Hands-on and Technical Knowledge : Intel Based Servers Dell, HP, PLC's, IBM Compatibles
Networking Hardware Hands-on : 3Com Super stack 1000, 3Com Boundary Router, Adtran TSU 120 Multiplexer, HPJetdirect, Print servers, Hubs, Intermec data collection hardware
Networking Apps : SCO Runtime TCP, NT 4.0, ICETCP, NFS
EDI : TPPC 32, RADLEY
Bar-coding : Printware 32, Loftware
Graphic and CAD Software : Corel Photo Paint 7.0, Photoshop, MS Image Editor, Autocad V14 and Lite