SUMMARY:

• Confidential Instructor Led Training: Oracle 12c, Linux Operating system, 11i implement Configurator; Administering Oracle CRM Contracts; Implement Contracts Core and Contracts Service; 11i Workflow; Oracle 9iAS Portal; Payroll Technical Foundation 11; Public Sector Budgeting Oracle 11i; Java Programming; Oracle 8i: New features for Database Administrators; Oracle 8: Database Administration; Oracle 8: Backup and Recovery; Data Modeling and Relational Database Design; Design and Building of Database Objects; Oracle 7: Database Administration; Oracle 7: Backup and Recovery; Oracle 7: Performance Tuning;
• PMP certified training.
• Self - Study: CRM 90 Days; XML Gateway; Oracle Alerts; Discoverer; 11i System Administration; Jdeveloper; Java; JSP;
• JavaScript, HTML DB, Data Warehouse, Oracle 10g

TECHNICAL SKILLS:

Languages: SQL, SQL*PLUS, PL/SQL, Shell scripts, Pro*C, Visual basic, XML, JSP

Databases: SQL Server, Oracle Database versions 7, 8, 9i, 10g and 11g. RAC, RMAN, SMO, OEM, ASM, Upgrades, Clones, Performance Tuning, Production and Development support, Backups and Recoveries, Team Lead for DBAs.

Operating Systems: LINUX, Windows 2008, Windows 2003, Windows NT/Win 2000, Windows 95/98, VAX/VMS

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Administrator

• Manage multiple Oracle(12c/11g10g/9i/8i) and MS SQL(2005/2000) databases in supporting various Overseas Building Operations (OBO) COTS applications including TRIRIGA, LIVELINK, ARTESIA, PRIMAVERA, SUCCESS ENTERPRISE, MS PROJECT SERVER, etc. Responsible for database installation, creation, and administration in development, test and production environment. Implemented the Department of State database security lock down, ensuring that the databases are maintained at acceptable levels of risk. Implemented the database backup strategy using RMAN and NetApp Snap Manger for Oracle (SMO). Perform database restoration and recovery due to databases failures or crashed. Performed database tuning using Toad Spotlight, Statspack, OEM, DBArtisan. Cloned the databases from production to test for new development testing purposes. Provided application development support for internal developers. Installed and configured Project Server 2002 with Microsoft Share Point and SQL Server 2003. Implemented the TRIRIGA migration from version 9.0.4 to 2.5.1. Installed the Primavera P5 client version on user computers as required. Managed and Created the Primavera users account and setup the appropriate roles and permission. Installed and setup the database for Eureka report designer on user computers as required. Created and Managed Eureka users and roles. Created, updated the Eureka metadata files for customized report designer. Developed scripts for extracting the data for Real Property Report.

Confidential

• Worked on Application Express migration from 2.2 to 3.2. Data migrations from 10g to 11g. Involved in performance tuning, database backup and recovery strategy for BANNER education system database and other databases. As an Oracle Apps DBA, installed and managed SOA (Fusion) 10.1.3.4 on CRS, RAC and related applications. Integrated SOA, BI and JDK on linux 5.0. Installed SOA on top of CRS and used cluster technology with RAC. Created clones of Oracle Applications release 11i and Databases release 10g. Worked with Confidential in implementations. Created power point presentation and helped developers use SOA and BI. Helped in Fixed Assets Migration, Worked on developing ACH automated payments and BIG-e automation. Shareplex, Cloning of databases and applications. Oracle Applications 11.5.9 and Oracle Database 9i. Provided support to production, development, test environments using Oracle Applications and Databases. Environment is Oracle Applications 11.5.10.2, Sun Solaris, Database 9.2.0.7, Clusters and RMAN. As a member of a team of 3 DBAs provided production support to Oracle Applications (11.5.10.2) and Database 10g on RAC. Also provided technical support to the development team. Worked on Upgrade of Oracle applications to 11.5.10.2. Environment is Oracle Applications 11.5.10.2, RAC, RMAN, linux, database 10.0.2.2.

Confidential

• Managed a team of about 10 DBAs involved in Oracle Applications migrations and upgrades of Applications from 11.5.9 to 11.5.10 and then to 11.5.10.2 involved in the upgrade of Oracle Database from 9i to 10g. As a development DBA involved in maintenance, performance tuning, upgrades, applying patches, patch sets and migrations of Databases and Oracle Applications. Worked on shareplex (Oracle Steams). Worked as production and development applications DBA. Managed the team member's schedule, rotations and interaction with IDC (India Development Support) for overnight support.

Confidential

• Provided Technical support to Oracle Applications (11.5.9) and Oracle Database (8i). Cloned Oracle applications (Financials) 11.5.9 and Oracle database 9i. Sun Solaris Operating System. Fixed technical issues related to Oracle Financials. Used tools such as SQL Navigator, Adpatch, autoconfig and RAC.

Confidential

• Worked as a Member of Oracle Applications Technology team. Responsibilities include, Apps DBA, Database Administration (8i, 9i, 10g), System Administration such as concurrent manager, apache and application server monitoring, upgrades of Oracle applications and database, Backup and recovery and tuning of Oracle Database. Running patches, adadmin tool, Technical issues in Oracle applications 11i (11.5.6, 11.5.7, 11.5.8, 11.5.10). Experience in fixing TARs in different modules and tools such as Oracle Financials and Cash Management, Oracle HRMS, Oracle Projects Accounting, Order management, Service Contracts, HTMLDB, DBI, Workflow, Forms, Alerts, e-Commerce and XML Gateways, XML Publisher, iStore, Supply Chain, Workflow Builder, Message Builder, Concurrent Requests, RTs using Winrunner, Oracle scripting, Oracle Stream, TOAD and SQL Navigator. Operating systems include Sun Solaris, Linux.

Confidential

• Worked as a Database Administrator in the production DBA team involved in the merging of databases and migration from Sybase to Oracle. Undergone training in cellular phone billing system (VIRTUOSOII) and related modules such as financials, market, order processing, collections, customer care, inventory and billing with ALLTEL. Worked in the redesign and reengineering the Real Estate Management Information System (REMIS). Created database objects in the physical database. Implemented business rules and data integrity using check constraints. Managed tables and indexes. Used database administration tools. Tuned applications, SQL scripts. Attended Hotline calls to monitor day-to-day maintenance of Applications. Designed and re-engineered the ER-diagram. Redesigning the existing SQL*Forms 3.0 system using Designer 2000 into Forms 4.5 and Generation of Reports 2.5 using Designer 2000.