PROFESSIONAL SUMMARY:

• Over 8+ years of experience as Oracle DBA, providing 24/7 support of development and production 12c/11g/10g/9i/8i databases on UNIX/LINUX and Windows environments.
• Expert in Cloning of databases from RAC to RAC and RAC to non - RAC.
• Experience in Automatic Storage Management (ASM) in 10g & 11g.
• Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
• Experience in Data Guard and Grid Infrastructure 11GR2
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution, Defrag etc. scenarios for the various Environments.
• Experience working in RAC environments. Worked on 2 nodes and 6 nodes Oracle RAC and ASM
• Experience in using OEM, TOAD, and Data Migrations using export/import, ATG, benchmarking using Load testing tools.
• Database Upgrading from one server to another using Export and Import utility.
• Worked on Oracle Real Application Testing (RAT) with Oracle Database 11g Enterprise Edition.
• Worked extensively with Oracle RDBMS; Comfortable with SQL, PL/SQL, and good knowledge on various database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Installed and Configured Oracle Enterprise Manager 12c.
• Worked on Oracle Applications Cloning and Oracle Database Refreshes
• Knowledge on high availability technology and clustering 10g and 11g RAC.
• Knowledge on Oracle Business Intelligence 11g.
• Strong database Administrative skills and having working experience on oracle RDBMS 9i, 10g and 11g.
• Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV’S, SRDF, and managing of partitions and clustering of tables.
• Excellent shell scripting, batch programming. Automated several routine DBA tasks and schedule jobs in cron.
• Proficient in DBA tools like - SQL Developer, Toad, OEM 11g & 12c.
• Excellent analytical, problem-solving and learning skills and ability to quickly embrace and understand new technologies as well as a keen interest in the emerging technologies.
• Worked on Simpana CommVault backup tool.
• Strong communication, motivational and presentation skills.
• Ability to multi-task and work independently.
• Highly motivated, results-oriented, self-driven IT professional; Good team player
• Administration and troubleshooting of RAC instance startups and instance evictions
• Expertise in planning, scheduling and managing Oracle RMAN based backup & recovery strategy.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR support Cloning, Backup and Recovery, Performance Tuning, Data Sharing and Disk Partitioning, capacity planning, script development, and documentation.
• Supporting Applications and ensuring their high availability, via SQL Performance Tuning to correct the performance issues in production databases.
• Experience in Data Compression, table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM
• Experience in Implementing Golden Gate, Streams, Data Pump, Export and Import utilities, SQL*Loader, Log miner tools.
• Experience in Data Compression, Table Compression, OLAP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Engineering of the existing databases and provide both a Physical and Logical/Physical data model to maintain an existing Database.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g/11g/12c RAC environment.
• Installation, configuration, upgrade and performance tuning of Oracle RAC.
• Experience in configuring oracle data guard and streams.
• Experience in applying oracle database patches using opatch utility

TECHNICAL SKILLS:

Operating Systems: Red Hat Enterprise Linux 4.5 & 5, UNIX, Sun Solaris 5.6/5.8/5.9/10, Windows NT, Windows 95, 98, Windows Server2003, Windows 7,HP-UX 11i, AIX 4.33, 5L.

Databases: Oracle 8i/9i/10g/11g/12c, RAC, SQL server

Database Skill sets: RAC, OEM 11g/12c, Toad, RMAN, Database performance tuning, troubleshooting, Oracle Apps / DB Security, Patching, Cloning, Migrations, configuration, tkprof, statspack, PL/SQL, SQL, Shell Scripts.

Programming: Unix Shell Scripting, Perl, Korn, JavaScript, SQL, Pl/SQL, HTML

Protocols: TCP/IP, HTTP, LDAP.

Other applications: Oracle E-Business R12, 11i, OBIEE 10g, Oracle GTM7.

Tools: Oracle Performance Pack OEM, TOAD, TKPROF, Explain plan, Statspack, Goldengate

PROFESSIONAL EXPERIENCE:

Confidential, Mentor, OH

Senior Oracle DBA

Environment: RHEL RedHat Linux, Sun Solaris, Oracle 12c/11g/10g, RAC, ASM, Dataguard, Streams, Golden gate, RMAN Duplication, SQL, PL/SQL, UNIX Scripting, OEM Grid Control, Ignite, Toad, Sql Developer, Datapump, Putty

Responsibilities:

• Performed Code migrations and Data fixes.
• Worked on SEV-1 SRS with Oracle Support.
• Involved in DR and HA activities.
• Upgrade/Migrated the production and development databases from 10g to 11g.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing
• Migrating databases from IBM mainframe based zLINUX servers to Oracle LINUX servers.
• Maintenance of materialized views as part of business requirements and refreshing using different refresh methods such as FAST, COMPLETE, FORCE.
• 24*7 On-Call Production Technical support and Hardware Support.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Responsible for upgrading Oracle 10g RAC to 11g RAC
• Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.
• Performed Online Table Redefinition
• Applied RDBMS and Interoperation patches for upgrading the database from 10g to 11g.
• Generating AWR reports to analyze the database performance
• JVM tuning in Oracle Applications
• Successfully implemented Backup and Recovery using RMAN, which includes hot backups and Cold backups to tape, drives, and disks.
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Experience in configuring and maintaining large volume OLAP & OLTP Databases with high volume of transactions.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring
• Implemented 11gR2 Data Guard using RMAN duplicate.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managed Oracle Grid control 11.1.0.1 and configured Data Guard for OMR in Linux environment
• Performed Oracle database upgrade from 11gR1 to 11gR2 in Linux RAC environment
• Extensively used AWR, ADDM for database performance statistics.

Confidential, Monroe, LA.

Senior Oracle DBA

Environment: RHEL HP-UX, IBM-AIX, Oracle 11g/10g, RAC, ASM, Dataguard, DGMGRL, RMAN, PL/SQL, UNIX Scripting, OEM Grid Control, EMC SAN, Toad, Datapump, SQL*Loader.

Responsibilities:

• Involved in 24*7 support for production RAC database with on-call pager
• Installed and configured OEM Grid Control
• Install and configure Oracle Goldengate
• Installation and creation of 11g and 10g databases for Testing, Development and Production
• Data Refresh from Production to Test and Development environments using RMAN Duplication
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK.
• Applied RDBMS and Interoperation patches for upgrading the database from 10g to 11g.
• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Installing binaries of Oracle data base and application databases
• Generating AWR reports to analyze the database performance
• Data Refresh/CloningOracle Applications from Production environment to setup Test/Development Environments.
• OracleDatabase monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• Monitoring theCPU, memory usage, I/Ocontentionon servers usingtop, iostat, sar, glance, vmstat, etc.
• Performed capacity planning and reorganization of the various tablespace for efficient use of the storage.
• Applied Bug fixes patches, Quarterly Security Patchesfor RAC and non-RAC servers for issues when upgrading the database servers and DR switchover testing.
• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Redesignedtableandindex partitioning strategies, usingHINTSto improve the query performance.
• Backup and Recovery proceduresfor production, non- production databases usingRMANin conjunction with Veritas Netbackupto take periodic Complete and Incremental Backups.
• Creating and Managing stored procedures and triggers, distributed data, database replication, server tuning, automation of administrative tasks, database.
• Implementation and maintenance of read only snapshots and snapshot logs.
• MULTILOAD, TPUMP, SQL, and TASM for workload management
• Monitored/managed 2 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery
• Monitored batch performance
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Goldengate
• Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager.

Confidential, Herndon, VA.

Oracle DBA

Environment: Oracle 8i/10g/11g,RHEL5.x, OEM, TOAD 12.1, PL/SQL Developer.

Responsibilities:

• Part of a 4 member Oracle Database Administrator team from Herndon.
• Providedon call DBA supportfor Oracle10g/11gProduction, QA, DEV databases on RHEL and Solaris forOLTPandData WarehouseEnvironments.
• Applied RDBMS and Interoperation patches for upgrading the database from 10g to 11g.
• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Backup and Recovery proceduresfor production, non- production databases usingRMANin conjunction with periodic Complete and Incremental Backup.
• Data Refresh/CloningOracle Applications from Production environment to setup Test/Development Environments.
• Performed capacity planning and reorganization of the various tablespace for efficient use of the storage.
• Tuning various queries using the HINTS or creating indexes.
• Worked with Shareplex support for the various issues related to critical Reporting data based on Shareplex.
• Applied critical patch updates (CPU) released by oracle quarterly.
• Performed advanced replication using Oracle Streams
• Installed Red Hat Enterprise Linux (RHEL-5) on VMWARE console.
• Performed export/import utility using oracle datapump from production to test/dev/QA environments.
• Closely worked with auditors on providing the User/Oracle/UNIX level password policies.
• Performing daily Archive log file backup and checking Alert Log files.
• Review alert logs and dump files to check for any problems related to the database/user.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• On call Production Support ON Shift Basis.
• Perform database capacity planning and growth projection by monitoring the tablesapce space requirements and ensuring that there is enough disk space available to support the various end-user applications that access the databases.
• Performance tuning of corporate databases, using tools like sql trace, tkprof, AWR, ADDM, SQL Tuning.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and analyze command.
• Logical backups are scheduled for Development, QA, Help Desk and UAT databases using export/import and Data Pump.
• Extensive Hand on experience in handling Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Tuning the initialization parameters as per the needs by analyzing the AWR reports.
• Creating private and public Database links between various databases residing on different host as the project requirements.
• Involved in data replication through creating materialized views and developing database triggers to keep track of the historical data.
• Involved in identifying the performance issues of the database and suggesting creating Indexes on different columns depending on the size and the dependencies of the database tables.
• Managing the database objects through OEM grid control and also monitoring various databases and tuning them through running Explain plan or SQL Advisor for various performance related issues.
• Scheduled shell scripts for running daily jobs using CRONTAB.
• Involved in creating stored procedures for using BULK INSERT feature for inserting huge data into the database tables which had improved the performance by huge amount.
• Creating table spaces and adding data files to the existing table spaces and resizing them as per the requirement and monitoring their growth in a timely manner

Confidential, Southborough, MA

Oracle Application DBA

Environment: Oracle 8i/10g/11g, RHEL4.x/5.x, Solaris 10, OEM, TOAD.

Responsibilities:

• Providedon-call DBA supportfor Oracle 10g/11g production, QA, DEV databases on RHEL and Solaris forOLTPandData warehouseEnvironments.
• Applied RDBMS and Interoperation patches for upgrading the database from 10g to 11g.
• Performed the Pre Patch analysis and post patch support for the baseline patches.
• Upgraded the database and clusterware from 10.2.0.4 to 11.2.0.2.
• Backup and Recovery proceduresfor production, non- production databases usingRMANin conjunction with periodic Complete and Incremental Backups,BCV backups.
• Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Bash Shells
• Installed and upgraded the DNB Integration Manager application which is used by the Oracle 11i Application for creating new customers.
• Troubleshoot the various performance issues for the mission critical RQF project.
• Data Refresh/CloningOracle Applications from Production environment to setup Test/Development Environments.
• Performed capacity planning and reorganization of the various tablespace for efficient use of the storage.
• Tuning various queries using the HINTS or creating indexes.
• Writing various shell and Perl scripts for the database and application monitoring.
• Worked with Shareplex support for the various issues related to critical Reporting data based on Shareplex.
• Replatform a large 8TB database from Solaris to Linux using the complex Transportable Tablespace and RMAN Convert.
• Experience with Database reorganization, collecting statistics and monitoring database performance using STATSPACK, OEM, and TOAD.
• 24*7 Production oracle database support and administration.
• Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Experienced in developing automated Jobs using Shell Scripting, PL/SQL.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Documented the steps of installing and configuring the Crystal Enterprise for the networking department built the servers when we have releases.
• 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, TOAD and Oracle Enterprise Manager
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Devised and Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation

Oracle DBA

Environment: Oracle 9i, 10g,10g RAC, RMAN,10g Data Guard, RAT, Oracle 10g Flashback, Datapump, PL/SQL, MKS Tool kit, CYGwin, SQL *Loader, tkprof, Statspack,Pstools, Forms 6.0, 4.5, Report builder.

Responsibilities:

• Responsible for both creation and manage Production, Development, Unit and Test instances of Oracle Version 9.2.0.6, 10g.
• Highly experienced in using STATSPACK, AWR to check health of database & hardware.
• Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT
• Deep Knowledge in using tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.
• Experience in writing UNIX shell scripts for automating daily, weekly and monthly activities, experienced in developing exhaustive documentation for all activities performed.
• Experience in taking Export, Import and Loading data using SQL*Loader, Punchout and Bulk Loader.
• To Review the team members weekly status reports, preparing Customers Monthly status Report.
• Database health check, pinning of objects, Monitoring the Database Growth and increasing the tablespace sizes, Reorg of Tablespaces, Identifying and Recompiling invalid schema objects and Building Schema Index bugs.
• Migrating Portal from Solaris to Linux with integration of Portal OID with Microsoft Active Directory.
• Configured Oracle 10G Data Guard for disaster recovery. Implemented Oracle 10G Flashback feature for recovery operations.
• Data export/import using Data pump an oracle 10g feature. Data movement using Transportable Tablespaces

Confidential, Beloit, WI.

Oracle DBA

Environment: Oracle 8i, 9i, 10g, RAT, Sun Solaris 2.10, Veritas software, EMC TimeFinder, SRDF, PL/SQL,, SQL*Loader, SPA, statspack, tkprof.

Responsibilities:

• Responsible for, both manage and support all Production, Development and Test instances of Oracle Version 9.2.07, 9.2.0.5, 8.1.7.4
• Maintaining (VLDB) OLTP databases in 24x7 Production environments on Multiple Applications Tiers with Load balancing of forms tiers. Upgraded QA instance from 11.5.9 to 11.5.10.
• Implemented a Green Belt Project by developing automated complete clone using shell scripting. The script is designed to perform preclone, database removal, restoration (datafiles and application binaries restoration), db recover, Adconfig (on both DT and AT), postclone, generating validation report in HTML format.
• Implemented a Lean project by developing automated post-clone process using shell scripting. Post-clone activity involves changing passwords (system, apps, standard, custom), profile values, dropping and creating dblinks, restoring env file’s from backup, uploading responsibilities, and performing validation and generating a HTML report.
• Developed a UNIX shell script to reduce the restoration (datafiles) to half the actual time.
• Development of BPEL/SOA best practices and standards.
• Performed disaster recovery, wide area network data transfer and data warehousing purposes using MGA.
• Installed MGA duplica on 10g Application server.
• Created user accounts, roles and granting access permissions to the database.
• Implemented the rsync methodology to reduce the time on restoration of binaries during a clone.
• Installed Oracle Internet Directory (OID) and Novell EIV on a Solaris OS in Oracle 11.5.10.2 with RAC.
• Fine tuned Memory, I/O and Database Objects.
• SQL Performance Analyzer (SPA) to foresee SQL performance changes (execution plans, statistics).
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g RAC in UNIX/LINUX and Windows environment.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Worked with SQL Performance Analyzer (SPA) to allow for the comparison of SQL performance statistics.
• Maintenance tasks like bouncing the production database, services through veritas.
• BPEL/Workflow performance troubleshooting and tuning.
• Implemented security in a DMZ configuration.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc and Building Schema Index bugs.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Single Sign on (SSO) and SSL implementation.
• Troubleshot Concurrent service and Concurrent manager issues
• Sync Split activity (hot and cold) through EMC TimeFinder using BCV's.
• Document standards and operating procedures.
• Develop and Maintain BPEL process reports as required
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Goldengate
• Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & move procedures
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Optimal Space utilization in tablespace by avoiding fragmentation
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions

Confidential

Oracle DBA

Environment: Oracle 8i, Shareplex 4.1, 3.2, Sun Solaris 2.6, Noetix, Veritas software, EMC TimeFinder, SRDF, PL/SQL, Forms 6.0, Reports 6.0.

Responsibilities:

• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment. Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Noetix installation for reporting Environment
• Actually started with resource limitation of only 1 member providing 24X7 Support to reporting environment.
• As the availability of reporting instance is critical to business Implemented Pro-active scripts across the reporting servers to reduce the failure of replication.
• Identified the cause for failure of replication or slow replication, built indexes to enhance the replication process. SSL and SSO Implementation.
• Automated compare - repair utility in Shareplex to keep the tables (target) in sync with source.
• Performed day-to-day database and oracle apps tasks like code movements, package and form compilations.
• Implemented shell scripts to reduce the time for large code movements during cut over tasks.
• Responsible for, both manage and support all Production, Development and Test instances of Oracle Version 8.1.7.4.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary. Online/Offline Database Backups and managing database recovery with RMAN.
• Provide technical assistance to developers in all matters concerning performance, application related issues.
• Monitor database and make recommendations to improve performance when appropriate, and schedules/perform table and index reorgs as necessary.
• Maintenance tasks like bouncing the production database, services through veritas.
• Gathering the statistics for pinning the objects. Resolving listener and tnsnames.ora issues.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls
• Developed UNIX shell scripts to perform the above tasks efficiently
• Worked as a member of production DBA team in perfect coordination with seniors and team members.