TECHNICAL SKILLS:

Oracle: 7.3 - 11g Database, RAC, DataGuard, RMAN, Advanced Security, OAM/OIM/OID/SSO, Gateway, OAS/Fusion Middleware/Weblogic, Grid Control, EBusiness Suite CRM/ Financial/HR modules. Version 11i - R12. Oracle Workflow, Oracle Discoverer, Application Express, Collaboration Suite, Oracle Business Intelligence Enterprise Edition (OBIEE), SOA

Languages: Perl, PL/SQL, Shell Script, HTML/Java Script, XML, UML, VB, ASPHA Products: Sun Cluster, Veritas Cluster

OS: Linux, Solaris, AIX, HP-UX, Digital, Mainframe, Windows, Citrix, VMWare

Other DB: IBM VSAM, DB2, Microsoft SQL Server, ACCESS, MYSQL

Other Tools: JavaScript, PHP, CGI, Flash, Apache/Tomcat, Dun & Bradstreet, Tibco, Quest Tools, Apple Object C

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Applications Specialist

Responsibilities:

• Installed, upgraded servers to Redhat Enterprise Linux 4.5 and 5. Patched and installed additional packages. Setup disk groups and volumes. Configured system parameters. Configured and troubleshoot networking.
• Installed and Configured
• Oracle Applications R12
• Oracle Collaboration Suite in a reverse-proxy configuration.
• Oracle Application Express 3.0 hosted in a Oracle 10gAS 10.1.3
• Designed and developed demo application on APEX 3.0
• Cloned Oracle Applications R12.
• Worked on OID to configure Oracle 10gAS virtual services.
• Conducted presentation, seminars for Confidential customers on Oracle products.

Consultant

Confidential

Responsibilities:

• Support development team in maintain Oracle E-Business Suite environments, database and JVM performance tuning, troubleshooting forms, reports, java issues, concurrent job process related issues, workflow issues.
• CRM technical and functional configuration and deployment of FORMS, Reports, Java codes, etc.
• Designed and carried out strategy of upgrade Oracle Ebusiness suite from 11i to R12 and from R12.0.4 to R12.1.2 on a system with complex architecture and many integration points with other applications.
• Provided expert guidance on Oracle security and how it fit within the scheme of Confidential corporate security.
• Supported integration effort of CRM with call center telephony technology and SQLServer.
• Performed typical administration activities for Oracle EBusiness 11i Financial system with Informatica, OBIEE, SOA, SSO integrations. Cloned Oracle EBusiness Suite environments. Perform STIG security reviews and implemented best security practices for EBusiness, Fusion Middle ware. Developed custom monitoring, diagnostic, and performance reports using scripts, concurrent programs, and Grid Control. Install and configure Grid Control for EBusiness Suite and SOA monitoring. Developed standard procedure and check list documentation for DBA tasks. Performed BTA tickets supports.
• Performed typical administration activities supporting Ebusiness Suite 11i HR system with Informatica, Discoverer, and SSO integrations and RAC database. Administer Informatica repository using Power Center tool. Cloned and managed Oracle Access Manager (OAM) and Oracle Identity Management (OIM) system with Fusion Middleware/Weblogic components. Configured Weblogic domains and clustering. Installed and configured Oracle Internet Directory 11g. Integrated OAM/OIM/CAC single-sign-on solution with high availability design. Conducted extensive DOD standard STIG security reviews and implemented best security practices for EBusiness 11i, Discoverer, Apache, and Oracle Application Server.

Confidential

Sr Oracle Applications DBA

Responsibilities:

• Support and administer Oracle 11i Ebusiness Suite, Oracle 9iAS and 10gAS, Oracle databases, Webcache, Grid Control, Discoverer, Mobile Server. Set up, tune, troubleshoot Logical Standby database. Installed and Configured RAC on Linux. Installed 11i Apps patches, RUP 4 patches. Performed 11i Clone Installation. Configured and Administered Concurrent Requests. Performance tuning concurrent processes.
• Administered, configured, troubleshoot Tibco process, Tibco Hawk agents.
• Installed, Configured Dun & Bradstreet Integration Manager, .
• Other tools worked on, used included BigTop Load Balancer, Documentum RightSite, Quest Central, Foglight, Spotlight, Rational Clearcase.

Confidential

Responsibilities:

• 10g RAC, DataGuard, Vertias Cluster and other expertise in enterprise architecture design.
• 24x7 support of production/development/testing/staging/ databases from 8i to 10g
• Designed and Implemented database backup strategies including using Oracle standby database, DataGuard, RMAN, Veritas Storage Checkpoint, hot backup, export, from version 8i to 10g release 2.
• Conducted Database security review and analysis on 10g.
• Reviewed Java codes and database application user schema.
• Trained and gained experience in Websphere Application Server operation and troubleshooting.
• Performance tuning with ADDM, AWR, Statspack, Utlstat, TOAD, FogLight, and scripts.
• Troubleshoot problems using tools such as RDA, DBVerify, Oradebug, network diagnostic tools, etc. from DB version 8i to 10g, Sun version 5.6 to 5.9
• Developed database standard documents.
• Setup monitoring using NETIQ, Sitescope, TeamQuest, self-developed scripts.
• Designed and Implemented various disk layout for database including Veritas Quick IO, raw partition.
• Evaluated different database tools such BMC Patrol, ISS Scanner (security audit tool)
• Gained experience on Citrix environment and administration.
• Planning, redesign, and implementation of database aspects for custom applications, such as Internet ticketing, SPEAR and MAXIMO work management systems, Call Center Studio (Outbound Marketing) application, Content management system, etc. and associated software such as Mapquest,
• WebMethod, SAP database install
• Evaluated Oracle Collaboration Suite and Times Ten Database.
• Installed and Evaluated Oracle 9iAS against Websphere.
• Troubleshoot Oracle 9iAS used for Grid Control and Collaboration Suite.
• Designed Oracle Parallel Server (8.1.6) system architecture on Sun Cluster 2.2 for Nextel datamart.
• Setup/configure Sun Cluster, install/configure OPS, configure Oracle database and Oracle replication. Deployed production web datamart in Argentina and in Mexico.
• Production database support, including backup and recovery, OLTP performance tuning.
• FedCenter web site project Database and system architecture design, on Solaris Enterprise Cluster Servers involving Veritas, EMC design, Oracle Intermedia and Fine-Grained Security implementation for E-Commerce product search and secured-transactions. Java code and database design reviews.
• Microsoft SQLServer to Oracle 8i replication architecture design using Commerce-Route, DataJunction.
• Performance design and benchmark using raw partition, Veritas Quick I/O.
• Database sizing and disk layout design.
• Backup and recovery design and documentation, implementation with scripts.
• MySAP integration with Database

Confidential

Responsibilities:

• Military Traffic Management Control project: Support, performance tuning, migration of multiple Oracle production and development databases in heterogeneous platforms (Solaris, HP, NT).
• Installed, Configured Oracle RDBMS database 8.0.6, 8.1.5, Oracle Application Server 4, Oracle WEBDB, Oracle Designer 6, Oracle Developer 6, 6I beta, Forms Server, Reports Server.
• Implemented single sign on for database application using Perl CGI integration.
• Assisted users troubleshoot forms, reports, Java Servlets, JSP and JDeveloper issues.
• Prototyped Java Servlet applications with Oracle Application Server.

Confidential

Responsibilities:

• Implemented database backup and monitoring with OEM, RMAN, Legato Networker.
• Developed Java application featured browse, search, purchase, shopping-cart, video streaming, text/image labeling, web-based administration and cataloging of assets for administrator. Designed Data Model
• Administered OAS, database, OEM, Solaris Servers.
• Setup Legato Networker, tape library jukebox, multi-node backup of NT and UNIX file systems.
• Designed Database and application performance strategy, backup and recovery strategy
• Analyzed security requirement and designed single sign-on security with Netscape Enterprise Server, Open SSL, Oracle Intercartridge Exchange and Network Sockets programming via HTTP over TCP/IP.
• Access control, data modeling, performance tuning, growth planning and monitoring, test data refresh.
• Wrote Designer API scripts for repository synchronization automation and customized reports.
• Designed Intranet application to automate internal task and change tracking.
• Prototyped reporting mechanism with WebSQRibe and COGNOS tools.

Confidential

Responsibilities:

• Financial Decision Confidential Corp of Engineers EPA project: Business requirement analysis,
• Database logical and physical design. Data replication with custom codes.
• Developed programs with PL/SQL procedure and trigger, VB, FrontPage, ASP, ODBC, DAO, Access modules, macros, libraries featuring reports, and graphics, forms, custom search, security enhancement;

Confidential

Responsibilities:

• Gained experience on Oracle database (7.3, 8.0.3), Oracle Datamart Suite, Oracle Developer/2000, Oracle/Designer 2000 in NT platform. Installed NT server/workstation, configured DHCP, NT registry maintenance, email configuration. Developed backup and recovery procedure and verified.

Confidential

Responsibilities:

• Recruiting and reservation system - Mainframe application system with large user base world wide.
• Integrated Code build with Oracle PRO*C make file, RATIONAL APEX C++ Make file, Tuxedo C make file, compilers, and Tuxedo processes using shell script.
• Database Tasks of Oracle 7.3, DB2, VSAM on MVS/CMS, AIX, Solaris, including Access control, DDL, tuning with indexes, space management, backup. Developed triggers, procedures to refine security.
• Database logical and physical design using ERWIN, DATA-ARCHITECT, UML/OO Design.
• Mainframe Data replication, Data Migration from Mainframe to Oracle 7.3;
• Code design and reviews. Life cycle software development and redesign.