EXPERIENCE SUMMARY:

• 9 Years of experience as Oracle DBA (12c/11g/10g/9i/8i) which includes Installation, Configuration, Performance Tuning, Backup/Recovery, Disaster Recovery, upgradation, cloning, patching, Rac, Asm Golden Gate, 24X7 On - Call production support and pl/sql coding on different HP-UX, Sun Solaris, Linux, AIX, and Windows along with SQL server, Mysql administration and Mongo db administration.
• Experienced in designing and capacity planning of databases up to terabytes of data.
• Performed administrative maintenance, monitoring for Oracle and MS SQL Server, Mongo database systems in a global 24x7 operational environment.
• Experienced in maintaining large Production, UAT, QA and DEV environments.
• Experienced in data center migrations.
• Strong experience in designing databases with clusters and node setup for EBS applications in RAC along with vendor clusters.
• Good experience in GOLDEN GATE setup and troubleshooting
• Creating new Oracle databases using DBCA or database scripts. Installing creating new ASM disk group or raw devices for RAC databases.
• Strong knowledge on GRID/CRS, OCR, VOTING, OLR, GPNPD, GLOBAL CACHE mechanism.
• 24/7 support for Production databases and responsible for round-the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior importance.
• Experience in installation and configuration of Oracle Automatic Storage Management (ASM) in RAC environment and migrating databases from file systems to ASM.
• Experience in installing, configuring and administering 10g and 11g 2/3/4 node RAC databases.
• Experience in using 10g and 11g features like Data pump, Flashback Recovery, ASM and Compression.
• Upgrading the databases from various versions to 11gr2.
• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, analyzing security problems and auditing.
• Tuned the database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK proof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM.
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backups.
• Experience in cloning the process of copying an existing Oracle installation to a different location and updating the copied bits to work in the new environment.
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Experienced in planning, designing and maintenance of the golden gate environments.
• Good experience in Oracle 11g/10g RAC, Standby Database (Data Guard), ACTIVE STANDBY, Replication, BCV backups.
• Experience in various scenarios of Database Recovery and Real application testing (RAT). Good hands on experience in configuring and maintaining 11i/12c ORACLE ENTERPRISE MANAGER (OEM).
• Delivering SQL and Database performance tuning services via V$/GV$views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• Used PL/SQL (Stored procedures, triggers, packages (DBMS *, UTL *)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Extensive Experience in Oracle Architecture, I/O tuning, Memory Tuning, Performance Tuning, Backups, Recoveries, RMAN backups, Optimization, Crash/Disaster Recovery, Networking.
• Installation and Configuration of Oracle 10g Application servers.
• Experience in implementing ILM.
• Experience in writing cronjobs with shell scripting
• Good experience in handling with mviews of different types and maintaining mview logs.
• Preparing SOP documents for all databases under support
• Excellent problem solving skills in dealing with distributed transactions in OLTP systems.
• Experienced in managing partitioned tables like creating the partitioned tables, addition of new partitions, compression, exchange partitioning and carrying out maintenance activities
• Good Written and verbal Communication skills with a customer service oriented attitude.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Proficient with 11g new features: Active Datagaurd, configuring Snapshot standby database.
• Performance tuning, backup and recovery, space management, database security, Auditing.
• Cloning the Database from Prod to Dev using USER MANAGED and RMAN techniques like ACTIVE DUPLICATE.
• Migrating the schemas using traditional exp/imp and Oracle Data pump utilities.
• Setting up and Monitor transactional replication, Database mirroring in SQL servers
• Created SQL Server user/roles with db authentication or windows authentication.

TECHNICAL SKILLS:

Relational Databases: Oracle 8i (8.1.5, 8.1.6, 8.1.7.4). Oracle 9i (9.2.0.1, 9.2.0.4, 9.2.0.5, 9.2.0.6, 9.2.0.7, 9.2.0.8). Oracle10g Release 2 (10.2.0.1, 10.2.0.3, 10.2.0.4). Oracle 11g Release 1 (11.1.0.6,11.1.0.7,11.2.0.1). Oracle 11g Release 2 (11.2.0.1, 11.2.0.2,11.2.0.3). Microsoft SQL server 2000/2005/2008/2012 and Mysql.

High Availability & Tuning/Monitoring: Real Application Cluster (RAC) 11g R2 and R1 with ASM. Real Application Cluster (RAC) 10g Release 2 with ASM. Oracle Management Server (OMS) 9i, 10g &11g. Oracle Enterprise Manager (OEM) 9i, 10g & 11g. LOG MINER, Physical Standby. Data - Guard 9i, 10g & 11g. Database Cloning (Manual, RMAN). Standby Databases (Manual, RMAN) (Physical & Logical). RMAN 9i, 10g & 11g. AWR, ADDM, ADRCI, ASSM, OEM, GOLDEN GATE, Stats pack Reports & other Logs. Tuning with SQLT, ADDM.

Operating Systems: Linux Solaris 8,9,10 Rhel 5,4,3 Hp - UX Aix Windows

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

• Upgraded the RMS database from 8i to 11gr2.
• Created 12c databases with proper capacity planning.
• Implemented 12c new features like ADAPTIVE PLANS, PARTIAL INDEXING, ORACLE RESTART, CPU CAGING for optimizing performance.
• OEM 12c set up and active agent installations performed.
• Implemented partitioning for better performance of databases with terabytes of data.
• Troubleshooting ASM and clustering issues.
• Performed OCR and VOTING DISK maintenance for 3 node RAC environments.
• Troubleshooting network issues in RAC environments and provided permanent fixes for them.
• Dealt with Interconnect issues from different applications to oracle databases.
• Participated in data center management for setting up the database backups.
• Removing the fragmentation from core objects with minimal downtime.
• Maintenance of partitioned tables and archiving.
• Working with online record management systems for SQL tuning.
• Made use of expdp and impdp new features for migrating large amounts of data of about 2 terabytes.
• Tuning the sqls and moving them to the production for district wise modules.
• Worked on resolving distributed transaction issues by dealing with DBA 2PC PENDING
• Implemented 10g and 11g new features.
• Dealt with histograms for fixing data corruptions by coordinating with Oracle Support.
• Scheduling and troubleshooting the materialized view refreshes.
• Worked on configuring backups using netbackup, uni-trans backups.
• Installing and creating the databases of enterprise versions.
• Migrating the data from sql database to oracle database.
• Worked on configuring the suitable adapters in coherence with oracle databases for front-end police devices.
• Active participation in RESTORATION of databases.
• Cloning the databases using RMAN DUPLICATE and manual methods.
• Configuring the jobs with shell scripting and usage of cronjobs.
• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Usage of logon triggers for core level auditing.
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Automated Rebuilding indexes, Partition additions and space additions.
• Dealt with database cloning, Migration, Data Guard and Patching of Oracle Databases.
• Created MONGODB databases with shardening feature.
• Performed maintenance on mongo db machines with mongo db latest releases.

Confidential

Database Administrator

Responsibilities:

• Played major role in R12 upgrading.
• Worked on Oracle Databases supporting EBS systems.
• Worked on GOLDEN GATE setup for production environments.
• Worked on OEM11G and 12C.
• SQL Server support involves transaction log shipping, code deployment, daily backup (full and transaction logs) and managing datafiles / filegroups
• Setting up and Monitor transactional replication, Database mirroring in SQL servers
• Experience on installing 2012 SQL Server Microsoft Management Studio service pack 2
• Designing and migrating applications among different environments.
• 24*7 production Support for mission critical production systems.
• Installation and configuration of Oracle databases (single instance).
• Installation and configuration of 3 node RAC instances in 11g.
• Resolving ASM multipathing issues.
• Supporting EBS databases and troubleshooting concurrent manager issues.
• Bouncing concurrent managers and form severs.
• Tuning database parameters relative to the EBS systems.
• Active Duplicate cloning of the databases using RMAN.
• Cloning from cold backup using RMAN.
• Perform refreshes from non-RAC database to a RAC environment.
• Involved in testing several 11gr2 features in Oracle and upgraded several instances from 10g to 11g.
• Moving pl/sql codes in to production and validating the codes.
• Tuning the sqls before using them in production environments.
• Responsible for moving data from Production to lower environments for various testing cycles using Oracle data pump and also refresh the UAT and Test environments with Prod data.
• Generated AWR and ADDM reports for Performance and Tuning.
• Supported large data warehousing systems with a capacity ranging from 2 TB to 15 TB.
• Renaming databases with NID.
• Involved in ETL development and Data Modeling using DATASTAGE and ERWIN tool
• Security Administration including the management of profiles, roles, users and their privileges.
• Configure and mange RMAN backup using GRID.
• Flash back technology.
• Experience in opening, managing, and resolving Oracle Service Requests.
• Resolve issues during migration from different ASM disk groups following up with Oracle.
• Administrate RAC service with SRVCTL.
• Manage the Cluster Services in case of any abnormal failures.
• Worked with users in tuning their bad sql.
• Tuned and optimized SQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours
• Worked on Database optimization by setting various initialization parameters on Oracle request
• Restorations of databases using RMAN.
• Upgrading the databases to higher versions of oracle by manual and DBUA.
• Experience in various recovery scenarios.
• Implementing database parameters to support ORALCE EBS.
• Generating awr reports on regular basis to identify the database performance at peak load.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Making use of 11gR2 Features like ADRCI.
• Implemented stored scripts in catalog for effective use of rman.
• Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance.
• Working with the solution design team and identifying solutions to the new business functionalities.
• Preparing the weekly and monthly status reports to the management.
• Tuning memory parameters.
• Performed logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup.
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.

Database Administrator

Responsibilities:

• Installation and configuration of RAC instances in 11Gr2for about 32 environments.
• Played major role in design and setup of cluster environments for new products.
• Designing and configuring 3 node RAC databases with capacity planning.
• Implementation of space optimization methods.
• Changing OCR and VOTING disks.
• Working on POC with oracle support and designing methods for ROLLOUTS.
• Maintaining clusters with utilities like CRSCTL,SRVCTL,OCRCONFIG,OCRDUMP
• Generating reports from OEM 11G.
• Writing documentation for Clusterware installation, RAC RDBMSinstallation, RACDatabase creation, Grid Control installation, Oracle 11g Standby Documentation Active Duplicate cloning of the databases using RMAN.
• Highly experienced in using STATSPACK, AWR to check health of database & hardware.
• Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance.
• Migrating the database objects including the PL/SQL codes.
• Documenting various recovery scenarios for DR site.
• Managing the gaps in archive logs to bring the standby in sync with primary database.
• Building DR environment for the business critical databases.
• Perform refreshes from non-RAC database to a RAC environment.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experienced with DATA GUARD implementation and Point in time Recovery.
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.
• Managing partitioned tables.
• Installing and configuring CRS on all cluster nodes.
• Installing Oracle 10g software for RAC with ASM.
• Upgraded databases from 9.2.0.6 to 10.2.0.4.
• Configuration of ASM.
• Migrated databases from file system to ASM.
• Converted single instance database to two instance RAC database.
• Prepared plan for upgradation along with time lines.
• Installation of Oracle 10.2.0.4 and upgraded the database.
• Building load test environments by cloning.
• Migrating DB’s across servers.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving the performance of the Query.
• Installing Oracle 11g software for RAC with ASM.
• Maintaining 4 node RAC systems.
• Configuration of ASM and two instance RAC database.
• Resolving ASM issues like rebalancing, disk additions and managing asm with asmcmd.
• Managing all databases like Critical production, standby, report databases of different platforms like Linux, Sun Solaris.

Confidential

Database Administrator

Responsibilities:

• Played major role in Data Centre migration.
• Designed server migrations and storage syncs.
• Working with BCV backups for cloning and migrations.
• Planning and maintaining golden gate environments.
• Maintaining GG tables and keeping them in sync.
• 24*7 production Support for mission critical production systems.
• Installation and configuration of Oracle databases (single instance).
• Installation and configuration of RAC instances in oracle 10g and 11g.
• Working with OEM11g.
• Maintaining RAC databases on vendor clusters like sun cluster.
• Configuring RMAN backup for the databases with catalogue.
• Performed Import any Export using Oracle Data pump utilities EXPDP and IMPDP.
• Trouble shooting the databases for various dynamic issues during run time.
• Solving performance problems with the databases with respect to sql tuning, DB parameters tuning, OS level and network level issues.
• Migration of the databases to different servers.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Cloning of the databases.
• Restorations of databases using RMAN.
• Upgrading the databases to higher versions of oracle.
• Experience in various recovery scenarios.
• Configuring the DR databases and troubleshooting the various issues related to the DR recovery.
• Performing switchover between Primary and standby databases.
• Performing DR Drills once in every year.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Deployment of applications and troubleshooting the issues related to application servers.
• Generating stats pack reports on regular basis to identify the database performance at peak load.
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Implemented scripts to monitor the health of the databases and application servers.
• Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performance.
• Checking CRON jobs. Monitoring Application specific background processes.
• Planning and implementing the Archival policies as per the requirements.
• Working with the solution design team and identifying solutions to the new business functionalities.
• Preparing the weekly and monthly status reports to the management.
• Performed REDO logs management and tuning by creating new members and resizing them.
• Working with applications like tuxedo which are hardcoded with database tables.
• Working on distributed transactions (DBA 2PC PENDING) for a group of databases with distributed architecture.
• Building datagaurd environments.
• Testing database failover with virtual networks.
• Partitioning tables to improve performance.
• Performing archrivals with exchange partition concepts.
• Instance wise performance optimization for rac databases with the use of database parameters like cursor sharing.
• Converting single instance databases to rac databases.
• Allocating system storage and planning future storage requirements for the database system.

Confidential

Database Administrator

Responsibilities:

• Actively involved in strategic backup,restore and recovery using RMAN for complete recoverability.
• Installed and configured Oracle RDBMS on UNIX and LINUX.
• Performed Import and Export using oracle datapump utilities like EXPDP AND IMPDP.
• Installed, and patched Oracle software and associated applications.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server. Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Established and maintained sound backup recovery and procedures.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Experience in configuring Data guard 10g R2 for physical standby database. Experienced in managing data guard configuration using DGMCRL tool.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Cloned environments to create patch test, development and QA environments.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Responsible for setting and managinguser accounts, Granting required privileges to users.

Confidential

Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for setting and managinguser accounts, Granting required privileges to users.
• Involved in the installation of Oracle 9i on Linux.
• Execute Hot, Cold and RMAN backups and recoveries.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Cloned environments to create patch test, development and QA environments.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Responsible for setting and managinguser accounts, Granting required privileges to users.
• Providing 24*7 on call support for the business crirical production database.
• Managing 2 node rac databases.
• Performed database migration from 9.2.0.4 to 10.1.0.3.
• Cleaning oracle home file system by cleaning the log files like listener logs.
• Identifying and trouble shooting day to day issue like locking, scripts execution and data audits.
• Creating users, database links, sanpshots on production and development databases.
• Solving problems of database connectivity related to network and load issues.
• Creating and maintaining materialized views and materialize view logs with rowid and priamary key.
• Working with application teams on load balancing corresponding to system resources.
• Applied High priority, security patches downloaded from Metalink.
• Trouble shooting issues while moving codes in to production.
• Deploying war, ear files in oracle 10g application servers.
• Working with oc4j containers, http and apache and jvm memory issues in application servers.