SUMMARY

• Over 8+ years of experience in Oracle Database Administration in very large Production, Test and Development environments of Oracle 9i/10g/11g/12c databases on various versions of UNIX/LINUX and Windows Operating Systems.
• Experience in Oracle Database Administration includes Installation, Upgrading and Patching, Database Creation, Backups, Recovery, Optimization and Performance Tuning of Oracle 9i/10 g /11 g/12c in diversified environment such as Red Hat Linux, OEL, HP - UX, Sun Solaris and Microsoft Windows.
• Proficient in Migration of Database and up gradation from 10g to 11g and Cross PlatformSunOS to Linux.
• Cold/Hot/Logical Backup and Restoration of database
• Backup and Recovery strategies for Import and Export backups, Data Pump backups and Hot backups using Recover Manager(RMAN)
• Proficient in using Oracle utilities like Export/Import & Data Pump, Flash Back Recovery, Data Guard, TOAD, SQL Loader, Oracle SQL Developer, OEM, ASM and AWR.
• Automation of the database Backup and Recovery process using Shell Scripts
• Experience in Installation and configuration of Oracle 10g, 11g on Real Application Clusters (RAC) using Automatic Storage Management (ASM)&Standby Databases for High Availability and Disaster Recovery purpose.
• Experience in implementing Oracle 10g Grid control to monitor Enterprise Databases
• Experience in Configuring the Database Hosts, Cluster Databases, Database instances, ASM instances in Grid control
• Working knowledge in Production (24x7), Staging, and Development & Test Databases.
• Perform interface development and operations, Database Tuning, Capacity Planning, Storage Allocation and Database Monitoring Management
• Strong Knowledge and Experience of Creating Users, Views, Materialized Views, Public Synonyms, Database Links, Roles, Profiles, Privileges and Assigning roles to users.
• Good experience in Stored Procedures, Functions, Database Triggers, Packages and DML, DCL, DDL using PL/SQL
• Knowledge of Normalization, DataWarehousing, and OLAP 24X7 support, data transfer, developers support, code review, load balancing, remote administration etc.
• Good experience in maintaining Tables, Indexes, Views, Partitions and OptimizePL/SQL queries
• Strong Troubleshooting, Problem solving, Analytical and Design Skills
• Proven ability to work effectively and provide support within a technical team
• Highly motivated, excellent team player and quick learner of new technologies with Strong interpersonal and communication skills.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g/12c

Operating Systems: Red Hat Enterprise Linux 3.0/4.4, Red Hat Advanced server 2.1, HP-UX 11/11i, AIX 5.2/5.3/6.1, Sun Solaris 8/9, Oracle Enterprise Linux, Oracle VM Server, VMware, Microsoft Windows NT/200/2003

High Availability: Oracle 10g/11g RAC, Standby Database, Data Guard and Clustering Setup, Automatic Storage Management (ASM)

Oracle Tools: Oracle Enterprise Manager (OEM), Recovery Manager (RMAN),Export/Import, Data-Pump, TOAD, APEX, SQL Loader, Erwin, Putty

Languages: SQL, PL/SQL, C, VB, HTML, Unix Shell Scripting

Others: Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Environment: - Oracle 9i/10g/11g/12c, OEM, Red Hat Enterprise Linux, AIX, Sun Solaris, OEL, RAC, ASM, RMAN, Data Guard, TOAD, SQL Developer, Putty

Responsibilities:

• Responsible for DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• 24x7 Oracle Database Administrator for Production, Development and Standby Databases and provided on-call support
• Monitored Standby Databases and perform switchover mechanisms of Data guard
• Implemented ASM, Migrate Databases from non-ASM file system to ASM file system with normal redundancy and external redundancy.
• Implemented and maintained Oracle 10g/11g Data Guard/Standby Databases for fail-over purposes.
• Experience on Oracle RAC and Monitoring RAC Databases
• Performed Backups (Cold/Hot, Logical Export/Import, Data Pump, Full, Cumulative, Differential), Recoveries using Oracle Recovery Manager RMAN
• Implementation of database backups using RMAN &exp/imp utilities for Transactions DBs and backups for Data warehouse.
• Used Data pump for exporting and importing tables, schemas and table spaces
• Performed tasks to restore and recover databases from file system backup in order to bring it to the original state as per the business or user requirement.
• Responsible for Database Tuning, Application Tuning & Performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System Kernel parameters.
• Working with Oracle utilities i.e. Export/Import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM Grid Control.
• Setup and Upgraded of the Oracle Databases from Oracle 10g to 11g.
• Involved in performing migration from Oracle 10g to Oracle 11gR2 RAC database
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Refresh/Cloning of Database from Production environment to Test environment
• Migrating Oracle databases from Windows to Linux and over the network
• Applied various patches on regular basis to Oracle software homes
• Created and maintained Databases manually as well as using DBCA
• Created Materialized Views/Materialized Views Logs for data replications
• Tuned SQL and PL/SQL code using Oracle Enterprise Manager (OEM) Tools, Query Analyzer and Explain Plans
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc
• Implementing and Maintaining Database security by creating and maintaining users, roles and assigning privileges
• Monitored Oracle Instances, Users, Tables, Table spaces, Memory Structures, Roll Back Segments, Redo Logs, Archive Logs and Alerts
• Partitioning large objects to improve the performance and manageability.
• Read Alert Log and User trace Files and Diagnosing the Problem
• Experience working with PL/SQL scripting and programming
• Continuous Performance monitoring and tuning of the databases and application using TOAD and OEM, Tuning Pack, Diagnostics Pack, and STATSPACK
• Responsible for Creation and maintenance table space, data files, redo log files and renaming /relocating of data files on servers.
• Extensive experience with Oracle productiondatabase (physical and logical database designs, implementation and programming)
• Administered database regarding space related issues- monitoring tablespaces, users security of data accessibility and Configuring Archive log destinations and flash recovery area

Confidential, Lewisville TX

Sr. Oracle Database Administrator

Environment: - Oracle 9i/10g/11g, RAC, ASM, RMAN, SQL Loader, OEM, Sun Solaris, Red Hat Linux, OEL, Toad, PL/SQL

Responsibilities:

• Provided full life cycle on DBA/on call support for Production Databases, Administering, UAT, Development and QA databases
• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and performing production databases Maintenance
• Involved in 24x7 Production Database Administration and support
• Overall maintenance of Oracle database, performance, tuning, backup, recoveries and other database related activities
• Configured Automatic Storage Management (ASM) for Oracle 11g RAC databases for reducing disk contention and providing centralized management for Disks
• Standby Database (Data Guard) setup and configuration for Disaster Recovery
• Restored and recovered the databases using RMAN.(point-in-time recover, media failures recover, data files recover and block recover)
• Installation and configuration of Oracle 10g& 11gRAC database and Performed DBA tasks
• Performed database Migration from Windows platform to Linux using RMAN and Datapump
• Involved in performing migration from Oracle 9i, 10g to Oracle 10g Release2 RAC database
• Cloning of Database and applications for development and testing purpose.
• Monitored and Administrated RAC databases on Oracle 11g Clusters
• Configured the RMAN Backupsand monitored scheduled Backups
• Established and Documented Backup and Recovery strategies and procedures after evaluating various options including RMAN
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures
• Installed and created 10g and 11g databases for Testing, Development and Production
• Optimization of SQL queries, PL/SQL, Stored Procedures, Functions, Database Triggers and Shell scripting and worked with the users to meet business requirements.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Performance Tuning of application by identifying the SQL, which are not written well, providing inputs to the application programmer, correcting and implementing the right components
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Table Partitioning, Creating Locally managed Table spaces.
• Created & Managed Database Structures, Storage Allocations, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.
• Involved in the design, review, implementation, testing, and release of databases, design specifications, and application software
• Created Partitioned and Sub Partitioned tables
• Managed and monitored the use of disk space, memory and connection
• Developed SQL scripts to create database objects like Tables, Views, Indexes and Sequences
• Involved in Audit trails, Security, Testing, Debugging, Implementation, Monitoring and Performance Tuning
• Created and dropped users, granting and revoking rights as and when required
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queriesRebuilt Indexes for better performance, maintenance of Oracle Database
• Handled Database storage, logical and physical data modeling, architectural level designing on new projects using tools like ERWIN

Confidential

Jr. Oracle DBA & PL/SQL Developer

Environment: - Oracle 9i/10g, SQL Loader, OEM, Red Hat Linux, Toad, PL/SQL, SQL Loader

Responsibilities:

• Installed Oracle 9i/10g software on Linux server and creating database for production, development and test environments
• Monitor and optimize performance analysis of different database objects, planed for backup and recovery of the Database
• Backup recovery (Hot and Cold, RMAN and classic methods), developing disaster recovery procedures and documentation for various scenarios
• Configured user log on load balancing and failover on RAC database
• Performed Data guard set up for failover strategy
• Created database-related scripts and programs to support development and production environments.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts
• Migrated data from Production to Test/Dev databases as per the development team requirements
• Exported and imported databases from higher version to lower version of databases and vice versa using Exp/imp and expdp/impdp
• Wrote UNIX shell scripts/PLSQL scripts to automate day-to-day database administration activities like Monitoring the disk space, alert logs, and archive logs.
• Setup user accounts on databases and issued appropriate roles to the accounts
• Performed day-to-day DBA jobs for managing 9 Prod/Dev/Test databases
• Estimated Storage requirement, Creation of Table spaces and other Database Primary Objects
• Created database objects like tables, indexes, stored procedures, snapshots and views etc
• Created and maintained users, profiles and roles and maintaining system security
• Interacted with Oracle Support for resolving various critical database issues