CAREER SUMMARY

• 7+ years of extensive experience in IT industry. 6 years of Oracle database administration supporting mission critical databases, around 2 years of experience as Java Developer
• Advanced performance tuning, database design, capacity planning and establishing standards for Oracle Database installations, disaster recovery, and maintenance.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Oracle 9i, 10G RAC, RMAN, Data Guard
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, Explain Plan and TOAD
• Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, database access and Security and auditing
• Performing tuning of application with RBO, CBO, using SqlTrace, Tkprof, and Explain plan and ADDM
• Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Backup/restore and disaster recovery plans for production servers.
• Implementing and administering database replication between dissimilar databases.
• Involved proactive detecting, diagnose and resolve potential database bottlenecks before they affect end users
• Identified performance bottlenecks like queries utilizing high CPU, internal lock waits; redo log buffer waits and Cartesian joins etc. Resolved such issues by fixing code, tuning query and instance accordingly.
• Participated in report analysis, design, development, quality control testing, and deployment and integration.
• Fast and self-studying learner of new and required technologies.
• Acquired and nurtured excellent communication skills, both written and oral, with people of all technical levels.

EDUCATION

• Masters in Computer Science
• Bachelors in Computer Science

EXPERIENCE
Client: Confidential,Washington DC 08/2006 – 11/2009
Role: Oracle Database Administrator

Responsibilities:

• Evaluating, installing Database servers 10g RAC,11g, Database software, upgrading to new versions, coordinating with hardware changes and applying database patches
• Worked on oracle 10g to 11g migration projects with low maintenance window and applied patches to various databases
• Created, upgraded, and cloned Oracle databases for Development and UAT databases
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN
• Perform capacity planning required to create and maintain database environments
• Supported 24/7 on-call pager support for mission critical financial databases
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports
• Created users, roles and granted privileges according to the business requirements
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters
• Disaster recovery implementation using physical standby (data guard) databases for high availability
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company\'s business projections and growth
• Experience with production of Oracle 10g with multi node RAC with ASM
• Applied latest patches as per evaluation requirement

Environment: Oracle 10g RAC with Solaris, Oracle11g, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN,ASM, Data Guard, Solaris 10, AIX 5.1, 5.2, Shell Scripting, HP-UX,RAC.

Client: Confidential,Tampa, FL 11/2003 – 07/2006
Role: Oracle Database Administrator

Responsibilities:

• Identify all Oracle databases, document every database along with the server information, and prepare documents related to every activity done on the database including database jobs, cron jobs set up on operating system.
• Prepare backup scripts and set up jobs for various kinds of backups.
• Migration of database from Oracle 9i to Oracle 10g.
• Extract data as a logical backup from the production database and import it into the data warehouse.
• Working with VLDB up to 30TB.
• Data from Metrica database is imported into Oracle database; the database adds about 3TB every quarter. The tables did not have any retention policies which was setup per table. Most of the tables were not partitioned which was done based on the data (range/hash, range-hash). Scripts were written to automate the creation and removal of partitions based on a table’s retention policy. Accordingly, global indexes were created using Oracle Partitioning.
• Kernel parameters were customized according the existing and new database needs.
• Install Oracle software (Oracle 9i) on various platforms like HP UNIX, HP UNIX Itanium, Sun Solaris (32bit, 64bit) Windows Server 2003. Create customized database, import data from staging database(s). Upgrade the database from 9.2.0.1 to 9.2.0.4 (for specific third party applications), 9.2.0.6 and 9.2.0.7. Apply critical patch upgrade.
• Setup replication of a production database schema in the east coast to be replicated at west coast. It was a read-only replica which was refreshed every 15 minutes (read-only asynchronous materialized views having frequent update to the local site was setup).
• Interact with the administration team to check on the processes, disk usage, OS backup etc.
• Maintain various production databases running on VERITAS clustering for high availability.

Environment: HP UNIX, HP UNIX Itanium, Sun Solaris, Oracle (10g, 9i), Oracle Enterprise Manager, SQL*Plus, SQL*Loader, Export/Import Utilities, SQL*Navigator, VERITAS Clustering.

Confidential,Chennai, India 01/2003 – 08/2003
Role: Java Developer

Loan Origination System is developed for the customer - Bank of Punjab. This application automates the entire lending process from origination through funding. It includes automated underwriting, customizable workflow, document preparation management, loan application processing, schemes management, Enrollment in particular schemes and customer relationship management.

Responsibilities

• Developed application module by creating Java Classes, Servlets, JSP and JavaScript.
• Involved in requirements gathering and documenting the functional specifications.
• Contributed to the Logical Data Model design.
• Involved in designing the database schema.
• Developed stored procedures in PL/SQL on Oracle 9i database.
• Involved in designing the workflow and screen work flow.
• Involved in Troubleshooting, Bug fixing and Customer Support.

Environment: Java 1.3, HTML, JSP, CSS, DHTML, Servlets, JavaScript, PL/SQL, Oracle 9i, EJB 2.0, WebSphere 4.0, Windows NT.

Confidential,Chennai, India 02/2002 – 12/2002
Role: Java Developer

Existing website’s presentation layer was upgraded to accommodate for globalization & localization needs. Project also involved reducing the complexity of the presentation layer; cleaning up the code by eliminating dead code and reducing heavy dependency on include files.

Responsibilities

• Involved in analysis of client requirements, design and architecture of the overall system
• Actively participated in Design and Development of the entire system with EJB, JDBC, XML, Servlets, and JSP etc
• Implemented the business logic with EJB and Java Bean for the critical components of the system
• Designed and developed EJB components under the WebLogic application server
• Involved in the overall system’s support and maintenance services such as defect fixing, feature enhancements, testing and documentation
• Implemented unit testing using Junit
• Involved in peer code review

Environment: Java 1.3, EJB 2.0, JSP, Servlets, Java Beans, XML, DTD, HTML, JavaScript, JDBC 2.0, PL/SQL, Oracle 9i, JDeveloper, WebLogic 6.1.

SKILL SET

: Java, PL/SQL, C, C++, VisualStudio.NET

Databases/Tools

:Oracle 9i/10g/11g, MS-Access, MySQL, SQL*PLUS, TOAD, SQL Navigator, Putty, OEM, RMAN, SQL* LOADER, Import /Export and Data pump

Web Technologies

:HTML, DHTML, JavaScript, JSP, ASP

Application & Web Servers

: Websphere, BEA Weblogic Sever, JBoss, Apache Tomcat, IIS

Operating Systems

: DOS, Windows 95/98/Me/2000/XP, Windows NT 4.0, UNIX Systems (HP-UX 10/11.x, Solaris 8/9/10, IBM AIX 5.1/5.2/6.1, Linux)

Packages

: Office 2000, Office XP and MS-Office 2003 & 2007

Others

: Shell Scripting