SUMMARY

• 7+ years of experience as Oracle Database Administrator with extensive knowledge and experience in Oracle (8i/9i/10g/11g). Experience in test, development and production databases as well as Online Transaction Processing (OLTP) and Decision - Support System (DSS) database.
• Expert in Installing and Configuring the Oracle Databases (8i/9i/10g/11g) RDBMS, Performing Preinstallation and Postinstallation tasks and Using Oracle Flexible Architecture in RHEL, Sun Solaris, HP-UX
• Expert in RMAN-Managed backups in catalog & nocatalog mode to create full database backups, incremental backups, consistent and inconsistent backups according to SLAs and using VERITAS Net Backup
• Experienced in configuring Dataguard in Oracle 10g with physical standby database
• Ability to use Flashback drop, Flashback Query, Flashback Table features in Oracle 10g databases to recover from user errors
• Frequently performed User-Managed Backups such as Cold Backups, and Hot Backups manually as well as using scripts
• Implemented Export and Import using original Export/Import method in Oracle 9i Databases and Data pump in Oracle 10g Databases
• Experienced in writing Shell Scripts and Scheduling automatic Hot Backups and RMAN Backups using CRONTAB on Linux Operating Systems
• Experienced in Designing, Installing, Configuring, and Maintaining Real Application Cluster (RAC) Database for high availability of in Oracle (10g/11g) Databases
• Ability to use Automatic Shared Memory management, Automatic Storage Management and Automatic Undo Management to manage Oracle (9i/10g/11g) databases
• Familiar with Tablespace Point-in-time Recovery (TSPITR)
• Experienced in Cloning Databases using traditional method and RMAN Duplicate command
• Experienced in Performance Tuning using EXPLAIN PLAN, SQL TRACE, 10046 Trace Event, Trace Analyzer (TRCA), Statspack, Utlbstat, Utlestat, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM)
• Experienced in Loading and Transforming Data using SQL*Loader and External Tables
• Extensively used Toad, Putty, and SQL Developer tools
• Expert in creating databases both using Scripts and Database Configuration Assistant (DBCA)
• Expert in Upgrading from 9i to10g and 10g to 11g both in traditional manual method and Database Upgrade Assistant (DBUA) method
• Clear understanding of Oracle (8i/9i/10g) Architectures
• Expert in creating schema objects such as Tablespaces, Tables, Indexes, Constraints, Views, Materialized Views, Synonyms, Sequences, and Triggers
• Thorough understanding about Oracle Enterprise Manager(OEM) Architecture
• Experienced in Installing and Configuring OEM Database Control, OEM Grid Control
• Expert in User Management and Database Security operations such as creating users, roles and granting roles and privileges
• Experienced in Troubleshooting various failures such as Media Failure, Instance Failure, Network Failure, User Errors, User Process failure and Statement Failures
• Comfortable working on Operating Systems such as RHEL (4.0/5.0), Sun Solaris (5.6/5.7/5.8/5.9 ), AIX (5.2/5.3), Ubuntu, Cent OS 5.0 and HP-UX (9.0/10.0/11.0 )
• Provided 24/7 on-call support and production support for mission critical databases.
• Strong interpersonal, documentation and communication skills

TECHNICAL SKILLS

Installation & Configuration: Interactive Method and Silent Method (Response File).

Scripting: Shell Scripting (Bash & Korn)

Oracle Net Configuration Tools: Netmgr, and Netca Data Loading

Backup and Recovery tools: SQL*Loader, Data Pump, Export/Import, RMAN, Flashback and VERITAS

High Availability: Real Application Clusters (RAC), Dataguard, Automatic Storage Management(ASM)

Performance Tuning: EXPLAIN PLAN, TKPROF, SQL Trace, Data Dictionary Views, Dynamic Performance Views, Trace Analyzer (TRCA), 10046 Trace Event, SQL Tuning and Access Advisors, Undo Management Advisor, Memory Advisor, MTTR Advisor, Segment Advisor, AWR and ADDM.

Languages: SQL, PL/SQL, JSP, C, Shell Scripting and C++.

Web Designing: HTML, DHTML, DOTNETNUKE, .NET

Operating Systems: UNIX, Sun Solaris (5.6/5.7/5.8/5.9 ), RHEL (4.0/5.0), Windows NT, Windows 98/2000, Windows XP, HP-UX (9.0/10.0/11.0 ).Certification Oracle Certified Associate (OCA) on Oracle 10g/11

PROFESSIONAL EXPERIENCE:

Confidential, CA

DBA

Responsibilities:

• Created and Maintained 11.2.0.2 and 10.2.0.4 RAC and Stand-alone databases
• Devised and implemented backup strategies for hot, cold, export and RMAN
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• Reorganized large partitioned tables regularly in order to gain space by eliminating fragmentation across the board
• Created and Maintained the Physical standby databases using one of the high availability solutions using Dataguard
• Participated in monthly refreshes of several marketing environments which were mainly used for generating reports using NFS mount and RMAN restore
• Monitored RMAN incremental level 0 and level 1 backup for all the environments
• Created capacity planning documents on a weekly basis to keep track of resources consumed
• Performed restoration of tables using data pump ( Expdp / Impdp ) as well as original export/import
• Carried out the day-to-day activities such as creating users according to access policies, maintaining tablespaces and administering database sessions
• Improved the performance of database by creating and managing database objects such as tables, indexes, partition tables, index organized tables, material views and views
• Performance tuning RAC, applications, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/Logical IO and Memory Usage
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks
• Experienced in using utilities like Export/Import and SQL Loader

Environment: Oracle 10g / 11gr2, ASM 10g, CRS 10g/11g, Dataguard, RMAN, RHEL 5.5, OEM 10g, EMC, OCFS

Confidential, Charlotte, NC

DBA

Responsibilities:

• Applied numerous numbers of one-off patches, RAC bundle patches, CPU patches, and CRS patches on 10g/11g environments
• Created database and ASM instances on Oracle 10g/11g
• Tuned memory parameters for according to the nature of the database
• Assisted application developers in writing efficient PL/SQL code such as packages, stored procedures, functions etc
• Managed and Implemented code releases of several applications on DEV, QA, UAT, PROD databases
• Tuned performances of Databases as a whole using AWR/ADDM/ASH reports and individual queries from applications using tools like 10046 trace, EXPLAIN PLAN, TKPROF etc
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Maximum Extents, Coalescing using CRONTAB
• Migrated 10g databases from Non-ASM to ASM file system including standby databases
• Installed, Configured and Upgraded Oracle Clusterware ( 11.1.0.7 ) and RDBMS software ( 11.1.0.7 ) on Solaris boxes
• Experience in creating partitioned tables and adding, dropping, splitting, and merging daily, monthly, Weekly and yearly partitions and collecting statistics for them to improve performance using scripts and manually
• Managed, developed and implemented the RMAN back up scripts for the databases as a part of day-to-day activities
• Tuned the backup scripts by coming up with incremental back up strategies
• Installed, Configured and Upgraded oracle agents (10.2.0.4/10.2.0.5 )

Environment: Oracle 10g/11g, ASM 10g, Solaris (5.9/5.10), RMAN, OEM 10g, VERITAS Netbackup

Confidential, Chicago, IL

DBA

Responsibilities:

• Installation, configuration of Oracle 10g database RAC, and Data guard/Standby switchover/failover technologies to reduce database downtime
• Database Administration, Support and monitoring to ensure proactive problem recognition and resolution of database issues
• Actively participated in upgrade and Migration of production and development Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required
• Performed daily database administration tasks like user management, web connectivity, space monitoring and management, performance monitoring and tuning
• Plan and perform point - in-time recovery of databases as part of disaster recovery implementation
• Installed 10g management agent for Grid control monitoring and Setup, maintain 2-node RAC databases
• Monitor full and incremental backups by using Recovery Manager (RMAN)
• Configured OEM (grid control) 10g for diagnosing and monitoring performance related problems
• Write SQL/Unix Shell Scripts for gathering capacity planning information and compiling estimates based on new client requirements
• Monitor logical Backup and Recovery by import & export, Datapump, for databases
• Troubleshooting, analyzing explain Plan, STATSPACK reports and tracing user sessions for performance analysis
• Ensuring high availability of Production, Test, and development databases for users to minimize database downtime
• Performed database cloning to setup test and development database

Environment: Oracle 10g Release 2, RAC 10g, IBM-AIX 5.3, Oracle Enterprise manager (OEM) database control

Confidential, Chicago, IL

DBA

Responsibilities:

• Administered Oracle 9i database installation, creation, modification, and tuning issues of Oracle
• Database Security Administration involving creation of users, managing their roles and privileges
• Configured database using the latest features of Oracle 9i like Undo - Tablespace, Locally Managed Tablespace and Sorting Parameters
• Experience in Installing/Configuring and Maintaining Oracle9i Real Application Cluster (RAC) Database for High Availability, Scalability and Performance which includes determining the Cluster architecture choosing the best MPP RAC servers and hardware configuring the raw disks for Oracle RAC
• Analyzed the database as to allow Oracle optimizer to choose best plan in executing the queries
• Performed capacity planning and sizing of databases based on input from business
• Performance tuning of Oracle 9i/8i databases including optimization of Oracle init.ora, Oracle SGA, memory tuning
• Install, upgrade, configure and apply patches to Oracle server and application software
• Creating users, granting the permissions and coping with the day-to-day demands and troubleshooting their connectivity, permissions, lock contention and performance problems
• Worked with users to determine system requirements
• Understanding the existing Database Structure and suggesting the database reorganization
• Pinning most widely used Tables/Objects in the Oracle Shared Pool
• Tuning the Database Operations. Range Based Partitioning for Large Tables
• Using Materialized Views/Views for Generating Reports
• Wrote SQL scripts for DB monitoring, and online backups
• Implemented Oracle Replication setup using oracle materialized view to collect data from different table
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks
• Experienced in using utilities like Export/Import and SQL Loader

Environment: Oracle 9i, RAC, Solaris 5.8, RMAN,, SQL*LOADER, Oracle OEM, Import/Export Data pump, STATSPACK

Confidential

DBA

Responsibilities:

• Installed and maintained Oracle 8.x for development, testing and production purposes
• Installing and loading new patches necessary for Oracle and other applications relevant to Oracle
• Managed and resolved design issues during development
• Moved database Schema changes to stage or production
• Created and maintained UNIX scripts for Oracle maintenance and statistics
• Performed daily database administration tasks like user management, web connectivity, space monitoring and management, performance monitoring and tuning
• Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check reports for space, Maximum Extents, Coalescing using CRONTAB
• Performed database cloning to setup test and development database
• Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment
• Created tables, views, index, partitioned tables, and cluster table
• Tune application with EXPLAIN PLAN, and TKPROF
• Configure databases for adequate performance and availability
• Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database
• Monitor logical Backup and Recovery by import & export, Data pump, for databases
• Implemented backup/recovery and database monitoring strategies using Unix Shell scripts and Oracle enterprise manager

Environment: Oracle 8i, Win-NT/2000, HP-UX 10.0/11.0, OEM, STATSPACK, RMAN, ftp, SQL*Loader, ERWIN, TKPROF