PROFILE

• For the last Fifteen years, Confidential has provided various IT services. His focus has been in the area of Oracle Fusion Middleware, 11g RAC with ASM and Active DataGuard, Oracle Hyperion Essbase Database, PostgreSQL, MySQL Database Administrator, Performance Tuning, Database Backup and Recovery and Programming. He has current and strong skills in the development of SQL Reports, SQL Forms, Korn Shell scripting, PL/SQL procedures, functions and packages programs, Oracle Business Intelligence report. Tuxedo, PeopleTools 8.51, Weblogic Server, EPM Database, OBIEE 11g Fusion Intelligence, DataStage. PeopleSoft EPM 9.1 Module
• Confidential is well versed in the functionality of Oracle 10g and 11g Real Application Cluster RAC ,ASM, skilled at Project Management, gathering Technical requirements, Testing and Training. He also specialized in tools such as SQL Developer, OEM, TOAD, ErWin, BCV, Oracle Designer, JDeveloper, Oracle APEX ,Oracle Hyperion and Essbase Database and is able to serve as a knowledge base for others. He has worked on all configurations of the Oracle Database and Apps Server: Distributed Option, Parallel Server, Parallel Query, Oracle Essbase, Oracle GoldenGate, Active Data Guard, Oracle OBIEE Suite, Oracle Beehive, Oracle Data Integrator, Oracle E - Business Suite, Oracle PeopleSoft, Oracle Application Server, Flashback, Linux, RMAN,ASM, Oracle GRID Control, Oracle OID. WebLogic Server, SOA Suite, OBPM Suite, Oracle Fusion Middleware, Forms, Reports and EAR, WAR files Deployment. Wrote and tuned SQL and PL/SQL code, scripts, triggers, views. Implemented data models and database designs, data access and table maintenance codes.
• Confidential is open to both contract and permanent positions and willing to travel. Please feel free to contact him on or for additional information.
• Hardware, Programming Languages Operating Systems:
• IBM RISC 6000, HP 9000 T520, T500, Sun Enterprise 220R, Sun Fire V240, DELL Powerage. HTML, XML,PL/SQL, Java, JavaScript, PERL. PVCS, ClearCase, BCV,
• AIX 3.2.5, 4.1.4, 4.3.2, 4.3.3, HP-UX 9.04, 10.10, 10.20, SOLARIS 2.5, 2.6, 2.7, 2.8, TRU64 V5.1 732 alpha, Linux. Windows Advanced server 2008.
• Various training in Oracle Database: Oracle RAC with ASM, Active DataGuard, Oracle Applications12i, JDeveloper, Oracle Designer and Oracle's Tools, Solaris, Legato Networker, Cognos, Microsoft SQL Server 2000, Erwin, Oracle OBIEE, Oracle APEX, Oracle OID, Fusion Middleware, WebLogic, Enterprise manager, Forms, Reports and EAR files deployment.
• 24/7 DBA Service DBA Consultant

PROFESSIONAL DATA ARCHITECT AND DBA EXPERIENCE

Oracle DBA/Developer

Confidential

• Installed and configured Oracle Enterprise Manager GRID to assist in managing databases, application servers and web servers.
• Installed and configured 11g Real Application Cluster RAC with ASM on Linux using Oracle Grid Infrastructure with Single Client Access Name SCAN .
• Installed, Configured and Administered Linux Server and Oracle ASM.
• Implemented Active Oracle Data Guard, and Enabled Flashback as Oracle's data protection and disaster recovery solution.
• Installed and Configure Oracle Beehive in the back end server, and in the DMZ, Oracle Beekeeper. Support Oracle Beehive users.
• Implemented GoldenGate Replication: Prepared the Source and Target Environment: Configured the Manager, Extract, Replica processes for GoldenGate. Configured Initial Data Load using Direct Load Method with Initial Load capture on source and Initial load delivery process on target. Configured Change capture on source and Change delivery on target.
• Installed and Configured Oracle OBIEE Suite. Maintain and Tune Oracle OBIEE Portal environment. Generated Ad Hoc, Drill down Reports with graphs on the Dashboard using OBIEE.
• Created Materialized views and enabled query rewrite parameters.
• Created Hash sub-partitions within the existing Range partitions to use Partition pruning on SQL. Implemented indexes strategies using bitmap and local indexes and enabled star transformation to improve performance of the Data Warehouse.
• Refreshed and cloned Development and Test Databases. Deployed Forms and Reports. Migrated Various Oracle databases to new Versions. Setup and Maintained oracle APEX environment.
• Wrote and tuned SQL and PL/SQL code, scripts, triggers, implemented data models and database designs, data access, table maintenance codes, and Deployed them to the databases.
• Installed, Configured and Maintained Tuxedo
• Installed, Configured and Maintained PeopleTools 8.51, Weblogic Server

Oracle DBA/Architect

Confidential

• Installed, configured, and maintained Oracle Fusion Middleware with SOA, OBPM Suite and WebLogic Server. Installed JDeveloper on the client Machine. Deployed Java EAR files.
• Add users to OID and to their appropriate group.
• Created RMAN cronjobs for hot Cumulative Level 1 incremental Backup. Tuned and implemented Block Change tracking file to improve RMAN backup.
• Migrated the Oracle portal contents from different environment. Installed, Configured, supported Oracle Warehouse Builder for the mapping, transformation and data load.
• Installed CPU quarterly patches. Setup Metrics and alert with Grid Control to send e-mail notifications to DBA's when databases and listeners are down and when tablespaces or filesystems get to 90 full. Automatically monitor the 24/7 system with Oracle's workload Repository and Advisory Framework. Implemented ADDM Automatic Database Diagnostic Monitor to automatically detects and diagnoses common performance problems. Used Active Session History AHS, Automatic Workload Repository AWR reports.
• Used sar, vmstat, iostat, top to tune Oracle databases. Used PVCS for version Control.
• Installed, Configured and Maintained OBIEE 11g Fusion Intelligence
• Installed, Configured and Maintained DataStage
• Installed, Configured and Maintained Hyperion Essbase

Oracle DBA/Architect

Confidential

• Installed and Configured Solaris.
• Installed and Configured 10g RAC on Sun Solaris, and configured the RMAN Backup.
• Configured Data Guard for the Disaster recovery in Addition to the BCV.
• Applied Patches with Rolling Patch Upgrades feature using RAC and using Data Guard.
• Configured Portal clusters behind a set of Web Cache servers.
• Designed and planned the layout of the Application Servers universe, including clustering of the infrastructure, integrated Oracle OID with Microsoft Active directory. Maintained and Supported MySQL Database.
• Used Oracle BIEE Administration Tool to build, modify, enhance, and manage an Oracle BI repository.
• Installed, Configured and Maintained Oracle E-Business Suite.
• Integrated 10gAS to work with a backend RAC database.Deployed EAR files to cluster OC4J instances. Create business intelligence Portal Report via Oracle BI user interfaces, such as Oracle BI Answers and Oracle BI Interactive Dashboards. Used Oracle Utilities Sql loader and Data pump to load and refresh data.
• Generated AWR Automatic Warehouse Repository Reports to detects and diagnoses common performance problems. Used ClearCase for version Control.
• Implemented Single Sign-on SSO plan for 0TR including the integration of Oracle infrastructures, Portal, Business Intelligence Reports. Apply Oracle patches. Installed,configured, and maintained Oracle Hyperion and Essbase Database.
• Served as technical lead, and DBA consultant on the Datawarehouse project using Oracle 11g RDBMS on a RAC server, ODI ETL, Oracle Discoverer Business Intelligence implementation.
• Frequently used Erwin to model staging, enterprise Datawarehouse and Data Mart logical models and physical architectures.
• Designed a sound backup and recovery strategy on multi-terabytes database, including crisis scenario, capacity planning.
• Setup, configuration maintenance of Real time replication, using Oracle Streams, between ERP production database and other Oracle production databases
• Oracle Database backups recovery using, RMAN and Legato Networker, perl, k-shell scripts

Oracle DBA/Developer

Confidential

• Performance tuning involving Disk, Memory and SQL tuning considering performance and physical resources. Tuning techniques include querying Dynamic Performance Tables, Multiple Background processes, changing initialization parameters, implementing partitioning and function based indexes, parallel queries and Data striping etc. Used tools such as Explain Plan, TKPROF, StatsPack. Implementation resulted in dramatic improvement in accuracy, reliability and operating efficiency. Installed, Configured and maintained PostgreSQL Database. Installed and configure Oracle RAC with ASM. Maintain and support ASM Diskgroup.
• Database Design, Review and Modeling: Logical and Physical database design
• Participates in new product design and planning.
• Work in database design process and suggest database design best practices through all phases of SDLC. Created Stored procedures, functions, Triggers, Materialized Views, Tables, and PLSQL Code Packages.
• Designed Maintenance involving performance monitoring, backup monitoring, upgrading to new releases and patches, manage space, instance/SQL tuning, process scheduler maintenance, perform adhoc SQL for users and review production process logs. Supported and Maintained Oracle PeopleSoft Database
• Installed and maintained Oracle WebLogic Server with SOA and OBPM Suite.
• Providing database support, guidance and training for developers. Worked closely with programmers, administrator and support staff for wide range of Oracle programming initiatives, including data migrations, database modeling and backend application design, coding, debugging, testing and training support.

Oracle Data Warehouse DBA/Developer U.S. Dept of Health

Confidential

• Installed, Configured, supported Oracle Warehouse Builder.
• Installed and administered Oracle 9iAS and set up reports and forms services.
• Set up Virtual hosts and tuned Apache Web Server.
• Troubleshot Oracle reports issues and tuned reports parameters.
• Proposed and documented proof of concept for selecting an ETL tool.
• Designed, developed and executed Proof of Concept for Business Intelligence BI tools including Oracle Discoverer and Business Objects BO . Additional responsibilities include database security management, designing the tables and indexes partitioning, Unix shell scripting and application related system management.
• Daily responsibilities include database design and modeling, performance tuning, database objects table spaces, tables, indexes, users procedures, functions, triggers etc.

Oracle DBA/Unix Admin

Confidential

• Created and deployed innovative Web Services using Oracle 9iAS Oc4j.
• Coded fast SQL queries, PL/SQL procedures, packages and triggers to scrub and pull data from mainframe and flat files and generate and output to feed into the SAS analytical Engine.
• Designed a sound backup and recovery strategy on multi-terabytes databases, including crisis scenario, capacity planning.
• Executed clustering and high availability solutions, using Sun Cluster Server, Oracle Failsafe, and Oracle 9i Real Application Clusters RAC .
• Installed setup, configured and administered the oracle application web server and Designer repository and Oracle Management server.
• Worked intensively on Server performance monitoring, tuning and troubleshooting the data bases, instances in Unix systems.