Summary

• 5 years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web developments and Application development.
• Experience translating business requirements into conceptual, logical, and physical data models
• Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisor, and autotrace and execution plan.
• Management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.
• Experience on Metadata definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation.
• Experience in data replication using Oracle streams.
• Working experience of defining triggers events, cursors, stored procedures and packages.
• Installation, configuration and upgrade of Oracle 10g, 11g RAC.
• Extensive work experience on single instances, Oracle RAC databases in both OLTP and OLAP environments.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience as Oracle DBA providing support to many Production, Development, Test, CRP instances comprising of some of the more complex and challenging environments from versions 9i to 11g releases.
• Installing and upgrading Oracle Server 10g to 11i , 11gR1, 11gR2, 11gR12
• Administering Oracle 10g, 11i, 11g instances.
• Multiple upgrades of Oracle server older version to newer versions.

Technical skills

Professional Experience

Confidential

Role: Oracle Database Administrator

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 5.3. Databases size range from 10GB to 2TB in ODS EDW environments .
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting tuning of 10g Oracle databases 10g and 11g single instances running on both IBM AIX 5.2, Sun OS 5.8 HP-UX B.11.11
• Create oracle databases on configured servers using both the DBCA Data creation scripts.
• Planned and implemented high availability solution such as Real Application Cluster RAC in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experience in data replication using Golden gate
• Highly experience in Oracle 11g, 10g Automatic Storage Management ASM required to fulfill the storage needs.
• Installed, configured and maintained physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Designed daily, weekly, Backup and Recovery procedure for production, non-production databases using RMANbackups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh /Cloning from Production environment to setup QA/DEV using RMAN Duplicate.
• Intensively used latest 10g/11g Automatic Workload Repository AWR Automatic Database Diagnostic Monitoring ADDM reports for health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Schedule UNIX scripts in crontab jobs to improve the IO performance of the database.
• Export/Import, datapump , Transportable tablespaces to migrate databases from one database to another.
• Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Recovery of Database Recovery from media failure, Recovering the tables dropped accidentally, Recovering data files, Recovering from Block corruption from previous RMAN backups.
• Performed capacity planning, space monitoring like tablespace growth, ASM disc space.
• Resolve critical issues by raising SR with Oracle support and Root Cause Analysis RAC .
• Application of Oracle software patches when/where necessary.
• Backup/Recovery monitoring and reporting using both BMC SQL Backtrack Oracle RMAN
• Technical documentations of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• Work closely with systems Analysts, Systems Engineers/Admin Application Developers through the SDLC from Development to production, via Tech-Test in needs assessment, Requirements Gathering Server hardware/OS specifications for Oracle Installs , Database Designing Physical Logical and Implementation, database user creation and database access both at role table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces , schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database refresh from Production to Tech Test as needed.
• Tools Used: Oracle RMAN, Oracle 10g 9.2.0.8 , DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Role: Oracle Database Administrator

• Perform Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC Real Application Clusters Database.
• Implementing Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11gR2.
• Successfully performed data replication using Materialized views and Oracle streams in Oracle 11gR2
• Implemented recovery strategies whenever required and successfully recovered database in case database crash, media/disk failure by using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration.
• Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process.
• Worked with different middleware IDM teams to resolve their issues from the database side.
• Refreshed non-production environment with production using Data pump RMAN
• Applied patches and database re-organization using oracle enterprise manager OEM .
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Used to run the scripts to check the status of databases such as growingtable sizes, extend allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintain the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 supports for all the production and development databases.
• Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle streams, RMAN, Data pump, SQL TRACE, TKPROOF, EXPLAIN PLAN

Confidential

Role: Oracle Junior DBA

• Configure, implement Deploy Oracle 10g 11g, single instances on SunOS 5.9 using files system for storage VERITAS Clustering for high availability using IBM's HACMP
• Create oracle database single instance on configured servers using both the DBCA and Database Creation Scripts.
• Monitoring database system and providing technical support for database system issues and application performance enhancement/improvement using both Oracle 11g Grid Control SQL PLUS, as well as UNIX Shell Scripts.
• Worked closely with Application Developers to Design/Create new Oracle databases/create new schemas/databases objects, as well as making databases changes from DEV to PROD, via TST following request /demands from the development team.
• Backup/Recovery of Oracle 10g/11g databases using Oracle RMAN.
• Tools Used: Oracle 10.2.0.1, RMAN, Data Pump, SQL TRACE, TKPROOF, EXPLAIN PLAN