Professional Summary:

• Multifaceted and result driven professional with 8.5 yrs of experience in Information Technology.
• A result oriented professional with proven abilities of 3.5 yrs in Oracle Database Administration
• Database Cloning and Database Upgradation/Migration.
• Database activities such as Installation, Patching, and implementing Backup and Recovery Strategy, User Administration, Tablespace Management on Standalone DB.
• Experience of Database backup and recovery, using hot backup, cold backup and database refreshes, logical backups (exp, imp, datapump), database cloning using RMAN scripts.
• Recovery of the database: Whenever there is a major crash (like a disk crash) recovery of the database from production backups has to be carried out.
• Performance tuning consists of AWR, explain plan and SQL tuning of production databases and programs
• 5 years of experience in Design, Development, Enhancements and Maintaining applications in Oracle 9i/10g/11g using SQL, PL/SQL. Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Expert knowledge in using data modeling tools like ER-WIN and ER diagrams with Model mart exposure. Normalization Techniques for designing database with Relational technology on N-Tier Architecture.
• Hands on experience in design and deployment of UNIX Shell Scripts using K Shell.
• Oracle Certified Professional - 9i/10g.
• Possess excellent problem solving, analytical, and interpersonal skills.

Technical Skills:

Database Tool: RAC, Dataguard, RMAN, DBCA, OEM, SQL*Plus, Putty, Expdp/Impdp
Database: Oracle 11gr2/10g/9i
RDBMS: Oracle SQL, PL/SQL
GUI Tools: Developer 6.0/9i/10g,PL/SQL Developer, Toad 8.3,9
Operating System: Windows NT/2008/XP, HP UX, Solaris and UNIX 5.0
Languages: C, HTML, JavaScript, Core Java and Visual Basic

PROJECT SUMMARY

Confidential, USA TX July 2012 - Till date
Oracle DBA

Responsibilities:

• Responsible for maintenance, tuning and 24x7 support of Production, Development and Staging instances of Oracle Version 8i, 9i ,10g in HP-UX Unix environments.
• Implementation of daily, weekly, and monthly DBA checklists for each environment.
• Maintain terabyte Data warehouse Oracle database in 24x7 Production Environment.
• Excellent skills in troubleshooting Oracle Database and query issues.
• Refresh and Clone Databases as per customer requirements.
• Ensuring successful and periodical Backup, Restoration & Tuning of databases.
• Implemented backup and recovery using RMAN in development environment. Documented the process for implementation in production and staging environments
• Write PL/SQL and UNIX shell scripts to automate database functions,
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
• Works directly with software developers to develop and enhance applications and data conversions.
• Provide Business Intelligence support to OBIEE users. Responsible for design, maintenance, debugging, and execution of BI Reports in Development and Production Environments.
• Provide on-call support in adherence to specific business and customer Service Level Agreements

Confidential, USA NJ Jan 2011 - May 2012
Oracle DBA

Responsibilities:

• Responsible for maintenance and 24x7 Support of multi-terabyte databases (Oracle 8i, 9i, 10g) in production, testing and development environments hosted on Unix servers (HP, Linux) and Windows servers.
• Responsible for RMAN backups of production databases.
• Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump, and hot backup scripts.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Installation, upgrade and patching of databases from Oracle 8i, 9i to Oracle 10g.
• Monitor database performance via STATSPACK, Automatic Workload Repository, Database Control, and Quest Tools.
• Participation in design reviews for upcoming application enhancements.
• Provide on-call support in adherence to specific business and customer Service Level Agreements

Confidential, Singapore January 2009 - March 2011

Project: eOASIS
Jr DBA

Responsibilities:

• Daily management, maintenance, monitoring, tuning and support of Oracle 8i and 9i databases in Unix environments (Sun Solaris, Linux Redhat 7.2), and Windows NT platforms.
• Maintain multi-terabyte Data warehouse Oracle database in 24x7 Production Environment.
• Configuration of Oracle 8.1.7 standby database.
• Implementation of backup, recovery and disaster recovery procedures.
• Data Loading using SQL*Loader
• Technical documentation of Oracle 8i and 9i databases, hardware, and custom applications.
• Installation and maintenance of Oracle 9iAS in pre-production environment.
• Provide on-call support in adherence to specific business and customer Service Level Agreements

Confidential, October 2008 - December 2008
Project: Price Agreement Tool (PAT)
Lead PL/SQL Developer

PAT application is used by internal field sales users of GEW & PT located throughout the globe for updating, renewing, extending and terminating the Price Agreements with the workflow approval process. PAT involves retrieving book price details for SAP. The users with following roles can access the application. CA - Contract Admin, IC - Index Calculator, AM - Account Manager, EF - Exception Filter
GPM - Global Product Manager, PPA - Pole Price Approver

Responsibilities:

• Development, Execution & Tuning of PL/SQL procedures & Materialized views.
• Day to day report on work progress to the Lead and co-ordination with the testing team for any issue clarifications.

Environment: Unix/Oracle (SQL and PL/SQL).

Confidential, US February 2008 - September 2008
Project: Matrix
PL/SQL Developer

Confidential, is a trading system that is used by Equity Finance desk, across the globe. It has a Java based front end GUI that runs on UNIX servers on the backend and Oracle as the DB Server. Matrix has been used in New York, London, Tokyo, Sydney, Frankfurt, Hong Kong and Korea. Matrix providing various GUI supports for various purpose of trading activities

Responsibilities:

• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules and Tuning of PL/SQL procedures
• Day to day report on work progress to the Lead and co-ordination with the testing team for any issue clarifications.

Environment: Unix/Oracle (SQL and PL/SQL).

Confidential, Australia October 2007 - February 2008

PL/SQL Developer

The Intellect Invest - Special product, a part of the Intellect suite of products, is designed to address the needs of Fund Distributors/Investment Managers/Fund Houses in recording and reporting the Structured Product deals. System will be accessible via Point of Sales/Distributing branches. The system supports Order Placement, Order Execution, Order Contracting and Maturity Processing for Special Products.

Responsibilities:

• Development of the application and Data migration
• Involved in Development, Execution & Tuning of oracle PL/SQL Stored Procedures.

Environment: Unix/Oracle (SQL and PL/SQL), Agile Methodology

Project: ICICI WMS Implementation
PL/SQL Developer

The Intellect Invest -Brokerage product, a part of the Intellect suite of products, is a back office and retail brokerage solutions system that enables banks to offer brokerage distribution services for their retail clients. The system is a core product processor that can be linked to multiple other product processors and delivery channels

Responsibilities:

• Development of the application and Data migration
• Involved in Development, Execution & Tuning of oracle PL/SQL Stored Procedures.

Environment: Unix/ Oracle (SQL and PL/SQL).

Confidential, US September 2006 - December 2006
Project: CFC- StatusMart (Data & Utility Migration)
Software Engineer

Countrywide Financial Corporation, US is a 2nd largest financial institution, which provides the loans for the qualified customers. The system was developed initially in SQL Server and now the system is migration to Oracle 9i. StatusMart is the reporting system, which provides the end of the day reports.

Responsibilities:

• Development and maintenance of the application
• Involved in Development, Execution & Tuning of oracle PL/SQL Stored Procedures.

Environment: Unix, SQL Server and Oracle 9i (SQL and PL/SQL)

Confidential, US September 2005 - August 2006

Software Engineer

Phillip Morris, a cigarette manufacturing company uses Material Management System (MMS) to manage its warehouse, inventory and production houses.

Responsibilities:

• Development, maintenance, enhancement, production and user support of the application
• Involved in Development, Execution & Tuning of oracle PL/SQL Stored Procedures.

Environment: Unix, Oracle 8i (SQL and PL/SQL), Pro*C Batch programs.

Confidential, US July 2004 - August 2005
Project: Philip Morris - Tobacco Farmer Partnering Program
Software Engineer

Phillip Morris, a cigarette manufacturing company uses Tobacco Farmers Partnering program (TFPP) to manage its inventory and production houses.

Responsibilities:

• Development and Maintenance of the application
• Providing support to the application
• Involved in Development, Execution & Tuning of oracle PL/SQL Stored Procedures.

Environment: Windows, Oracle 8i(SQL and PL/SQL), MS SQL Server and VB

Education:

• Bachelor of Science -Electronics

Certifications:

• Certified in Oracle Database 10g: Administration.
• Certified in Oracle Database 10g: Administration II.
• Certified in Introduction to Oracle9i: SQL
• Certified in Oracle9i: Program with PL/SQL

Trainings:

• BS7799 Security Systems
• QMS (Quality Management System)