EXPERIENCE SUMMARY

• Effective interpersonal, leadership and verbal communication skills
• Good analytical and problem solving skills
• Veritas VM, VCS clustering, NetBackup, Oracle OPS/RAC and Quest Shareplex.
• Administration of Oracle server software and 3rd party tools residing on the client i.e. SQL Net, TCP/IP, OEM, OFA/OSA, Express server, Discoverer .
• Intimate knowledge of data normalization theory and knowledge of object-oriented modeling with Unified Modeling Language UML and knowledge of other database design methodologies such as CORBA, XML, VB, JAVA and J2EE.
• Strong knowledge of Unix C and Shell Scripting on SUN Solaris, AIX, Linux and HP-UX Operating Systems.
• With over twenty years experience Project design, System architecture, Oracle database logical/physical design, deployment, management, and support with expertise in Oracle RDBMS, Financial Applications, E-Business Suite for both Window and Unix environments.
• Proven abilities on database administration and technical support in the following areas:
• Oracle RDBMS v7/v8/v9/10g/11g and its associated tools, and 3rd party client server tools, Business Objects Reporting Tools.
• Backup/Recovery administration for production/development Databases.
• Creation and installation of MS SQL Server 2000 Databases.
• Using Veritas Cluster Server and NetBackup for database backup and recovery.
• Support and administration of Oracle Parallel Server OPS , Real application clusters
• Implemented and enhanced SQL queries and PL/SQL package/procedure/function by using Oracle SQL i.e. DDL, DML and DTL etc.,

PROFESSIONAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

• Leaded in projects Web Attendance/Grade, Content Management, SCT Exeter 2.0.1.1 .
• Upgraded Oracle Applications release 11.5.0 to release 11.5.5.
• Migrated system above - from release 11.5.5 Windows to 11.5.10.2 Unix .
• Applications included Student Market System, Web Application, Reports and Oracle CRM, ERP, Workflow ...etc.
• Upgraded/Migrated/Implemented Oracle OEM Grid-Control, and XML Database.
• Using Recovery Manager with Oracle Data Guard in Oracle Database 10g/11g.
• Enabled/Automated the management of a disaster recovery solution for Oracle databases - database cloning, ASM, flashback technology.

Confidential

Senior Oracle DBA Consultant

• Leaded in Design and layout plan for new Market Trade Loading System.
• Wrote and enhanced stored procedures/function, packages and triggers to accommodate new schema for business logic.
• Convert inbound and outbound processes.
• Oracle 9.2.0.4 Installed under Linux RedHat 9 Servers.
• Configured a Real application clusters database for high availability, transaction processing, or query processing.
• Designed a Real application clusters database for scalability.
• Created a Real application clusters database.
• Develop a backup and recovery strategy for a Real application clusters database
• Used configuration and management tools for a clustered database
• Monitored and tune a Real application clusters database
• Identified cluster hardware and Real application clusters components

Environment: Windows, Linux, Oracle 9i RAC, PL/SQL, SQL Loader, Unix shell scripts, OEM with Tuning and Diagnostic pack. Oracle 9i application Server, Tomcat application, Data Modeling.

Confidential

• Oracle 9iAs Portal application server and database v9.2.0.0.1 support and administration.
• Oracle 8i upgrade to 9i with data migration into new application.
• Oracle 8i upgrade to 9i and designed input forms and reports on 9iAS.
• Trouble-shooting performance problem with their mortgage application and production database in Sun Solaris E450.
• Recommended Unix SA to add 2CPU and 8 Gb. RAM memory.

Environment: Sun Solaris 2.8, Oracle 9i/8i, OEM 9i, 9iAS, RAC, Designer 6i, PL/SQL, SQL Loader, Sun Unix shell scripts, TOAD, SQL Navigator and Windows NT/2000

Confidential

• Oracle Application v11.5.8 installation, customization, support and administration. Financial and other modules: Workflow, AR, AP, General Ledger, Order Management, Telesales, ERP, CRM, HR
• Upgraded Oracle Applications release 10.7 SC 16.1 to release 11.5.8. Worked as project lead for the entire upgrade, leading a staff of 9 developers, business analyst, UNIX administrators and database administrators. Applications included General Ledger, Applications Desktop Integrator, Payables, Purchasing, Assets, Receivables, Personal Time and Expenses PTE and Projects.
• Supported Trade Application project team refreshed test/QA schema from production database, QA stress/load testing.
• Backup and restore production databases snapshot of database for QA.
• Applied Oracle Application AR and OM patches using admin utilities like Adclone and ADPATCH, ADADMIN, ADCTRL, ADRELINK.
• Administered and monitored GFInet Trading databases in OPS environment.
• Installed and set up Oracle Financial/Sales analyzer and Express servers.

Confidential

• Installed Oracle Database v8.1.7 and v9.0.2 for Linux and NT environments.
• Wrote and implemented Unix Shell and DOS batch scripts for migration of database from Production to Development system.
• Trouble-shooting OEM Server setup and export/import problems.

Confidential

Senior Oracle DBA

• Oracle Application v11i/11.03 installation, customization, support and administration. Financial and other modules: Workflow, General Ledger, Purchasing, Payables, Order Management, Telesales, ERP, CRM and HR.
• Upgraded Oracle Applications release 11.03 NCA to release 11i 11.5.7 . Worked as the project lead for the entire upgrade, leading a team of business analyst and system users through the Oracle Receivables portion of the upgrade. This process included mapping of business requirements to 11i functionality, eliminating prior customizations where business requirements were met by new 11i functionality, updating functional specifications documentation where prior customizations needed to be carried forward, conducting multiple conference room pilot sessions to validate 11i functionally, conducting system tests and testing of integration with other application modules and outside systems Oracle Order Management, legacy order management systems, outside invoice/statement print vendors, and lockbox processors during multiple test upgrade passes, development of web based and instructor led training, and post upgrade support.
• Oracle Database server installation, migration, maintenance and administration in VISION , TEST, QA and PRODUCTION environment.
• Proficient in Application Object Library, Application system administration and admin utilities like ADPATCH, ADADMIN, ADCTRL, ADRELINK.
• Applied Product specific Patches and Mega post installation patches in ERP/CRM for Apps. modules.
• Very good knowledge of Oracle web, Form, Apache servers, Concurrent Manager.
• Conducted Oracle application testing in relation to several Oracle modules.
• Migrating WebLogic Applications to WebSphere Advanced Edition.
• Enhanced scalability using the Oracle Multi-Threaded sever future - for a given amount of memory it allows you to support a larger number of users than when using dedicated servers. especial for OLTP database
• Supported Content management project for the Content Engine 1 2 databases.
• Assisted developers on database objects designs - partitioning, bitmap indexes, materialized views etc.,
• Installed the Oracle knowledge modules for each database. Setting up a centralized OEM repository V2.1/2.2 to complement the monitor and analyze toolsets for databases.
• Responsible for administering, maintaining and troubleshooting over 20 instances of Oracle databases on Sun Solaris, Linux and NT platforms.
• Provided database capacity planning, performance tuning, upgrades, and migration from Oracle 8.0.5.1 to Oracle 8.1.6.3/8.1.7.2 using Oracle migration utility.
• Implemented robust backup and recovery strategies using Veritas VCS/NetBackup and Oracle Recovery Manager RMAN .
• Installed Hot Standby and Advanced replication for production instances.
• Involved in data process/ data modeling using Oracle Designer/2000 , Erwin Oracle's Web DB 2.2.
• Worked on a corporate Data Mart project . Involved in dimensional data modeling and designing the data staging process. Defined the requirements. Analyzed the source system. Designed the Star Schema. Converted the source flat files the media/text content data into the source module through OWB. Created the staging and data mart warehouse modules in OWB. Defined facts, dimensions and lookup tables. Defined the mapping and transformations for the source to stage mapping. Generated DDL for the facts and dimensions. Loaded data into the data mart using OWB. - running under RDBMS v8.1.7.2 of Unix Sun Solaris E4500.

Confidential

Role: Senior Production Database Administrator.

• Database storage monitoring and maintains. 24x7 On call support.
• Installed Oracle, created database, instances and standby database.
• Used the new features of Oracle 8i in the areas of Temporary tables, function base index, Partitioning of tables and indexes, index-Only tables, Parallel query and DML Options.
• Oracle MTS Configuration, Password management, Disaster recovery.
• Supported Business Objects Reporting Tools Informatica, Brio, Cognos administration for large-scale OLTP system - CIS 300 G. bytes production and QA databases.
• Refreshing database, imp/exp, backup and space management.
• Backup and Recovery using RMAN with Veritas Netbackup.
• Involved in writing PL/SQL stored procedures and triggers.
• Involved in data replication, creating snapshots and db links.
• Involved in database tuning for optimal utilization of resources - tuning of database block buffers, library cache, dictionary cache, latches and rollback segments.
• Tuned Oracle databases - Implemented Oracle new tuning STATSPACK.
• Involved in studying the existing data model, business rules and make the required changes in the existing logical and physical database design using Erwin.
• Involved in working on Windows related issues, installing from media, creating Oracle group and users, modifying registry, installation and configuration of OFA, setting up profiles/ links/permissions.
• Configure SQL Net on the Server and client PCs.
• Installed and upgraded the Oracle Server software from v8.0.5 to v8.1.6 and Application tools. Provided support to PC analysts in the areas of Oracle client software installation and upgrade.
• PL/SQL Procedures are created for the Informatica Transformations and Source Qualifiers.
• Informatica is used to extract, transform and load ETL data from original sources into a consolidated data warehouse database.
• Running and monitoring the mappings of the scheduled processes using Powermart Server.
• Enhanced the data transformation definition and execution metadata representation in the Informatica metadata repository.
• Upgraded and configured Informatica PowerCenter and PowerMart from v4.0 to v4.5 . Design and implement various components of Informatica metadata repository server.
• Provided installation and support for software products Cognos, Impromptu and Crystal Reports.
• Performed resource management and capacity planning.
• Created and maintained primary database storage structures by Oracle OFA and objects as necessary due to performance maintenance and disk usage requirements.
• Monitor database and application performance on regular basis and schedule/execute optimization procedures as required.
• Set up user access and maintain Oracle system security to the databases.
• Work with UNIX system administrator to plan for backup and recovery of database information using RMAN. Participated in disaster recovery testing.
• Provide aid in the use of the Oracle system and tools to IT developers, IT technical staff, and Oracle end users. Provided training as necessary.
• Defined database management procedures and established database standards.
• Developed technical documentation as necessary.

Environment: Sun Solaris 2.6/2.8, Oracle 8i, OEM 2.2, VERITAS Netbackup fail over, RMAN, PL/SQL, NT scripts, Window Cluster, Diagnostic and Tuning Tools, Standby Database, NT RAS, Citrix, Unix Shell Scripts, Terminal Server, Windows NT/2000.

Confidential

Consultant/Senior Oracle DBA

• Responsible for designing new databases for several In-house application projects.
• Leaded an Oracle DBA team of four members, supported the development of a DSS/Global Data Mart application for Data Warehouse Project Work closely with PriceWaterCoopers seven consultants on logical database design and data modeling, configured the multi-threaded server and created secured database user pool with approximately 120 users singed up. Handled various database change requests such as implemented partitioning several larger tables ranged by month value. This large scaled database is running under Oracle v8.0.5 on Sun Unix and Database size will grow about 600 GB in three years.
• Supported Manugistics Supply Chain Management QAD and administration installed patch upgrade Oracle OPS v7.3.4 to v7.3.4.2 in Open VMS environment.
• Developed performance monitoring scripts using dynamic performance tables as well as used OEM performance utilities Expert, Top-sessions, Diagnostics and Tuning packs . These are the OLTP production databases on Window NT using Oracle v7.3.4.2 resided in several branches.
• Provided technical assistance to developers for writing smart SQL and PL/SQL codes to avoid unnecessary trips to database to access the required data that resulted in overall performance gain.
• Developed a reliable and up-to-the-minute backup and recovery strategy for the Oracle RDBMS and verified it by simulating catastrophic situations.
• Supported projects of migration and enhancement of Sybase and MS SQL server 6 databases into Oracle v8.0.5 databases on Sun Sparc. The effort heavily involved PL/SQL procedure conversions, modifications and creations while testing interfaces with Manugistics production systems. Testing new introduced Maestro application to schedule database jobs. Additionally, identified data migration problems so that data could be cleaned or scripts could be modified to handle the problems.

Environment: Sun Solaris 2.5, HP UX, AIX, Open VMS, Oracle 7/8, MS SQL Server 6, OEM 2.1, RMAN, PL/SQL, NT scripts, Diagnostic and Tuning Tools, Standby Database, Citrix, Unix Shell Scripts, Windows NT/98.

Confidential

Project Leader/Oracle DBA

• Technical Leader of BRPP Project team for more than two years.
• Assumed various Oracle DBA responsibilities including installation and upgrades, creating database storage structures and primary objects, allocating system storage, loading data, creating and maintaining user accounts. Monitored and optimized database performance. Backup and restored database objects.
• Migrated Oracle v7.1.6 to v7.2.3 on HP UNIX - Used Full Export/Import for migration.
• Spread the tablespace storage across several disks to speed up the query performance.
• Had supported seven systems. These systems had on-line screens and batch Cobol II programs, utilizing IMS databases as well as DB2. Effectively shared and utilized designs and development skills to assure that these systems have so few production problems that mean time to repair is minuscule to nonexistent.

Skills