SUMMARY

• An Oracle Database Administrator with over 6 years of experience in the Database Installation, Development and Production System Support.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting, database design, Unix shell scripting and documentation.
• Worked with Oracle Databases 10g/11g RAC on Unix/Linux/Windows platforms.
• Experience with Installation, Configuration, Upgrades, Migrations, Administration and Patching of Oracle Databases and Oracle Applications.
• Proficient with Standby Database, Data Guard, Replication.
• 24x7 production oracle database support.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup.
• Excellent skills in shell scripting to automate jobs.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Database performance tuning using STATPACK, TKPROF, AWR Report,SQL Trace, Explain Plan
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, Logical and Physical Database Design, Backup and Recovery procedures.
• Experiencing in basic and advanced replication using Oracle Stream and Golden Gate.
• Install and configured Golden gate on Oracle and Sql servers for table and schema level replication.
• Experience in using OEM,TOAD
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations, Benchmarking
• Expertise in loading data from flat files using external tables, SQL*LOADER.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.
• Result oriented, self - motivated, Team player, ability to work independently and within a team.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Databases: Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, and Oracle 7.x

Oracle Products: OEM (Oracle Enterprise Manager), Data Guard, RAC, RMAN, SQL Loader

Languages: SQL, PL/SQL, and Shell scripts

Operating System: AIX, HP-UX, SUN Solaris, LINUX, Windows 2000/NT/XP, UNIXRedhat Linux, MS DOS.

Other Tools: TOAD, Veritas NetBackup

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior DBA

Responsibilities:

• Installation, configuration and maintenance of oracle 10g, 11g on AIX 6.1
• Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management
• Applied Security patches and Patch set on Oracle Databases.
• Implemented backup/recovery procedures using RMAN, Data Pump, performed database recoveries.
• Performed Large Terabyte size Database Backup including Physical backup through hot backup/Cold Backup of Oracle Database with RMAN.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Defined backup policies for NetBackup and tested RMAN hot backups. Also ensured that file system backups are done.
• Installation of Golden gate Replication 10.4 for one-way replication to a Reporting Database and conversion of streams processes.
• Administration and applying patches to the golden gate.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to help developers.
• Involved in Installation oracle 11g Grid Infrastructure on RHEL5.
• Implemented Active dataguard on oracle 11g with physical and logical Standby
• Worked on Tuning and Troubleshooting the Data Guard Configuration.
• Worked with Developers creating Data Model using Erwin Data Modeler.
• Maintaining schemas and partitioning tables.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Worked on Automatic Storage Management (ASM) .
• Utilized SQL*Loader to load data from SQL Server 2000/2005 databases.
• Schemas refresh using Datapump. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.
• Creating Database Monitoring scripts and batch files for schedule jobs.
• Configured Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file, and virtual catalogs for security.
• Written shell scripts to automate the task for extracting and loading the data.
• Working on enhancement to the existing processes.
• Working on Production Maintenance and change requests (PMRs).
• Tracking all the production changes thru ClearQuest
• Tracking all the problems/requests with production processes thru Remedy tool

Confidential, Des Plains, IL

DBA

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installing 9i, 10g and 11g databases on Solaris and Linux.
• Skilled with AWR, ADDM to check health of database & hardware.
• Using the tools such as tkprof, explain plans, and trace files to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing& capacity planning for Oracle databases.
• Upgraded Oracle version from 9.2.0.4to10.2.0.1 and applied necessary oraclepatches.
• Migration of Databases from Windows to Linux
• Upgrade of Databases from 10g to 11g applying patches whenever required.
• Developed PL/SQL Packages from the scratch which are used for Extract Transform and Load purpose
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using tools such as PL/SQL, Oracle Hints, SQL Trace, Explain plans
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Tuning high resource queries introducing hints and creating indexes/partitions, changing the query if necessary
• Experienced with DataguardImplementation
• Implemented oracle high availability solution using oracle 10g Physical Standby
• Importing data from flat files into database using SQL loader and External Tables
• Experienced in Volume management, Disk Management using veritas volume manager.
• Written shellscripts to automate the tasks
• Physical and Logical database design.
• Mapping of old data fields to new model data fields for data migration
• Worked very closely with development team

Confidential, Farmington Hills, MI

DBA

Responsibilities:

• Responsible for designing the Oracle Database & Schemas.
• Responsible for migration, up gradation from oracle 8i to 9i on Windows 2000/Unix environment.
• Designed and Installed the Oracle 8i, 9i database.
• Responsible for pre-install analysis, activities, and installation of 8i, 9i software on server and clients and post-install testing and analysis.
• 24 X 7 Production Support. Responsible for Backup & Recovery for Oracle Databases.
• Responsible for all post-migration analysis and tuning.
• Responsible for Logical/HOT/Cold backup of Oracle Databases.
• Installed and configured Oracle Dataguard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• Installed & Configured Veritas Net Backup for Oracle on Unix.
• Monitoring and optimizing the performance of database.
• User creation and implemented Security administration by creating roles, views and granting the necessary system and object privileges for users.
• Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning of the database.
• Allocating system storage and planning future storage requirements for the database system.
• Creation of table spaces, tables, views and indexes.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Created Locally Managed tablespaces for better space management and less fragmentation of data.
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges & resources.
• Table partitioning as per database requirement.
• Managing of Tablespace for different user by granting quota on Default & Temporary Table spaces.
• Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical (Online & Offline) Backup. Responsible for UNIX Shell Scripts for Housekeeping.

Confidential

Jr DBA

Responsibilities:

• Contributed in Database Installations, Database Recreations.
• Moving the database on the network 24 x 7 support on pager call duty.
• Troubleshooting and Problem resolution Exports/ Imports.
• Hot and Cold Backups, Shell Scripting, Restoration Space Management.
• Tuning Memory, SGA, I/O, Security Management.
• Objects sizing Strategizing Backups including usage of RMAN Database Recovery, Involvement in Database Migrations.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Assisted application development team with database design and support.
• Snapshots creations, strategizing and troubleshooting, DBA JOBS scheduling, monitoring and maintaining, Jobs scheduling with CRON TAB.
• Grant privileges and Roles to users Created database objects, managed partitioned tables, managed table spaces
• Backups taken regularly using Hot Backup and Cold Backup
• Created both locally managed and dictionary managed tablespaces
• Restored and Recovered using RMAN and user managed techniques
• Performed database performance tuning, stats pack reports automation, stress test on production copy for scalability, resolving production performance issues
• Maintained data integrity by working on constraints
• Query Optimization using Explain plan and SQL trace with TKPROF
• Tuned Oracle database server to suit 100% additional workload from existing 250 users to 500 users.
• Proactively monitored the database and database access, and maintained the database security