SUMMARY:

• Looking Part time job 20 hours a week night shift DBA jobs only
• Over 20 years of experience in the IT Industry having extensive experience working as an Oracle Database Administrator. (DBA) and worked 10 years as Business Intelligence Consultant. Hands on experience include extensive work on database administration and support using Oracle 9i/10g/11g. Have working knowledge on SQL Server. Experience include working on RAC databases, ASM, data guard, Oracle Audit Vault, Oracle Streams, Golden Gate, Disaster backup and recovery from RMAN and Networker tape backups. Worked on different ETL tools like Oracle Warehouse builder, Informatica. Have knowledge on Oracle Endeca and OBIEE. Worked on reporting tools like Business Objects and Cognos.

TECHNICAL SKILLS:

OBIEE: Oracle Endeca

Oracle Real Application Clusters (RAC): Oracle Enterprise Manager (OEM)

Oracle Audit Vault: Oracle Streams

Configuring/maintaining ASM storage: AWR, ADDM, Statspack

Oracle Enterprise Grid Control (GRID): Golden Gate

Install/maintain Oracle Data Guard: IBM AIX Unix/HP Unix

Oracle Data Integrator: Windows Server 2003/2008

Red Hat Enterprise Linux: Network Configuration/Setup

Cognos: Business Objects

SQL and PL/SQL: Recovery Manager (RMAN)

Data Pump (export/import): SQL*Loader

SQL*Plus: Networker tape backup

Informatica: Oracle Warehouse Builder

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential

Responsibilities:

• Install, configure, manage and administer Oracle 10g/11g databases in test, development and production environments running on HP UNIX and Linux servers.
• Setting up Oracle streams on both source and target ODS database using capture, propagation and apply process.
• Perform installation of Oracle Database 10g/11g software and Oracle Enterprise Grid Control.
• Installing the Oracle Audit Vault databases and creating the collectors for all the databases.
• Administer and monitor databases using OEM Grid Control.
• Install and configure Oracle 10g RAC databases with ASM on new servers.
• Configure standby database using Oracle Data Guard for Data Replication.
• Configured Golden Gate on ODS source database to push the trial files to EIS target database.
• Manage backup/recovery using RMAN backups performing hot and daily incremental backups and work with restore and recovery using networker tape backups.
• Installing 3 - Node RAC and configuring the RAC databases.
• Troubleshoot issues relating to performance or storage and documented the root cause analysis for the issues.
• Create and maintain users, roles, privileges and assign roles to users.
• Upgrade Oracle databases to latest version and patch levels and worked on issues related to these patches and fixed them.
• Work with developers to fix or improve database related issues.
• Support the database to resolve data related issues providing 24x7 rotational efforts.
• Installing and troubleshoot issues with Oracle Golden gate.
• Performed Export and import of data and debug issues with the process.
• Worked with Oracle support on various issues and fixed them.
• Tested Production backups from tapes to ensure that that disaster recovery process is working without issues.
• Attended training on Oracle Data guard and configured the data guard environment.
• Performed Rolling patch upgrade on the 3- Node RAC database.
• Attended and actively participated in change control and release control meetings to ensure the changes are moved from migrated to different environments from test environments.

Oracle Business Intelligence Consultant

Confidential

Responsibilities:

• Gathered requirements for the Business Intelligence reporting.
• Worked on analysis of different tools like tools OBIEE, ETL tools like Informatica/Oracle warehouse builder.
• Created and developed complex mappings using Oracle warehouse builder ETL tool.
• Tuned long running report and reduced report time by 75%.
• Performance tuned long running EOM/BOM jobs at CalWIN.
• Used OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, creation of users, schemas, Tablespaces and other database objects.
• Worked with the developers to fine tune the SQL code.
• Worked on star schema and dimensional modeling.
• Extensively used different transformations like filters, aggregators, splitters etc .
• Scheduled ETL jobs as processes.
• Migrated the ETL mappings from development to test, pre- production and then to production environment.
• Developed exception reports and management reports using Business Objects reporting tool.

Oracle Database Consultant

Confidential, Oakland, CA

Responsibilities:

• Analyzing dependencies across several schemas/applications and designed and documented the migration process that is least disruptive. . Discovered and dropped many unused objects before migration. Developed the DDL scripts for the migration of several schemas
• Designed and developed intermediate processes and creative workarounds when all the data cannot be migrated at the same time using SQL, PL/SQL, Shell scripts.
• Set up RMAN backups, exports and automated other maintenance tasks for the 11g databases. Implemented best practices for Oracle Backup architecture, schedules, retention times, offsite backups etc.
• Applied Oracle 9i/10g installation upgrades and patches.
• Troubleshooting any problems that the primary DBAs could not resolve.

Senior Oracle BI Consultant

Confidential, Atlanta, GA

Responsibilities:

• Loading the Data from Oracle database to enterprise data warehouse.
• Loading the Data flat files to the staging tables and the Enterprise Data warehouse.
• Creating Views and Stored Procedures.
• Worked with star schema.
• Created ETL mapping and transformation specification for the ETL load process.
• Loaded data into the staging area using the mappings and then loaded the data from the staging to the data warehouse environment.
• Loading the data from SQL server to the Oracle tables
• Used PL/SQL bulk insert to insert the data into multiple tables.
• Wrote Database PL/SQL triggers as needed to meet the business functionality.
• Usage of DBMS Scheduler to run the batch job process.
• Tuned PL/SQL Packages and PL/SQL Stored procedures /Functions to improve the performance using explain plan, TKPROF.

Senior Oracle Database Consultant

Confidential, Roseville, CA

Responsibilities:

• Installation and configuration of Oracle servers and creation of databases in Windows environments.
• Troubleshoot performance problems.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of cron jobs.
• Establishing and monitoring database backup and export schemes (hot/cold).
• Provide Proactive and innovative ideas while coming up with the table designs and structure.
• Develop Load scripts using SQL*Loader.
• Developed PLSQL Packages, Stored Procedures and functions.
• Involved extensively in performance tuning as we were processing more than a million records at a time.
• Tuned packages and anonymous blocks by studying the pattern of data flow.
• Participated in Performance Tuning using Explain Plan and TkProf.

Oracle Database Consultant

Confidential, Madison, WI

Responsibilities:

• Created procedures, functions, packages, and triggers using PL/SQL.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Involved in the Design (Logical & Physical) and maintenance of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Oracle database administration on Solaris platform.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles, Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Oracle Database Consultant

Confidential, Redwood City, CA

Responsibilities:

• Project for Oracle Database support and Oracle DW Setup for marketing
• Created and managed projects plans and risk mitigation plans.
• Performed requirements gathering, design, development, test and deployment.
• Coordinated all project activities with business owners and other support, technical infrastructure and application teams.
• Reviewed and managed all changes to the requirements through a formally defined scope change process.
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 9i databases.
• Migrated production and development environments from Oracle 8i, Oracle 9i, Oracle 10g RAC environment. Responsible for installing, upgrade and configuring the Oracle.

Business Intelligence Consultant

Confidential, Sacramento, CA

Responsibilities:

• Designed backup and recovery procedures for OLTP system, performing periodic cold and hot backups.
• Database cloning done to create test and training environments.
• SQL, PL/SQL Programming. Written PL/SQL Functions, Procedures, Packages and Triggers.
• Partitioned large tables to increase the performance and manageability.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Backup Databases & Transaction Logs / Archives Logs.
• Periodic Testing & Review of Backup and Recovery Strategies.
• Performed Database Back Up, Repairs & Recovery
• Monitored System Resource Usage (Memory, CPU, Drive Space & I/O) & Event Logs
• Setting up Tasks and Alerts.

Oracle Warehouse Builder Consultant

Confidential, Florida, FL

Responsibilities:

• Used Various types of sources like COBOL/Mainframe
• Extensively used various types of Transformations De-Duplicator, Set - Operation, Pivot Operator, Key Lookups, Aggregator Transformations, Filter Transformations, Mapping table, Mapping Transformations, Joiner and Splitter Transformations.
• By using OWB deployment manager in OWB, deployed all the mappings from QA Environment and Production Environment.
• Configured Locations and connectors in OWB designer.
• Involving Performance tuning of the mapping. Creating various types of indexes like
• Bitmap indexes, unique indexes.
• Creating Tables in OWB, Writing Functions and Stored Procedures in Oracle using PL/SQL.
• Involved in Creating Backup Scripts to restore the database
• Involving in Creating Work Flow Diagrams.

Senior ETL Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Developed various transformations using Oracle Warehouse Builder for migration of data from the Source to the target database
• Developed various Mappings by using different transformations for migration of data from the Source to the target database using .Oracle Designer
• Created Process Flow Diagrams
• Involved in performance tuning of the long running sessions. Involved in creating UNIX shell scripts for creating the Ghost (Source) Scripts as the source is Oracle DMP files.
• Involved in Partitioning of Large fact tables and in performance tuning.
• Created PL/SQL Stored procedures and Functions and called these through Informatica.
• Created the Job chains in Redwood Cronacle to automatically the daily load process of OHR load
• Extensively used Power play Transformer to move relative data mart data into powercubes and cube groups
• Involved in testing of all the sessions that have been migrated to version 6.1.2.
• Changed the reporting tool from Business Objects to Cognos.

Senior Informatica/Cognos Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Worked on AP and AR Oracle Apps Modules.Developed various Informatica Mappings, and Transformations for migration of data from the Source to the target database using informatica designer.
• Involved in performance tuning of the long running sessions. Extensively used transformations like lookups, stored procedures, Expressions, Aggregations, etc.
• Involved in setting up of Cronacle for VCF- Variable Compensation Feed Informatica mappings.
• Involved in creating QUOTE mapping which extracts data from the Blob to XML File. Used XML file as the source and created the mapping to populate the Quote Target Table. Extensively used Power play Transformer to move relative data mart data into powercubes and cube groups.

ETL Developer

Confidential, New Jersey

Responsibilities:

• Used Informatica ETL tool to transfer Data from DB2, flat files data into Oracle. Developed various Informatica Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using Informatica Designer.
• Used Server Manager to create sessions and batches and Repository Manager to give Permissions to users and to create new users .Worked on Power play Transformer to move data mart data into power cubes and published the power play reports using Upfront.Designed and developed catalog by creating links between the Fact table and the dimension table to form a Star Schema

ETL Developer

Confidential, New Jersey

Responsibilities:

• Extensively worked on Oracle warehouse Builder ETL tool for Extraction and transformation of data. Worked on PL/SQL stored procedures. Worked on COGNOS Impromptu and power play for analysis of reports. Responsible for creating Dimensional Maps, Transformer Models, Power-Cubes, Drill through and detail reports, catalogs, folders, filters, prompts, calculated columns and conditions for multi dimensional analysis.
• Used Teradata External Loader load utility to load the data into Teradata database.

Oracle Developer

Confidential

Responsibilities:

• Created Custom ETL using SQL Loader and PL/SQL routines to interface client legacy systems, which increased overall quality of incoming data