EXPERIENCE SUMMARY

• Over all Seven years of IT experience as an Oracle Database Administrator providing 24/7 production and development support of Oracle 11g RAC, Oracle 10g RAC, 9i, 8i
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, HP-UX, AIX, Red Hat Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Bi Directional Streams Replication, GoldenGate.
• Experience in database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis, Design and Data Modeling.
• Recovery of Databases from Media failure, Block Corruptions, User errors.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and 10g OEM Grid Monitoring.
• Experience with writing Packages, Stored Procedures, Functions and Database Triggers.
• Proficient in SQL, PL/SQL Shell Scripting and analyzed Batch programs.
• Proficient in Database Design (Physical and Logical Database Design) and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
• Good Knowledge of SQL Server.
• Ability to work independently with Strong analytical and problem solving skills.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating Systems

UNIX (Sun Solaris/HP-UX/IBM AIX), RedHat Linux, SLES and Windows NT/2000/2003

Relational Databases

Oracle 11g RAC, Oracle 10g RAC, Oracle 9i, Oracle 8i, SQL Server, TERADATA

Data Modeling Tool

ERWIN

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPAK, AWR, ADDM

Tools and Utilities

RMAN, Import / Export, SQL*Loader, Expdp, Impdp, TOAD

ETL Tools

Informatica 5.1, Data Stage 6.0

Querying/Reporting

PL/SQL, SQL

Languages

SQL, PL/SQL, C, C++, JAVA, VB, UNIX Shell Scripting

Administration Tool

Oracle Enterprise Manager, SQL Navigator, BMC Patrol, Spotlight

Other

Golden Gate, Oracle Streams, EMC, Veritas NetBackup, IBM TSM, TAM, NetApp

EDUCATION:

Bachelor of Engineering

PROFESSIONAL EXPERIENCE

Confidential, Radnor, PA Feb 08 - Present
Senior Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Installation and configuration of Oracle 11g RAC, 10g RAC
• Converted a single instance database to Oracle 11g RAC.
• Upgraded Oracle different version from 8i, 9i to 10g and 9i to 11g, 10g to 11g.
• Involved in Capacity Planning and Optimal setting of Storage Parameters.
• Performed Database administration activities like user and roles administration, schema management and checking alert log of all the databases.
• Involved in RAC administration including Oracle 11g and 10g database, cloning, tuning, patching and monitoring.
• Applied CPU patches
• Performing Backup/Recovery of Oracle databases.
• Implemented Standby Database (Data Guard) for high availability/ disaster recovery purpose.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Developed stored procedures, packages and database triggers.
• Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
• Create table spaces, tables and indexes, sizing the system table space, allocating default table space for users.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Knowledge of writing Automated Scripts in the cron for backups and restoration, arch to TSM.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM to improve the performance.
• Monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck.
• Performing SQL*Loader jobs for loading data from text files.
• Writing SQL scripts to monitor Archive log gaps in DR, monitor table space and extent growth.
• Working with Materialized views with Query Rewrite, Bitmapped Indexes, etc
• Involved in the migration of cluster databases and single instance databases.
• Automation of Startup, Shutdown, Backup, Cloning of the databases.
• Handling day-to-day activities.

Environment: Oracle 11g RAC, Oracle 10g RAC, 9.2.x, HP-UX 11, RHEL 4.x, AIX 5.3

Confidential, Irving TX May 07 - Jan 08
Oracle DBA.

Responsibilities:

• 24x7 production database and applications support
• Involved in Database Design with Data Architects.
• Evaluating database products and third party tools for the Project.
• Setup of the database environments for the Dev and QA teams.
• Installation and configuration of Oracle 10g RAC for High Availability
• Involved in migration of the database from Oracle 9i to Oracle 10g.
• Reorganizing Tables and Indexes for improving performance.
• Created the database objects based on the requirements for project requirement.
• Table space analysis, space allocations for tables, rollback segment monitoring and as member of application development team.
• Implemented complex business rules using database triggers and constraints.
• Adding, dropping users, creating Roles, Profiles and Grants based on the Role of the user.
• Planned and implemented database Backup on development and preproduction databases.
• Implemented Snapshots for remote objects for Reporting team.
• Testing of Backup's and Documenting backup strategies.
• Developed stored procedures, packages and database triggers.
• Performed Diagnosis & Tuned database and SQL statements as and when required.
• Managing Production as well as Development Instances.
• Identified and provided solutions for poorly written queries.

Environment: Oracle 10g with RAC, Erwin, Clear Case, Toad, Shell Scripts.

Confidential, Kansas City, MO Feb 06 - Apr 07
Oracle DBA.

Responsibilities:

• Provided 24x7 Database Administration and support.
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity.
• Monitor the scheduled oracle jobs, manage data feeds, verify the log tables and tune the performance of the database.
• Provide user account administration, optimizing SQL queries; optimizing developer code, manage table partitions, large data sets and provide manual reports using SQL.
• Backup and Recovery via RMAN scripts and troubleshooting.
• The size of the production databases ranges from 1TB to 6TB.
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues.
• Handle service requests from the business using CIT Helpdesk Service Management.
• Database Administration on application side, Web Server/Messenger Express Server Administration.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Upgrade of Database from 9.2.0.6 and to 10.2.0.2.
• Partitioned large table spaces to increase the performance of the database.
• Converted dictionary based table spaces to locally managed table spaces to eliminate fragmentation, better performance and reduced maintenance.
• Performed Tuning of various SQL queries to improve the performance of the database.
• Installation of Oracle 10g on HP-UX and AIX.
• Logical and Physical data modeling.
• Hard disk and Database space monitoring.
• Migrated file systems to ASM (Automatic Storage Management).
• General database administration including the management of instances, redo logs, temp space, rollback/undo segments and schema management.

Environment: Oracle 10g RAC/ 9i, RH Linux, TOAD, OEM, STATSPACK, TKPROF, SQL, Erwin 4.0

Confidential, Arizona. Nov 04 - Jan 06
Oracle DBA

Responsibilities:

• Installation, Configuration, Upgrade, Patching of Oracle RDBMS and Applications.
• The work involves overall ORACLE Database Maintenance, Performance Tuning, Backup, Recovery and other Database related activities.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Installation of Oracle version 10g on Solaris, HP-UX
• Database dot release upgrades using oracle universal installer and catpatch.sql
• Upgrade of Database from 9.2.0.6 and to 10.2.0.2
• Designing the logical and physical database structure.
• Designing the security and database access strategies.
• Logical and Physical data modeling.
• Create table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• REFRESH/CLONING of Database and applications for development, testing
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions)
• Using TKPROF, EXPLAIN PLAN, STATSPACK for the Better performance.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Performing backups and recoveries using RMAN conventional hot backups.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Partitioning Strategies for very large tables.
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Data refresh from production to test and development, maintain Database Security.
• Assist Programmers and Developers with Oracle problems.
• Write Korn shell scripts to monitor and maintain the Oracle database.
• Write SQL scripts to Monitor Tablespace and Extent Growth.
• Resolve various application failures due to data entry errors or system errors.
• Involves identifying problems and implementing corrective actions.
• Providing Solutions to the Problem Faced by End Users Or Programmers.
• OS level activities like space monitoring of Mount points.
• Automation of Startup Shutdown on all Production and Development Database.
• Daily Health Check of the Database.
• Diagnose and troubleshoot Database problems and failures.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: Oracle Server 10g/9i, SQL, RHEL, AIX 5.2, Shell scripting, SQL Server 2000

Confidential, Hyderabad, INDIA Dec 02 - Sep 04
Database Administrator

Responsibilities:

• Installation of Oracle Database and Oracle products.
• Creating users and maintaining database security.
• Maintained in-house Oracle Databases running on various operating systems like Windows NT and Linux.
• Designing and enforcing standards and naming conventions.
• Testing of Backup's and Documenting backup strategies.
• Implementing Backup/Recovery Strategies.
• Writing UNIX shell scripts for backup and recovery.
• Monitored SGA, Shared Memory, Memory Segments, LRUs and Buffers etc.
• System tuning for better performance.
• Creating stored procedures, packages and database triggers.
• Worked with application developers to debug PL/SQL procedure, tune queries and database sizing.
• Supervised the installation and configuration of Oracle databases on Linux and Windows NT.
• Writing SQL scripts to monitor database performance.
• Writing SQL Loader control files for data loading to the payroll system.
• Database tuning, backup and recovery and general day to day running of the system.
• Used Oracle Enterprise Manager to start up and shut down databases, to check for locks, monitor and kill user sessions, monitor database performance and other day-to-day tasks.
• Systems analysis and design.
• Creating project plans and implementation schedules.

Environment: Unix (IBM AIX) Windows, Oracle 8i, Oracle 9i