SUMMARY:

• Over 8+ years of experience in IT industry, worked as Oracle Database Administrator, encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Monitoring, Performance Tuning, Real Application Cluster and Exadata.
• Extensively Worked on databases in machine critical large OLTP systems in a variety of environments like Linux, IBM - AIX, Sun Solaris, RHEL and Windows on highly transactive and very large databases(VLDB).
• Expert in planning, creation, administration and troubleshooting of Oracle 12c/11g/10g/9i OLTP (multiple instances)/OLAP databases in production.
• Having good experience in 12c database administration and Installed 12c database on RHEL/AIX on Test Servers.
• Hands on experience in implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM on 10g/11g/12c).
• Experience in Creating database in Oracle 12c using multiple PDBs.
• Configuration of Automatic Storage Management (ASM).
• Migrated single instances databases to Real Application Cluster (RAC) using RMAN, and RCONFIG.
• Implemented disaster recovery databases using data guard & configured physical standby on 10g/11g.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and from Grid Control/Cloud Control.
• Experience in switching the Physical Standby database to Snapshot Standby database and back to Physical Standby.
• Involved in configuring Exadata X2-2, X2-8 and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Installed, configured and maintained RAC databases on EXADATA.
• Having good knowledge on EXADATA (x4-2, x4-8, x5-2, x5-8).
• Expertise in applying Oracle PSU and CPU patches.
• Installed patches using opatch utility for single instances, as well as for cluster environments and upgraded databases from 9i/10g to 11gR2.
• Installed and configured Oracle Enterprise Manager Cloud Control 12c on AIX, Linux environments.
• Installed Oracle 12c Agent on Windows, AIX, Linux and Solaris environments.
• Experience in upgrading Grid Control from 11g to Cloud Control 12c.
• Implemented backup strategies using Oracle Enterprise Manager (OEM) Cloud Control 12c and Grid Control.
• Experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Created clone databases for development and test environments using RMAN Duplicate.
• Configured RMAN and registered the databases in Recovery Catalog.
• Experience in Data transfer and Refresh with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.
• Performed cross platform database migration from Sun Solaris to Linux.
• Implementation of Flashback Technology.
• Created and monitored database objects like Tables, Indexes, Views, Users and DB links.
• Implemented database security using Data Masking and Transparent Data Encryption (TDE).
• Configured Oracle Advanced Security to implement Transparent Data Encryption at tablespace, table and column levels.
• Proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections).
• Performance tuning of the database SQL Tuning, Used tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using Explain Plan for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Writing scripts in the UNIX based environments for Managing the user's roles and privileges, scheduled backups (using data-pump / cold backups), manage statistics, Disk space management.
• Experience in writing PL/SQL Stored Procedures, Functions, Packages and Triggers, various Unix Shell Scripting.
• Experience in using HP Service Manager and BMC Remedy Ticketing tools for monitoring.
• Good knowledge on Oracle support process for technical requests using Metal link and other support features.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Worked along with System and Network Administrators for minimal downtime of the Databases.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
• Supported machine critical application databases by giving 24x7 supports.

TECHNICAL SKILLS:

Database: Oracle 12c/11gR2/11gR1/10g,9i

Oracle Products: Real Application Cluster(RAC), Automatic Storage Management(ASM), Data guard, EXADATA, Import and Export, Data pumps, Recovery Manager(RMAN), TDE, Data Masking, Oracle Enterprise Manager(OEM) Cloud Control 12c and Grid Control

Operating System: Oracle Linux (OEL) 6.3, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x 5.x, Sun Solaris 9, 10 Windows XP/2003/2008, IBM-AIX 6.1.

Languages: SQL, PL/SQL, Unix shell scripting

Tools: SQL Trace and SQL tuning Advisory, SQL* plus, SQL * LOADER, ADDM, DBCA, VERITAS, Log Miner, TKPROF, Explain Plan, AWR, ASH, Toad, Putty, ERWIN, ETL tool, Net Manager

PROFESSIONAL EXPERIENCE:

Confidential, Bedford, MA

Oracle DBA

Responsibilities:

• Installed, configured and maintained Oracle 2 Node Real Application Cluster.
• Configured Transparent Application Failover (TAF) to provide Connection failover recovery capabilities.
• Migrated databases on standalone server to 2 node RAC cluster.
• Upgrade Grid Infrastructure (Cluster-ware) and databases from 11.2.0.2/11.2.0.3 to 11.2.0.4 in a 2 node RAC environment and applied GI and databases patches using OPATCH AUTO.
• Created physical standby databases for Dev and production Databases using 12c OEM and manually.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and 12c Cloud Control.
• Performed upgrade of databases from 11.2.0.2/11.2.0.3 to 11.2.0.4 and applied PSU and CPU patches required to make the ORACLE HOME up to date.
• Involved in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN by 12c Cloud Control and Grid Control.
• Created Recovery Catalog Database and register all the databases in Recovery Catalog manually and by using Cloud Control and Grid Control.
• Performed troubleshooting of failed backups by working closely with TSM/TDPO Support.
• Cloned/Restored Databases for QA and development environments from production environments using RMAN (Recovery Manager) Duplicate/Restore.
• Performed cross Platform migration of databases using export/import and data pump export/import utilities.
• Performed monthly and Quarterly Data Refresh from Production to Development and Test environments using Data Pump export/import.
• Involved in user management, Tablespace Management, Session Management, undo Management issues.
• Managed space issues in the Database Level for tablespace and Regular file system cleanup at UNIX level.
• Worked in Data Warehouse environment, involved in activities like partitioning of tables, Creating materialized views and OLTP Compression.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
• Configured Oracle Wallet for Transparent Data Encryption (TDE).
• Encrypted sensitive information like Tables, tablespaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.
• Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism, Compression.
• Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM,
• Database Replay and EXPLAIN PLAN analysis for query optimization.
• Migrated data from non-encrypted tablespaces to encrypted tablespaces.
• Enabled and disabled database vault on 11g & 12c environments.
• Used HP Service Manager (HPSM) ticketing tool for monitoring the Incidents and Service Requests.
• Provided 24*7 production supports as was always on call for maintenance activities.

Environment: Oracle 12c/11g/10g, RAC, ASM, Data Guard, OEM Cloud Control, Grid Control, AIX 6.1, Windows 2003/2008, Sun Solaris 10, Linux, RMAN, EXPDP/IMPDP, PUTTY, Xming, HP Service Manager, TSM.

Oracle DBA

Responsibilities:

• Administering and supporting Oracle database environment over 60 databases, up to 8TB utilizing advanced concepts such as Data Guard and Oracle RAC combined on all the production, development and testing environments.
• Installed, configured and maintained Oracle 2 Node Real Application Cluster.
• Configured Transparent Application Failover (TAF) to provide Connection failover recovery capabilities.
• Configured disaster recovery databases using data guard and perform switchover & failover and monitor using Data Guard manager command line.
• Worked on Active data guard and performed troubleshooting data guard environment.
• Configured Database File System (DBFS) on EXADATA.
• Migrated NON-ASM databases to ASM on EXADATA.
• Involved in moving databases in EXADATA RAC environment.
• Worked on databases on EXADATA various compression methodologies including OLTP compression, HCC, EXADATA Query specific.
• Involved in configuring Exadata X2-2, X2-8 and have a good knowledge on smart flash cache, storage index, storage management and migration.
• Involved in upgrade of databases from 10g to 11g and applied PSU and CPU patches whenever required to make the database software up to date.
• Upgraded development and production databases from 10g to 11g on Linux.
• Providing Application Support for performance and database related issues.
• Involved in building Databases for BI (Business Intelligence) Applications.
• Worked on storage Indexes and tested their behavior with different query predicate conditions.
• Performed cross platform migration of databases on Solaris 10g to Linux 11g.
• Extensively used data pump for migrating data between platforms.
• Installed and Implemented Backup & Recovery procedures.
• Implemented Hot, Cold and Logical backup plans.
• Implementation of Flashback Technology and cloned databases for development and test environments using Recovery Manager (RMAN).
• Involved in scheduling incremental, cumulative and full backups and configured retention policy.
• Worked in Data Warehouse environment, involved in activities like partitioning of tables, Creating materialized views and OLTP Compression.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
• Used 10046 Trace for tracing client connections, SQL statements and bind variables.
• Implemented database security using Transparent Data Encryption (TDE).
• Configured Oracle Wallet for Transparent Data Encryption (TDE).
• Encrypted sensitive information like Tables, tablespaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.
• Performed Explain Plan analysis for Query Optimization and SQL tuning.
• Performed Database and SQL tuning by using various Tools like AWR, ADDR, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.
• Involved in managing end-end lifecycle of user identities across the enterprise resources using Oracle IDM (Identity Management).
• Effective 24/7 Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 11gR2, Solaris/Linux, SQL, OEM, RAC, ASM, Data guard 10g/11g, EXADATA (x2-2, x2-8), RMAN, Explain Plan, AWR, ADDM, ASH, TTS, Flashback, Data pumps, Shell Scripting, putty, ETL, ERWIN.

Oracle DBA

Responsibilities:

• Install Oracle DB 10g,11g RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support and performance tuning etc.
• Created and maintained various databases for Production, Development and Testing using Oracle 9i, 10g, 11g.
• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments.
• Oracle Grid Control 11g Installation and Configuration.
• Applied necessary Patches during installation.
• Handy in utilizing data pump tool for exporting and importing the data.
• Upgraded Analytical Databases from 10g to 11g.
• Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases.
• Involved in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases.
• Performance tuning of queries consuming Excessive Resources or slow running queries by Providing Required Hints to the Query.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Understood the concepts of AMS (Archival Management System) and implemented successfully in production environment to archive historical data.
• Well Experienced in taking Cold Backup for a very Huge 64-Tb Database.
• Involved in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import.
• Involved in user management, Tablespace Management, Session Management, undo Management issues.
• Managed space issues in the Database Level for table space and Regular file system cleanup at UNIX level.
• Performed troubleshooting of failed backups by working closely with TSM and Net backup Support.
• Involved in Installing OEM agent and hooking up to the grid.
• Configuring Heterogeneous Gateways in the OEM grid for monitoring the Listeners present in the oracle environment.
• Worked with peregrine ticketing tools for resolving the tickets.

Environment: Linux, Solaris 10, Oracle 9i,10g,11g, OEM, SQL*Plus, Xming, Putty, Shell Scripting, ASM, Data Guard, Peregrine, Enterprise change Management Systems(ECMS), TSM, VERITAS.

Oracle DBA

Responsibilities:

• Responsible for setup and implementation of 2 NODE RAC on 10g.
• Added a new node for 2 Node RAC for minimizing the downtime, maximizing availability and also achieved load balancing by minimizing the interconnect traffic.
• Used CRSCTL and SRVCTL commands for the stop / start Cluster operations.
• Worked on database Sizes of more than 3TB.
• Responsible for capacity planning, database security, recovery planning and installing patches.
• Involved in up gradation of databases from 10.2.0.2 to 10.2.0.4 on Sun Solaris.
• Installed 10.2.0.4 agent and involved in registering of databases in OEM.
• Installed standalone servers on ASM and migrated databases to ASM.
• Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's.
• Implemented Disaster Recovery Plan for critical databases using DATAGUARD.
• Worked on physical and snapshot standby databases in Data-guard environment.
• Involved in construction of Disaster Recovery (DR) for all the production databases using DATAGUARD.
• Configured pfile, Listener and Net service names manually for production and physical standby databases in Data-guard.
• Performed Database Refresh from production to testing and development environment and used EXPDP for schema level.
• Worked closely with PL/SQL developers for fine performance tuning and Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Scheduled database backup jobs using Crontab.
• Created a Clone database using RMAN on remote server.
• Worked with VERITAS net backup team.
• Involved in database design and used Erwin as a Data Modeling tool & Designing the ETL processes.
• Involvement in space management, rectification of lock problems, managed quotas.
• Monitored Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo-logs, Archived Redo-logs and Alerts.
• Worked extensively on performance tuning of queries by maintaining Aggregates, Compression, partition, indexing and use of statistics.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Created and monitored database objects like Tables, Indexes, Views, Users and DB links. .
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 11g/10g, RAC, ASM, Data Guard, Grid Control, RMAN, TOAD, EXPDP/IMPDP, ETL, Windows 2003, AIX, Sun Solaris.

Jr.Oracle DBA

Responsibilities:

• Installed and configured Oracle 9i, 10g on HP UNIX and Linux .
• Created logical and physical standby databases using Data-guard and converting physical standby to snapshot for testing purposes.
• Performed HOT/COLD backups using RMAN and Logical backups using data-pump .
• Configured Recovery Manager (RMAN) and performed Hot and Cold backups for production databases using RMAN.
• Performed block recovery and data file recovery using RMAN.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
• Involved in taking logical backup using Data pump and Exports/Imports Utility.
• Involved in checking the status of listener and restarting listener.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.

Environment: PL/SQL, Oracle 9i, 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 7, RMAN, DATA PUMPS.