PROFESSIONAL SUMMARY:

• Over 14 years of experience in the field of Oracle Database Administration and all aspects of Software Development Lifecycle.
• Extensively involved in designing, development, implementation, testing, maintenance, administration and tuning of Databases & Data Warehousing.
• Managing Physical Development, test, QA and Production environment.
• Responsible for Oracle 9i, 10g, 11g; Infrastructure Design and Optimization; Performance Tuning.
• Responsible for Database Administration; Project Management and Planning; Documenting and Implementation of Backup Procedure, Database Sizing and Standards, Guidelines and Best Practices.
• Oracle, PL/SQL, Oracle Enterprise Manager, Oracle Grid/Cloud Control, Forms, Reports, Stored Procedures, views, Triggers, Packages, Crystal Reports, Oracle Designer
• Creating complete applications using J2EE Technologies (JSP, Html, Java Beans etc)
• Experience complete applications using Developer 2000 and Form 6i.
• Responsible for Database Modeling (Logical and Physical structure); Data Conversion and Migration, Database Tuning.
• Experience in designing Data Model using Erwin, Dezign, Oracle Designer.
• Extensive programming experience in Java, Servlets, JSP, JDBC 2.0, Exception handling, Event handling.
• Creating Solution Architectures using object Oriented Methodologies, Design Patterns, Frameworks and Middleware Components.
• Experience in Designing and Developing Web applications based on MVC Framework.
• Experience in HTML, CSS and JavaScript.
• Experience in databases like Oracle 8, 9i, 10g, 11g, MySQL, SQL 2005/2008 Databases.
• Responsible for Taking Backups using RMAN and refreshing the Test / Development environments.
• Experience using oracle RMAN utility for Backup/Restores and Duplicating.
• Creating and maintaining Materialized Views.
• Responsible for Data loading using SQL*Loader for clients.
• Responsible for providing support to developers and validating Backups on regular intervals.
• Automated the backups using shell scripts, Enterprise manager jobs.
• Creating Complex Custom Reports using Oracle 10g Discoverer BI using Discoverer Plus. Upgraded Oracle 9i to 10g.
• Worked in Financial Services Industry.
• Upgraded database from 9.2 to 10g and 10g to 11gR2.Also upgraded Oracle Discoverer from 10g to 11g.

TECHNICAL SKILLS

Databases: Oracle (11g, 10g, 9i, 8i), Teradata 6.0, MS Access, MySql.SQL Server

Oracle Products: SQL Plus, PL/SQL, Oracle Enterprise Manager, Forms 4.5/6i/9i / Reports 2.5/6i/9i

Tools: Web sphere Studio Application Developer 5.0, Toad, Erwin for Database design

J2EE Technologies: EJB, JDBC, JSP, Servlets

Web Design Tools: FrontPage 2003,HomeSite Builder.

Operating System: Win XP, Win 2000, Win 98, IBM AIX, Solaris, HP - UX. Linux

Languages: Java’s, PL/SQL, C, COBOL, Unix Shell Scripts, HTML, XML JSP, and Java Servlets

Web/Application Servers: Oracle 10g IAS, Apache, Tomcat, Web Objects, IIS, IBM Web sphere 2.0/4.x, Web logic 8.x, Java Web Server, JBoss/ Tomcat 2.4.3, JRun

PROFESSIONAL EXPERIENCE

Confidential, NY-NY

Lead Oracle DBA

Responsibilities:

• Install, configure and provides technical support for Oracle 11g RAC databases as well as non-RAC databases on UNIX (IBM-AIX).
• Install, configure and provides support for Oracle11g RAC database on Linux for Oracle.
• Managed a 15 Terabytes Datawarehouse with 8 Production and a dozen test/dev environment.
• Installation and support of OBIEE 11g on AIX 6.1 for Development and Test Environment.
• Created and execute backup/restore strategy and scripts for databases in UNIX environment.
• Support and implement database scaling methodologies.
• Design and implement database security model specific to each applications.
• Implement RMAN secure backups for all production Oracle databases.
• Implement Oracle Enterprise Manager 12c for managing Oracle Databases.
• Upgraded the Oracle Discoverer 9i to 10g and also from 10g to 11g under UNIX.
• Write Custom shell scripts for Database backups, Health checkups and for reporting purposes.
• Designed SQL Server databases to suit OLTP applications following normalization standards.
• Developing stored procedures, triggers, views and adding/modifying tables for data loads, transformations, and data extractions.
• Implementation/Maintenance of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Provided support in the Migration of Storage from the EMC to Hitachi on the test and development servers.
• Using export import and exp data pump utility for loading data into the
• Monitoring database consistency by scheduling DBCC consistency checks at regular intervals.
• Monitoring all SQL Server instances performance using profiler to identify performance glitches and deadlocks.
• Automated Disk space checks, memory usage and user connections.
• Automated Database Integrity Checks, Database Statistics updates and Re-indexing.
• Implemented the Integration of various UNIX script on different server using remote shell (rcp/rsh).
• Frequently monitored databases for changes are made to existing structures.
• Designed and implemented comprehensive Backup plans and disaster recovery strategies.
• Automated export/import data from various data sources using SSIS.
• Monitored/tuned query performance using execution plans and index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Assisted in successful migration of all databases to SQL Server 2008 R2 Enterprise Edition after testing/modifying all the databases for incompatibilities and making necessary modifications.
• Designed, Implemented, and monitored SQL Server Integration Services (SSIS).
• Packages to load data from heterogeneous data sources and assisted in upgrading all existing packages from DTS/SSIS 2005 to SSIS 2008 R2.
• Evaluated reporting products and recommended SQL Server Reporting Services (SSRS) 2008 R2.
• Implemented Fog light Monitoring Tool (Version 4.x and 5.x)
• Lead in Oracle Discoverer Administration Tool.
• Installation and Administration of OBIEE (Oracle Business Intelligence) tool.

Environment: Oracle 10g /11g, AIX 5.3/6.1,RAC,RMAN,Oracle Enterprise Manager, SQL Server2008,Unix shell, Oracle Discoverer BI 10.2, OBIEE 11g, SQL Server 2008, Fog light 4/5

Confidential, Norwalk CT

Consistency

Responsibilities:

• I did the complete Data Modelling using tools like Erwin and Dezign software.
• Created the basic infrastructure in Teradata and Mysql databases for the loading of data into a structured format.
• Used tools like navicat and My-SQL Front for loading information initially into MySQL Database (version 5.0). Created procedures within MySQL for data cleaning and validations. In the second phase of the project migrated the database from MySQL to Teradata (6) using tools like OLELoad and MySQL Assistant (7.0). Recreated the procedures in Teradata.
• Wrote procedure scripts for automating the data loading from Access to Teradata and performing calculations on the same.
• Developed the interfaces between the Teradata and ‘R’ Language which was used for developing statistical models for Risk Rating Models.

Environment: Teradata 6.0 on Unix,My Sql 5.0 on Mac OS X,MS Access/Excel, Navicat 2005,My Sql Front,SQL Assistant 7.0,OLE Load.Dezign for MySQL, Erwin 4.1.

Confidential -NY

Oracle DBA

Responsibilities:

• Applying latest individual patches or cluster of patches to the operating system and to the Oracle database.
• Preparing servers from the operating system as well as from the Oracle perspective.
• Creating user accounts/directories/permissions from operating system.
• Installing Oracle software according to the requirements of the client.
• Running scripts for creating there database environment.
• Multiple instances of Oracle (8i & 9i both) are running on several boxes according to the requirements of the applications, I am responsible for making them stable and checking their performance when applications are making huge amount of transactions.
• Automating the RMAN backup scripts, listener purge, alert log clearance, export backups, using shell scripts.
• Responsible for all the DBA related jobs for all the instances; performance tuning, backup & recovery .managing users & privileges, resource limits etc.
• Taking care of day-to-day related issues; importing/loading data, user related, performance tuning.
• Helping application developers in data modeling and assist in the physical & logical design of the database too.
• Also responsible for selecting the best UNIX box for client’s application, with respect to number of CPUs, the load balancing and also setting the environment variables and do the capacity planning for these boxes.

Environment: Oracle 9.2.0.5 on Red hat Linux Advanced Server, Web logic 8.1, Visual Source Safe, Jbuilder.

DBA/Developer

Confidential

Responsibilities:

• Creating the architecture of the application as per J2EE standards.
• Developing a Web Based Reporting Tool which had all the necessary check for security and authentications within it.
• Programming the application on incremental prototyping model.
• Writing shell scripts for standard repetitive procedures.
• Developing JSP(s) and Java Beans for the Application.
• Supporting Oracle databases as one of the Oracle DBA.
• Getting customer approval and impact analysis of change requests.
• Created Tables, Views and Indexes.
• Wrote stored Procedure, Function, Packages using PL/SQL
• Developed an application for exporting data from Oracle to Excel using PL/SQL
• Performed regular Full Data Exports of the Database using export utility.
• Installed Oracle 9i Server and Clients.

Environment: Oracle 9.2 Server, Oracle 9iAS, Apache Tomcat Application Server, NetBeans, AIX 5

Confidential

Business Analyst/Technical Consultant

Responsibilities:

• Data Model Analysis of an existing application (Mikro Mauriac).
• Created Tables, Views and Indexes.
• Wrote stored Procedure, Function, Packages using PL/SQL
• Developed an application for exporting data from Oracle to Excel using PL/SQL
• Performed regular Full Data Exports of the Database using export utility.
• Installed Oracle 9i Server and Clients.
• Installed the new IMDAS Application on Client machines.
• Providing Database support for the older application and helping in the migration process

Confidential

Oracle Developer

Responsibilities:

• Created Form modules and Reports using Forms 6i & Reports 6i tools.
• Created tables and indexes. Analyzing and Rebuilding of Indexes for better performance of database
• Wrote stored Procedure, Function, Packages using PL/SQL
• Used the Version Control System Software PVCS.
• Written Forms Triggers, Procedures and Functions.Performed Business Analysis in close interaction with domain experts
• Worked with project manager, programmers and consultants to develop creative solutions for the successful implementation of various applications.
• Experienced in the analysis and implementation of vendor supplied client/server applications
• Experienced in system analysis, design, vendor package installation, and support
• Normalized the data to remove redundant data.
• Updated the management about the current status of the Project

Environment: Oracle 9.1.2 Windows 2003 Server and Windows XP Clients.Forms 6.0/Reports 6.0

Confidential

Database/ Web Analyst

Responsibilities:

• Business Requirement Analysis for the Application.
• Developed the Data model and prepared the Design Document for the application.
• Developed the Use Cases and Sequence Diagrams for the application.
• Java Coding using Java Servlets /JSP.
• Data Modeling and Database Design (Logical and Physical).
• Server Installation and Configuration, Production and Development Support.
• Creation of Databases, Tables, Views, Indexes, Triggers, Stored Procedures.
• Enforced referential integrity and other Constraints.
• Created and maintained Roles and Database users.
• Optimization of queries and Performance Tuning.
• Implementation of Backup and Recovery strategies Wrote UNIX Shell scripts to automate routine processes.
• Created data flow diagrams for the application.
• Installed Oracle Application Server (Infrastructure and Middle Tier)
• Used Oracle App Server Management Tools (emctl, opmnctl and dcmctl)
• Managed the Oracle Internet Directory and the Oracle HTTP Server
• Managed and Configured Web Cache. Deployed J2EE Applications.
• Managed Access Using Delegated Administrative Services.
• Administered the SSO (Single Sign-On Server).
• My role as an Analyst was to understand the business functionalities and to discuss with the end users the current requirements and solutions required.
• I analysed and developed a complete Oracle based (using PL/SQL) solution for calculating the unrealised profits in inventory. The application successfully calculated the UPI for the financial reports of the company.
• Wrote stored Procedure, Function, and Packages using PL/SQL and wrote procedures to import Data exports from Access and SAP into Oracle.
• Performed Oracle DBA activities of backup, recovery and performance tuning.
• I worked closely with the Research Informatics department for the analysis and designing of the ongoing and future potential projects.
• Performed DBA related activities of taking backups and writing scripts for automatic backups. Used Oracle Enterprise Manager for Database Administration.

Environment: Oracle 8 under Windows 2000, Web Objects.

Confidential

Oracle DBA/Developer

Responsibilities:

• Responsibilities included development of MIS Reports, Database Administration, providing technical support to users and maintenance of the Systems on-line.
• Tuning the Applications for optimal performance, designed the backup strategy for the applications, Designed and developed table structures, PL/SQL stored procedures and database triggers to implement business rules. Created Tables, Views and Indexes for the Project.
• Created scripts to monitor the performance of database. Status reporting to Management, Imparted training to the end users for using the system and preparation of User manuals
• Developed reports for all the modules for the application using Crystal Reports and VC++ (front end).
• Status reporting to Management, Imparted training to the end users for using the system and preparation of User manuals

Environment: Oracle8, AIX UNIX Server and Windows 2000 Clients. VC++, Crystal Reports.

Confidential

System Analyst

Responsibilities:

• Prepared the System Requirement Specification (SRS).
• Created the Database Schemas using Designer 2000.
• Prepared the System Design Document (SDD) for the Application.
• Developed the Forms and Reports as per the specification.
• Creation of Databases, Tables, Views, Indexes, Triggers, Stored Procedures.
• Enforced referential integrity and other Constraints.
• Created and maintained Roles and Database users.

Environment: Oracle 8, Windows 2000 Server and NT Clients. Forms 5, Reports 3.0, Designer 2000.