PROFILE

• For the last Fifteen years, Mr. Confidential has provided various IT services. His focus has been in the area of Oracle Fusion Middleware, 12c RAC with ASM and Active DataGuard, Oracle OBIEE, OID and OAM, Integrated OBIEE with Windows Active Directory AD, OAM and OID, Oracle OBIA with BIACM and FSM, Oracle Key Vault and Audit Vault with database Firewall, Oracle ODI, Oracle Exalogic and Oracle Exadata, Oracle Big Data Appliance, Oracle Hadoop and Oracle Endeca and Oracle Exalytics In - Memory Machine, Oracle Big Data Connectors, Oracle Linux, Oracle Hyperion Essbase Database, Oracle database Vault and Audit Vault, 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. Encryption in Oracle.
• Mr. 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.
• 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.

PROFESSIONAL DATA ARCHITECT AND DBA EXPERIENCE

Confidential

• Installed and Configured Oracle VM Server on 2 hypervisor raw disks machines and Oracle VM Manager on Oracle Linux Server.
• Discovered Oracle VM Servers, Created and configured Networks, Created Virtual Network Interfaces cards, Created and configured a Server pool, Created a server repository
• Imported the Oracle VM Templates, and Cloned virtual Machines from Templates. Backup the database Using RMAN
• Deployed a Two Node Oracle RAC 12c Cluster using Oracle VM Templates
• Installed and Configured the 12c Cloud Enterprise manager to monitor and maintained the Oracle Infrastructure and email notification to be pro-active.
• Configured and Maintained Oracle Essbase, and support the users to use Smart view and Hyperion planning to generate the report
• Installed and Configured Oracle Goldengate Implemented GoldenGate Replication from Mainframe DB2 to Oracle database, and also From Oracle to Oracle Using bi-directional Golgengate Replication: Prepared the Source and Target Environment: Configured the Manager, Extract, Replica processes for GoldenGate. Configured Change capture on source and Change delivery on target.
• Installed and configured Oracle BI Applications with Data Source E-Business Suite.
• Installed and Configured BI Administration Tool, Access to Repository
• Used Oracle BI Applications Configuration Manager BIACM , Functional Manager FSM, WebLogic for Setting up and Maintained Oracle BI Applications
• Installed, Configured and Maintained Oracle Data Integrator ODI: used Oracle ODI studio to Create ODI Master and work repositories: worked with ETL Project, Mapping, and packages. Executing ODI developments and Review Results.
• Configured Oracle Obiee and Oracle Endeca with Oracle Hadoop Oracle Big Data . Integrated OBIEE with OAM for Single Sign-On: Installed OID and OAM Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault, and Database Firewall: Tablespace encryption, data Masking, audit alert report, data redaction for IRS 1075 Compliance with Oracle data security.
• Built the start and Stop script that will include the OBIEE Admin server, Node Manager, Managed Server, and opmn processes
• Used OBIEE EM Fusion Middleware Control, WebLogic Administration Console, as well as the Windows-based BI Admin Tool
• Administered the repository, manage variables, the catalog, and security on several levels of OBIEE .Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Analysis, Delivers and Publisher.
• Managed Oracle Delivers, Scheduler iBots. Involved in Design and Data Modeling using Star schema. Designed Schema/Diagrams using Fact, Dimensions, Physical, Alias and Logical tables. Created Drill down Hierarchies
• Created Pivot Tables and manipulated Initialization Blocks for report analysis.Configured the Analysis and Dashboards settings.Configured the presentation services initialization file of OBIEE.
• Managed the mail and agent setting of OBIEE to properly configure report delivery. Read logs, diagnose problems, and fix them.
• OBIEE backup and recovery to protect your system against failure.

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 using RMAN and DataGuard.
• Installed and Configured the 2to pro-actively Monitor the Private Cloud environment and created metrics and email notifications alert.
• Installed and Configure Oracle Beehive in the back end server, and in the DMZ, Oracle Beekeeper. Support Oracle Beehive users.
• Integrated GoldenGate with Oracle ODI for the Change Data Capture CDC . Created Mappings, Transformations, and Loaded the Data into the target Datawarehouse with Oracle ODI. 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. Administered the repository, manage variables, the catalog, and security on several levels of OBIEE.
• Imported schemas, designed and built logical business models, and exposed business models to users in Oracle BI Analyses .Edit, Build physical and logical joins, simple measures, and calculation measures. Effectively interacted with the end users for requirement gathering and defined requirement specifications document. Involved in setting up LDAP security and Data level, Object level and user level security. Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Installed and Configured Oracle Big Data Appliance with Oracle Exadata and Oracle Big Data Connectors with Exalytics In-Memory Machine.
• Integrated OBIEE 11g with OID for user repository, Integrated OAM with OID for user repository, Enabled SSO in OBIEE using FMW Enterprise Manager Control, Testd OBIEE Single Sign-On configuration
• Performed testing, tuning, and configuration of Middleware products including WebLogic, Oracle BPM, Oracle SOA Suite, and Oracle Identity Manager, Oracle Access Manager, OWSM, Oracle Portal.
• 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 and 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.