Over 16 years of experience in system analysis, database design and administration of which 13 years has been primarily in Oracle database administration of Production Systems on Unix based systems. Self-starter, highly motivated, pro-active, strong analytical and inter-personal communication skills, good team player and capable of leading large teams, capacity to work independently or as a part of a Team.

Specialized in Project Management Lead, Database Team Lead, Complex Database Architecture, SQL Tuning, Performance Tuning, Disaster Recovery, Backup and Recovery,multi-node Oracle 10g RAC environments.

Well versed with complex architectures, stringent SLA standards, HA solutions, Data Center consolidations, Exposure to Monitoring tools such as Spotlight, BMC PATROL, OEM Grid control, Experienced with Change Management procedures.

Technical skills:

Operating Systems: MS Windows 9x/NT/ME/2000, MS DOS, Sun OS/Solaris, HP UNIX, 
Linux (Red Hat/SUSE), AIX 4.1/5.0 
Programming Languages: JAVA, C, C++, HTML, JAVA SCRIPT.
RDBMS: Oracle 7x/8x/8i/9i/10g, MSSQL Server 7x/2000, MS Access, Dbase, FoxPro, Watcom.
Case Tools: Erwin, Rational Rose, ER-Studio, PowerDesigner. 
DB Tools: Platinum DBA Advantage, SQL Station, Embarcadero DBArtisan,Data Junction, Oracle Enterprise Manager.
Application servers: IBM Websphere, JBoss.
Languages: C, C++, FORTRAN, Basic, SQL, PL/SQL, Transact SQL and Shells.

Role: Oracle DBA Lead/Consultant.

Project: Obsolescence

Obsolescence is the project of upgrading different versions of de-supported Oracle versions to supported version of Oracle. Provide database-consulting services to various Application teams across the organization. The DBA consulting services include such as planning and layout of the infrastructure during the database migrations/upgrades, tuning the database performance and SQL queries performance, assist L2 level DBAs in resolving critical issues etc.

Responsibilities:

• Schedule and support the Oracle database upgrades from 8i/9i to 10g and 11g versions.
• Provide technical expertise and guidance for the L2 DBA team to successfully complete the database upgrade process.
• Provide the technical expertise and guidance for the L2 DBA team to implement the Quarterly released Critical Update Patches successfully.
• Help the different application teams in identifying and tuning the sub-optimal SQL queries and any other performance bottlenecks.
• Working with the Operating System (SUN SOLARIS) issues during the upgrading/patching process.
• Plan and implement the infrastructure layout during the migration/upgrade of the databases.
• Implemented RMAN backups and configured Oracle Data Guard High Availability Solutions.
• Configured Oracle Grid for monitoring the databases.
• Documentation of the best practices in Oracle databases upgrade and patching process.
• Completed the Oracle E-Business Suite R12 training.

Confidential, Cincinnati (04/2007 - 08/2009)

Role: Sr. Oracle DBA.

Project: Confidential

Confidential is a customized application that is developed to support Check`nGo's Payday and Installment Loans. This application was customized to provide an online loan processing system and a store based loan-processing system. Two types of loans (Installment and Payday Loans) are supported by this application. Stars application is supported on Oracle 10g RAC database installed on Red Hat Linux RHEL 4.0.

Responsibilities:

• Installed and configured three different Oracle 10gR2 Production RAC databases on Red hat Linux RHEL 4.0.
• Installed and configured a two node Standard Edition32 bitRAC, Three node
• Enterprise Edition 64 bit RAC and a two node Standard Edition 64 bitRAC.
• Create databases using ASM on RAWDEVICES.
• Designed and implemented the database backup strategy using RMAN for the RAC configuration.
• Designed and planned the data migration from CMAX systems to Oracle RAC database.
• Analyzed the data and the different data types thoroughly between the two different systems before the data migration.
• Redesigning the poorly designed modules to enhance the Application performance.
• Identifying the sub-optimal backend SQL queries and working closely with the development team in tuning them.
• Tuning ther SQL statements involved in Denormalizing the data for better performance.
• Designed and developed the Oracle backend program (PL/SQL) to generate daily/monthly General Ledger file for the Finance team to reconcile.
• Tuned the End of Day process to improve the performance of the process.
• Providing all the required day to day database administration support for the Application.
• 13 Provided 24X7 production support for the RAC databases.

Confidential, Cincinnati(07/2004 - 04/2007)

Role: Sr. Oracle DBA.

Project: ORACLE DBA SERVICES

Responsibilities:

• Provided Oracle DBA services to various clients on wide range of operating systems.
• Installed and Patching Oracle 7x/8i/9i/10g software, upgrading the existing databases, migrating the database to different servers.
• Implemented Oracle 10g ASM and Flashback features.
• Installed and configured 10gR2 RAC on Linux servers. (Red Hat & SUSE)
• Implemented various backup and recovery procedures for different clients. These procedures include hot backups, cold backups, standby databases(manual and managed recovery), RMAN and Oracle Fail Safe.
• Cloned the development/test databases with the Production Databases using RMAN.
• Configured Oracle Data Guard high availability solutions.
• Extensive use of Export and Import and SQL*Loader utilities.
• Provided Database and SQL statements Performance and Tuning services to various customers.
• Improving the SQL statements performance would involve in designing the application modules with normalization and de-normalization the data.
• Performance tuning of the databases by running trace for various sessions, running STATSPACK reports and checking the response time.
• Completed Oracle 9i R2 RAC training at Oracle Corporation.
• Applying all the security patches and the Critical patches as required.
• Provided 24X7 production support as part of on-call pager rotation.

Clopay Corporation, Cincinnati(04/2003 - 06/2004)

Project: Confidential

Confidential is an image documenting system. Markview is used for the Install and Furnish of Garage doors business. This system is an OLTP system where the document flows through the predefined Work Flows. Each Purchase Order received from the stores is scanned as a TIF image and stored on the document server. This document (image) flows through the system depending on the Workflow defined in the System. The Workflow determines the next queue where the document has to go by triggering the Rules. The System is designed as a Web Client and Oracle as back end database.

Responsibilities:

• Performed Oracle Database Administration activities such as Installation of software, creating databases for all environments, Upgrading the existing databases, planning and Implementing the Backup and Recovery strategies using RMAN for the Production databases.
• Creation and maintenance of Database Objects.
• Customized the Application to meet the business requirements which includes Data Modeling, developing Oracle back end Stored Procedures, Functions, Packages and Triggers.
• Extensively used Oracle Export, Import utilities to export and import data into the databases.
• Modified the Stats Pack Scripts to monitor the SGA and tuned the SGA accordingly.
• Tuned many SQL queries using Explain Plan and Auto Tracing.
• Created and maintained Materialized Views to refresh every day.
• Implemented and maintained the back up and recovery procedures.

Wrote and maintained UNIX shell scripts to perform day-to-day database monitoring.

• Oracle Backend development (PL/SQL) to generate the monthly lead-time reports.
• Provided 24X7 production support.

Environment: Unix Sun OS 5.6/ HP UNIX 11.11, Windows NT 5.0/ 2000 ,Oracle 8.1.7.4/9.0.2/9.2. Oracle IAS 9.2.x

Confidential, Houston(08/2002 - 03/2003)

Role: Sr. Oracle DBA

Responsibilities:

• Performed several Oracle 7.x/8.x/8.1.x/9i server installations, database implementations, systems migration and setting up maintenance scripts for GMS, GISB and EnGenius customers on Windows NT/2000.
• Implemented several 24x7 application environments, troubleshot customer servers and set up different backup strategies such as Transaction Log, Exports, Hot Backups, Cold Backups and Archive Logs and Replication for several customers.
• Gathering business requirements, analyzed and Designed Logical and physical models for web based (Internet) new Gas Pipeline system using Erwin, Rational Rose on Oracle 8.1.7.
• Worked in the design analysis and implementation of Gas Management System (GMS), GISB SQL Server, Oracle and Sybase database servers using Erwin. Designed and written several database stored procedures, triggers, and defaults for SQL Server, Oracle and Sybase.
• Was responsible for documentation, maintenance of internal servers, and setting up testing application environments. Supported several internal databases on daily basis.
• Implemented various automated maintenance scripts such as computing statistics, backup procedures, space management, and schema maintenance scripts for customer servers and internal servers.
• Performed I/O and Memory performance monitoring and tuning of database servers for various customers.
• Implemented Backup and Recovery strategies using RMAN.
• Worked as an backup SQL and Sybase DBA.
• Created database standards and object naming standards for the physical Implementations.
• Worked on the performance analysis forhigh volume transactions. Assisted development team in database design analysis, query performance tuning and query optimization. Worked in application migration team on the migration process and analysis.
• Responsible for setting up database upgrade path for GMS, GISB applications.
• Performed/Ported several database migrations from Oracle to SQL Server and Vice Versa. Designed and Developed Database Schema Migration tool to convert SQL Server and Sybase databases to Oracle Schemas and vice versa. Environment: Unix Sun OS 5.6, Windows NT 5.0/2000 ,Oracle 8.1.7/9i , SQL Server 6.5/7.0/2000, Sybase 10.7

Confidential (12/1997 - 06/2002)

Role: Oracle DBA/Developer

Project: Confidential

Confidential is a data store for the Wireless billing system called Atlys. Billing data is extracted from the Billing System in form of flat files and loaded into the database on a daily basis. End users generate reports from the Data warehouse application database. 
Churn management is a term used in the telecommunications industry to describe the process of ensuring that profitable customers stay with a particular company. Data warehousing is used to gather data relating to churn from an organization\'s operational systems, such as billing, and organize it into a form suitable for analysis. A data warehouse allows the relevant operational data to be stored separately from the transactional systems themselves so that reporting on the data does not impact processing speed, and organized according to units that helps marketing analysts for customer retention.

Responsibilities:

• Performed Oracle Database Administration activities such as Installing of software, creating databases for all environments, Upgrading the existing databases, planning and Implementing the Backup and Recovery strategies for the Production databases.
• Creation and maintenance of Database Objects.
• Worked with Designer2000 tool for Data Modeling to design a STAR SCHEMA.
• Extensively used Oracle Export, Import utilities to export and import data into the databases.
• Involved in tuning the database for better performance.
• Wrote and maintained UNIX shell scripts to perform day-to-day database monitoring.
• Wrote SQL scripts to extract data from the billing source system.
• Backend Programming (PL/SQL) to load the data from flat files into Oracle Database Objects.
• Developed control files to load data to the tables using SQL*LOADER.
• Performed Unix Administration activities like taking the file systems backup and Operating System level Backup.
• Prepared the DOCUMENTATION for the system.

Environment: Unix Sun OS 5.6, Windows NT 5.0,Oracle 8.1.5, Visual Basic 6.0 and Sagents.

Confidential. New Jersey (03/1997 - 12/1997)

Role: Oracle DBA/Developer.

Project: Confidential

Confidential is Insurance based Workers Compensation System. The system processes quote requests, Policy Renewals, Cancellations, Reinstatement and rating of the policies. The system is also responsible for Backend Daily Close process, to move cash from the Account Receivable. Disbursements of cash and automatic cancellation and renewals of policies were handled.

Responsibilities:

• Involved in creation of complex Stored Procedures, Triggers and Functions using Oracle PL/SQL.
• Developed several reports to handle Agent Summary, Account Summary, Cash balance transactions and Work In Process files.
• Developed control files to load data to the tables using SQL*LOADER. Used Oracle Export, Import utilities to export data and import data into the database.
• Performed Database Administration activities like creating database and other day to day DBA jobs like taking backup and giving online assistance to the team like creating database objects, and Managing database effectively.
• Prepared the DOCUMENTATION for the system.

Environment: Unix Sun OS 5.6, Oracle 7.3, Power Builder V5.0.

Confidential, India (03/1995 - 03/1997)

Role: Oracle Developer.

Project: Confidential

Dispatch Management helps in the preparation of dispatch advice. The system provides On-line information on the availability of goods in the factory and regional warehouses. The availability information includes available on-hand, blocked quantity and quantity on-order or on transit. The aggregate dispatch file is transmitted automatically for timely shipment. Each warehouse transmits shipment data back to the system for invoice preparation. The system generates sales order dispatch advice and invoice reports upon request and periodically.

Responsibilities:

• Developed PL/SQL Stored Procedures, Functions, and Triggers to handle the Backend database transactions.
• Developed conversion utility programs using PL/SQL to maintain changes to the production database.
• Developed control files to load data from the database using SQL*Loader.
• Export and Import utilities were used to export and import data from the database.

Environment: Unix Sun OS 5.6, Oracle 7.3, Power Builder V5.0

Education/ Training/ Recognition:

• Bachelor of Technology, India 1992
• Trainee at Confidential, India.
• SEE (Spotlighting Employee Excellence) Award for Second Quarter 2001.