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:

• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• 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
• Data Guard using physical standby database, implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• 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.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• 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:

• As an Oracle DBA, I am working directly with the Confidential (UHIP) to facilitate reviews of data scripts and data root and run queries to test data fixes within an Oracle environment and root cause analysis with double as data script approver (focusing on data integrity checks and fixes)
• Performing day to day activities using OEM such as performance diagnosis and tuning, setting up and scheduling RMAN database backups, and setting up and managing Oracle Active Data Guard, cloning and provisioning, configuration management and monitoring of the server, operating system and database management to schedule and execute scripts at the database or operating system level.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Meeting with the State Client, Confidential 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:

• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• 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
• Data Guard using physical standby database, implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• 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.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• 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:

• FulfilledBusiness Analystrequirements by CompletingUniverseDevelopmentLife Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop UniversesMeeting User Needs and Requirements from both technical and strategic views of an organization.
• Involved in establishingSAP BO connectivity with Universe Designer and Business objects Infoview, using SAP integration kit and installedjava connectorto import the roles of the SAP user to Business objects.
• 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.
• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc., and Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.
• Designed complex reports based on discussions with user groups and created various objects using built-infunctions (like prompt, select, where, and aggregate),complexSQL queriesand joins. Thus, considering best business practices usingWeb Intelligence Rich Client.
• 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.
• Developed Cross Tab Reports, Sub Reports by usingCrystal Reports2008 andembedded Xcelsius onto Crystal Reportsfor better results and provide users with clear understanding.
• 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.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• 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.
• Designed Data Modeling, Design Specifications and to analyzeDependencies.
• Creatingindexeson tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• 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.