SUMMARY

• About 7 years of experience as Oracle Database Administrator and Developer in Production, Development and Testing Environments.
• Good experience in 24/7 Production Environment Support.
• Handled back end database configuration and provide the full database tier support to all phases of software development.
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version 8i, 9i, 10g and 11g.
• Solid experience in managing Oracle in High Availability environments using Real Application Cluster (RAC), Failovers, Data Guard and Cloning technologies.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Database Performance Tuning using dynamic performance views, AWR, Explain Plan, SQL TRACE, STATSPACK and different OEM utilities.
• Proficient in developing PL/SQL program units using Stored Procedures, Functions, Packages and Triggers.
• Supporting Oracle databases, with experience including requirements definition, data modeling, and logical/physical design.
• Well versed with client server environment & tools like SQL*LOADER and TOAD.
• Upgrading and Migrating of Database from lower version to higher version.
• Installation of Patch and fix bugs.
• Worked on Database Performance Tuning, SQL Tuning and Optimization.
• Worked on New Environments setup includes ASM, RAC Databases Installations.
• 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.
• Working experience with SQL, PL/SQL, Toad & other tools including creating database objects like tablespaces, tables, views, indexes, constraints, sequences, functions, procedures, trigger, partition tables.
• Experience with Oracle GoldenGate and Streams.
• Installation, configuration and monitoring of Oracle Exadata Database machine
• 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.
• Maintaining data integrity and tune database for optimum performance and availability.
• 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.
• 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)

Web Servers: Tomcat, Apache, Orion, WebLogic, Oracle Apps Server 10g.

PROFESSIONAL EXPERIENCE

Confidential, Fortworth, 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
• Creating and rebuilding of physical and logical standby databases for production servers
• Backup and restore the databases using RMAN performing point in time recoveries, using Hot/Cold Backups, Data Pump tools
• Cloning databases to the existing servers as well as to new database servers
• Migration and upgrading databases from 11.1.0.7, 11.2.0.2 database to 11.2.0.4
• Configuring RMAN backup scripts to run the full database backups and archivelog backups from the 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
• Daily monitoring like alerts checking, log checking, fixing space issues, fixing application connectivity issues
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions, triggers etc
• Refreshing schemas using Export/Import utility
• Migration of data across different platforms i.e. from Solaris to AIX and from Windows to AIX
• Gathering Database, Schema and Table Statistics and setting up automated jobs for it
• Creating roles, privileges, profiles, users. Granting permissions and assigning roles, privileges to users
• Worked on audit and security compliance to enable different audit settings on the Production as well as Non-Production servers as per Confidential standards
• Creating database link between various databases
• Creating profiles and password verify function for databases
• 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
• Rollback segments, Constraints, Database Access, Roles and Privileges
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Worked on building schemas, cursors, developed stored procedures and database triggers in PL/SQL
• Working as part of oncall 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:

• Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups with Database Refresh.
• 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.
• Importing data using SQL*Loader, Monitoring the database performance and providing assistance to development teams. Constantly monitored the performance of the database using V$ dynamic performance views at peak load and by viewing Alert log files & Trace files.
• 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
• Daily monitoring like alerts checking, log checking, fixing space issues, fixing application connectivity issues, tuning databases, tuning application related queires, indexing tables, gathering statistics for optimum results.
• Planned and implemented backup strategy of data in both archive and non-archive mode.
• Granting privileges to users to access systems and databases.
• Performing cloning of a database to generate reports.
• 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.
• Working experience with SQL, PL/SQL, Toad & other tools including creating database objects like tablespaces, tables, views, indexes, constraints, sequences, functions, procedures, trigger, partition tables.
• Oracle Database Administration activities such as starting and shutdown of Databases. Creation of Databases whenever necessity arises. Security administration by creating users with appropriate Roles and Privileges.
• 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.
• Using OEM to manage multiple instances and Toad for development and reporting.
• Involved in Functional Design Review and preparing the Detail Design Document.

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.
• To monitor database to take preventive steps against any database errors.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Experienced in implementation of large data warehouse databases in Oracle 9i and 10g.
• Taking Hot and Cold Backups, Logical backups (Export) on specified databases.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions.
• Good understanding of the Oracle Administration and familiar with ETL.
• 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.
• Implemnting Physical and Logical Standby setups Data guard Configurations.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Worked on different Platforms like Oracle with windows, UNIX, Solaris.
• 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).
• Tablespace Management, objects creation, and user management.
• 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.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Controlling and monitoring user access to the database, Monitor and optimize the performance of the database and Maintaining archived data.
• 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 DBA

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.
• Provided continuous feedback and support for PLSQL and SQL Performance tuning to developers and Code review.
• Assisted code writing in development using PL/SQL Block, Procedures, Functions Database Triggers and Packages
• Maintaining 9i RAC and 10g RAC databases and Dataguard.
• Writing Oracle Procedures and functions
• Identified Worst Queries in development and fine tuned
• 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
• Did SQL tuning and Instance tuning.
• Rollback segments, Constraints, Database Access, Roles and Privileges.
• Creating new tablespaces, tables, indexes, synonyms, procedures, functions etc..
• Used various data movement utilities like export, import and Load, Planning
• Handled the Back up and Restoration Strategy, Executed Shell Scripts using Cron jobs, Planned and scheduled Backups, took Logical Backups (with Export / Import utilities).

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.