SUMMARY

• Over 8 years of IT Experience as anOracleDatabase Administrator of real time challenging projects with system analysis, design including monitoring and maintenance.
• I have good exposure to all stages of designing and implementation of database and ability to understand Functional Requirements and Design Documents.
• Database administration, development, production support, installation, configuration, upgrades, patches, backup and recovery, database security, auditing and space management.
• Installation and configuration ofOracle8i, 9i, 10g, 11g, 12c databases in Solaris and Linux environment.
• Expertise on performing cold backups, hot backups, and recovery.
• Designed and implemented centralized backups and recovery strategies using recovery manager (RMAN).
• Use of RMAN scripts to perform full and incremental backups.
• Experience with Flashback and RMAN recovery techniques.
• Patching the databases with CPU/PSU on quarterly cycles or ad - hoc needs.
• Installed and configuredOracle12c Cloud Control and deployed agents on managed targets.
• Configured RAC database instances with two to four nodes.
• Experience in using and creating SQL, PL/SQL stored procedures, functions, indexes, materialized views, partitioned tables, packages and triggers.
• Created and refreshedOracledatabases for development, test and stage environments.
• Performance Tuning: Experience in identifying poor SQL statements using Explain Plan, Stats pack, TKPROF, SQL Trace, OEM Cloud/Grid Monitoring, AWR, ADDM, SQL tuning advisor.
• Experience in leveraging theOracleSupport for Service Requests.
• Good experience in managing large OLTP and Data warehousing databases.
• Creating shell scripts and scheduler jobs for monitoring purposes.
• Involved in logical and physical database designs and worked as on-call support team member for administering OLTP 24X7 production databases.
• Excellent communication skills, strong analytical & logical abilities, problem solving skills and fast learning.

TECHNICAL SKILLS

RDMS: Oracle10g, 11g, 12c

Languages: SQL, PL/SQL,C,Bashshell

Tools: RMAN, OEM,SQL*Loader,data pump, SQL Developer, TOAD, putty

Tuning Tools: ASH,TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Operating Systems: AIX, Linux, Red HatEnterpriseLinux, HP-UX, SCO, Sun Solaris, Windows

Virtualization Technologies: VMware,OracleVirtual Machine

Utilities: SQL Loader, Exp/Imp, Data Pump, Expdp/Impdp, TKPROF,TRCAandStats pack, 10046 Trace, Oradebug.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Oracle DBA

Responsibilities:

• Architected, Designed, Installed and configured a 4 node RAC Database on Solaris 11, and Linuxplatforms.
• Ensure technical documentation is kept up to date (architecture/integration diagrams and documentation)
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Execute the collection of requirements, product comparisons, product research, and architecture.
• Implements, administers, manages, monitors, and tunes the assigned application databases in development, pre-production and production environments.
• Designs and implements performancetuning improvements and advises developers on tuning options. Ensures that data integrity and datasecurity is maintained.
• Demonstrates advanced troubleshooting and analytical skills through problemresolution.
• Actively participating and/or serving in a supporting role to meet the customer's obligations and mandates. Prepares status updates for management. Provide technical leadership to the Applications
• Support Team, Developers and System Admins.
• Support Production, QA, DEV, UAT databases.
• Performed and taken care of various node eviction issues
• Provide level advanced technical system expertise, oversight, and accountability for resolution of outages, service level issues, and user/customer support needs in coordination with the Steady state support teams.
• Established RMAN backups and recovery policies.
• Upgraded production and all test databases from11.2.0.X to 12.1.0.2.
• Clonedoracleproduction databases for development and testing.
• Cross platform Migration of databases using export/import and datapump.
• Daily health checkup of databases.
• Participate in planning strategies for future database needs for business needs in perspective of capacity planning, performance and available technology.
• Configuration ofOracleDisaster Recovery Solution (DR) from Production Server to the DR Server.
• Resolution of day to day related issues, documentation ofOracleDBAroutine tasks.
• Creating documentation during project planning, project execution and project maintenance phases.

Environment: Oracle11gR2,OracleRAC (11g),OracleGrid Control, RMAN, ASM, SQL Developer, TOAD, SQL*Plus.

Confidential, Pittsburgh, PA

OracleDBA

Responsibilities:

• Build RAC node clusters.
• Created databases using scripts, OMF and via silent installs.
• Handling the code deployments developed by Developers on Dev, Test and Production.
• Managing users, profiles, roles and table space according to the requirement.
• Created shell script to automate jobs.
• Database user backup using Export /Import Utility. And database backup using data pump.
• Production refresh to PRR environment and conversion environment when required.
• Done partitions on tables and indexes to get better performance on large tables.
• Monitoring Backup report, Database sync report (Verifying Production & Standby Database Synchronization), AWR report and wait events reports using OEM and Custom scripts.
• Configured OEM for the performance monitoring and database administration.
• Monitored indexes and analyzed their status for performance tuning and query optimization
• Used SQL Trace, TKPROF, STATSPACK, PerfStat, Explain Plan, AWR and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM.
• MigratedOracleNon-RAC databases toOracleRAC databases.
• MigratedOracledatabase from file system to ASM.
• Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.
• Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps usingOraclebest practices.
• Perform database tuning and performance monitoring at the OS level, DB level and SQL level. Analyze data and make recommendations relating to performance and efficiency of data storage.
• Perform capacity testing before implementing new major application release to production environment.
• Provide advice and solution to Application Development Team to have effective use of indexes, how to reduce waits or other advices from OEM Grid control.
• Work with the system administrator and storage administrator to perform software installations, and to configure hardware and software so that it functions optimally with theOracleinfrastructure.
• Monitor and maintain database security. Co-ordinate with Security administrator in adding, maintaining and removing users account, administering quotas, auditing, and checking for security issues.
• Written shell scripts to automate tasks.
• Provide after hours and weekend on-call support on a rotation basis.

Environment: Oracle10.2.0.4, HP-UX 11, Sun Solaris 10.0, RAC,RMAN, Data Pump, SQL TRACEEXPLAIN PLAN

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Installed and implemented 10g RAC with 2 nodes with ASM.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e., 9i, 10g and 11g.
• Database migration from 10g to 11g.
• 24x7x365 production support.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Recovered databases and clone applications Using RMAN.
• Responsible for resolving several complex recovery scenarios (including RMAN) with critical production database.
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• OEM Grid Control installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export usingOracleData pump utilities.
• Administered and maintained database security policies and procedures.
• Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for troubleshooting performance and networking issues. Basic OS system administration.
• Create and maintain users, roles and privileges.
• Build RAC from scratch.
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Provided 24/7 on-call support.

Environment: Oracle10g, 11g on RAC,OracleEnterprise Manager,OracleGrid control, RHEL, HP UNIX.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Installed, configured, and maintainedOracle10g and 11g on Linux
• Upgraded fromOracle10g to 11g.
• Performed the migration from Tandem toOracle11g.
• Expertise in designing the table structure using Visio by creating ER diagram and normalized all the tables from the scratch according to the specifications provided.
• Performed administrative maintenance, monitoring onOracledatabase systems in a global 24x7 operational environment.
• Performed Database Refresh from Production to Development databases.
• Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER oforacle database.
• Supported different Databases like Testing, Staging and Training.
• Performed installation and configuration ofOracle10g/11g RAC databases on Linux.
• Upgraded theOracle10g database to 11gR2 version and also applied patch set and interim patches whenever required to make the database software up to date.
• Installed RAC onOracle10g and worked on ASM feature ofOracle.
• Worked closely with developers during release and usedoracleadvanced features to achieve minimum downtime.
• Good experience in Performance tuning of large databases.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Perform Logical backup using full/partial export/import and data pump.
• Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Perform Daily Monitoring ofOracleInstances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, managed quotas.
• Implemented advanced features ofOracle10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Cloned schemas, objects and data on new server using Data pump.
• Managing databases on multiple servers.
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle11g/10g, UNIX RHEL 5.x, OEM (Grid Control), RMAN, RAC, Explain plan,OracleSupport, SQL Developer, Data Pump, Business Objects, Toad, AWR, ADDM, SQL Loader