PROFESSIONAL SUMMARY:

• About 8+ years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading teh databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 24*7 production database support with Support to developers & end-users.
• Installed Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.
• Expert in implementing ORACLE STREAMS and Gloden Gate 11x (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, Tuning heavy data loads, Monitoring and Performance tuning.
• Having knowledge on teh ORACLE EXADATA for teh extreme performance of teh database.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user Table space across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to teh databases.
• TEMPEffective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning teh tables and Indexes.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams,Gloden Gate)

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP

LANGUAGES: SQL, PL/SQL, T-SQL, C, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr.DBA

Environment: Red Hat Linux 5.0, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, ASM,, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Responsibilities:

• Installed Oracle 11g/12.1.0.2 and RAC (4-node) systems on Linux 6.5
• Upgraded database from 11.2.0.4 to 12.1.0.2 on Linux 6.7.
• Installed and configure teh Gloden gate in directional replication, performed teh resync activities whenever teh systems were out of sync.
• Worked on storage migration with EMC SAN team.
• Experience in Managing Applications on oracle 11g / 10g RAC databases using ASM.
• Involved in Implementation of Oracle 11g Active Data guard.
• Responsible for finding performance problems in production databases by identifying issues using AWR, ASH and ADDM reports.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Upgraded Oracle 10g databases to Oracle 11.2.0.4.
• Applied PSU & CPU patches for teh oracle enterprise database servers.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Installation and configuration of Oracle Grid Control and installing OEM agents on all teh database server hosts.
• Provided support on performance issues during project development resulting in improved response times and reduced contention.
• Monitoring teh operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
• Used Stored Outlines, SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose performance issues.
• Database recovering using Veritas Netbackup and RMAN.
• Monitoring production databases through Oracle Enterprise Manager(12c) to troubleshoot and diagnose database problems.
• Cloning databases for development/testing environments using RMAN.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, incremental backups and troubleshooting ORA errors for backup issues.
• Scheduled various maintenance jobs using DBMS SCHEDULER.
• Loading data using SQL Loader and Data Pump utilities.
• Good experience in schema management, objects & Partitioning of tables & indexes.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Monitoring table space usage and adding space, adding disks to ASM disk groups and performing ASM disk group rebalance when required.
• Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.
• Apply database schema changes in Production, Development, UAT & SIT Environments.
• Worked as a primary for weekly and monthly releases and coordinated with application teams and development teams in release window times.

Confidential, TN

Sr. Oracle DBA

Environment: Red Hat Linux 5.0, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, ASM,, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on IBM-AIX nodes.
• Worked as a part of team in Data Center Migration project for 6 months.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
• 24x7 remote support and on call Database support for Database developers & end-users.
• Experienced in implementing Oracle Database advanced security practices.
• Implemented Streams replication between RAC and non RAC database environments.
• Successfully configured and installed Oracle Gloden Gate for replication.
• Worked with application team to resolve conflict handlers and troubleshoot teh replication issues.
• Experience in cloning RAC databases using RMAN tool.
• Experienced in Design, implementation and generating documentation of Oracle 11g Data Guard on both physical/logical standby databases in high availability mode.
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11gRAC environment for teh Production databases.
• Writing and modifying UNIX shell scripts manage Oracle environments and for Backend Oracle Processes.
• Installed Oracle Streams as an enhancement for teh Client’s DW method and monitored Streams Issues using Grid Control.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor teh 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 teh same.
• Performance tuning and diagnosing DBMS and individual Production databases. Organized various migration review meetings with teh application team to discuss teh migration strategy based on their requirements.
• Performed policies on data confidentiality, integrity, availability, and audit ability, Based on Access Controls for Access to Data at teh database level.
• 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 teh nightly RMAN backups for teh 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 teh database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Autantication.
• Applying security patches both Server side and Client side and Performed testing.
• Worked closely with teh Oracle developers for teh better performance in Applications in writing teh Packages, Triggers, Mat Views and Indexes on teh tables.
• Used Secure SCP & FTP extensively for teh File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.
• Resolved TAR issues 24x7 while assisting teh functional team and oracle support (Metalink) and managing database security.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Confidential

Sr. DBA

Environment: Red Hat Linux4, Oracle 9.2.0.8/10.2.0.3, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, ToadV9.7 & SQL, Navigator V6.1.

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problemrecognition and resolution of database issues.
• Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes10g.
• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating teh database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Implemented backup strategies using hot/cold, exp/imp used on teh business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery using RMAN.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performed conversion single instance to Real Application Cluster (RAC) database instances.
• Utilized Oracle Streams to capture, propagate, and apply teh transfer of data, transactions, and events within managed databases.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting teh Very Large Databases by export / import, cloning those using RMAN duplicate features and tan upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Autantication and Risk management.
• Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
• Resolved TAR issues 24x7 while assisting teh functional team and oracle support.

Confidential

DBA

Environment:Oracle database 10g (10.1.0.5 to 10.2.0.4), 9i (9.2.0.8), Redhat4, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problemrecognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Oracle Grid Control Management Server Installation.
• Used transportable tablespaces (TTS) to move teh data Oracle on a different platform and also much faster than performing either an export/import or unload/load of teh same data.
• Implementation of 10g Data Guard and Bi-directional streams implementation.
• Handling large database environments using Oracle Enterprise Manager (OEM) on daily basis observing teh performance of teh production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Made performance improvements to teh database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for teh same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Autantication and Risk management.
• Performed application migrations to non-cluster databases to cluster databases.
• Devised & Implemented backup strategies using hot, cold, and exports based on teh business requirements.
• Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.