SUMMARY

• Around 7+ years of experience as an Oracle Database Administrator, my experience has scaled in providing client support, analysis, designing, development, testing, installation, migration, maintenance and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning and space management using ORACLE 11g, 10g, 9i, 8i, performing the role of Oracle Database Administrator according to the set standards and timelines.
• Extensive knowledge on database administration for Oracle7i, 8i, 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP systems
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g/9i/8i/7.x, OLTP (multiple instances)/OLAP databases in production.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.
• Worked on HP - UX, AIX, Sun Solaris, Linux AS 4 and Windows environments.
• Installed and maintained Oracle 11g/10g RAC with ASM & OCFS2 File systems.
• Proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections).
• Have implemented ORACLE STREAMS for replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for DR and high availability.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager also profound in using the New oracle 11g features in these utilities.
• Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups (using datapump /cold backups), manage statistics, Disk space management.
• Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in ER diagrams, Data Flow Diagrams, Data Modeling using Erwin, Physical/Logical Database designing.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various scripting languages such as Perl, awk and UNIX Shell Scripting.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams (Replication).
• Extensively used BMC Remedy, HP Quality Center ticketing systems & HP Java ITO (OVO) Console for monitoring.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x,11.x, Sun Solaris 2.5,2.6,8,9,10, AIX 5.1,5.2, Red Hat Linux 2.1,3.x,4.x, SCO-UNIX and windows 98/ME/NT/2000/XP

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g Real Application Cluster (RAC), ASM

Tools: and Utilities: RMAN, OEM, TOAD, SQL*Loader, Erwin, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard.

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting, awk Scripting, Perl.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Others: NetApp, Veritas NetBackup, EMC, TSM, HP Data Protector, BRTOOLS (for SAP)

Web Technology: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console

PROFESSIONAL EXPERIENCE

Confidential, Wichita, KS

Oracle DBA

Environment: Solaris 10, AIX, HP-UX, Red Hat Linux 4.x and Windows NT/2000/2003, Oracle 9i,10g,11g, TOAD/SQL Developer, Java ITO Console for monitoring, BMC Remedy, RMAN, Data Guard, Enterprise Manager 10g/11g.

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on various environments.
• Upgraded and migrated from Oracle 10.2.0.4 databases to Oracle11.2.0.2
• Involved in Installation of Oracle 10g/11g - RAC database on Sun Solaris, Red Hat Linux, and HP-UX.
• Resolved many critical issues on Agents, RAC & Data Guard based environments, Flashback (with ASM) enabled databases.
• Resynchronized standby databases when they are out of sync. Also built standby databases using RMAN backups manually & using grid Control.
• Performed switch-over/failover using Dataguard, when there is crucial situation and production went unresponsive.
• Extensively used BMC Remedy ticketing system for production support.
• Coordinated with UNIX administrators for space management on various servers.
• Duplicated, Refreshed, Restored Development/Test/Production databases using RMAN followed by upgrading the databases when necessary.
• Refreshed TEST databases on standard filesystems from Production databases sitting on ASM filesystems.
• Successfully recovered production databases from RMAN backups & oracle flashback feature, due to an unexpected media failure resulting in data corruption errors and loss of control files
• Created Grid jobs in Grid Control to do automatic database refreshes, full/incremental/archive backups.
• Performed many table-level, schema-level, database-level refreshes using Traditional and Datapump import-export utilities.
• Used HP ITO console to monitor health of databases and filesystems.
• Monitored various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability.
• Unix Shell scripting in (c shell) csh, (korn shell) ksh, Perl for automating startup/shutdown of databases, getting system alerts, monitoring purposes, verifying configurations, and various other needs.
• Extensively worked on hang analysis and performance tuning using Oracle grid (ADDM, AWR, SQL access Advisor), and other Oracle utilities.
• Dealt with 2-phase Locks, dead locks, and other blocking session issues in both standalone & distributed databases.
• Used hints, Explain Plan for SQL tuning and optimization.
• Database Performance Tuning, Memory Tuning, Application Tuning. Performed tablespace shrinking when necessary to retain space.
• Used BRTOOLS for SAP databases to alter/add datafiles/tablespaces, update statistics.
• Created Users, Groups, Roles, Profiles, and assigned users to groups and granted privileges and permissions to appropriate groups manually and using Grid Control of Oracle Enterprise Manager (OEM)
• Provided high degree of coordination between user, technical and application to ensure effective database management

Confidential, Milwaukee, WI

Oracle DBA

Environment: Oracle 9i,10g,11g, Solaris 10, AIX, HP-UX, and Windows NT/2000/2003, TOAD/SQL Developer Database Tools/Utilities, RMAN, Data Guard, Enterprise Manager 10g/11g.

Responsibilities:

• Setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM).
• Worked on HP-UX, Linux AS 4 and Windows environments.
• Installed, maintained, upgraded Oracle 10g databases, then Upgraded databases from 10.2.0.4 to 11g.
• Worked on the Oracle 11g RAC (crs) on 10g database implementation, performance optimization & monitoring.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, import/export and SQL Loader, RMAN-managed backup with or without catalog database and implementing backup and recovery strategies.
• Writing scripts in the UNIX based environments for managing and scheduling the user's roles and privileges (security scripts), disk space & tablespace management scripts, scripts for cloning and datapump exports/imports.
• Extensively used the segment advisor from grid control and with PL/SQL packages for effective space management and performance in oracle 10g & 11g compared to import/export of the tablespace/databases till oracle 9i.
• Proactive performance monitoring and tuning - SQL Tuning using SQL tuning Advisor, SQL access advisor, ADDM, profound in analyzing the health of database using AWR, Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes, creating Materialized Views if needed.
• Expertise in Using EXPLAIN PLAN for query optimization, automated scripts to gather & import statistics during non-peaks hours and import them into the system tables to reduce load during peak hours, creation of various types of indexes if needed and performance diagnostic tools like SQL Trace & TKPROF in previous versions of oracle.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, and various scripting languages such as Perl, awk and UNIX Shell Scripting
• Efficiently used the advantages of the New Features of oracle 11g on installation (including DBCA), PL/SQL, SQL Performance Analyzer, Statistics, and Maintenance, ADDM & AWR features, New Security Features, RMAN features, datapump utilities, ASM features and RAC.
• Profound in using SQL, PL/SQL, ETL loading using java based UDL code for small Data Warehouse databases and tuning the nightly ETL builds to optimize the load time.
• Solved critical performance issues, data related issues like duplicate results, data retrieval issues due to flaws in optimizer, raised SR to oracle support and coordinated with them to solve internal error/issues.

Confidential, Chicago, IL

Oracle DBA

Environment: Windows NT/2000/2003, Solaris 10, AIX, HP-UX and Red Hat Linux 4.x, Oracle 9i,10g,11g, TOAD Database Tools/Utilities, Enterprise Manager, HP Quality Center, Query Analyzer.

Responsibilities:

• Installed Oracle 9i, 10g, 11g database on HP-UX 11.0 and Linux.
• Installed and maintained Oracle 10g 2 node RAC and worked on ASM feature
• Installed, configured and maintained Oracle data guard(primary andphysical/local standby databases) to ensure disaster recovery, high availability and data protection.
• Involved in setting up of OEM and Oracle grid control.
• Upgraded databases from 9i to 10g, 10.2.0.1 to 10.2.0.4 and applied patches.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Synchronize Databases with production for data and testing purpose.
• Creating Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups using OEM & SQL commands.
• Involved in migrating databases from HP-UX to Linux.
• Implemented design of physical data storage, maintenance, access and security administration
• Supported data transfer operations - import/export, SQL*Loader and data pump.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Used Logminer utility for precision recovery.
• Cloned Production databases using RMAN, hot and cold backups.
• Expertise in using RMAN for not only backup and recovery strategies but also to validate databases regularly to reduce redundancy and disk space usage.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Handful of experience in performance tuning using the reports generated by AWR, ADDM, Statspack.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Developed database and warehousing designs across multiple platforms and computing environments.
• Utilized advanced Oracle features such as table partitioning, Oracle Streams.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Help and co-ordinate with UNIX Administrators and development team for space management on various servers and help in Oracle installation, upgrading and database issues.
• Active participation in all team meetings and group meetings to meet the business requirements.

Confidential, Cleveland, OH

Oracle DBA

Environment: Oracle 10g/9i/8i, Sun Solaris 9, HP-UX, Windows NT / 2000, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, OEM.

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and windows environments.
• Installation, Configuration and Maintenance of Oracle RDBMS Software, of Logical/Physical standby database in Dataguard and Oracle Grid Control.
• Involved in process improvement, Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Guard, Advanced Replication, Real Application Clusters, Standby.
• Refreshing Development and test instances with data from Production on a regular basis using import/export utilities and RMAN duplicate database.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Upgraded and migrated databases from Oracle 9.2.0.8 to Oracle10.2.0.1 and applied patches.
• Have created database on SQLsqrver2005, backup and recovery.
• Configured Oracle data guard and Streams.
• Analyzed tables and re-built indexes regularly.
• Setup of Jobs (startup/shutdown/export data pump) using the Oracle Grid.
• Setup of the cold backup of test/development databases through RMAN for weekly maintenance.
• Migrated Databases from Oracle 8i, 9i to Oracle10g.
• Designed and implementedDataguard, Supported backup/recovery using Sql backtrack and developed scripts to deploy RMANbackup strategy.
• Automating the routine DBA tasks through the Crontab.
• Improving the performance using the AWR, ADDM, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrievaland processing of queries used for retrieving the data.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Involved in creation of prototype designs against logical data models that defines data repository requirements, dictionaries and warehousing requirements.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Confidential, Basking Ridge NJ

Oracle DBA

Environment: Oracle 10g/9i/8i, Sun Solaris 8, AIX, Red Hat Linux, OEM, SQL, PL/SQL,SQL Plus, Unix, Erwin Data Modeler.

Responsibilities:

• Extensively involved in analyzing the functional requirements for the Database Access Profiles.
• Provided high degree of coordination between user, technical and application to ensure effective database management.
• Implemented Index organized tables to improve the performance.
• Tuning of INIT parameters to improve the performance during data loading.
• Performed Operational Data Store (ODS) using third party tool.
• Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
• Generating the Dataflow Diagrams and ER Diagrams by using Erwin.
• Synchronize Databases with production for data and testing purpose.
• Database system Architecture, Data Modeling, Logical/Physical database design (Dataguard implementation for Disaster Recovery), creation, maintenance, and documentation.
• Help Development team for technical issues related to database issues.
• Involved in running the Access Profile batch jobs.
• Creating the database schema, converting VIEWS specific to database.
• Development of backup and recovery procedures, Import and Export of Data (Logical Backup) and RMAN.
• Creation of the Test database, Table spaces, Tables and Indexes, Index rebuilding.
• Data migration and loading with SQL Loader.
• Used Hints, Indexes, Explain Plan, Sql Trace and Tkprof for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.

Confidential

Oracle DBA

Environment: Oracle 9i, Sun Solaris 8, HP-UX, SQL, PL/SQL, Toad, Developer, Erwin, RHEL 3.x, Windows 2003, OEM, RMAN, Export/Import.

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features and audit mechanisms for Fine grained access control.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Implementing Backup/Recovery Strategies. Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Maintained the RMAN repository and customized recovery catalog.
• Database Restore using RMAN, Cold Backup and Export.
• Refresh schema using Export/Import. Creating the database, tablespaces, tables, indexes, settings privileges and user
• Table Partitioning, creating Index Organized tables, Creating Locally managed Tablespaces.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Confidential

Oracle Developer/ Jr. DBA

Environment: Oracle 8i/9i, SQL, PL/SQL, SQL plus, TOAD, Erwin, Import/Export Oracle Enterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat Linux 2.1

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in function and procedure.
• Used UTLBSTAT, UTLESTAT, Statspack, Perfstat, TKPROF utilities for Tuning and analysis.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Prepare technical documents for all the programs developed & generated.
• Responsible in coding and debugging.