SUMMARY:

• Skilled leader with 10 years of experience in Large & Complex Database Environments with Banking, Healthcare and Bio - pharmaceutical experience.
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version 9i, 10g,11g, 12c and Cluster (RAC), Switchovers, Data Guard and various Cloning technologies
• Possess & Demonstrated proven expertise in Performance Tuning, Instance Tuning and analyzing with stats pack/AWR utility for bottle necks.
• Supporting Oracle databases, with experience including requirements definition, data modeling, and logical/physical design
• Upgrading and Migrating of Database across various data centres.
• Worked on Database Performance Tuning, SQL Tuning and Optimization
• Good experience in applying Critical Patch Update on Databases, Application Servers and Middle Tiers
• Involved in all the database activities such as creating tables, databases, backup, recovery and replication
• Expert in installation, monitoring and scheduling jobs in OEM 13c.
• Working experience in Oracle Virtual Machines
• Mentored and provided oversight and backup for the production Databases
• Administrating Database in various platforms like WINDOWS NT / 2000/ 2003, SUN SOLARIS 8/9, HP UNIX, and Red Hat Enterprise Linux 6.0.
• Good knowledge of Oracle Golden Gate. Experience with SSIS, SSRS on SQL Server.
• 2+ years of experience on DBVISIT (3rd party DR solution for Oracle Standard Edition ).
• Deep understanding about Exadata specified features such as Smart Scan, HCC (Hybrid Columnar Compression), Flash Cache, etc.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.Good experience on switch over the DR database using DGMGRL, OEM and using SQL.
• Proficient in participating in an ON-CALL and perform night and weekend maintenances.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Database: Oracle 9i/10g/11g,12c with Real Application Clusters, Data Guard

PL/SQL Development: TOAD, SQL WorkSheet

Application Tuning: AWR, ASH, ADDM, SQL Trace, Explain Plan, Wait Events, STATSPACK, TKProf, OEM12 and 13c, Tuning Pack

Interface Tools: SQL Developer, SQL*Loader, TOAD, SQL Developer

Languages: SQL, PL/SQL, JAVA, HTML, C, XML, Perl

Operating Systems: Windows 2003/XP, Sun Solaris HP-UX 11, Linux (Red Hat, SUSE)

PROFESSIONAL EXPERIENCE:

Confidential, California-Redwood City

Senior Oracle DBA

Responsibilities:

• Installation and creation of databases on 10g, 11g and 12c servers in Production and Non-Production environments.
• Upgrading different versions of 10g,11g databases to 11.2.0.3/11.2.0.4 and 12.1.0.1/12.1.0.2 databases on all the environments in a procedural approach Dev, Test, QA and Production.
• Installation of RAC using ASM. Installed RAC (2 Node) for 11.2.0.4 and 12.1.0.2 on AIX 6.1 and 7.1.
• Creating and rebuilding of physical and logical standby databases.
• Cloning databases to the existing servers as well as to new database servers.
• Configuring RMAN backup scripts to run the full database backups and archive-log backups.
• Applied the PSU, CPU patches to all test, development and production databases on 10g, 11g databases.
• Installing the OEM 12c agent on 9i, 10g, 11g and 12c. Worked on getting the agents up on the databases and registering them on the OEM server.
• Configuration of Oracle OEM 13c to monitor databases and generate report on events.
• Migration of data across different platforms i.e. from Solaris to AIX and from Windows to AIX.
• Worked on audit and security compliance to enable different audit settings on the Production as well as Non-Production servers as per Confidential standards.
• Generating Execution Plan, AWR, ADDM, tracefiles reports for Performance tuning.
• Demonstrated expertise in Performance Tuning.
• Proficient in Exacheck report extraction.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Experienced in Handling Oracle 11g and 12c databases on X6- Full rack Exadata machines.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager 12c and 13c solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Used ADDM to identify performance bottlenecks, for database configuration issues and for RAC specific issues.
• Used ASH to track session activity and deal with performance related issues.
• Expertise in Fixing standby sync issues with production.
• Rebuilding the physical standby using RMAN incremental backup.
• Working on production support. Worked on incidents, requests, tasks. Applied bug fixes to resolve issues.
• Hot and Cold Backup, Recovery and Cloning of databases using RMAN.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Working as part of on call rotation to deploy production changes on the weekends

Environment:: Oracle 11g,12c RAC, Dataguard 11g,12c, RDBMS, RMAN, AIX 5.8, 6.1,Linux 6/7, Solaris 9.0/10.0, Oracle 9i, 10G, 11G OEM 13c Grid control

Confidential, Charlotte, NC

Senior Oracle DBA

Responsibilities:

• Planning, Implementing and validating various versions of Oracle Databases to 11g Release upgrades on all the environments in a procedural approach Dev, Test, Stage and Production.
• Proficient with installation, silent installation, de-installation of 10g, 11g and 12c databases.
• Extensively used Explain Plan and Oracle enterprise manager grid control.
• Used ADDM to identify performance bottlenecks, for database configuration issues and for RAC specific issues.
• Used ASH to track session activity and deal with performance related issues
• Mastered in add Node or remove Node from RAC.
• Performing Patch analysis, impact analysis and patching the database and application.
• Experience in managing Oracle in High Availability environments using Real Application Cluster, Failovers, Data Guard and Cloning technologies.
• Proficient in fixing Data Guard related issues.
• Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs, managing the security at user level and at application level and Recover Point Level.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools and Net Backup.
• Working knowledge in Golden Gate.
• Worked on large set of performance monitoring skills like Oracle, UNIX, and Solaris.
• Shell scripting for automating, monitoring and performing routine database jobs.
• Worked on Database Performance Tuning, SQL Tuning and Optimization.
• Provide development and production support related to database.
• Evaluated new features and enhancements in later versions of Oracle for possible implementations like Data Pump, Transportable Tablespaces, Cross-Platform Transportable Tablespaces, External Tables, and Partitions.

Environment: s: Oracle 9i/10g/11g/12c, Windows 2003, Red Hat Linux 3.0/4.0/6.0/7.0, RAC, Export/Import, RMAN, SQL * Loader, SQL, PLSQL, SQLTRACE, STATSPACK, SQL Tuning Advisor, Data guard, OEM 12c,Replication, Data Grid Control, Materialized Views, Snapshot, Migration, upgrades, installation

Confidential, Des Moines, IOWA

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 9i/10g &11g
• Applying Critical Patch Update and security patches in various environments (Prod / Staging / Testing).
• Upgraded Oracle databases from 9i to 10g and 10g to 11g.
• Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs, managing the security at user level and at application level.
• Optimized database performance by analyzing database objects, gathering statistics, creating indexes and Data Modeling for web portals.
• To create and analyze Statspack report, AWR reports and identifying solutions.
• Experience with Oracle GoldenGate.
• Managed Oracle in High Availability environments using Real Application Cluster (RAC), Failovers, Data Guard and Cloning technologies.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues, helping to transform business requirements into environment specific databases.
• Capacity planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation).
• Used various data movement utilities like export, import and Load, Planning.
• Worked with development team to analyze and support production database performance and third-party resources to create, manage, and tune information feeds from various sources.
• Handled the Backup and Restoration Strategy, Executed Shell Scripts using Cron jobs, Planned and scheduled Backups, took Logical Backups (with Export / Import utilities) and NET Backup.

Environment: Oracle databases 8i/9i/10g, router, switches, SQL*Loader, Sun Solaris 8, download router, switches (third party tools), scripts, procedures, functions, Dataguard, SQL Tuning Advisor, ERWIN, Hot backup, Export/Import, RMAN, Veritas NetBackup, Statspack, Replication (Materialized views and snapshots), upgrades, Migration

Confidential

Oracle DBA

Responsibilities:

• Provide Primary DBA support for Oracle Applications and Administration, Configuration and Maintenance of RAC and Non-RAC Databases.
• Work within the production support team and maintain operational consistency and efficiency.
• Provide input to the Project and Enhancement teams to define database storage structure after application developers have designed an application.
• Implementation of reviewed changes to the production databases.
• Provide primary DBA support to Production support developers.
• Having good knowledge on Microsoft Access, Excel and SQL.
• Provide application DBA skills to identify and focus on strategic opportunities.
• Creating primary objects (tables, views, indexes, snapshots, database links, etc) once application developers have designed an application.
• Modifying the database structure as necessary, from information given by application developers.
• Collaborate with Enhancement and Production support teams to verify all instances are healthy and up.
• Verify success of database backup (Maintaining RMAN Backups and Logical Backups)
• Implemented database refresh with the hot backup using DUPLICATE or full export
• Monitoring security policy violations
• Tune SQL, I/O, Application and Database
• Review Data Fragmentation
• Development/Test Instances Creation
• Refresh Databases and Schemas with Production Database
• Migrating data from development data to Stage and then Stage to production SQL/PLSQL and UNIX Shell Scripting for monitoring space and extent growth.

Environment: Oracle databases 8i/9i/10g, router, switches, SQL*Loader, Sun Solaris 8, download router, switches (third party tools), scripts, procedures, functions, Dataguard, SQL Tuning Advisor, Hot backup, Export/Import, RMAN, Veritas NetBackup, Statspack, Replication (Materialized views and snapshots), upgrades, Migration.

Confidential

Associate Oracle Database Analyst

Responsibilities:

• Provided 24*7 on-call Production support for Oracle 9i and 10g
• Single point of contact for Production Support DBA in British Petroleum (Bp).
• Installed and implemented the Oracle Database 10g,11g.
• Gathered Statistics and monitored TOP SQL’s for performance.
• Completed database Cloning and Database up gradation from old version
• Maintained Version Control for Production Environments
• Take care of the Database design and implementation
• Setup and maintain documentation and standards
• Plan growth and changes (capacity planning)
• Implemented physical and logical database design.
• Created Service Request to Oracle for performance problems.
• Assisted code writing in development using PL/SQL Block, Procedures, Functions Database Triggers and Packages
• Changing database from No Archive to Archive Log Mode and vice versa. Identified inefficient queries in development and fine-tuned and worked with Development team as needed
• Worked with development team to analyze and support production database performance and third-party resources to create, manage, and tune information feeds from various sources
• Ensure data security by establishing and enforcing proper access policy managed Database structure in SAN
• Shell scripting in csh, ksh (KORN) for automating startup/shutdown of databases, getting system alerts etc
• Handled the Backup and Recovery using RMAN
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc.
• Used various data movement utilities like export, import and Load, Planning

Environment: Oracle databases 8i/9i/10g,, router, switches, SQL*Loader, Sun Solaris 8, download router, switches (third party tools), scripts, procedures, functions, Dataguard, SQL Tuning Advisor, ERWIN, Hot backup, Export/Import, RMAN, Veritas NetBackup, Statspack, Replication (Materialized views and snapshots), upgrades, Migration.