TECHNICAL

SKILLS:

Oracle 7.3x 8.0x, 8i, 9i, 10G, PL/SQL 10G, Onyx Administration, Vantive CRM, Genesys CTI, Upstream Works CTI, Sybase 11, ALSB, Aqua Logic Service Bus, Web Logic Server Administration, Informix 7.3.4, 9.4, HPloadder, SQL Server 7, SQL Server 2000/2005/2008, Unix Solaris 2.6 - 2.8, HP-Unix, Peoplesoft 7.x 8x, Peopletools, Kronos 4.3, PTC WINDCHILL, Quest Central Quest Spotlight Monitoring Tools, Quest Live Reorg, Clarify, Oracle Financials 11i, ER/Win, SqlBacktrack, HP-UX, Autosys/Trivoli/ Remedy, Oracle RMAN, SAP/R3, Oracle Forms 3.5/4.0, Unix Shell Scripting, Windows NT, 2000, Clarify. PL/SQL, SQLPLUS, Oracle Enterprise Manager OEM . SQL Navigator, SQL Loader, Java, Visual Basic, Actuate Reports Server, Web Design, HR Vantage, NU View, Kronos, Ceridian, ADP Payroll Software, Linux, AIX OS, ETL/Informatica, Peoplesoft 8.8, 9.0, Oracle Data Guard, Oracle 10G Grid Control, Oracle OEM, Oracle Financial, RAC Stretched Cluster, Oracle Express, CICS, JCL, Control-M, Veritas Cluster, Oracle 11G, Oracle 11i E-Business Suite, Oracle Discoverer, Oracle Browser, SSL,LDAP, JAX-WS, JAX-B, JAX-R Portlets, JSR 168, JSP/JSF, Service Discovery UDDI .Visio, Nexprise, Windchill, ABAP programming, Microsoft Excel,SOA, Web Services, PTC Windchill, Java, JSP, HTML, JavaScript, Windchill PDM Link Toolsuite, Windchill PDM Link 9.1. Guardium, Arcsight, Sophos, S-tap, Phython, Perl, Golden Gate, IBM AIX 5.3,6.1 on P550, IBM Director, Remedy, BMC Patrol, Morphotrak, Gogent, Oracle 11R2, Data Guard, ASM, Oracle Clusterware, Oracle 11G Grid Control Red Hat Linux 2.3. Trivoli Storage Management TSM . Oracle Application Express 4.0. Backup Exec. VMware, EMC Clarion CX3,CX4 SAN Administration. ClearCase. Veritas Netbackup, Shadow Image.AIX 5.3/6.1 Virtual LPARS, Amisys R5, Appsworks, Millman ASP, .NET, Cypress, Interactive Intelligence, Spruce, Tomcat, Apache. Health Care Economist. Manhattan ERP Product.

EXPERIENCE:

Confidential

Senior DataBase Administrator

• Upgraded Amysis R1 to Amysis R5 on Oracle 10.2.0.4 on HP UX
• Performed Capacity Planning analysis and Performance Tuning before and after Upgrade of Amisys R5.
• Trained in Health Care Economics Explanation of Benefits, Explanation of Coverage, Symmetry, ICD-9, UB-92 etc
• Administered and Monitored Oracle 10.2.0.4 on an HP UX
• Built a Logical Standby Database using Oracle 10.2.0.4
• Participated in Amisys R5 Health Care Information Management Application Stress Test.
• Wrote SQL Server Credentialing Reports for NCQA Conference.
• Wrote ICD-9 Codes Report for Ingenix Vendor.
• Supported Enrollment, Claim Payment System, Underwriting users etc on a Daily Basis.

Confidential

• Senior Oracle DataBase Administrator Integrated Netbackup with Oracle RMAN for an Oracle Database 11.0.6. Refreshed Oracle Database schemas from Test to Productions using Data pump import/Import for Oracle 11G. Performed Oracle Tuning for Oracle Standard and Enterprise 11G Databases. Administered Large Oracle Databases on Oracle 11G uisng IBM AIX P750. Implemented Oracle E-Business suite and Oracle SOA integration.
• Installed Oracle 11G using X-Windows. Studied and Analyzed Capacity Planning for Oracle 11G Databases for an ERP Product called Manhattan.

Confidential

Senior Oracle DataBase/SQL Server Administrator.

Led the Development Support team in performing database administration-related tasks on current Oracle and SQL platforms. Led Specific project assignments to include capacity planning / growth trend analysis, performance tuning, developing best practices for patch management and backup/recovery, replication setup and recommendations, enforced auditing/security procedures, establishing centralized monitoring servers and perform cross-training of staff regarding implemented projects/procedures On Oracle 10G/11GR2 on Linux and Unix Platforms. Upgraded Oracle Application Express to Version 4.0. Tuned SQL Server including sql clustering mirroring, db performance tuning, capacity planning, sql monitoring, backup recovery. Supported Nightly batch processing using DTS and SSIS packages. Migrated Oracle Databases between different O/S and hardware architectures migrating from physical to virtual environments . Performed Installations, upgrades and patch updates. Used DB Artisan and Quest Software including TOAD. Wrote PL/SQL Scripts to automate Oracle tools for Monitoring and Backup. Reviewed Alarm Monitoring and Backup Software for server environments. Experience in Veritas and Sun Cluster Server. Familiarity with Sybase ID and Golden Gate. Used Oracle Grid Control for Central DataBase Administration and Management. Developed, Implemented and Supported high availability and disaster recovery strategies for Database Environments including backup, restore, replication and fail over. Installed, Supported, Tuned and administered Oracle 10G/11G RAC ASM, OEM 11G Grid, Data Guard, Flashback Technology on SUN SOLARIS/LINUX environments. Managed Log Growth in SQL Server 2005/2008 Set up Automatic Threshold alerts in OEM 10G Grid Control. Evaluated and Recommended third Party Monitoring tools. 24X7X365 on call Production Support.

Confidential

Senior Oracle DataBase Administrator

Participated, Installed, Supported, Tuned and Administered 10 Print Projects using Morphotrak Biometric applications and Gogent Biometric Applications on Oracle RAC 10G/11R2 ASM, OEM 11G Grid Control, Data Guard Flashback Technology Databases. Managed and Administered very large Oracle 11R2 OLTP Databases on AIX 5.3 IBM P550. Managed and Administered SQL Server 2005/2008 Databases. Trained on Morphotrak and Cogent Application and AIX PowerVM 6.1. Trained on Remedy Software, BMC Patrol, Foglight, Spotlight, Quest Central, Quest Live-Reorg for monitoring. Upgraded Oracle 9i/10G Databases to Oracle 11gR2. Performed Core Database management tasks including Database Creation, Installation, backup and Recovery. Monitored and Optimized databases. Trained on Advanced Oracle Queuing techniques. Trained on TiBCO Softwareand Oracle Advanced Queuing . IEEE Biometric Certification Certified Biometric Professional . Oracle Certified 11R2. Installed, Administered, Troubleshooted Oracle RAC 10/11G for different ERP applications including Peoplesoft Financial 9.1 including HR, GL, AP, PO, Siebel, SAP applications including ERP Central Component ECC, Business Intelligence BI, Enterprise Portal EP, Kronos. Administered OLTP and DataWarehousing Databases up to 130TB. 24x7x365 on call Production Support in a Dynamic and critical environment.

Confidential

Lead Oracle DBA 10G/11G

• Led/Participated in database projects and worked with partners to bring projects to successful and timely completion.
• Supported 24x7 environments and ensure their availability, performance, security and operational efficiency.
• Implemented Full life Cycle Development of Oracle Application 11i including Supply Chain sustainment.
• Performed core database management tasks including software installation, database creation and configuration, database upgrades, backup and recovery, space management, partition maintenance and object reorganization.
• Monitored and optimized database performance as it relates to partitioning strategies, index tuning, ETL, and query optimization on Data warehousing environment.
• Researched, evaluated, recommended new technologies and products. Supported Oracle 10G/11g RAC using Linux Red Hat and Solaris.
• Wrote a lot of C shell and Korn shell script in order to automate database processes.
• Working knowledge of Cybermation ESP, Control M and other scheduling tools.
• Working knowledge of Oracle Business Intelligence. Designed, implemented Oracle SOA suite at Cobbham Defense Systems.
• Migrated Informix/SAP/R3 data to Microsoft SQL Server 2005/SAP/R3 and BIW. .
• Converted and Migrated Legacy data to Oracle E-business suite. Strong experience with Oracle Financial and HR Systems. Strong experience with Unix scripting C shell and Corn Shell .
• Strong experience using SOA and web services.
• Strong experience with Applications Implementation Method AIM .
• Implemented Full Life Cycle Development of Oracle E-Business suite applications 11.5.10.
• Working knowledge of Oracle Finance and HR systems.
• Working knowledge of Oracle 10G PL/SQL and SQL.
• Converted and Migrated SAP/R3 from Oracle 9i to Microsoft SQL Server 2008.
• Administered, monitored, tuned SAP/R3 BIW applications on Oracle 11G databases.

Confidential

Senior Oracle Database/SQL Server Administrator/Senior Integrator

• Supported Various databases Including Vantive CRM and Genesys CTI on Oracle 10G and Oracle 9i for Emergency Call Center.
• Performed Performance tuning on Oracle 9i/10g databases PeopleSoft Payroll and Kronos .
• Upgraded Oracle Vantive CRM and Genesys CTI from 9i to 10G Using Unix Solaris 10.
• Provided application and database support on a 24X7X365 environment for Oracle 10G and SQL Server 2000/2005 databases to respond and resolve production issues.
• Monitored, guided and assisted junior developers and DBA's and outside teams as they develop plans. Performed, designed, developed solutions and maintained their knowledge bases.
• Managed, implemented and monitored Sales Automation project using ONYX and Solar Wind Systems. Deployed SQL code to Microsoft SQL production servers.
• Experience with Java/J2EE, XML, SOAP, HTTP, WSDL, JMS Queue, Linux and Windows, Enterprise Service Bus ESB, Business Process Modeling and Management, Enterprise Application Integration EAI, BPM, LDAP, VMS, Single sign-on SSO, Virtual Operating System Environments, NET 3.5 requirements, XSLT, XSD.
• Developed software processes, standards, configuration management systems, tracking systems and associated best practices. Participated in project and program reviews.
• Supported, maintained and installed Oracle 10G RAC.
• Applied Patch 10.1.0.5 to subscriber database.
• Worked with the SQA group to assure best quality and rapid turnaround for changes that surface during testing. Very proficient with Sql Sever, DTS, SQL Server Integration Services.
• Evaluated tools/core technologies CRM, OS, Backup tools, monitoring and tuning tools, Software and Hardware tools and provided recommendations for their use.
• Supported Oracle 11i E-Business Suite on Oracle 10G databases.
• Troubleshot production processes and solved problems in real time. Monitored database system details within the database, including stored procedures and execution time, and implemented efficiency improvements.
• Acted as a liaison between users to solve production issues and translated business users requirements into specifications for development teams.
• Designed, implemented, supported deployed Oracle SOA suite trained in SOA principles from BEA Software Company.

Confidential

Oracle Database Administrator/Team Lead

• Led, supervised and trained a team of four Informix DBA's into Oracle.
• Supported various databases on Oracle 8x, Informix 7.3.4, SQL Server, Sybase, DB2 on a 24X7X365 environment.
• Upgraded Oracle Peoplesoft Databases from 8.1.6 to 8.1.7.3.4 using AIX OS.
• Solved and tuned database performance problems on Oracle Peoplesoft and Kronos databases.
• Supported SAP/R3 application on Informix, PTC Windchill application on Oracle, Peoplesoft application on Oracle and Kronos application on Oracle and Marketing and Sales application on Sql Server 7 and SQL Server 2000.
• Custom designed SAP/R3 according to customer needs. Reviewed, interpreted, changed ABAP/4 programming code in order to modify SAP/R3 according to client's needs. Supported SA/R3 on Informix and Oracle Databases- Administered SAP/R3 Basis on Oracle 9i and Informix databases. Modified modules like FICO, HR, SD, PP etc. Automated test loads using Mercury Interactive load runner and Mercury Winrunner in order to ensure that SA/R3 system would perform reliably and effectively.
• Upgraded Oracle Peoplesoft 8x databases from 8i to 9i.
• Installed and built Oracle Databases from scratch for PTC Windchill and Kronos applications according to OFA. Working knowledge of Windchill PDMLink 9.1. Working knowledge of Windchill MPM Link. Working knowledge of JMS Queues. Working knowledge of Oracle SOA Integrations.
• Maintained and monitored Oracle, Informix, SQL Server databases including Reorg, Space Management, Row Chaining, Performance Tuning.
• Supported an SAP/R3 Data Warehousing Application BW on Informix 7.3.4.
• Evaluated and wrote reviews for a database Team of four people.
• Interviewed, recruited and trained new Oracle DBA's to the DB team.
• Recovered databases using BCV copies to various points in time.
• Installed and maintained RMAN to Interface with EMC EDM.
• Attended Oracle DBA Bootcamp in Las Vegas October 2001 and IOUG-A in Orlando April 2003 .

Confidential

Senior Oracle Database Administrator/Systems Officer

• Administered and supported Peoplesoft applications 7.x HR GL on Oracle 8x databases.
• Administered and supported Oracle Financial 11i on Oracle databases.
• Configured and Certified Oracle servers.
• Designed and implemented backups for all Database systems Oracle 8.x and 7.x using SQLBACKTRACK BMC Software .
• Developed strategy and planned for the Corporate Actions/ARP move to Production.
• Built, supported, maintained a Web based corporate actions/ automated response process database.
• Provided production and tuning databases in Oracle environments.

Oracle Database Administrator/Developer

• Support on a 24X7X365 environment for 455 Oracle, Sybase and Informix Servers running Unix Solaris.
• Monitored and tuned a Trail database using Oracle Enterprise Manager OEM .
• Apply Patches for the Trail Oracle database from 7.3.0.1 to 7.3.4.
• Sized objects, tablespaces including rollback and temp for Corporate Action system.
• Built Trail Y2k and Corporate Actions Y2K applications.
• Used BMC's SQLBACKTRACK software for enterprise backup with IBM's ADSM backup solution.
• Attended IOUG, a conference in Dallas April 1997 and Oracle Open World in San Francisco November 1996 .

Confidential

• Designed and implemented a Customer Order Entry System using Forms 3.5 on Oracle 7.x using HP-UX 10.20.
• Used ER/Win for Database Modeling and Reverse Engineering.
• Performed Oracle DBA functions on Oracle 7.x using HP-UX 10.20.
• Defragged and refreshed databases using Import/Export.
• Designed, implemented and maintained a Clarify applications for customer support with Oracle 7.x using HP-UX 10.20.
• Performed Oracle DBA functions Performance Tuning, Space Management for Clarify Application and Customer Order Entry System .
• Supported a Customer Order Entry System on a 24X7X365 for Salespeople Worldwide on Oracle Databases.
• Traveled to Europe in order to implement and train users on Clarify applications.
• Helped developers utilize I/O statistics, Explain Plans, TKprof, to improve execution time of queries.
• Attended Oracle Open World Conference in September 1995.

Confidential

Programmer/Analyst

• Designed and implemented a data entry system using Keymaster TSI in a mainframe MVS.
• Designed, implemented and customized a Customer Order Processing System using ASI Software.
• Built JCL jobs and worked with Operations for Application Production Turnover.
• Attended Keymaster Conference in Tampa on June 1989.
• Designed and implemented a Warehouse Management System using Natural/Adabas.

TEACHING

EXPERIENCE:

Confidential

Adjunct Professor

Taught Operating System using Unix and C, Java

Confidential

Adjunct Professor

Taught Oracle 8i

Confidential

Adjunct Professor

Taught Operating System, Introduction to Computers Networking

Confidential

Adjunct Professor

Confidential

Adjunct Professor

Taught Linux and Unix