SUMMARY

• An Oracle DBA & PL/SQL professional with 9+ years of experience in Design and Implementation of Business Applications, Development and Production environments involving Oracle 9i/10g/11g/11gR2, Designer IDT/UDT, RDBMS, Info view, CMC, RAC, Data Guard and performance tuning with different domains like Banking, Healthcare & Pharmaceutical.
• Installation, configuration maintenance of Oracle 10g, 11g, Standby Databases (Data Guard).
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, Golden Gate, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments and mission critical large OLTP and OLAP systems.
• Expertise in Business Objects enterprise products such as Universe Designer, Desktop Intelligence, Web Intelligence, Info view, CMC and its deployments.
• More than 5 years of experience in migrating and upgrading databases of different versions of Oracle (8i, 9i, 10g, 11g) and in different environments.
• Experience withData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces.
• Strong experience inData warehouse concepts, ETL.
• Good knowledge on logical and physicalData Modelingusingnormalizing Techniques.
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and Function Based).
• Developed Complex database objects likeStored Procedures, Functions, Cursors, Packages and Triggers using SQL and PL/SQL.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• Experience in creating complex ADHOC reports and used various feature like Joins, Alias and Contexts in universe designer to overcome traps and loops.
• CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
• Worked extensively onRef Cursor, External TablesandCollections.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Experience in training and supporting end user needs using Business Objects
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Setup, Configured and Maintained Oracle Data Guards to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
• Experience in writing Shell scripts to backup, restore database and automate daily activities.
• Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
• Specify, design and implement modest changes to existing software architecture to meet changing needs. Oracle Golden Gate (OGG) provides a complete solution in high availability, real-time data integration, transactional change data capture, data replication, transformations, and verification.
• Extensively used advanced reporting functionabilities such as Master detailed, Drill, Filters, rankings, Sections, Graphs and Breaks
• Troubleshooting production issues, Performance Tuning, Physical Database design, Table Space Administration and managing Data Dictionary objects. Extensive SQL and PL/SQL skills
• Exposure to Dimension Data Modelling, Star Schema Modelling and Snowflake Modelling.
• Skilled in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.

TECHNICAL SKILLS

Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i.MS SQL Server

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB, SAP BO 3.0/3.1 4.0/4.1, UDT, IDT,Desktop Intelligence, Web Intelligence,Infoview,CMC.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatica (Power Center 5.1/6.2/7.1/8.6.1/9.1.0, Power Mart 5.1, Power Connect/Power Exchange, Data pump, Share Plex.

Data Modeling: Erwin 3.5.2, Star Schema, Snow Flake,Dimensional Data

Other: EMC, Data Pump, Data Guard VERITAS, Golden Gate, Oracle Wallet Manager.

PROFESSIONAL EXPERIENCE

Confidential - Sacramento, CA

Sr. Oracle Developer

Responsibilities:

• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Install GoldenGate software in Test region to perform POC
• Expertise on database design, SQL performance tuning and all aspects of high-value add applications database support and bull
• Setup GoldenGate Database User with necessary privileges
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.

Confidential, Providence, Rhode Island

Oracle DBA/PLSQL Developer

Responsibilities:

• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Meeting with the State Client, Deloitte and working RI Bridges tickets for the data fix scripts.
• Providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Understanding the Architecture by the kind of data modelling and the work flow by executing SQL scripts

Environment: Oracle OEM, Share Point, Jira, Jama, Windows 2010, RHEL 6.0, Pl/Sql Developer, RMAN, Data Guard, UHIP VPN Production Database.

Confidential, Dublin OH

Sr. Oracle DBA

Responsibilities:

• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Install GoldenGate software in Test region to perform POC
• Expertise on database design, SQL performance tuning and all aspects of high-value add applications database support and bull
• Setup GoldenGate Database User with necessary privileges
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

ENVIRONMENT: Oracle 12c/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, RHEL, HTTP, Golden Gate, Confidential -Secure SSH, Confidential -Secure FTP, Oracle Enterprise Manager 12c, TOAD, ASM, Data Guard other Oracle tools.

Confidential

SAP BOBJ Developer

RESPONSIBILITIES:

• Performed day to day admin tasks likemonitoring DB Services,creation ofuser groups and handled password resets,monitoring ofuser activities/ sessions, universe connection and availability checks.
• Conducted Study to BuildUniverse's Classes and Objectsinvolving everyday terms that supports Users. Object properties defining Measure, Dimension and Details were created.
• Involved increation of Reports, formatting reports, generation of charts, barsetc. as per user requirements usingWebI, Infoview.
• Developed new set of standardWeb Intelligencereports against the new universe. Completed ad-hoc data requests as required.
• Migrating the reports from WEBI 3.0/3.1 to Infoview 4.0/4.1 and testing the data in different environments.
• Creating complexdata flows with inner R/3 data flows and declaring parameters at different levels of Workflow.
• Supporting the end users with the development related issues and production support issues
• PerformedETL activitiesusingData Integratorand Data Services, by extracting data from various sources.
• Worked on certain issues and dealt withInfo View, CMC.

ENVIRONMENT: SAP Business Objects XI 3.1/3.2, XCelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, T-SQL, Oracle PL/SQL, Info View, CMC.

Confidential

Oracle Developer

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• UpgradedOracle 9i to 10gsoftware in different environments for latest features and also tested databases.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• UsedDiscoverer 2000to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000,Windows 2000, Toad.