SUMMARY:

• DBA Experience in Oracle 11g/10g/9i/8i/8.0/7.3 Administration, Monitoring, Performance Tuning, SQL tuning, Database Backup and Recovery, Disaster Recovery, Data Replication, Database Refresh on Sun Solaris, Unix, Linux, HP-UX ,AIX, Windows environments.
• Excellent team player and flair to learn and implement new technologies.

Education & Certifications:

• Masters in Computer Applications.
• Oracle Certified Professional (OCP 10g) - Database Administrator.
• Oracle 10g RAC OCE.
• Microsoft Certified Professional (MCP).
• Microsoft Certification on Implementing and Administering Microsoft Windows 2000 Server.
• Attended trainings on MCSE.

Technical Details:

Skills Summary :

• SQL,PL/SQL
• Oracle 11g/10g/9i/8i
• Unix Flavors :Sun Solaris, HP-UX
• Oracle 10g Real Application Clusters (RAC)
• Automatic Storage Management(ASM)
• Recovery Manager (RMAN)
• Data Guard
• Performance Tuning(Explain Plan, TOAD,SQL Trace, Grid Control, ADDM,AWR)
• Oracle 9i/10g Enterprise Manager (OEM)
• SQL Loader, EXP/IMP
• Database Design: ERWIN
• Replication: Sharplex
• TOAD

PROFESSIONAL EXPERIENCE:

Client: Confidential,NJ Sep 2008 - Current
Role: Worked as Oracle DBA.
Environment: Oracle 11g, 10g, 9i, Toad, RMAN, Netbackup, EXPLAIN PLAN, Export and Import, AWR, ADDM, Grid Control, ASM, Sun Solaris, Unix, Linux, HP-UX ,Windows environments

Description:
Confidential,is a global leader in assurance, tax, transaction and advisory services. Involved in support team for the Global IT infrastructure, Global Operational Services (GOS). Work within the Applications Development Group to provide Oracle and PeopleSoft subject matter expertise across all related projects and providing administrative support for oracle database in RAC and Non-RAC environment along with PeopleSoft Financial, Human Resources Management Applications and Oracle Apex (Application Express).

Responsibilities:

• Perform installation, upgrade and configuration of oracle (8i, 9i, 10g, and 11g) binaries, creating new database, Upgrade Databases to 10g, schemas, user and roles, project migration across development to production, tablespace management and rollback tablespace management, transaction management, security administration and creating and maintaining database objects.
• Apply patches and updates to oracle database software, creating TAR for oracle and follow up till resolve issues.
• Perform environment design and implementations, capacity sizing for databases, and creating, maintaining and refresh materialized views to maintain replication environment.
• Manage the Oracle PeopleSoft Enterprise and Embedded software applications schemas.
• Maintain and troubleshooting out-of-sync issues between physical and standby database using DataGuard utility.
• Worked day to day support using Remedy ticket queue and provided 24x7 Production on-call support.
• Maintaining and using 10g Grid Control for better manageability, automatic performance tuning, notification etc
• Database refreshing and Replication using exp/imp, RMAN and HOT/COLD backup in RAC and Non-RAC environment from production to testing environment.
• Installations, configuration and maintenance oracle 11g real application cluster (RAC) and ASM and add new nodes to RAC 11g Cluster to distribute the load.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Extensive Performance Tuning, Memory(SGA) tuning
• Provided technical support to development team to fine tune SQL and PL/SQL code using Explain Plan, AWR, ADDM, SQL Tuning Advisor and evaluating and monitoring database to resolve performance issues including troubleshooting errors.
• Write UNIX Shell scripts for database job atomization.

Client: Confidential,NJ Jun 2006 – Aug 2008
Role: Worked as Oracle DBA.
Environment: Oracle 10.2, 9.2, Toad, Sql Loader, Sql Trace, TKPROF, EXPLAIN PLAN, Export and Import, Sun Solaries, Shareplex, Statspack.

Description:
Confidential,one of the largest telecommunication companies, recently acquired AT&T,. Database of Records (DBOR) is an Enterprise solution for AT&T business to solve issues of data quality, integrity and accuracy.

DBOR is an AT&T project to address data inconsistency issues between multiple AT&T systems. DBOR will cleanse and aggregate the data from different systems to provide a consistent database of record (DBOR) view of data.

Responsibilities:

• Installed configured and maintained Oracle 10g /9i on Sun Solaris and upgraded to 9i to 10g.
• Installed and configured of Oracle 10g/9i RAC (Real Application Clusters) on Redhat Linux. Add new nodes to RAC 10g Cluster to distribute the load.
• Performed Oracle Clusterware installation, Configuration and monitor Oracle Clusterware resources.
• Provided performance tuning on a 10G RAC database on a Linux platform.
• Created and Managed Services for RAC DB Load balancing.
• Setup and supported HA solutions Standby servers, Data Guard Setup, Configured Oracle Data Guard using physical standby database.
• Creating, maintaining and refresh materialized views to maintain replication environment and resolved out-of-sync issues between replicated databases.
• Performed DB performance monitoring, generated Stats pack reports to observe overall DB performance and top wait events, and SQL optimization/tuning using Explain Plan.
• Created shell scripts to refresh database schema using Exp/Imp utility and Clone/Refresh of Production databases to Testing environment.
• Implemented RMAN backup/recovery procedures using shell scripts.

Responsible for maintaining application schema, schema changes.

• Handled Security Management that includes enrolling users and maintaining system security by controlling and monitoring user access to database.
• Involved in Production 24X7 on call rotation schedule and Interacted with Oracle Support for resolving various critical database issues
• Writing error handler procedures for, update and delete conflict and writing the cause of error to log files.
• Provide database administration on production, testing and development database servers. Creation of database objects like tables, indexes, stored procedures, DB links etc.

Client: Confidential,NJ Aug 05 – May 06
Role: Worked as Oracle DBA.
Environment: Oracle 9.2, SQL Server ,Toad 7.3, ERWIN 4.1, Sql Loader, Sql Trace, TKPROF, EXPLAIN PLAN, Export and Import, HP-UX 11.0.
Description:
Confidential,is a global educational and professional publishing, financial, information and media services company. McGraw-Hill Construction (MHC), a division of The McGraw-Hill Companies connects people, projects and products across the design and construction industry. Involved in Product Network (previously referred as Sweets) applications.

In the Sweets marketplace top manufacturers provide comprehensive, detailed product information so the building professional can browse, select and specify the products they need. A sweet is the top decision- making resource for 90 percent of design and construction professionals. Sweets.com is a product information resource for construction professionals featuring product catalog, CAD details and 3-part specifications.
Core users: Architects and Engineers, Owners, Contractors, Sub-Contractors.

Responsibilities:

• Assist in code release for developers in QA/staging and production environments (check code for correct tablespace allocation, recompile invalid objects etc.)
• Wrote UNIX shell scripts for cronjobs under UNIX to load data using SQL*loader into QA/Dev database.
• Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, Optimizer Hints, Stats pack and TKPROF utility.

Used EXPORT/IMPORT utilities for logical backups. Transferred the data from one database to another database. RMAN for hot and cold backup and for online/offline backups. Created backup scripts and ensured backups were occurring as expected. Responsible for maintaining application schema, schema changes. Utilized Erwin for data modeling and applied changes in data modeling and documented.

• Handled Space Management which includes table space creation, adding new data files, and creating rollback segments.
• Handled Security Management that includes enrolling users and maintaining system security by controlling and monitoring user access to database.

Client: Confidential,MD Nov 04 –Jul 05
Role Worked as Oracle DBA.
Environment: Oracle 8.1.6/7.3.4, HP-UX 10.2/11.0, HP 9000, Windows NT 4.0, Export/Import, Unix Shell Scripts, TOAD, Tkprof and SQL*Net/Net8
Description:
The primary objective of the Unified Service System (USS) initiative is to implement a new Customer Support system that delivers operational efficiency, improves customer service, and positions Care First for future market opportunities.
In the USS Project Tibco as the middleware to connect front end EPNY and backend Oracle.Input Request is made from EPNY, then request hits the queue in Tibco to transform the request to a canonical request which Tibco understands using the xsl and then make a call to the oracle stored procedure using the ADB Adapter by the request response service. The service waits for a response from the stored procedure and sends back it to EPNY.

The goals of the USS project include:

• Increasing productivity of Care First customer service staff by integrating systems, providing better tools for customer service reps, and taking advantage of opportunities for automation.
• Increasing customer satisfaction by providing improved call handling, centralized status of information, and improved ability to sell services and products.
• Improving management of Care First’s call center environment through meaningful reporting and analysis of customer cases.

Responsibilities:

• Involved in Application Coding and Testing.
• Involved in Development of PL/SQL Procedures, Packages and Database Triggers and materialized view.
• Using Quest Toad to Develop, Debug Stored Procedures and Monitor DB Performance.
• Involved in Fixed defects according to the business requirement.
• Worked on enhancements.
• Involved in Fine-Tuning Application & Database Performance.
• Handled Space Management which includes table space creation, adding new data files, and creating rollback segments.
• Handled Security Management that includes enrolling users and maintaining system security by controlling and monitoring user access to database.

Client: Confidential,San Francisco, CA Apr 02 – Oct 04
Role: Worked as Oracle DBA.
Environment: HP Servers T500/I60/K570, Oracle 9i/8i, HP-UX 10.20/9.04, TKRPOF, Oracle Enterprise Manager, Windows NT, Perl.
Description:
Confidential,is one of the Major banking and financial firm. Involved in Card Member Services Application Design and development, this provides a solution for integrating different credit card types within LOB credit card financial resources.
Responsibilities

Worked on 6-member DBA team supporting 9 production instances and 10 development/testing/demo instances Involved in data extraction and load operations using SQL*Loader utility for data warehousing application. Significantly reduced the time for data load using SQL Loader Direct Path and Parallel Load. Involved in performance tuning for data warehouse which includes tuning at the server level (identifying and modifying Init.ora parameters). Used RMAN for hot and cold backup and for online/offline backups Created backup scripts and ensured backups were occurring as expected. Responsible for maintaining application schema, schema changes Utilized Erwin for data modeling. Involved in Database Replication by using Quest Shareplex.

Client: Confidential,Chennai, India. Oct 00 – Dec 02
Role: Data warehouse Developer
Environment: Informatica 4.7, Oracle 8i, Sql Server 7.0., TERADATA, Maestro Tool (IBM) and MS Visio.
Description
Confidential,is the largest electronic retailer in USA for consumer electronics, home office equipment, entertainment software and appliances it has under its fold, the following companies. Sun Coast, On-Cue, Magnolia Hi-Fi, Music Land & Future Shop. Every day its OLTP data is bought into its huge Data warehouse. This data is cleansed and summarized and projected to the senior management using DSS. Worked on various modules like Sales, Cost Optimization Modules, Clicks Reporting, Retek to Data warehousing, Data marts are created and data is extracted from Oracle – RDBMS, through Informatica Power Center.
Responsibilities:

• Creating Mappings as per the requirement given in the A4.
• Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Tool set of Informatica
• Creating the workflow and executing the session to check whether the data is loading to the target as per the requirement.
• Preparation of Technical Specifications.
• Unit Testing and Specification.
• Preparation of Process Flow Diagram using Ms Visio.
• Preparation of Job Documentation.
• Scheduled Jobs Using Maestro Job Scheduler
• Populating the data in TERADATA using Multi load & Fast load