SUMMARY:

• Have over 12 years of focused experience in IT industry
• Comprehensive experience as Oracle DBA in various fields like Insurance, Retail and Telecom, Extensive experience in relational database design, analysis, development, administration, implementation, trouble shooting and quality management.
• Extensive experience in 11gr2 RAC, Exadata, ASM,RMAN, Data Guard, Golden Gate
• Oracle Certified Professional ( OCP DBA) in 10g
• Worked in 24x7 production environment and provided on - call and day-to-day support.
• Comprehensive experience as performance Tuning/Table Partitioning ( OLTP and Data wareHousing ) Oracle RAC/ASM DBA Experience
• Installing & configuring and supporting RAC/ASM environment
• Clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of clusterware)
• Worked with customer for different RAC related issue: Cluster startup issue, ASM disk header corruption, Node eviction, ASM memory Increase, multiplex voting disk, OCR issues, Service Relocation
• Troubleshoot performance issues for the RAC instances
• RAC database restore and backup & cloning
• Upgrade of 10g R2 RAC to 11g R2 RAC
• Patching RAC cluster and database Oracle Golden Gate DBA Experience
• Installing & configuring golden gate environment
• Performing Initial Data load, configure extract, datapump, manager & replicate process
• Troubleshooting golden gate abend process, handcollison & lag issues,logdump
• Implemented Oracle Golden Gate for table level replication with multiple extract replicate processes. replicating huge & mixed number of tables
• Implemented Golden Gate from Oracle to replicating databases using Oracle Golden Gate between homogeneous and heterogeneous databases.
• Oracle DBA Experience (11g/10g/9i)
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Manage RAC environment for Day to Day Database administrator
• Expertise in Oracle Data Guard and Physical Standby databases,
• Expertise in Oracle Enterprise Manager (OEM), TOAD,
• Expertise in DataPump ( Expdp,Impdp), SqlLoader, Materliazed View
• Experience in Migration of DB2 to Oracle database
• Expertise in Performance tuning the production database towards optimal performance
• Experience in capacity planning, Space management, database Upgrades/Migration planning/implementing Backup/recovery strategies using RMAN
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and PL/Sql- Tables, Materialized views
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such as Import/Export, SQL*Loader and SQL*PLUS.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
• Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML-11g
• Using SqlLoader to Load XML and flat files in oracle database
• Extensively Used the XML SQL Oracle (Extract, ExistsNode, ExtractValue, XMLSequence, Append ChildXML) functions to generate, insert and manipulate XML files in Oracle 11g
• Creating and translating business process specifications into design specs and XML business rules.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required. Session Tracing, AWR reports
• Data Modelling using Erwin
• Source data analysis, table design using Erwin, Improved designs for ease of data loading
• Changed architecture and mapings as needed to improve performace
• Business analysis and data model design for new tables related to ETL
• Design and create database tables needed for application
• Experience in understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Good ability to quickly grasp and master new concepts and technologies.
• Involved in handling the changes in compiling scripts according to the database changes
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• Created SQL*Loader scripts to load data into temporary staging tables
• Data types conversion and mapping between different source

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/NT/XP, MS-DOS and UNIX,AIX,LINUX

Application Domain: Telecom, Retail, Health care, Insurance, Banking,SAP

Tools: MS Office,Brtool, Toad, SQL Developer, OEM, File zila, Putty, BMC Remedy

Databases: Oracle 9i/10g/11gr2 RAC, ASM, RMAN, Data Guard, Golden Gate

PROFFESIONAL EXPERIENCE:

Confidential, New York

Sr. Database Administrator

Responsibilities:

• As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases of design architect and migration project.
• Working on 12c database and 11 g rac database
• Resolve the performance issues of Oracle11g databases.
• Handle daily production issues and migration of oracle database
• Rman cloning, back up and recovery and export and import
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential, New York

Sr. Database Administrator

Responsibilities:

• As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases of design architect and migration project.
• Working on 12c database and 11 g rac database
• Resolve the performance issues of Oracle11g databases.
• Handle daily production issues and migration of oracle database
• Data load using sql loader for production data into non production data
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential, San Jose, CA

Sr. Database Administrator

Responsibilities:

• As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases of design architect and migration project.
• Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
• Implemented High availability using Golden Gate Replication
• Troubleshooting golden gate abend process, handcollison & lag issues,logdump
• Resolve the performance issues of Oracle11g databases.
• Handle daily production issues and migration of oracle database
• Data load using sql loader for production data into non production data
• Manage databases in a 24x7 mission-critical production environment
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Confidential

Sr. Database Administrator

Responsibilities:

• As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases Confidential Project Europcar, Orange, Sequana, Gefco
• Advanced Backup and Recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via Korn shell scripting.
• Installation of RAC and Managing RAC Environment efficiently
• Managing Exadata database servers for two nodes clusters
• Mentor other DBAs in effective use of RMAN software, and my scripts.
• Resolve the performance issues of SAP Oracle databases.
• Handle daily production issues and migration of SAP
• Manage SAP databases in a 24x7 mission-critical production environment
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Implemented High availability using Golden Gate Replication
• Troubleshooting golden gate abend process, handcollison & lag issues,logdump
• Currently helping team to use existing infrastructure to achieve maximum benefit to reduce cost and maximum performance.
• Actively working with other teams for Server Consolidation & Database Consolidation.
• Changes were made dynamically whenever possible to fulfill high-availability requirements.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
• Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
• Proficient in RAC Performance Tuning. Create and maintain materialized views.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored the production Oracle alert logs for database errors.
• Monitored system resource availability and responded to system memory and data issues.
• Expert with OEM Grid Control.

Environment: SAP application, BO application with Oracle Database RAC 11gr2Single Instance 10g & 11g . Database Backup Schedule with RMAN using netbackup and

Confidential, New York

Lead Database Administrator

Responsibilities:

• DBA Lead and supporting 11gr2 RAC database
• Provided production database support for Application
• Helped other team members to complete PL/SQL code development and sql tuning
• Managed and coordinated with other team for database deployment in production.
• Provided support to QC and DEV database for application testing and coding.
• Provided business reports to management from reporting database
• RAC 11gr2 installation and configuration on prod and non prod database servers
• Single sign on implementation of oracle virtual directory in 11g
• Configure OIM ( Oracle identity manager) for application
• Integration with OVD ( Oracle virtual directory) and Active directory
• Understanding of Import users, account, roles, Policies, Business structure in OIM
• Configure the Oracle Identity Manager Data Collection Scheduler
• Import the Oracle Identity Manager (OIM) Data Into Oracle Identity Analytics
• Configure Oracle Identity Analytics to Connect to Oracle Identity Manager
• Scheduling Incremental Updates of Users, Accounts, User-Role Memberships, and Entitlements in OIM
• Using DBMS Scheduler for batch jobs
• Datapump expdp and impdp for data transfer

Confidential, Chicago, IL

Lead DBA and ETL Developer

Responsibilities:

• Project Lead and supporting 11gr2 RAC database
• Managing and coordinating with other team for database deployment in production.
• Providing support to QC and DEV database for application testing and coding.
• Developed PL/SQL packages, procedures and functions accordance with business requirements for loading data into database tables.
• Involved in unit testing of stored procedures and functions.
• Created materialized views and partitioning tables for performance reasons.
• Worked on various backend procedures and functions using PL/SQL.
• Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Developed UNIX shell scripts to perform a nightly refresh of the test system from production databases.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Developed procedures using Dynamic SQL.

Environment: Java J2ee application, data stage, cdc, golden gate, Naca tool with oracle database 10g/11g

Confidential, Georgia

Lead DBA and PL/SQL Developer

Responsibilities:

• DBA Lead and supporting business online application
• Production database support for Application
• Helping team to complete pl/sql code development and sql tuning
• Managing and coordinating with other team for database deployment in production.
• Providing support to QC and DEV database for application testing and coding.
• Provide business reports to management from reporting database
• Sql loader to load the bulk data in database
• Implementation of request for Change in database
• Database Cloning from prod to non prod
• Deploy the database build as release
• Upgrade 10g to 11g single database instance
• Database data testing
• Writing Trigger, Procedure, Package for application
• Writing queries and helping application for performance issue
• Making business reports using sqls
• Writing shell script for batch jobs
• Support application testing for data validation

Environment: Java application, OLTP business with retail Confidential & Confidential domain, UNIX and Win. NT

Confidential

Lead DBA and PL/SQL Developer

Responsibilities:

• Actively managed 40 database instances
• Provided 24*7 Support to database
• Responsible for database installation, instance creation, patching and upgrading, also involved in storage space management and planning
• Co-ordinated batch testing and load and performance testing
• Provided support to additional support to other projects
• Database backup and recovery
• Trouble shoot database related issues
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Used Oracle PL/SQL for implementing business rules and do performance tuning procedures.
• Created data mapping files for the data coming from different web services.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging. Tied the procedures into an existing ETL process.
• Developed procedures using Dynamic SQL..
• Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.