EXPERIENCE SUMMARY:

• About 8 Years of experience in IT industry as a Developer and Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security and performing upgrades of Oracle RDBMS environments on various platforms LINUX, AIX, UNIX, SUN SOLARIS.
• Extensive knowledge on database administration of Oracle 9i, 10g, 11g, 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• 24 7 production database support with Support to developers end-users.
• Excellent experience in installation, setup and configuration of Oracle 9i, 10g and 11g on Windows, RHEL platforms.
• Expertise in building RAC environments on RHEL/OEL platforms using ASM block level storage and Extensive hands on experience on building 11gr2 RAC databases.
• Knowledge of Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers. Worked on Oracle Exadata X2-2 servers
• Expert in converting single instance databases to RAC using RCONFIG, MANUAL CONVERSION and RMAN.
• Expertise in Installation, maintenance and tuning of RAC Applications.
• Installed oracle GOLDENGATE version 11.2.0.1.6 two-way replication on Oracle database 11.2.0.3.
• Extensive knowledge on creating physical standby databases using Active dataguard and syncing the databases using DGMGRL.
• Expertise in upgrading the Oracle databases from Oracle 10g to Oracle 11g.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Implemented RMAN backup Full, incremental and cumulative and recovery, Incomplete recovery and disaster recovery using Data Guard
• Experience with Real Application Testing RAT . Utilized Oracle Real Application Testing for migrations and workloads
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Data loading using SQL LOADER, Logical backups using full export and DATAPUMP.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Worked on Developing PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network SAN and Oracle ZFS storage.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Good Interpersonal communication skills and Documentation Skills.
• Experience as On-Call 24x7 production DBA support.

SKILLS PROFILE:

• Databases Skills: Oracle 9i/10g/11gR2/12c, SQL Server 2005, Backup planning and Implementation, Performance Monitoring, Analysis and Tuning, Install, Patch and Upgrade, Disaster Recovery planning and implementation, Partitioning, Replication.
• Database Advance Feature: RAC, Data Guard, ASM, Standby Database, Oracle Golden Gate, Advanced Replication/ Materialized View, Grid Control, TOAD, SQL Developer, logminer, Cron tab
• Oracle Utility: RMAN, RCONFIG, 12cOEM, Export/Import, DataPump, SQL Loader, DGMGRL, ASMCMD, OID.
• Performance Tuning: Grid control, AWR, ADDM, ASH report, SQL performance analyzer SPA , SQL Optimizer, STATSPACK, DB Artisan and OS Watcher.
• Languages: C, C , UNIX shell scripts, PL/SQL, perl
• Project Management Tools: Project Scheduling Microsoft Project , Microsoft Office Suite 2013, Minitab, Proplanner, SPC, FMEA, Design Of Experiments, Six Sigma, Lean Manufacturing, Quality Analysis.

Professional Experience

Confidential

Role: Sr. Oracle Database Administrator

• Installed and configured 12.1.0.1 oracle database software on LINUX 6.4 using silent installation.
• Setting up Enterprise wide RAC implementation strategies for client.
• Installed 27 Real Application Clusters on Linux platforms for System-test, Development and Production Servers.
• Created development, testing, staging, production, RAC and standby databases for OLTP systems.
• Migrated NON RAC databases to RAC databases using RCONFIG and manually.
• Used RACCHECK utility to monitor health of clusters, created services and troubleshooting issues in RAC.
• Applied patches in rolling passion on RAC upgraded and maintained and troubleshooting clusterware components in RAC environment.
• Installed GoldenGate on 11.2.0.3 on Amazon Web Server and implemented Two-directional replication.
• Setup active-active replication between two availability zones and Hooked up Golden Gate monitoring to central EM.
• Troubleshooting and resolved issues in GoldenGate environment.
• Installed and setup Oracle 12.1.0.1 Enterprise Manager for cloud on AWS.
• Hooked up all CDBs/PDBs and other AWS instances that reports status to Enterprise Manager.
• Performed monitoring of databases using OEM 12C. Generated AWR, ADDM, ASH and taken Backups using OEM.
• Responsible for performance tuning and identifying system bottlenecks / blocking and resolving in a timely manner.
• Configuring Database to schedule Database monitoring scripts.
• Supported development teams by providing SQL statement tuning and removing load and Query performance bottlenecks by using tools Explain Plan, AWR, ADDM, ASH, Statspack and TKPROF.
• Created Import/Export scripts for migrating data and data refresh activity.
• Created scripts for taking backups and exporting dumpfiles to EC2 Storage which is on Amazon Web Service AWS .
• Setup Oracle wallet keystore on an AWS instance and enabled schema encryption using Oracle Advanced Security.
• Identified data auditing requirements, implemented audit policies at column level. Also created mechanism to easily access audit data.
• Separated data schema from application logic schema.
• Created service accounts for application use, utility schema for logging, exception handling and audits, standard template for Packages and Stored Procedures with Change Log in header.
• Created Data Access Security policy, user accounts, user profiles and assigned roles, permissions.
• Created and set up VPD policy virtual private database for roles defined in business requirements
• Created generic logging utility. Enforced logging utility is used in all PL/SQL development.
• Created a utPL/SQL environment and a guideline document on how Unit Tests will be done in PL/SQL development.
• Static code analysis and code coverage. Identified applicable rules for static analysis and customize stored rules.
• Made static code reports analysis publish as part of continuous build.
• Hooked up PL/SQL compilation and code coverage reports as part of Continuous Integration.

Environment: Oracle Database 12c, Oracle GoldenGate 11i, Oracle RAC 11g, LINUX 6.4, RHEL 6.2, Toad 12.1, Oracle Enterprise Manager 12.1.0.1, Oracle Database Import/Export utility, Oracle Support, RACCHECK, AWR, STATSPACK, ASH, ADDM, JIRA Code Integration, Ticketing tool .

Confidential

Role: Sr. Oracle Database Administrator

Role Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.3 on 3 node RAC environment.
• Database Refresh from one version to another version.
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguard Exadata clusters for maximum availability.
• Disaster recovery of Exadata Dataguard Physical Standby.
• Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of data file testing.
• Use of RMAN for backup operations with Exadata.
• Worked on X3-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
• Scheduling the backups for the database using EM 12C cloud control.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented Data guard, creating physical standby databases in 10g and 11g RAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the Bi-directional replication.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN Recovery Manager backups.
• Used cross platform transportable table space TTS to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster RAC database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Daily Health Check Up of the Database using AWR, ADDM.
• Perform Daily Monitoring of Oracle Instances, monitor users, and tablespaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Created Users with Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Configured and Implemented Cold/Hot Backups.
• Also configured database cloning using RMAN.
• Efficient in using the Oracle Tools like OEM, SQL Plus, SQL Loader, TOAD TKPROF, LOGMINER, STATSPACK, SQL Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Experience with UNIX and SQL commands.
• Managing databases on multiple servers.

Environment: Oracle 10g, 11g, Linux 4/5, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Exadata X3-2, Data guard, SQL LOADER, Toad, Oracle Enterprise Manager AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential

Role: Sr. Oracle Database Administrator

Role Responsibilities:

• Worked on Oracle Real Application Cluster on 10g/11g, implemented high availability successfully in the environment using RAC and data guard.
• Defined guidelines and standards for Oracle installations and implementations by preparing documentations.
• Implemented 11g Data guard setup, maintenance and monitoring for production databases.
• Worked on data-guard 10g/11g troubleshooting issues in DG environment.
• Have hands on experience in implementing 11g new features in environment, i.e. Active Dataguard.
• configured pfile, LISTENER and Net Service Names manually for production and physical standby databases in dataguard environment.
• Configured dataguard broker between primary and standby database to perform switchover/Failover via DGMGRL.
• Worked on software upgrades and patches, upgraded databases from 10g to 11g.
• Applied PSU and CPU patches on 10g/11g whenever they are required.
• Installed Standalone servers on ASM, created disk groups using ASMCA, created databases on ASM, Maintained databases servers on ASM.
• Migrated databases from NON ASM to ASM, resolved issues in ASM environment Monitoring databases using Oracle Enterprise manager OEM 10g/11g.
• Worked on Oracle Grid Control project: Install, configure, OMS, Agents and repository database, Massive deploy and configure Grid Agents, Troubleshoot all levels of Grid issues.
• Worked with developers to manage, track and maintain urgent/critical incidents Monitoring of Oracle servers including capacity and space management.
• Implemented and managed RMAN integration with business continuity volumes in large storage environment.
• Initiate and implement RMAN/UNIX Shell backup, recovery cloning solutions.
• Worked on Performance tuning involving Memory, and SQL tuning and Tuned OLTP and DSS type queries, explain plans for developers, and reorganized tables and indexes.
• Support large Data Warehouse environment, troubleshoot ETL loading hang/locking/transient problem, performance tuning, query optimization, application server related issue.
• Used TKPROF to analyze the trace files for ORA-00060 Errors and helped application to redesign to avoid database problems.
• Generated AWR Reports, ADDM, ASH reports and also created SQL tuning sets to troubleshoot performance issues in environment.
• Created and assist developers and users by creating objects. Manages users accounts and database security.
• scheduling jobs through crontab, Oracle job scheduler.
• 24x7 production database administration, support and monitoring to ensure pro-active problem recognition and resolved database issues.

Environment: Oracle 10g/11g, Oracle RAC 10G/11G, DATAGUARD 10G/11G, Oracle Enterprise Manager 10G/11G, Oracle Database Import/Export utility, Oracle Support, TKPROF, AWR, STATSPACK, ASH, ADDM

Confidential

Role: Oracle Database Administrator

Role Responsibilities:

• Installed, configured and supported Oracle RAC on 10g/11g.
• Implemented dataguard Standby for high availability/disaster recovery purpose and maintained Standby Database minimizing downtime during database crash.
• Implemented Switch over and Fail over between Prod and Disaster Recovery Sites during Dry run for the Business justification.
• Implemented the secure backup of the data using RMAN and Export / Import utility.
• Oracle Database Refresh/Cloning/Duplication performed from Production to Test and Development databases using Full Online Backups of Target database.
• Implemented Export/Import to migrate Schemas from Source to Target environments.
• Construction of Catalog databases and developed scripts to perform Backups of Large Databases to fit the backup window using RMAN.
• Configured Channels, Parallelism, Optimization and performed backups using RMAN utility.
• Worked with Partition Tables. Partitioned Tables and sub-partitions as per the requirement of the Applications to improve performance and data management.
• Created and managing OEM , troubleshoot the grid environment.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK.
• Compared Object Count from Source with the Target System and compared AWR reports to resolve Performance issues.
• Tuning of SQL statements, SGA etc., taking periodical snapshots, interpreting STATSPACK reports to check the DB performance.
• Implemented Security at database level, user level and the data level using Auditing and Protegrity.
• Managing of Tablespace for different users by granting quota on Tablespaces.

Environment: Oracle 10g, Oracle 11G,Linux 4.0, Oracle GRID, Oracle RAC, Toad, Sql Server 2005 , Mysql ,Oracle RAC, Standby databases

Confidential

Role : Oracle Database Administrator

Roles and Responsibilities:

• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Management of tablespaces for different users by granting quota on Default Temporary tablespaces.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity planning.
• Created UNIX shell scripts to automate batch jobs through CRON.
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication using materialized views.
• Utilized SQL loader and exp/imp to load data into tables.
• Database Administration and Planning including logical design, physical design, backup recovery.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.

Environment: Oracle 10g, RHEL 5.2, RDBMS, SQL, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential

Role : Oracle Database Administrator

Role Responsibilities

• Database software install, configure, maintain, and troubleshoot Oracle on UNIX and Windows and database creation.
• Respond to availability e.g., DB up/down events and capacity e.g., table/database free space events.
• Support application support/ development teams.
• Identification of patches, apply one off and quarterly critical patches.
• Database sizing and memory management.
• Provides troubleshooting support for potential data issues.
• Refresh database using logical and physical backups.
• Backup and recovery using RMAN.
• Database and Application tuning and performance monitoring.
• Experience with Oracle 10g Installation, Administration, Monitoring, Maintenance, Database Backup and Recovery.
• Creation of standalone Database. Installation and configuration of Oracle client servers.
• Monitoring and dropping database Users, Roles, Privileges and Profiles.
• Oracle network administration by configuring tnsnames.ora, listener.ora.
• Managing Backups- Hot, Cold, RMAN Utility.
• Alert Monitoring/ Error Resolution Regular monitoring of Alert log files.
• Worked in a Team supporting 24/7 production environments.
• Creating and maintaining the change record for the changes that were being made on the Production databases and Light Weight Document Management System.

Environment: Oracle 9i, 10g AIX 5.3, Sun Solaris, Red Hat Linux, Putty, TOAD, RMAN, Export/Import and Data pump