SUMMARY

• Over 8 years of professional experience in Information Technology in design, development, implementation, maintenance, documentation and administration in various domains like manufacturing Finance, and Insurance industries.
• Experience in installation and configuration of Oracle Data guard, Switchover and Failover.
• Installed Grid infrastructure 11gR2 with ASM.
• Experience with using Oracle Golden Gate (OGG), OEM, ADDM, Partitioning and Oracle data design.
• Worked on setting Up High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2 RAC environments
• Installation, patching, updates, configuration maintenance of Oracle 10g RAC, 11gR1/R2 RAC Databases.
• Monitoring growth of tables and undertaking necessary re - organization of table spaces and indexes when required.
• Applied Patch set and Interim patches for databases. Upgraded the database's software up-to-date (i.e., from 8i to 9i, 9i to 10g and 10gR2 to 11gR1/R2).
• Experienced in loading data from flat files into database tables using SQL*Loader, ETL Tools and External Tables.
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Applied various database / applications PSU / CPU patches as required.
• Also applied monthly vertex updates. s like Automatic Storage management (ASM), Automatic Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Installed & configured Oracle Management Server (OMS) &Oracle Grid Control.
• Expertise in designing and implementing the backup policies and procedure (Database utilities like Data Pump, Import & Export, RMAN backups, SQL*Loader).
• Worked extensively on Oracle Migrations. Migrated database from Windows to Linux, HP-UX to AIX.
• Provided Oncall Support
• Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
• Creation and maintenance of Stand-alone and RAC Databases in Production, Test and Development environments.
• Installation and configuration of Standby Databases (Data Guard), Active Data guard, Snapshot Datagurad Broker.
• Migrated Single Node Instance to RAC Databases (Non-RAC to RAC).
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Installed and configured 12c / 10g Grid Control and also monitored various Production and Development databases.
• Installed and configured 10g/11g Oracle Transparent Gateways to connect to heterogeneous Databases.
• Support numerous instances of Production, QA and Development Databases. Assisted Development team with performance tuning of DB's.
• Strong experience in Migration (CUTOVER) and Cloning (COPY/DUPLICATE) of prod Database using RMAN.
• Generated Stats pack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports.
• Applying Oracle Critical Patch Update (CPU) to the database using Opatch utility.
• Good Experience in Managing, Restoring and Recovering Clusterware Components (OCR, VOTING DISK).
• Extensive performance tuning experience and troubleshooting of Oracle software server.
• Having good analytical, problem-solving and learning skills.

TECHNICAL SKILLS

Operating System: Red Hat Linux, Oracle Enterprise Linux 4 /5.5/6, Sun Solaris, MS Windows.

Programming: SQL, PL/SQL, Unix Shell scripting.

Databases: Oracle 9i,10g, 11g, 12c Versions,DB2.

Tools: Asmcmd, OEM, RMAN, Datapump, Vnc viewer, Putty, AWR, Lsnrctl, Tnsping, Opatch, Editplus Winscp, Quality Controller, ADDM, PL/SQL Developer.

RAC Utilities: Crsctl, Srvctl, Ocrconfig, Ocrdump, Ocrcheck, Oifcfg, Asmcmd, Taf Data guard Physical Standby, Active Data guard, and Snapshot Data guard

PROFESSIONAL EXPERIENCE

Confidential, Burns Harbor, IN

Sr.Oracle DBA

Responsibilities:

• Installed and configured 10g/11g OracleTransparent Gateways to connect to heterogeneous Databases
• Installation and Configuration of Oracle 11gdata file objects including tablespace and data files, object sizing as well as monitoring Managing database usage and growth.
• Worked on setting Up High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2 RAC environments (Front-end: IBM AIX 6.0, Back-end: Oracle Exadata).
• Did Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server).
• Performed pre-installation server validation checks.
• Implementation and support of 10g and 11g, upgrades from Oracle 10g to Oracle 11g databases, including RAC (Real Application Clusters) databases on IBM AIX and Linux.
• Performed oracle Software's Installations, Creation of new stand-alone and clustered databases.
• Administering and setting up of 11g RAC cluster ware and instances.
• Performing exports/imports and RMAN Backup and Recovery. Also managed tablespace, user profiles, Indexes, storage parameters.
• Scheduled RMAN backups, purge jobs, maintenance Jobs using control-M scheduler, DBMS JOBS, DBMS SCHEDULER and Crontab.
• Controlled database resource access through user profiles, Database Resource Manager and data access control FGA and principle of least privileges implementation
• Performance tuning using AWR.Installed and configured Oracle 11g software on AIX / UNIX / LINUX operating systems.
• Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups. Taking export backup of tables for future database recovery.
• Created a number of database instances for development, staging and production environments.
• Having good experience in using original exp/imp and Data pump utilities.
• Experienced in using AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Developed RMAN scripts for database back up including hot and cold backup options for both RAC and stand-alone instances. Performed Rman recovery from previous either full backup, or incremental backups.
• Generated Stats pack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time-consumingSQL queries, tablespace growth, and database growth.
• Provided 24x7 remote support and on call Database support (rotatory weekly backup DBA from 12am - 6am) using RSA-VPN.
• Ensured that standby database is always in sync with production database by checking ARCHIVELOG sequences.
• Involved in User management, Tablespace Management and regular maintenance activities.
• Involved in Creation and Maintenance of table partitions and indexes.
• Configuring of Load balancing and Failover using TAF policy. Also performed migration from Non-ASM to ASM.
• Created Database Links for accessing data from Remote Databases.
• Creating users, allocating table spaces to users, managing privileges with roles.
• Having good knowledge in Partition Management like Add, Drop, Coalesce, Exchange, Merge, Move, Split, and Truncate partition
• Created materialized views with fast refreshing techniques.
• Good in performing Online Redefinition (Non-Partition to Partition and Partition to Non-Partition).
• Having strong knowledge in creating table partitions like Range, Hash, List, Composite, Interval partitions.
• Performance SQL tuning based on reports generated by ASH, ADDM, AWR
• Identified and resolved performance issues caused my table fragmentation using Segment Advisors
• Troubleshooting and resolving locking and concurrency issues, Excessive parsing, Resource
• Very good in creating index partition like Local Prefixed Indexes, Local Non-prefixed Indexes, Global prefixed Indexes.
• Having good experience in creating Global Temporary Tables.
• Development experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL, PL/SQL.

Confidential, East Providence, RI

Oracle DBA

Responsibilities:

• Part of core Development DBA team maintaining Development databases.
• Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL.
• Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
• Creation and maintenance of standby database by using oracle high availability method and Oracle Data Guard.
• Tuning of the database using TKPROF utility, tuned the Shared pool and buffer cache to have better performance.
• Point in time recovery for recovering the master data when the tables are dropped by user errors.
• Identified, recommended and made necessary changes to the application code, the database architecture and server architecture.
• Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Log Miner, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
• Installation and configuration of Oracle databases on LINUX platforms.
• Administering the physical aspects of the databases such as creation of Table spaces, Users, Rollback segments, creating data files, helping users in creating database objects.
• Configured and maintained data loads in huge Data warehousing systems using the Informatica Power Center ETL tool. Supported data warehousing and databases
• Upgraded Oracle database using DBUA or Data Pump Export/Import
• Implemented Migration Strategies based on cost, time, and platforms requirements
• Advanced troubleshooting using trace files, alert log, and external links (Metalink or Oracle Support)
• Generated Reports and preparing memo to communicate progress and providing early alerts for major updates
• Analyzing performance issues and providing recommendation based on testing results using Oracle's tools like AWR, ASH& Data Recovery advisor.
• Configured Standby database for production database.
• Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Configured Standby database for production database.
• Participate in establishing and involving database standards within the company.
• Providing 24X7 support for Development databases and working experience on on-call.
• Design and implementation of Backup and Recovery activities using RMAN &Export/Import utilities.
• Taking Backups daily base and weekly backup.
• Preparing cluster, configuring and Installation of cluster ware and Oracle RAC on RHEL.
• Performance monitoring, Database tuning and Application tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack.
• Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.
• Monitoring Database Activities, Checking for Tablespace Availability, Checking the Alert Log File for errors.
• Troubleshoot /Configuration of tnsnames, listeners setup.
• Responsible for online and offline backups and recoveries of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Create new database users as required. Plans and implements backup and recovery of the Oracle database.
• Upgraded Oracle database using DBUA and (remove or) Data Pump Export/Import

Confidential

Oracle DBA

Responsibilities:

• Managing table spaces, user profiles, indexes, storage parameters.
• Performing database upgrades from Oracle 9i to 10g as part of new releases.
• Experience with installing, setting up and configuring DATAGURD, ASM, and RAC in a heterogeneous environment.
• Worked on several applications like CAPRS, EPECS, DICARS, PAPERLES, ACT, etc.
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Establish a backup and recovery strategy using daily hot backups, RMAN and weekly full backup.
• Responsible for overall strategic planning & redesign of databases like Requirements gathering and Analysis, Design, Test and Implementation through the phases of System Development Life Cycle.
• Hands on experience in performing exports/Imports and RMAN backup and recovery.
• Maintained database configurations in compliance with release management and change management
• Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• Implemented database Refresh (cloning) using full export for table level and full database defragmentation, resulting in improved performance and effective space management
• Applying regular CPU patches
• Installed and configured Oracle database 12C in an enterprise environment.
• Created data guard (standby) databases for all our production databases.
• Ensured daily RMAN backups are completed and valid for restore and recovery
• Configured the necessary parameters for Flashback database settings and Flash Recovery Area, then using RMAN to issue Flash Recovery Commands
• Created a number of database instances for development, testing and production.
• Upgrading the single Instance, RAC databases to 10gR2,11gR1/R2
• Performed number of dev., test and stage cloning from PROD databases.
• Migrated databases between machines.
• Adding space to the data files according to tablespace growth.
• Proactively diagnosed and resolved the problems affecting the database.
• Automate database administration routines in backup and recovery using Recovery Manager (RMAN), routine import/export activities, schema creation and disk usage monitoring.
• Strong experience with design, development, and testing of backup and recovery to ensure complete recoverability
• Solid experience in disaster recovery, routine maintenance for Oracle databases.
• Implemented Materialized Views for efficient and high availability of Processed Sales data.
• Regular database activities, backups monitoring and troubleshooting.
• Involved in User management, Tablespace Management and regular maintenance activities
• Installed patch sets and upgraded Oracle (RDBMS).
• Involved in Creation and Maintenance of table partitions and indexes
• Cloning the databases regularly for the reporting databases and stage environments.
• Developed SQL, PL/SQL, Unix Shell scripts for Development and scheduling activities.
• Monitoring and Tuning the CPU, memory usage, I/O contention, paging, network statistics on UNIX servers using TOP, IOSTAT, NETSTAT, VMSTAT, TOPAS,
• Migrated Oracle Applications and Databases to another location using cloning.
• Designed and created the Real Application Clusters (RAC).
• Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.

Confidential

Oracle DBA

Responsibilities:

• Experience with SQL, DDL, DML, DCL, PL/SQL coding, stored procedures, functions, packages, triggers and Periodically uploading data from flat files using SQL*Loader.
• Designed, and developed Oracle PL/SQL processes for loading data from internal systems using SQL Loader and External tables.
• Extracted data from different databases and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, synonyms, unique/non unique indexes, constraints, triggers, sequences, implicit/explicit cursors, cursor for loops, reference cursors and other database objects.
• Involved in ETL Development using native Oracle tools(SQL*LOADER, Oracle PL/SQL)
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Used CA/ERWIN Data Modeling Tool and the CA/Model Mart Data Model Management Tool.
• Creating control files for SQLLDR
• Stage tables/packages to load history files using SQLLDR and external tables.
• Exporting data using expdb and Importing data using impdb
• Involved in the creation of Partitioned Tables and Indexes
• Maintenance of production database and development database which includes table space management, user creation, privileges, and roles.
• Installation and configuration of Oracle 9i/10gR2
• Involved in various stages of the Oracle Database Administration Life cycles (Installation, Database builds/ instance creation and tuning, Migration and Upgrade, Applying Patches, Configuring of Clients).
• Coordinated with team members and integrated total project
• Prepared technical design document.
• Documentation of functional document MD70 which includes all the components that needs to be developed as part of the requirement - packages, procedures, table creation scripts etc.
• Providing support at customer site by solving bugs/problems and providing requested business information by building queries and/or extracting required data.
• Code reviews to achieve code optimization in order to enhance performance.
• Preparation of Unit Test Cases, Defect logs and Issue Log
• Oracle Database Refresh/Cloning performed from Production to Test, Parallel, Training and Development databases using RMAN
• Monitored the operating system response in terms of CPU usage, disk space, swap space and paging by using various UNIX utilities like SAR, vmstat and top.