SUMMARY:

• Over 14 years of experience in IT Industry, with 13 years of experience in Oracle database administration.
• Experience in Oracle 8i/9i/10g/11g/12c RAC and non - RAC Database administration, design, installation, up-gradation / Migration in RAC/Non-RAC databases on UNIX/Linux platforms on ASM/OCFS/ACFS/Veritas filesystem.
• Experience of working with databases in high transaction environments (OLTP) and data warehousing database (10 TB+)
• Experience in working as single point of contact for multiple application team to understand their database requirement, designing /creating databases as per business need.
• Designed and Implemented Oracle 11.2 Active Data Guard for RAC/Non RAC databases.
• Oracle 9i/10g/11gR2/12c RAC implementation on Red Hat Linux.
• Implemented and maintaining standby database, Active Data Guard environment, performed failover, switchover operations using SQLPLUS and Data Guard Broker.
• Designs and implements disaster recovery solutions for critical systems. Backup and recovery of databases using RMAN in various disaster scenarios.
• Oracle 11g/12c Grid Control implementation and administration on SUSE Linux Enterprise Server 9.
• OEM Agent installation in silent and GUI mode and troubleshooting OEM Agent related issues.
• Planning and implementing RMAN backup and recovery procedures, Flashback database.
• Performance Tuning using explain plan, TKPROF, Statspack, AWR, ADDM. Partitioning, Materialized views and 11g Grid Monitoring (Both in single and cluster environment).
• Worked on Oracle 11g Oracle Resource Manager, Transparent Data Encryption (TDE) setup.
• Experience in 24X7 Production Support environment
• Experience in database design and data modeling using Erwin, code review.
• Experience in Golden Gate Replication
• Experience in writing UNIX Shell Scripting for Oracle jobs.
• Experience in ticketing tools like Remedy, Kintana, IRIS (ServiceNow)
• Experience in Offshore and Client Co-ordination.
• Experience in ITIL process such as change management, incident management and problem management.
• Good exposure to Quality Management, SEI CMM-5 Processes, Six Sigma Tools/Techniques and Methodologies.
• Excellent analytical and troubleshooting skills and Problem solving.

TECHNICAL SKILLS:

Languages: Pascal, C, C++ and PL/SQL, UNIX Shell Scripting

Database: Oracle 8.x/9i/10g/11g/12c, 10g RAC with OCFS/ASM filesystem, 11g RAC with ASM and ACFS filesystem, MySQL

Operating Systems: SCO-Unix, Solaris, HP-UX, Linux, Windows 95/ 98 / 00/08

Replication Software: Oracle Golden Gate

Other Database: Avenue CRM and MS-Access

Tools: TOAD, Oracle Enterprise Manager and DBArtisan. Erwin, Putty, WRQ Reflection, AWR, ADDM, statspack, tkprof, dbverify, clearcase, Commvault Backup, OEM Grid Control, Data Pump, Export-Import, RMAN, BMC Patrol, Exceed, Service Now (IRIS), TIDAL

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Design Engineer III

Responsibilities:

• Oracle RAC database upgrade/migration from 11.2.0.X to 11.2.0.4 / 12 c.
• Creation of New Databases in RAC/Non-RAC environment using ASM/ACFS filesystem for various applications on UNIX.
• Installing Oracle Software and maintaining Oracle 11g RAC/Non-RAC databases on Red Hat Linux.
• Designing, implementing and maintaining Active Data Guard environment
• Tier 3/Tier 4 Operations Support.
• Database Performance Tuning.
• Collaborating with key stakeholders (Product Managers, Architects, Service Managers, Project Managers) to gather and develop requirements. Requirements assessment and solution recommendation that meets business need in alignment with ADP standards and strategic direction.
• Participating effectively with Development groups in relevant aspects of software development life cycle (SDLC) including assisting in design, testing, reviews and demonstrations. Collaborate with various teams to do performance analysis, tuning and right structural modification/design.
• Developing detailed designs for specific solution of focus. This includes infrastructure specifications, software versions, configurations, migration strategies.
• Participating in design reviews.
• Automation of various Oracle DBA related task like database migration.
• Yearly Capacity Planning for Oracle Database.
• Developing DR strategies, restoring production databases to DR server periodically.

Senior Oracle DBA / Operation Lead

Responsibilities:

• Responsible for Oracle Database Operation Support with team to more that 3000+ Oracle databases of multiple applications.
• Leading a team of DBAs onsite and offshore to provide 24*7 support to mission critical databases for client.
• Responsible for ITIL process adherence for client such as change management and problem management.
• Responsible to review project status and project metrics on weekly/Monthly basis with client.
• Worked as Primary DBA (single point of contact) for multiple applications, working closely with application team to understand the requirement, creating/designing/maintaining and supporting database as per their requirement. Participated in design and code review.
• Migration of existing databases to SDDC (Software Defined Data Center).
• Creation of New Databases in RAC/Non-RAC environment using ASM/ACFS filesystem for various applications on UNIX (10g/11g Databases with Advanced Options).
• Installing Oracle Software and maintaining Oracle 11g RAC/Non-RAC databases on Red Hat Linux, HP-UX.
• Designing, implementing and maintaining Active Data Guard environment
• Provisioning Oracle 12c stand-alone databases.
• Creating UNIX shell scripts to automate lot of process like building/rebuilding active database guard / monitoring databases, DB creation, backup scripts, pulling data from central server.
• Handling technical escalations and outage situations, finding & fixing root cause of the issue.
• Apply latest Grid and Database CPU/PSU/opatch patches.
• Addition of disk storage to ASM disk groups, Maintenance activities of RAC databases.
• Database upgrades from existing database to Oracle 12c.
• Database Performance Tuning, troubleshooting and tuning queries and database using TKPROF, Statspack/AWR/ADDM reports.
• Configuration, Installation of Oracle 9i/10g/11g/12c both primary and standby databases (Data Guard).
• Implementing switchover and failover to standby using Data Guard Broker and SQLPLUS.
• Working with Unix team to fail-over database to cluster node (OS cluster)
• Configured multiple standby databases for a single primary
• Implemented Transparent Data Encryption (TDE)
• Managed Fragmentation issues - Tablespace reorgs, table reorgs and index rebuilds.
• Developing DR strategies, restoring production databases to DR server periodically as requested by Client.
• Utilized Golden Gate for data replication and synchronization
• Extract/Replicat with Golden gate for active-passive, live setup
• Implement and Manage Oracle Golden Gate for Databases replication, Query offloading, Data loading from Oracle to Oracle
• Worked High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 11gR2 RAC environments
• Offshore and Client Coordination
• Refreshing data from Production into Development and QA environments (using EXP/IMP, RMAN Duplicate)
• OEM Agent installation.
• Implementing Enterprise security policies and procedures on databases
• 24/7 On-Call support for production support
• Maintaining and updating the database Support documentation
• Training, mentoring team members and providing help in troubleshooting complex technical issues.

Senior Oracle DBA

Responsibilities:

• Designing and implementing Active Data Guard (11.2.0.X) environment for Single instance primary to Single instance standby, 11g RAC primary to RAC standby, RAC primary to Single instance standby.
• Installing and maintaining Oracle 11.2 RAC on ASM file system on Red Hat Linux.
• Creation of New Databases in RAC/Non-RAC environment using ASM/OCFS filesystem/ACFS filesystem for various applications on UNIX (10g/11g Databases with Advanced Options).
• Installing and maintaining Oracle 11g RAC/Non-RAC databases on Veritas Shared file system /ASM and ACFS filesystem on Red Hat Linux.
• Apply latest Grid and Database PSU/opatch patches.
• Addition of disk storage to ASM diskgroups, Maintenance activities of RAC databases.
• Database upgrades from 9i and 10g, troubleshooting and tuning queries and database using TKPROF, Statspack/AWR/ADDM reports.
• Configuration, Installation of Oracle 9i/10g/11g both primary and standby databases (Data Guard). Plans, Perform daily, weekly and monthly tasks of the DBA.
• Implementing switchover and failover to standby using Data Guard Broker and SQLPLUS.
• Configured multiple standby databases for a single primary
• Implemented Transparent Data Encryption (TDE)
• Worked on Oracle Database Resource Manager
• Compared Golden Gate replication vs. Oracle 11.2 Active Data Guard Replication performance
• Utilized Golden Gate for data replication and synchronization
• Extract/Replicat with Golden gate for active-passive, live setup
• Implement and Manage Oracle Golden Gate for Databases replication, Query offloading, Data loading from Oracle to Oracle
• Worked High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 11gR2 RAC environments
• Creating UNIX shell scripts to automate lot of process like building/rebuilding active database guard/monitoring databases and for other tasks given by Client.

Senior Oracle DBA

Responsibilities:

• 10g OEM Grid Control installation and administration on SUSE Linux Enterprise Server 9
• OEM Agent installation in Silent and GUI mode on all the production and non-production databases and troubleshooting OEM Agent related issues.
• Creation of New Databases in RAC/Non-RAC environment using ASM/OCFS filesystem for various applications on UNIX (9i/10g Databases with Advanced Options).
• Installing and maintaining Oracle 10g RAC on ASM file system on Red Hat Linux.
• Addition of disk storage to ASM diskgroups, Maintenance activities of RAC databases.
• Database upgrades from 9i and 10g, troubleshooting and tuning queries and database using TKPROF, Statspack/AWR/ADDM reports.
• Configuration, Installation of Oracle 9i/10g both primary and standby databases (Data Guard). Plans, Perform daily, weekly and monthly tasks of the DBA.
• Setting up of dataguard and performing switchover, failover and Dataguard rebuilds.
• Backup and Recovery: Extensively worked on Oracle backup and recovery strategies, Maintaining Hot and Cold backups. Configuring and maintaining RMAN backups. Recovery using RMAN backups and/or flashback area. Testing and documenting various RMAN recovery scenarios.
• Restoring all production databases to DR server periodically as requested by Client.
• Recovery Catalog maintenance/upgrade.
• Daily monitoring for space & memory usage, fragmentation issues, Oracle alert logs for typical Oracle errors.
• Database level tuning, SQL Query Tuning for the Data warehouse and OLTP Databases
• Space Management - Addition/Deletion of datafiles, moving objects on-line.
• Data storage management, memory usage estimation for the existing and future expansion requirements.
• Managed Fragmentation issues - Tablespace reorgs, table reorgs and index rebuilds.
• Security: Worked on setting up user profiles and roles as per the access level of user for the data and application security.
• Worked on rotation as a 24x7 on-call DBA and handled many critical production issues.
• Preparation of Instance, Changing init.ora parameters for performance tuning. Maintained the data integrity and security using integrity constraints and database triggers
• Executing database change requests for all the production, staging, quality and development instances.
• Involved in applying security patches and bug fixes & migration of databases to newer releases of Oracle
• Co-ordinated with Server Engineering Team for storage/lun requests.
• Addition of disk storage to ASM diskgroups, Maintenance activities of RAC databases.
• Tuning and optimization, performance monitoring, resource usage and profiles.
• Creating & scheduling UNIX shell scripts for automation of various database activities.
• Opening Service Request (SR) with Oracle support and working with them as required.
• Database cloning
• Monitoring and fixing alert sent by OEM, monitoring daily RMAN/Export backups.
• Offshore and Client Coordination
• Refreshing data from Production into Development and QA environments (using EXP/IMP, RMAN Duplicate)
• Troubleshooting database problems faced by the application developer/users
• Maintaining and updating the database documentation

Senior Oracle DBA

Responsibilities:

• Leading a team of DBAs onsite and offshore to provide 24*7 support to mission critical databases for client.
• Installing and maintaining Oracle 10g RAC on ASM file system on Red Hat Linux.
• Addition of disk storage to ASM diskgroups, Maintenance activities of RAC databases.
• Oracle 9i RAC implementation on Linux Red Hat AS 4 & 3 with OCFS filesystem
• Built and Managed 9i/10g Data Guard environment effectivelyhandled the activities for setting up Data Guard environment created a physical standby database by using RMAN backups built a standby database by using manual backups performed switchover/failover operations
• Working with Unix team to fail-over database to cluster node (OS cluster)
• Creating data model using ER Win
• Performance tuning using explain plan, statspack, tkprof, AWR, ADDM report
• Partitioning the Non-partitioned Large tables for performance improvement
• Implementing Materialized view
• Database tuning by tweaking various init.ora parameter
• Managed Fragmentation issues - Tablespace reorgs, table reorgs and index rebuilds.
• Tuned RMAN backup job timing by tuning large pool size init.ora parameter
• Maintaining Service Level Agreement (SLA) for client with proper distribution of work and coordination with offshore team.
• Working with application team to generate user trace files to track expensive queries before changes go to the production environment
• Opening Service Request (SR) with Oracle support and working with them as required.
• Coordinating with UNIX team for OS related stuff.
• Upgrading existing databases from 9i to 10g
• Coordinating with Offshore team to provide 24 * 7 support
• Backup configuration using RMAN
• Maintaining 8i/9i/9i RAC/10g RAC databases
• Database changes in Dev / QA / Staging/Production databases using proper change control system
• Applying CPU patches
• Export Import
• Unix shell scripting for job automation
• Managing privileges and roles to ensure database security
• Handling Database Change Request.
• User creation
• Tablespace creation and adding data file to the database as database grows over a period of time.
• Refreshing data from Production into Development and QA environments
• Collect statistic for query tuning using TKPROF
• Generate status of Database (Database and listener)
• Loading data using Sql Loader
• Creation and Scheduling of the Cron jobs for maintenance activities.
• Troubleshooting database problems faced by the application developer/users
• Outage Call
• On call support for production instance.
• Maintaining and updating the database documentation
• Monitoring various database activities like number of users, memory usage, hit ratio, Alert log file, archive log files

DBA

Responsibilities:

• Installation of Oracle Software on different platform.
• Database Creation and maintenance.
• Database Consolidation
• Monitoring the offshore databases for various applications.
• Managing privileges and roles to ensure database security.
• Handling Database change request from the application developers on need basis.
• Tablespace creation and adding data files to the database as database grows over a period of time.
• Troubleshooting database problems faced by the application developers/users.
• Performing database recovery as and when required.
• Database Space management.
• Involved in maintaining & updating the database documentation
• Creating the users as & when new resource allocated to project. Backup monitoring and database alert monitoring
• Schema Refresh using export/import, database refresh using cold and hot backup.
• Cloning production database using RMAN duplicate
• Query Tuning

ORACLE DBA

Responsibilities:

• Creating and Managing Users accounts, Roles and Privileges
• Creating and maintaining Databases, Tablespaces & data files
• Hot / Cold Backup and Recovery.
• Creating and Maintaining Indexes
• Verification of contention at various parts of SGA, Performance tuning
• Managed Database Cloning

Confidential

ORACLE DBA

Responsibilities:

• Creating and maintaining Databases, Tablespaces & data files. User Managed Hot / Cold Backup and Recovery
• Verification of contention at various parts of SGA, Performance tuning
• Implemented Database security using Database Roles, User accounts and synonyms
• Periodically check up of data files and tablespaces, buffer cache, shared pool etc

Software Developer

Responsibilities:

• Coding
• Testing
• Maintenance
• Documentation
• Analysis

Confidential

Software Developer

Responsibilities:

• Coding
• Testing
• Maintenance
• Documentation
• Analysis