Summary

• Confidentialholds a Bachelors in Computer systems with over 3 years of experience as Oracle DBA, working with production and development databases on various UNIX platforms Linux, HP-UX, Solaris, AIX , Windows NT 4.0/2000/2003 with Oracle 8.0.5, 8i, 9i, 10g, 11g .
• Expert in managing objects, users, privileges, and roles.
• Proficient in Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Grid control.
• Experienced in cloning and relocation activities.
• Working knowledge of referential integrity, triggers and stored procedures.
• Expertise in replication technologies including GoldenGate, Streams, AQ and Materialized Views
• Adept in Database Maintenance and DatabaseMonitoring using tools like Automatic Workload Repository AWR , and Automatic Database Diagnostic Monitor ADDM .
• Performed backups and tested crash recoveries using conventional hot cold backups and RMAN.
• Proficient with database performance and tuning techniques to enhance database optimization plans.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, STATSPACK
• Experience in installation and configuration of Oracle RAC.
• Knowledge of database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Implemented DATAGUARD Standby for high availability/disaster recovery purpose.
• Expertise in maintaining Database Securityusing auditing.
• Experienced in using features like Data Pump, Flash-Back Recovery, Streams, and ASM, ADDM, SQL Tuning Advisor, Flashback and SQL Profiling.
• Troubleshooting and resolving critical production issues in complex application environment: SQL net connectivity issues, locking, database hang issues, OS/network issues, concurrent manager issues.
• Versed in Loading external data into the database using SQL Loader.
• Expertise in Managing and Administration of VLDB systems ranging from 1GB to 200TB.
• Experienced in UNIX shell scripting to run various CRON jobs.
• Hands on experience using the Oracle Enterprise Manager OEM for database monitoring and maintenance.
• Experienced working on OLTP, Data Warehousing, and ERP environment in various business environments.
• Extensive experience using Oracle technical support METALINK .
• Establishing standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical data model capacity planning, external data interface specs, data loading, data maintenance plan and security policies.
• Worked in 24x7 production environment and provided on-call and day-to-day support
• Experienced in using Oracle server utilities like Datapump,Export, Import, and SQL Loader
• Result oriented, self-motivated, Team player, with ability to work independently accepting new challenges
• Extensively used ODI Oracle Data Integrator to perform ELT from different sources using Oracle Data Integrator tools - Security Manger, Topology Manager, Designer and Operator
• Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts along with Oracle Data warehouse Configuration, Admin Console, Materialized views, Indexes.
• Extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata
• Used Topology Manager to define data servers and physical schemas for various sources and target databases.
• Implemented the Change Data Capture CDC feature of ODI to minimize the data load times.
• Used ODI Designer to develop complex interfaces mappings to load the data from the various sources into dimensions and facts.

Technical Skills

Hardware: HP-superdome, 9000 SunFireE20K, E25K, V490/890, SunSPARC and Ultra IBM RS/6000

Operating System: HP-UX 11/11i, Sun Solaris2.x/7/8/9/10, Red Hat AS 2.1, Windows NT/98/2000, Red Hat 6.2/7.x/8/9, IBM AIX 5.x, 4.x

RDBMS: Oracle 7.3, 8, 8i, 9i, 10g,11g 32 bit and 64 bit version, MS SQL 7/2000 SP 2,Informix 7.x,9.x and 10.x

Skills Highlight: Oracle 11g,10g, 9i, 8i RDBMS, Real Application Cluster RAC , Oracle Cluster File System OCSFS , ASM Advance Replication, SQL Trace, Explain Plan, Data Guard, RMAN, OFA, , SQL Loader, Export Import Utilities, PL/SQL, BMC SQL Backtrack, EMC SRDF, ERWIN, TOAD, Fast Unload, Veritas Quick IO, Spot Light, Precise, SQL Lab, MSQL Server 7.0 2000, Unix Solaris, HP, AIX , Linux, Windows NT, Win 2000.Real Application Clusters RAC , Data Guard DG , Physical and Logical Standby, RMAN, Log miner, Partitioning, Shell Scripting

Professional Experience

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle 11g Clusterware/RAC/ASM environment.
• Establishing standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical data model capacity planning, external data interface specs, data loading, data maintenance plan and security policies.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, UTLBSTAT, UTLESTAT, STATSPACK , ADDM , AWR Reports and using Grid Control performance reports
• Implemented RMAN backups and recovery procedures in ASM environment.
• ASM setup of disk groups for the database and flash recovery area.
• Provided thought leadership in large deal pursuits understanding the client needs, competitive situation analysis, strategic planning, consulting on selection, design, development and integration of multiplatform and distributed databases.
• Administered all database objects, including tables, clusters, indexes, views sequences packages and procedures troubleshoots with regards to database problems, applications
• Did migration of Oracle datafiles to ASM filesystem and written technical docs for this conversion.
• Done performance and tuning, monitoring, backup and recovery.
• Oracle experience/skills with logical and physical database design, setting up of high-availability and disaster recovery solutions.
• Created different types of Indexes B tree, reverse key, IOT and function based etc , different types of partitions List, hash, composite etc on different tables.
• Creation of Partition tables and implement of parallel query.
• Setting up of high-availability and disaster recovery solutions.
• Data loads using SQL Loader, export-imports for backing certain tables.
• Involved in 24x7 Production Database Administration and support.

Confidential

ETL-ELT/ODI Developer

Responsibilities:

• Involved in design, development of ODI for ETL ELT Project, gathering requirement specification documents and presenting and identifying data sources
• Used the Oracle Data Integrator Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Configured and setup ODI, Master repository, Work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata.
• Creating interfaces to map the data between source and target.
• Implementing Incremental update using IKM knowledge module.
• Implementing CDC to capture the changed data
• Installed and Setup ODI Master repository, Work Repository, Execution Repository
• Prepared technical specifications, mapping documents and test specifications as per business requirements.
• Developed real time Change Data Capture solutions to extract and load ERP data from Oracle applications Oracle Apps .
• Consolidated data from different systems to load Constellation Planning Data Warehouse using ODI interfaces and procedures.
• Develop packages for the ODI objects and scheduled them as scenarios.
• Implemented change data capture using Oracle Log Miner and ODI Journalizing on the source data.
• Fine tuned the applications for performance and Generated batch feeds for analytics.
• Developed ODI packages for creating workflows and scheduled them as scenarios.
• Migrated and converted the flat source files from multiple sources to ORACLE 10g.
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
• Built transformations, configured servers and established connections to various sources and targets
• Worked on pulling transactional and historical data from Legacy Applications and other applications to Data Warehouse based on user requirements.
• Customized Email distributions to get the error messages and output from PKG run. Modified Knowledge modules to customize it to ETL requirements
• Involved in troubleshooting of ODI objects, Optimized Query Performance, improved Workflow Performance and Reliability bases on statistics from logs
• Imported and integrated the Knowledge modules per load process and prepared the load modules based the design data models.
• Handled error through exception handling and configured the event-based scenarios to send the alert emails.

Environment: Oracle Data Integrator 10.1.3.4.0, OBIEE, Oracle 10g, DB2, Toad, Erwin 3.5.