SUMMARY

• Nearly 8 years of experience as Oracle database administrator, providing 24/7 support for mission critical production 11g/10g/9i/8i databases on Various Platforms.
• Excellent experience in Installation and configuration of Oracle 11g RAC/10g RAC/ 9i/8i in UNIX/LINUX and Windows environment
• Implementation of High Availability Solutions using Oracle 11g RAC, 10g RAC, Standby database (Data Guard)
• Involved in Installation, Configuration and deployment of Oracle database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM) and experience in adding and removing nodes.
• Profecient in Database Maintenance. Database Monitoring and the use of advanced tools like Automatic Workload Repository (AWR), and Automatic Database Diagnostic Monitor (ADDM), and well acquainted with Automatic Segment Space Management (ASSM), and automatically shared memory management (ASMM).
• Proficient in Database Administration activities such as Installation, Configuration, Database design, Upgrades, Patches, Performance Tuning, Backup & Recovery, Cloning, Auditing, Troubleshooting, TAR Support, Unix Shell scripting, and Documentation
• Efficient in understanding TCP/IP, DNS and RAID concepts
• Oracle Database Administration in a variety of environments like HP - UX, Sun Solaris, IBM AIX, Red Hat Linux, Microsoft Windows
• Experience in UNIX Shell Scripting for automating the DBA tasks
• Good Experience in Hot/Cold Backups, and Cloning of Databases
• Good Knowledge of RMAN backups.
• Skilled in developing scripts for database back ups including hot and cold backup options
• Extensive Knowledge of ASM, Flashback, Oracle Data Pump
• Proficient in Database Administration activities such as Patches, Upgrades, Migrations, TAR support
• Proficient in using OEM Grid Control
• Proficient in Performance Tuning the applications and database proactively using STATSPACK, TKPROF, SQL TRACE, EXPLAIN PLAN, AWR, ADDM
• Good knowledge in database replications (GoldenGate)
• Experience in Golden Gate replication monitoring, tuning.
• Good experience in creating, managing and merging Partitioned Tables
• Good experience in SQL, PL/SQL, Shell Scripting Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Proficient in using OEM, TOAD
• Good Experience in loading data from flat files to database using external tables and SQL *Loader
• Used ORACLE STREAMS to Replicate Databases
• Used Cron jobs to automate many DBA tasks
• Gathering of CBO statistics using DBMS STATS package
• Good experience in OLTP/DSS, VLDB
• Good experience in installation and administration of SQL server database.
• Involved In data migration from SQL server to Oracle database.
• Result oriented, self-motivated, team player, ability to work independently.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

DBMS & RDBMS: Oracle 8i,Oracle 9i,Oracle10g RAC, Oracle 11g RAC,MS - Access, Sql Server 2005, MYSQL 5.1

High Availability, Tuning & Monitoring Products: Oracle 10g RAC, Oracle 11g RAC, ASM, Streams, Data Guard, Golden Gate, Grid Control (OEM), Tkproof, Statspack. AWRADDM, ASSM

Operating Systems: Solaris 9/10,Linux RHAT 3/4/5, HP-UX 10.x/11.x,AIX 5.2/5.3, Microsoft Windows 2000/2003/2005.

Tools: & Utilities: Oracle SQL Developer, TOAD, RMAN, Export/Import, EXPDP/IMPDP, SQLLoader, OID, Golden Gate

ETL & Reporting Tools: Informatica 5.1 Power Center 8.5/8.0,Data Stage6.0,1.0Business Objects Xi R26.1, Oracle Data Integrator.

Backup Tools: Veritas NetBackup, NetApp, HP OmniBack, TSM,EMC

MS Office Tools: Excel, Word, PowerPoint, Outlook, Visio

Programming Languages: C,Asp.Net, XML,HTML,DHTML,CSS

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Oracle DBA

Responsibilities:

• Build and configuration of various 11gR2 standalone databases on AIX 5.3.
• Installed and configured oracle 11gR2 RAC on AIX 6.1
• Upgraded 10g CRS and ASM to 11g Grid.
• Migration of code from development to production instances, database space and file system space monitoring, purging of unwanted data and files.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including Database locking, Database corruption, Low disk spaces and Performance issues.
• Performed database migrations from 10g RAC (10.2.0.4) to 11gR2 RAC (11.2.0.2).
• Installed and Configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (data-guard) using CRS and ASM .
• Added nodes to the RAC cluster for the increased load and removed it when not necessary.
• Applied CPU and quarterly patches in the development and production environments using Opatch utility.
• Assisted developers with various aspects of database and in SQL/PLSQL tuning.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Developed UNIX Shell scripts for daily database logical backups, data retention, purging and other scheduled database procedures
• Installed foglight and OSWatcher on various database servers.
• Worked with Oracle support to resolve database critical issues.
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication
• Installed Oracle Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Provided 24/7 on call support.
• Consulted frequently and participated with the database design team and adhered to the business rules and maintained documentations and standards.
• Monitored and managed databases to maintain high level of performance and availability as well as performed other routine DBA tasks.
• Used Data Pump Import/Export to move data.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP
• Scheduled jobs using Oracle Job Scheduler

Environment: Oracle 11g/10g, RAC, Data Guard. Sun Solaris 10/9, HP-UX, AIX5.3/6.1, RHEL, OEM, Explain Plan, Tkprof, SQL*LOADER.

Confidential, Philadelphia, PA

Sr. Oracle DBA

Responsibilities:

• Involved in 24x7 support for Production database and applications with on-call pager
• Installation and creation of 11g RAC, 10g RAC and 9i databases for Testing, Development and Production
• Supported upgrades from oracle 9i to 10g, 9i/10g to 11g.
• Performed migration from 10g to 11g.
• Supported development, implementation and maintenance of sql server database.
• Supported migration, and performance tuning on sql server database.
• Installed and configured oracle 10g/11g RAC for high availability
• Creating and Managing Table spaces with different block sizes to prevent row chaining
• Data Refresh from Production to Test and Development environments using manual method and RMAN Duplication
• Resolving Performance issues
• Involved in Golden Gate installation
• Created users account for the Golden Gate and granting privileges.
• Involved in one-way and bi-directional replication with Golden Gate
• Worked on installation of the Golden Gate on Oracle 10g R2 and configuring archive log directories
• Cloned environments to create patch test, development and QA environments.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, STATSPACK
• Setup of Standby Database(Data Guard). Performing Failover and Switchovers
• Load balancing, Database/Schema/Table Re-Organization for faster performance using export/import & move procedures
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM
• Rebuilding of Indexes for better performance, maintenance of Oracle Database
• Implemented Database Replication using ORACLE STREAMS
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contentions
• Taking periodic Backup of the Database and the software using RMAN and VERITAS NETBACKUP
• Scheduled jobs using Oracle Job Scheduler
• Partitioning large objects for better performance.
• Scripts for Cold Backup, Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption)
• Installation and configuration of Oracle Client software and Tools
• Created Scripts to query performance views to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and the PGA
• SQL scripts to monitor Table spaces and Extent growth
• Writing UNIX shell scripts for backup and recovery, import and export procedures.
• Experience in using UNIX utility commands such as grep, awk and sed.
• Monitoring and Optimizing Database Performance

Environment: Oracle 11g RAC/10g RAC/9i, ASM, HP-UX, Sun Solaris, Red Hat Enterprise Linux, OEM, Explain Plan, Tkprof, SQL*LOADER.

Confidential, Columbus, OH

Sr.Oracle DBA

Responsibilities:

• Involved in 24x7 support for both Production and Development databases
• Installation, creation of 10g RAC and 9i databases for Testing, Development and Production
• Performed Cloning/Refresh to setup Test and Development databases
• Installation and Maintenance of Standby database
• Upgradation/Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches when required
• Responsible for optimizing the queries and application tuning
• Partitioned large tables to increase the performance
• Implementing Range, List, Hash Partitions
• Creating and refreshing Materialized views
• Performed SQL Tuning and assisted developers with coding PL/SQL
• Performance tuning of Oracle Database Objects by fixing row chaining
• Performed the daily Maintenance Tasks and Health Check of the Database
• Performance Monitoring using OEM 10g Grid Control
• Created scripts for hot backup on a daily basis scheduled with cron jobs and Autosys conducting sizing & capacity planning for Oracle databases Implement “stored procedures and triggers” based on business plans using PL/SQL
• Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups
• Performed Switchovers and Failover drills
• Continuous monitoring of the Database and troubleshooting the issues, if any
• Responsible for setting and managing user accounts, granting required privileges to users
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK, AWR, ADDM
• Tuning heavy data loads
• Applied Security Patches from Metalink when needed

Environment: Oracle 10g RAC/9i, Red Hat Enterprise Linux 4.x, IBM AIX, DATAGUARD, ASMReplication, Explain plan, TKprof, PL/SQL

Confidential, Richmond, VA

Oracle DBA

Responsibilities:

• 24 X 7 Production Oracle database support and administration and on call rotation.
• Installation, Configuration and Administration of Oracle 10g databases includes Database cloning for test environment and applying patches, tuning etc.
• Upgraded databases from Oracle 9i to Oracle 10g
• Converted a single instance database to Oracle RAC 10g.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Configured the Public Network/Private Interconnect for Oracle 10g RAC.
• Involved in Database migration from Oracle9i to Oracle 10g.
• Oracle Applications 11i administration support
• Setting up and testing the backup and recovery strategies.
• SQL, PL/SQL, Shell Scripting
• Oracle Database and SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF etc…
• Used External Tables to Load data from flat files to database.
• Implemented different Partition methodologies to improve performance and manageability.
• Oracle Database and Oracle Applications cloning/refresh
• Monitored and effectively tuned the 11i database instances by utilizing own scripts, Oracle Statspack utilities.
• Involved in database administration including 10g RAC Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases and applications.
• Cloned/Refreshed environments to create patch test, development and QA environments
• Created scripts to monitor and manage the databases.
• Performed hot, cold, tablespace level backups.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades
• Recovered the 11i instance production database as a result of data corruption by successfully applying the archive redo log files

Environment: Oracle 10g RAC/Oracle 9i, Oracle Applications 11i, IBM AIX, Sun Solaris, Red Hat Linux.

Confidential

Oracle DBA

Responsibilities:

• Supporting production database system 24*7
• Senior DBA, Primary point of contact for client for production database support
• Installation and Configuration of Oracle 10g RAC
• Migrating Oracle databases from windows to Linux
• Developer Environment Setup, Support, Cloning and Refreshes
• Performed database cloning to setup test and development database
• Used RMAN for backup and recovery. Performed backup validations using RMAN
• Implemented Hot, Cold and Logical backup plans
• Database patching using opatch.pl Perl script
• Proactive database monitoring using 10g grid control
• SQL tuning using Statspack, AWR, Explain plan, Tkprof
• Installation, Configuration and Maintenance of Logical and Physical Standby databases
• Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, Data warehouse, and Business object repositories. Fix backup failures, address and implement resolutions
• Conducting sizing & capacity planning for Oracle databases
• Storage and space management including table spaces and data files
• Management of table space growth, monitoring data files additions, extent growth
• Upgraded Oracle 8i, 9i databases to Oracle 10g
• Applied patches to Oracle Databases
• Monitoring Growth of tables and undertaking necessary re-organization of database objects as and when required
• Responsible for optimizing the queries and application tuning
• Oracle Database monitoring, troubleshooting and resolved the issues
• Management of schemas, objects partitioning the tables & indexes

Environment: Oracle 10g/9i RAC,IBM AIX, Sun Solaris, Red Hat Linux, Windows 2003, Streams, SQL*Plus, Grid Control, TOAD