Experience Summary

• Strong knowledge and experience on Oracle 7, 8i, 9i, 10g, 11g with 10 years of Production experience as an Oracle Database Administrator.
• Experience managing Oracle database on LUW platforms.
• Experience with administration of high-performance and large-scale, multi-terabytes database installation, migrations, upgrades, patches, tuning ,monitoring, backup, recovery and disaster recovery implementation.
• Design, test and implement high availability solutions – VCS, Data Guard, Real Application Clusters.
• Configure Oracle database on a variety of Virtual environments Solaris zones, Linux Xen and VMware.
• Oracle configuration on diverse storage types like FAST-T, EMC, 3PAR, ASM.
• Performance Tuning, proactive and reactive for optimal performance to meet Business SLA.
• SQL& PL/SQL programming in Oracle Database Administration activities.
• Backup and Recovery using RMAN, Flashback Recovery and Block Media Recovery techniques.
• Configuration of TDE and Oracle Advanced Compression.
• Familiar with utilities like SQLLDR, Oracle Export/Import, Data pump, Scheduler.
• Experience on handling OLTP and Data warehouse database with sizes varying from 100GB to TBs of data.
• OEM configuration for Centralized monitoring, tuning, deployment & provisioning.

• Oracle 7.3,8i,9i ,10g,11g
• Real Application Clusters (RAC)
• Performance Tuning
• Security Administration
• TDE, Partitioning
• Data Guard
• Disaster Recovery Solutions
• Oracle Enterprise Manager (OEM)
• Recovery Manager (RMAN)
• UDB 9.x
• Unix Shell Scripting, PERL
• SQL, PL/SQL
• Pro*C , C, C++, Java, VB6.0
• Solaris, HPUX, Linux, AIX, IBM z O/S
• Windows NT, 2000
• HTML,ASP, PHP, JSP
• IIS, PWS, Oracle 10gAS
• SQL* Forms(3.0, 4.5, 6i), VSS

• Bachelor of Technology in Computer Science and System Engineering.

Work Experience Summary

Nov’04 – Present: Oracle Database Administrator at Confidential,AL

• Production DBA supporting over 200 Oracle, 40 UDB development, test, production database size ranging from Gigabits to multiple Terabytes.
• Planned, coordinated and implemented database migration from 9i to 10g and 11g.
• Design, implement and support for Regions Mobile Banking 11gR2 RAC database on Linux.
• Installation of Quarterly CPU, PSU and other interim fixes released by Oracle Support.
• Ensure strong back up and recovery standards are in place to meet business SLA to restore database operations after failures.
• Administer and maintain database security policies and procedures.
• Installed and configured Oracle Internet Directory to enable central management of TNS services.
• Installed and configured Oracle Enterprise Manager and Intelligent Agents for enterprise level monitoring of all Oracle database.
• Configured Oracle database and Agents on high availability environments like VCS.
• Refresh of development and reporting environments using RMAN, data pump, Transportable Tablespace and logical database models.
• Production database recovery for single instance and RAC database.
• Design scripts for bulk load/unload for DW environments, partition exchange.
• Configure TDE to encrypt business critical data at rest.
• SQL query tuning for optimal performance and worked with Application teams to achieve maximum through put by enhancing SQL queries.
• Online Reorganization of huge Tables and Partitions for optimal performance and space utilization of the database.
• Configuration of Heterogeneous Services using ODBC and third party drivers to connect to various RDBMS (SQL Server, TeraData etc) from Oracle database.
• Experience in developing Stored Packages, Functions, Procedures, Materialized Views and Triggers.
• Actively work with Oracle Support in resolving ORA-0600 and other undocumented bugs and issues.
• Compose, maintain and Monitor compliance to standards and practices. Assist IT Analysts on technical database issues and features. Resolve data integration issues. Enforce standards for data usage and population.
• Strict adherence to policies and procedures - specifically in regard to change management.
• Involved in various Merger related activities related to conversion at the Enterprise Level.
• Production coordinator to ensure all standards are met before goes live.
• Provide 24x7 technical support as a part of on call rotation and whenever necessary.

Environment : Oracle Enterprise Edition 8i, 9i, 10g, 11g, Sun OS 5.x, AIX, Red Hat
Linux, Windows Server 2003, Perl, Shell Scripts, IBM z O/S, TSM
TIVOLI, VERITAS Net Backup, Oracle Enterprise Manager 10g/11g,
Oracle Intelligent Agent, Oracle Internet Directory.

An in-house project for DBA Team to view the information related to various Oracle, SQL Server, DB2 and Teradata database. The portal provides one stop central access to all information related to the startup / shutdown times, Backup status for all database in the organization, License Information etc. It also hosts a repository of all internal documents needed for installation, upgrade and all DBA related activities in the company.

RESPONSIBILTIES:

• Installation and configuration of Oracle 10gAS infrastructure and Oracle 9i Database.
• Design and creation of the database objects required for the portal.
• Creation of Dynamic Portal pages to connect to different servers and get the updated information about the status of various databases dynamically.
• Creation of database links, procedures and system level triggers to dump the startup and shutdown information in to the central repository database.
• Procedures to run the Operating System commands from the oracle environment to gather various information like no of CPU’s RAM information etc.
• Dynamic page with built in Procedures to read an OS directory and display the files as links to download and vie w from the portal.
  

Environment : Oracle Enterprise Edition 9.1.0.5.0, Oracle 10gAS, SQL, PL/SQL,
Sun OS 5.9, HTML, Java Script

Sep’ 02 - Sep’04: Assistant System Engineer at Confidential,INDIA.

Integrated Standard Banking System

Integrated Standard Banking System is total bank mechanization software product developed by Tata Consultancy Services and deployed at more than 1250 Branches across India. Designed using Oracle RDBMS, C, Forms 4.5 & Pro*C it runs on different flavors of UNIX. It comprises of core package consisting of modules for transaction processing with add–on modules like ATM, Tele-banking and Multi Branch Banking. It deals with banking functionalities like Deposits, Flexi-Deposits, ATM, Clearing, Transaction Processing, Debit card interface etc. It caters to the needs of the leading financial institutions in India like Bank of Baroda, Oriental bank of Commerce, Central Bank of India and PNB.


RESPONSIBILTIES:

• Site In-Charge for Bank of Baroda handling 28 Bank Branches in and around Mumbai.
• Installation of production and test Oracle Database Servers 7.3 (Enterprise and Work Group Servers) using manual scripts.
• Database planning and administration including logical design, physical design, backup & recovery.
• Implemented Conventional Hot backup, Cold Backup and Export Backup using Export utility provided by Oracle.
• Recovery of database from loss of control file, loss of data file, oracle internal process terminations. Importing of lost data into production database using Import utility.
• Deployment of application sources (SQL FORMS4.5, Pro* C) and compilation on various UNIX environments. Handling new installations at Banks and deploying new sources for up gradation of the software.
• Testing, debugging programs for enhancements and change requests using Pro*C & PL/SQL.
• Requirements gathering and crystallization of change requests.
• Change Requirements Servicing, Bug Fixes, Testing and Integration and releases of the enhanced programs.
• Involved in the coding and implementation of Universal Teller module using oracle Forms 4.5 and PL/SQL, Pro* C for Bank of Baroda. Developed Unix Shell scripts to automate the process of Implementation.
• Implementation of Debit Card Interface (Java and Pro *C) across 51 branches all over India for Bank of Baroda.
• Active support during the closing activities at Financial Year end process.
• Conversion of database from file system to oracle RDBMS using tools like SQL Loader and UNIX shell scripting to automate the process.

Environment : Sco UNIX 5.0.5, HP-UX 10.2, Sun Solaris, Pro * C, Oracle Forms 4.5,
Oracle Enterprise Server 7.3, SQL, PL/SQL, Shell Scripts

Mar ’01- Aug ’02: Software Engineer at Confidential,Hyderabad, INDIA
Scholar
Scholar is a complete administration product for educational institutions that provides a unique solution for the administration of an education institution deployed and being used by more than 25 schools & colleges in Hyderabad. The project contains three modules Administration, Accounts and Payroll. A reports module for each & every module is an added advantage.

RESPONSIBILTIES:

Involved in designing and coding of visual basic forms for front –end application.
Designing and normalization activities of the database.
Creation of various reports using VB reports and crystal reports for evaluating the attendance and performance of students at various competency levels.
Created Test plan, Test Design and responsible for implementation of Test cases.
Creation of Active X controls to enhance the reusability of code.

• Participation in project status meetings.
• Developed stored procedures and Functions which carry business logic for various modules like payroll and administration.
• Implementation and production support for about 15 branches in and round Hyderabad.

Environment : Visual Basic 6.0, Active X controls 2.5, Crystal Reports 6.0, SQL,
PL/SQL and Oracle 8.1.7

Confidential,INDIA
The software handles the analysis of different fatty acids basing upon the ingredients and using different formulae to analyze the fatty acids for generation of reports. The project mainly deals in analyzing the inputs given and thus generating molecular percentage of the fatty acid.
RESPONSIBILTIES:

Involved in designing and coding of Visual Basic Forms for front –end application.
Designing and normalization activities of the database.
Created Test plan, Test Design and responsible for implementation of Test cases.
Creation of Active X controls to enhance the reusability of code.
Created stored procedures and functions to apply business logic to the analyzed data collected from the user.
Designed reports on various custom formats for chemical analysis of the fatty acids.

Environment : Visual Basic 6.0, Crystal Reports 6.0, MS-Access, Windows NT/98