SUMMARY:

• Over 8 years of experience in the Information Technology field as Oracle Database Administrator having hands on experience in database administration, development, production support, installation, configuration, upgrades & patches, performance tuning, backup and recovery, cloning, space management, database security on various environment like Sun Solaris, RHEL, HP - UX, AIX, LINUX and Windows.
• 5 years of experience in full life cycle implementation of large Data Warehouse, Data Modeling, Logical/Physical design and Data Architect.
• Extensive knowledge on database administration for Oracle 11g /10g /9i/8i
• Solid experience in Oracle Recovery Manager (RMAN), advanced replication, and standby database using Data Guard
• Expert in Oracle PL/SQL Programming, writing Stored Procedures, Functions, Database Triggers
• Excellent knowledge in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring, cloning, upgrading of Oracle software & tools and migration
• Solid knowledge in performing import and export using Datapump
• Expert level knowledge in SQL, PL/SQL Programming, SQL*Loader
• Solid experience with logical and physical database design and implementation.
• Developed Materialized Views for Data Warehouse and shell scripts to automate
• Proficient in Oracle Database Capacity Planning, Administration, Data Modeling and Performance tuning
• Good knowledge working on multi node RAC architecture
• Involved in taking periodic Backup of the Database and the software using RMAN, VERITAS Cluster Services and Net backup
• Maintained Multi-Terabyte Production database as well as Development/Test/Stage databases supporting Data Warehousing and OLTP applications
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL*Net, V$ and DBA views
• Proficient with Oracle Identity Manager (OIM) install and configuration on Weblogic server
• Proficient with OEM Grid Control, ERwin, SQL Developer, RMAN and Veritas Cluster Services
• Capable of working under pressure and stiff deadlines with 24/7 Database support
• Experience in analyzing, translating business requirements to technical requirements and architecture
• Communicate with the application developers and business users as needed.

TECHNICAL SKILLS:

Operating Systems: UNIX - (Sun Solaris, HP-UX, AIX, RHEL), RedHat Enterprise Linux Server 5.4, MS SQL Server 2005

Databases: Oracle 11g R2/10g, 10g RAC/9i/8i, 11i (AP, OM, AR, GL), MS SQL Server, DB2

Languages: SQLPLUS, Perl, C, UNIX shell, T-SQL and Shell Scripting

Performance Tuning: TKPROF, EXPLAIN PLAN, STATSPACK, Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), SQL Tuning Advisor, SQL Tuning Sets, SQL Performance Analyzer and Active Session History (ASH), Memory Optimization

Database Backup & Disaster Recovery: RMAN, Cold & Hot backups, import/export, Data Pump

Tools: Oracle Discoverer 10g, Business Object, Informatica Power Mart, Oracle Warehouse Builder (OWB) 10g, Oracle Data Integrator (ODI) 10.1.3, SQL Loader, SQL Server Management Studio (2005), Oracle EM, Oracle Identity Manager (OIM), Veritas Cluster Manager 5.0.Toad, OEM DB Control, SQL Loader, Transact SQL

Database Modeling: Erwin and Embarcadero (ER Studio)

Other: Golden Gate, Oracle Data Integrator, OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, Tampa - FL

Senior Oracle DBA

Environment: Oracle 11gR2, 10g/10g RAC, SunOS Sparc, Linux Redhat, Oracle Identity Manager (OIM) 9.1.0.4, OEM Grid, Weblogic 10.3.3, Korn shell, TOAD, Remedy Datapump, Veritas Cluster Services

Responsibilities:

• 24x7 Production Database support of multi-terabyte Oracle 11g/10g databases
• As a member of DBA group of 16 DBAs, routine tasks include capacity planning, database design, creation, maintenance, backup and recovery, performance tuning, apply database patches, cloning for Disaster Recovery using Data Guard and UNIX scripting for automation for various processes
• Installed 11gR2/10g databases for various projects complying with DBA group’s specific best practices
• Installed and configured Oracle Identity Manager (OIM) on Weblogic server for security and auditing
• Implemented data warehouse history migration process using Data Pump Utility (expdp/impdp)
• Analyze requirements and prioritize requests. Communicate with users/requestors on their requirements, as needed
• Communicate with sysadmin group, managerial, administrative and technical staff to determine technical needs data flows and systems definitions
• Responsible for database code migration and maintenance during all lifecycle phases of the projects assigned
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database
• Tune SQL, PL/SQL statements found in the reporting utilities and queries
• Implemented different Partition Methodologies to improve performance and manageability.
• Involved in performance-tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention
• Involved in failover testing using Veritas Cluster Manager
• Troubleshooting Remedy tickets on database related issues
• Acted as primary point of contact between customer and core development team for certain projects
• Documentations

Confidential - Boston

Oracle DBA Consultant

Environment: Oracle 11gR1, 10gR2, Sun Solaris, Linux Redhat, Korn shell, PL/SQL, IMP/EXP, SQL*Loader, ERWin, TOAD

Responsibilities:

• 24x7 production support, Performance tuning/monitoring, manage user security and database development.
• Installation and configuration of the Development, Test and Production Oracle 11gR1/10g databases
• Created/maintained PL/SQL packages, procedures, triggers and functions for various projects
• Data Modeling, logical and physical database design.
• Installed and Configured Oracle10g Grid Control
• Upgrade/patches of Oracle products.
• Troubleshooting for Production database issues/Performance issues based on the tickets assigned
• Automated load process from flat files using External Tables/Unix scripts
• UNIX shell scripting for file ftp and processing.
• Coordinate and communicate with application development teams for database code migration per release.
• Create and manage documentations on processes and technical design
• Implemented various partitioning strategies for very large tables
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required
• Troubleshooting database production issues on a regular basis

Confidential . Tampa-FL

Oracle DBA

Environment: Oracle 10g, 9i, Oracle 10g RAC, Oracle 10g Grid, Sun Solaris, Linux Redhat, ERWIN 7, AWR/ADDM reports, ER Studio, Oracle Data Integrator(ODI) v10.1,RMAN, 10g Grid Control, SQL Server 2005, MS-SSMS, Teradata

Responsibilities:

• Manage and support Oracle DB (3+ TB) and SQL Server 2005 databases on a 24x7 production support.
• Database performance monitoring and troubleshooting using OEM, ADDM & AWR reports
• Installation and configuration of Development, Test and Production Oracle 10g/9i databases
• Performed periodical Backups and using RMAN and maintain standby databases using Data Guard
• Acted as the primary point of contact for the DBA group and project managers for various projects
• Maintain and manage Oracle 10g RAC (Real Application Cluster) environment 3 nodes on ASM
• Troubleshooting application SQLs and database performance tuning, table partitioning, tablespace reorg
• PL/SQL packages, functions, materialized views and UNIX shell scripting for application performance
• Data Warehouse data cleansing, developed archiving and purge process.
• Responsible for database changes for the projects assigned and code migration process from development to production
• Support QA team on replicating the production data on the QA environment.
• 9i to 10g upgrade in all the test and stage environments.
• Documentation on best practice for naming convention and code migration process by coordinating with the developing teams and their schedules.

Confidential, Tampa-FL

DBA/Data Architect

Environment: Oracle 9i, ERWIN 4.1.4, Data Mirror5.0, Sun4u Sparc v5.8

Responsibilities:

• Database design, performance tuning and maintenance.
• Responsible for developing and maintaining enterprise model blueprints
• Logical modeling and physical database implementation using ERWIN
• Data conversion and migration from DB2 on AS400 to Oracle database on Unix.
• Shell scripting for ftp file processing and management.
• PL/SQL packages, procedures and function and Triggers.
• Automated loading and billing data process for online client dashboard using SQL*Loader
• Import/Export for data migration and schema creation QA testing environments
• Work with corporate business users and developers on database requirements.
• Assist developers and business groups on data models, data identification and conversion as needed

Confidential - New York, NY

Senior Consultant

Environment: Linux Redhat 3.0, IBM Itanium, Oracle 10g, OWB 10g

Responsibilities:

• Installed Oracle 10g database software on development, staging, QA and production environments.
• Installed and configured Oracle Warehouse Builder (OWB) 10g - designer and runtime repository on development and stating environments and runtime repository on QA and production environments.
• Create OWB mapping and source sample data for training.
• User training on OWB designer, mapping and code migration processing

Confidential - VA

DBA / Data Warehouse Lead

Environment: IBM Itanium, Oracle 10g, OWB 10g, Discover4i

Responsibilities:

• Install and configure Oracle 10g database on development, QA and production environments.
• Worked with business and end users to gather requirements for (TSD) technical design document.
• Logical and physical design of the data warehouse.
• Implemented table partitioning, bitmap index and materialized views for performance on a very high volume transaction environment.
• ETL process architect, design and strategies.
• Prototype presentation to the client.

Confidential - NJ

DBA/Lead ETL Architect

Environment: Oracle Warehouse Builder 10G, Discoverer 4.1.47, Oracle 11i (AR and OM), LINUX

Responsibilities:

• Designed and implemented full lifecycle Sales Data Mart
• Logical star schema modeling and physical implementation of the Sales data mart.
• Architect ETL process to extract data from Oracle Applications (OM, AR, AP) modules.
• Initiated the migration process from development, QA to production environment.
• Created and configured EUL (End User Layer) and sales report prototypes.
• User training on Discover Administration and reporting.

Confidential - CT

Oracle Reports Lead

Environment: IBM RS6000 AIX V4, Oracle 6i and 9i, PL/SQL, Discoverer 4.1.46

Responsibilities:

• Developed dashboard reports on Oracle Portal for Sales & Service group
• Created PL/SQL package and functions to extract data from Oracle Applications (AR, WSH, MTL, ONT) modules.
• Database and SQL performance tuning to reduce report runtime by creating materialized views, functions table partitions and indexes.
• Created Discoverer reports running against the custom tables and materialized views.

Confidential - New York City

Oracle DBA

Environment: Oracle 9iAS, Discoverer 4i, Portal, Unix, Korn Shell

Responsibilities:

• Install and configure Oracle 9iAS and portal on Sun Solaris.
• Setup Discoverer 4i and configure 9iAS portal.
• Created Oracle Admin Discover EULs (End User Layer) for reporting.
• Imparted user training on Oracle Discover.

Confidential - NJ

ETL Technical Lead

Environment: SUN4u Sparc 5.8, Oracle 9i, PL/SQL, UNIX shell scripts, Informatica PowerMart V-5.1.2, Business Object 5.1.6.

Responsibilities:

• Designed and architected Point-Of-Sale data for client’s retail data warehouse
• Data sourced from TOMAX (Retail POS system), transformed and loaded into the retail dimensions and fact tables.
• Created star schema data model for the POS SALES FACT and INVENTORY.
• Logical & physical design of the star schema and ETL process architecture to load the target schemas.
• Full lifecycle implementation from DEV, QA to Production.
• Developed Sales, Inventory and Financial reports in Business Object reporting tool for business users based on Sales and Inventory Universe. Emphasized user access/security on the Universe.

Confidential - NJ

Oracle Reporting Technical Lead

Environment: IBM RS6000 AIX V4, Oracle 8i, PL/SQL, Unix, Forms and Reports 6i, 9iAS Rel1 on NT.

Responsibilities:

• Designed, developed, and implemented a reporting environment using Oracle Reports accessing OFSA (Oracle Financial Services Application).
• Lead the Source System Analysis initiative, mapped source data into the reporting data mart, and designed & developed the data migration/load routines to support the Data Mart Reporting System.
• Database reporting tables, PL/SQL packages and procedures to load reporting tables from OFSA.
• Setup Reports and Forms to run in an Oracle 9ias environment on NT Server platform.
• Reports for Sr. Management, Customers, and Organizational Profitability

Confidential - CA

Lead Developer

Environment: LINUX V 0.9.6, Oracle 9i, PL/SQL, Reports 9i.

Responsibilities:

• Interview business users and documented the functional specifications and technical requirements.
• Put in place Data Migration, ETL and loading processes, extract processes from source OFA, PAA and Oracle financials (AR, AP GL) modules to the reporting environment.
• Designed and developed multiple financial reports using Oracle Reports for an executive management scorecard.
• Implemented the security within Oracle Portal to ensure data reported is based on the user security level interfacing with SSO (single sign on) feature.

Confidential - NJ

Technical Lead/Developer

Environment: Compaq Tru64 UNIX V.1, Oracle 9i, PL/SQL, Oracle Discoverer, SQL LOADER, SQL Navigator, UNIX, korn shell, Forms 6i, 9iAS R2

Responsibilities:

• As lead developer developed consultant skills and training path portal
• DBA tasks: Database design, backup/recovery procedures, production support.
• Data Architect (Source data analysis, mapping, and ETL development).
• PL/SQL packages and triggers, Oracle forms 6i and Discover reports for various user groups.
• Install Oracle 9iAS application server.

Confidential - CT

Discoverer Reporting and ETL Technical Lead

Environment: HP-UX 9000, Oracle 8.0.5, PL/SQL, Oracle Discoverer, SQL LOADER, SQL Navigator, Unix, korn shell

Responsibilities:

• Responsible for designing, developing and maintaining the decision support reporting environment
• Developed Operational & Planning, Sales, Profitability and Product Data Marts.
• Created load Modules for populating various Data Marts using PL/SQL and SQL LOADER.
• Upgrade from Discoverer 3i to Discoverer 4i.
• Tuned the Oracle End User Layer (EUL) for performance.
• Various Discover BI reports for business and sales users.

Confidential - NY

ETL Team Lead/ Developer

Environment: Unix, Korn shell scripts on sun4u Sparc SUNW Ultra-4, PL/SQL, Oracle 8.1.6, Awk/Sed

Responsibilities:

• Developed automated process to capture click stream data and load to Oracle matrix tables for analysis and reporting using UNIX shell scripts.
• Automated several extract processes from the Oracle matrix tables to data warehouse using ETL/PLSQL processes.
• Improved controls by creating error or success messages for each load and sending results via e-mail to the group administrator.

Confidential - New York City

Developer/Data Architect

Environment: SUN Solaris, Oracle 8I, SQL Loader V8.0, Developer V6.0, PL/SQL, PL/SQL Procedures, Unix, Korn Shell

Responsibilities:

• Created logical and physical database design for the DW/DSS application using Developer V6.0. Developed ETL process and workflow to load data warehouse schemas.
• Designed interface from Oracle Application to the DW dimensional model using SQL Loader and scripts to extract data from the source database.
• Oracle BI reports for dashboard reporting and presentation

Confidential - Danbury CT

Team Lead/Developer

Environment: RS6000 (AIX), UDB5, SQL, CGI, Perl, C, Korn Shell, HTML, ERWIN V4.0

Responsibilities:

• Responsibilities include database design and development, database consulting in UDB5, coding, testing and implementing on the production server.
• Designed and developed the front-end tools for user interface to this application. Coding includes embedded SQL in ‘C’, DDLs, DMLs, Database triggers, CGI, Perl Scripts, HTML, UNIX (Korn Shell) scripts.

Confidential - NY

Senior Developer

Environment: IBM AIX, RS6000, DB2 V2.1, ERWIN, API, C, Shell, awk, sed, WindowsNT

Responsibilities:

• Responsible for the logical & physical design. As DBA consultant, designed physical database using the ERWIN Case Tool for data modeling on DB2 and developed database backup/archiving procedures.
• Developed web-forms for database administration and customer service tools using HTML, Net.data, CGI, embedded SQL scripts, IBM Live Connection Manager, and API library to provide control for service and network management.