SUMMARY

• Around 8 years of experience as Oracle Database Administrator and Developer in Production, Development and Testing Environments
• Provide 24/7 on - call rotation support
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version 8i, 9i, 10g and 11g
• Good knowledge and experience in managing Oracle in High Availability environments using Real Application Cluster (RAC), Failovers, Data Guard and Cloning technologies
• Database Performance Tuning
• Supporting Oracle databases, with experience including requirements definition, data modeling, and logical/physical design
• Upgrading and Migrating of Database across various data centers
• 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
• Mentored and provided oversight and backup for the production Databases
• Experienced in implementation of large data warehouse databases in Oracle 11g/10g with several key features like ASM, Partitioning, Resource Manager Model, Password Complexity, VPD Security and Compression
• Administrating Database in various platforms like WINDOWS NT / 2000/ 2003, SUN SOLARIS 8/9, HP UNIX, and Red Hat Enterprise Linux
• Excellent in troubleshooting Oracle Network issues
• Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time
• Knowledge of Oracle Golden Gate. Experience with SSIS, SSRS on SQL Server
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g 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, OEM, 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, Fort Worth, TX

Oracle DBA

Responsibilities:

• Installation and creation of databases on 10g, 11g servers in Production and Non-Production environments.
• Upgrading different versions of 10g databases to 11.2.0.3 and 11.2.0.4 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 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 archivelog backups from the EMC networker
• 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. Worked on getting the agents up on the databases and registering them on the OEM server
• Configuration of Oracle OEM 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 reports for Performance tuning
• 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
• Worked on Database Performance Tuning, SQL Tuning and Optimization.
• 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 10g/11g RAC, RDBMS, RMAN, AIX 5.8, 6.1, Solaris 9.0/10.0, Oracle 9i, 10G, 11G OEM Grid control

Confidential, Miami, FL

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.
• Experienced in implementation of large data warehouse databases in Oracle 9i, 10g and 11g.
• Extensively used Explain Plan and Oracle enterprise manager.
• 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
• Upgraded and rated the Databases from lower to higher versions and 9i, 10g to 11g.
• Implemented Oracle Advanced Replication using snapshots, materialized views, and multimaster and refresh groups.
• Having good knowledge on UNIX and Linux Servers.
• Experience in managing Oracle in High Availability environments using Real Application Cluster, Failovers, Data Guard and Cloning technologies.
• 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.
• 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, Oracle10g AS, Windows 2003, Red Hat Linux 3.0/4.0, RAC, Export/Import, RMAN, SQL * Loader, SQL, PLSQL, SQLTRACE, STATSPACK, SQL Tuning Advisor, Data guard, Replication, Data Grid Control, Materialized Views, Snapshot, Migration, upgrades, installation

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 9i/10g.
• 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 and Streams.
• 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).
• SQL and PL/SQL Scripting (Writing Stored Procedures and triggers for internal usage for monitoring and auditing.
• Implemented Oracle Advanced Replication using snapshots, materialized views, and multimaster and refresh groups.
• 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, Seattle, WA

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, SQL and VBA Programming.
• Provide application DBA skills to identify and focus on strategic opportunities.
• Worked on programs like Word, Excel and Access in Microsoft Office, including the latest version, Office 2003, Visual Basic for Applications.
• 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, ERWIN, Hot backup, Export/Import, RMAN, Veritas NetBackup, Statspack, Replication (Materialized views and snapshots), upgrades, Migration.

Confidential, McLean, VA

Oracle Database Engineer

Responsibilities:

• Provided 24*7 on-call Production support for Oracle 9i and 10g
• Installed and implemented the Oracle Database creation
• 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
• Writing Oracle Procedures and functions
• 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.