Professional Summary:

Certified Oracle Database Administrator with over 7 years of experience, Technical strengths include experience in the area of Oracle database administration involving in production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, replication, space management, database security, cloning, migration, shell scripting.

Technical Skills Summary:

• Hands on experience on working with Oracle 9i, 10g R1,R2 11g R1,R2 on multiple platforms like IBM AIX, Windows, UNIX/Linux, Sun Solaris and HP-UX in various domains like Financial, Health Care and Telecom.
• Experienced in setting up a Grid Infrastructure, Installing and configuring Real Application Clusters on Oracle 10gR2, 11gR2 with ASM and NON-ASM.
• Hands on experience in upgrading from 5 node RAC cluster non-ASM Oracle 10.2.0.4 to Oracle 11.2.0.3 ASM.
• Hands on experience in upgrading database from 11.2.0.1 to 11.2.0.3 on RAC environment.
• Applied CPU/PSU and interim patches on Grid infrastructure, rdbms, clusterware on 10.2.0.4, 10.2.0.5, 11.2.0.2, 11.2.0.3 for RAC and standalone environments.
• Experienced with very large scale Database environment and mission critical large OLTP and OLAP systems.
• Hands on Experienced on managing very large database VLDB in Production, Development and Testing Environment.
• Hands on experience in working with three way replication using Shareplex 7.0, 7.6, 8.0.
• Upgraded shareplex from 7.0 to 7.6 in complex three way replication environment.
• Hands on experience in working with in setting up a uni-directional replication using Oracle Goldengate v11.1.1.1.0 and v11.2.1.0.1.
• Experience in setting up a Physical Standby dataguard and Active physical standy dataguard.
• Hands on experience in building RMAN virtual catalog database and manages recovery catalog for 35 production databases.
• Hands on Experience in configuring RMAN and managing the Backup and Recovery of databases using RMAN.
• Hands on experience on Oracle grid control oracle 11g and 12c.
• Experience in Migration of database from non ASM to ASM.
• Experience in writing scripts proactive monitoring like monitoring the disk usage and the memory usage of the server and monitoring Tablespace.
• Worked with oracle support to resolve the ongoing issues. Worked closely with oracle support on pro active SR and successfully resolve the issues.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Experience in tuning a database at SQL level using utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ASH, ADDM
• Tuning of SGA components like buffer cache, shared pool to avoid paging swapping.
• Collected the stats periodically to optimize the SQL queries.
• Strong Knowledge and experience of Creating Users, Public Synonyms, Database Links, roles, profiles, privileges and assigning roles to users.
• Experience in Capacity Planning, Storage Allocation and Space Monitoring Management.
• Month end activities and database capacity planning and space management.
• Developing complex shell scripts for backup, rotating logs/files, etc.
• Experience in writing a automated scripts using Crontab for Archiving old records and Backups
• Hands on Experience on Automated jobs using different technologies like Oracle Scheduler, Autosys Jobs, Crontab
• Experience in Extracting, Transforming and Loading data from various Flat Files using SQL loader utility.
• Experience in working with Oracle's Transportable Tablespace TTS .
• Hands on experience in supporting multiple production databases running 24 x 7 mission-critical / OLTP applications demanding high availability and increased performance.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies, Strong interpersonal and communication skills

Technical Skills:

Confidential

Oracle DBA

Environment: Oracle 10g and 11gR1/R2, Grid Control 11g/12c, Enterprise Manager, RMAN, RAC, DataGuard, ASM, Goldengate, Shareplex, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL Plus, PL/SQL, SQL Loader, Oracle Solaris 10, AIX 5.2/5.3, Red Hat Linux 5.0/6.0 and TOAD 10.0/11.0,

Responsibilities:

• Experience in supporting a critical production environments with RAC, Standalone, ASM or NON-ASM environments.
• Successfully upgraded 5 nodes RAC cluster from 10.2.0.4 non-ASM to 11.2.0.3 ASM.
• Upgraded standalone database from 11.2.0.2 to 11.2.0.3.
• Installation, configuration, maintenance and tuning on Oracle11g and 10g on Solaris, IBM-AIX 5.3 and RHEL 5/6.
• Installed and configure more than 10 rac cluster on 11.2.0.3 with ASM, non-ASM.
• Installed and configure one node Oracle 11.2.0.3 rac cluster database with ASM on RHEL 6.
• Involved in upgrading 10.2.0.4 to 11.2.0.3.
• Installed and setup a three way replication using shareplex 7.6 on oracle 11.2.0.3. worked on complex replication environment.
• Experience in creating, configuring and maintaining DataGuard using Physical Standby and Active dataguard physical standby on 11gR2
• Successfully upgraded Oracle RAC 10g 10.2.0.4 to Oracle 11g 11.2.0.2 on Solaris
• Worked on multi way replication supported a VLDB database's with a maximum size of 50 terabyte.
• Configure RMAN backup for database for ASM, non-ASM environments. Worked with IBM trivoli team to configure table backup.
• Create and manage RMAN VIRTUAL CATALOG database which is currently running a central repository for all production environments.
• Applied CPU/PSU and interim patches on Grid infrastructure, rdbms, clusterware on 10.2.0.5, 10.2.0.5, 11.2.0.2, 11.2.0.3 for RAC and standalone environments.
• SQL tuning and Database performance tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ASH, ADDM, SQLT and monitored the database performance on a daily basis.
• Planning Backup/Restoration/Validation Strategy, taking Backups with RMAN as well as DataPump exp/imp .
• Created Managed Database Structures, Storage Allocations, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and automatic session history.
• Configure gather statistics and copy stats jobs on production environment.
• Configure monitoring jobs like Long running sql/active session count/inactive session count/full table scan/missing or unusable index/invalid object/partition not available.
• Worked closely Datawarehouse teams and automate the feed as per the application requirement.
• Experience in using packages like DBMS SCHEDULER to schedule tasks Involved in developing UNIX shell scripts to automate and scheduled the database backup jobs.
• Involved in code optimization for better performance in production environment.
• Worked on Oracle partitioning. Created and managed the partitioned tables.
• Used partitioning to break very large table and its associated indexes into smaller pieces so that each pieces either a table or an index together make up a larger object.
• Expertise in recovering databases. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiles and Privileges.
• Used various methods like SCP, SFTP, FTP and PSFTP from windows to transfer files from legacy server to DCC servers.
• Provided troubleshooting and problem solving support to application developers.
• Regular analysis of alert log for error tracing and used ticketing tools like Remedy

Confidential

Oracle DBA

Environment: Oracle 10g and 11g, TOAD 9.0, Oracle Grid Control, Oracle Enterprise Manager, RMAN, RAC, DataGuard, ASM, SCP/SFTP, Shareplex, Erwin 4.0, TKPROF, Explain plan, AWR, ADDM, SQL Plus, PL/SQL, SQL Loader, T-SQL, SQL Server 2005, Bugzilla, Visual Source Safe, AIX 5.2/5.3 and Red Hat Linux 5.0

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
• Successfully upgraded Oracle 10gR2 to Oracle 11gR1on IBM-AIX platform.
• Involved in Installation and configuration of Oracle 10g 4 node RAC cluster.
• Successfully Migrated Non RAC single instance to Real Application Cluster RAC database instances.
• 24x7 remote support and on call Database support for Database developers end-users.
• Experienced in the installation of Oracle Grid Control in Server OMS Oracle management Server and installing the Agents in all the production, test and development databases and configuring them.
• Experienced in implementation and configuring physical standby dataguard on Oracle 10gR2.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• Developed SQL PLUS PL/SQL scripts for Extraction, Transporting Transforming ETL data from Production databases to Data Warehouse Databases.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• Creating Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performance tuning and diagnosing DBMS and individual Production databases.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and automatic session history.
• Logical and Physical Database Modeling using CA Erwin 4.1.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Cloning Duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Implemented VERITAS Net Backup using RMAN Recovery Manager as a media management layer.
• Worked with Oracle developers in writing the Packages, Triggers, Materialized Views and Indexes on the tables.
• Used Secure SCP FTP extensively for the File transfers from machines to remote server.
• Implementation of Oracle Application Software Patches and maintaining SW License and maintenance agreements.

Confidential

Oracle DBA

Environment: ORACLE 8i, 9i, SQL, PL/SQL, SQL Loader, RMAN, Toad, Erwin, UNIX AIX 5.1, Windows 2000, UNIX Shell Scripting, export/import utilities.

Responsibilities:

• Installed and configured Oracle RDBMS on Linux and Windows environments.
• Responsible for administering, supporting production and development of Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Responsible for setting and managing user accounts and granting required privileges to users.
• Loaded data from flat file to Oracle database using SQL Loader. Created indexes on tables for performance tuning. Performance monitoring, tuning and space management in database with Grid control. Performed Troubleshooting and system maintenance.
• Involved in user creation and user access control. Involved in Schema creation and management. And Developed stored procedures, stand alone functions and PL/SQL packages to comply with the requirements.
• In depth knowledge of setting up RMAN backups and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.
• Develop, implement and test Backup and recovery strategies for development databases.
• Performed Database Reorganization to remove row migrations and fragmentation using exp/imp utilities.
• Maintained the RMAN repository and customized recovery catalog and also Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.
• Managing the features like Undo Management, locally managed table spaces and auto segment space management.
• Migration of database from Oracle 8i to Oracle 9i.
• Regular monitoring of trace files log files.
• Working with SQL Loader, for loading the test data during the integration testing
• Monitoring hit ratio of SGA components
• Maintaining regular backups.
• Communicating with Oracle Technical Support
• Refreshing the Production over the Development and UAT and also keeping the Test Instances in sync with other instances.