SUMMARY

• Over 7 years of extensive experience as an Oracle Production Database Administrator on versions 11g/10g/9i/ on different UNIX Platforms.
• Expertise in Installation, Configuration, Upgradation, Patching, Migration, Trouble shooting and Performance tuning of oracle 8i/9i/10g/11g databases on UNIX, LINUX and Windows environments
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for off - line and on-line Backups.
• Hardworking, result oriented good interpersonal and communication skills
• Experience in working with RAC environment.
• Created and configured Data Guard (Standby Database)
• Experienced in Oracle 8i/9i/10g features (RMAN Duplicate database, Data Guard, and Standby Database).
• Worked in performance tuning in SQL, database server configuration, Shared Pool and Buffer Cache.
• Strong experience in OEM (Oracle Enterprise Manager), Oracle Data Guard, SQL* Net, SQL * Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Experience with standby (Data Guard) databases configuration and maintenance.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Good knowledge of Flashback Technology, Flash recovery Area, Automatic Storage management (ASM) and RAC.
• Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Experience in migration from Oracle 9i to 10g using direct and indirect methods.
• Supporting development 24/7 production systems. Providing on call support for mission critical applications.
• Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Performing tuning of application with RBO, CBO, using SqlTrace, Tkprof, and Explain plan, Statspack, AWR and ADDM.
• Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL Navigator, and SQL* Loader, Data Pump (expdp/impdp).
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Experience with testing and pre-production and production of Oracle 10gR2 with 2 node RAC on Red Hat Linux with ASM
• Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, backup/recovery, patches, monitoring, export/imports and SQL loader.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Good exposure on Data warehouse ODS and Reporting services.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, and volatility of the data, recovery time allowed etc.
• Implemented data replication through materialized views.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, OOPS, JAVA, Visual Basics

Script and Markup Languages: Unix bash shell programming, HTML, Windows Batch files

Internet Web Servers: Apache, Java Web Server (1.1.3,2.0), Oracle Web/Application Server (3.0,4.0,9iAS), Familiar with Weblogic and Websphere

OS & Administration: Sun Solaris, HPUX, Linux, NT/2000/2003, Novell Netware.

Database: Oracle 9i,10g, 11g

Concepts and Administration: Data Guard (Standby)

Real Application Cluster (RAC): Automatic Storage Management (ASM)

Data Guard: OCFS

Database Control: Grid Control, MS SQL Server

PROFESSIONAL EXPERIENCE

Confidential, Iowa

Oracle DBA

Environment: Oracle 9i, 10g, 11g RAC, ASM, Linux, Solaris, Data Guard, GoldenGate

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 10g and 11g clients/databases on Solaris and Linux.
• Complete Build of 4-node 10g RAC Cluster on RHEL 4 from scratch.
• Migrated 10g database to 11g R2.
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Conducting sizing & capacity planning for Oracle databases.
• Migration of Databases and applying patches whenever required.
• Developed 10 PL/SQL Packages from the scratch for monitoring purpose.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management 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.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farm house.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Tuning high - resource queries introducing hints and creating indexes/parturitions, changing the query if necessary
• Configured and Maintenance of SQL Server databases
• Implemented 10g, 11g Physical Data Guard.
• Implemented Oracle high availability solution using oracle RAC, Physical Standby and GoldenGate.
• Importing data from flat files into database using SQL loader and External Tables
• Written shell scripts to automate the tasks
• Physical and Logical database design.
• Database sizing, Capacity Planning.
• Worked on relational modeling using ERWIN.
• Worked very closely with development team

Confidential, Falls Church, VA

Oracle DBA

Environment: Oracle 10g RAC, ASM, AIX, Linux, Solaris, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Datapump, STATSPACK

Responsibilities:

• Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
• Maintaining databases from all the environments from all pre production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
• Experienced in ORACLE 11g installation, configuration, and upgrading.
• Experience with rolling upgrade to Oracle 11G RAC.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle
• 10g RAC on AIX and HACMP.
• Worked extensively on a 2 node RAC on EMC SAN with ASM, ~4 TB including
• Installation, Configuration, Upgrading, Migration and Maintenance.
• Configure, maintain and deploy the Data Guard and grid control.
• Installing and maintaining Oracle GRID CONTROL
• Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
• Worked extensively on Oracle Streams.
• Troubleshoot OCFS2 install issues and working with Enterprise Manager.
• Design and implement Auditing and other security features for the existing Production systems.
• Worked with system administrators, business analysts in designing and implementing backup and recovery procedures using RMAN, SAN based backups using EMC BCVS
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Migration from Linux to Solaris and 32 bit to 64 bit.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Good working knowledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to the requirements.
• Working knowledge on UNIX administration on AIX server.
• Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.

Confidential, San Mateo, CA

Oracle DBA

Environment: Production and Non-Production on Linux/ Confidential UX and NT.

Responsibilities:

• All the daily database administration tasks including backup and recovery thru RMAN,
• Import/Export, grants and roles etc.
• Monitor production and non-production 40 database thru Grid Control.
• Optimized queries and generated graphical SQL results from Grid Control. Starting and shutting down and configured agents for various different maintenance tasks
• Installing, Monitoring, Upgrading Oracle 9i/8i/8.0
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Perform Backup and Recovery thru RMAN.
• Full fill developers request to refresh schema's on a daily basis.
• Resolved db performance issues.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.