SUMMARY

• Total 6+ years of experience as Database Administrator in Production, Development and Testing Environments.
• Responsible for, both manage and support all Production, Development and Staging instances of Oracle Version 8i, 9i, 10g and 11g. Managing Very Large Database. Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, DataPump tools.
• Experience in project life cycle includes Requirement gathering and Analysis, Database design, Database development (SQL, PL/SQL), Test, Implementation & Support. Upgrading and Migrating of Database from lower version to higher version.
• Experience with Enterprise Manager Grid Control. Backup: Using OS backup (Hot and Cold).Oracle backups, generally through Export - Import utilities, also through Recovery Manager (RMAN). Worked on Database Performance Tuning, SQL Tuning and Optimization.
• Worked with SQL& other tools including creating database objects like tablespaces, tables, views, indexes. Administrating Database in various platforms like WIN 2003/2008, SUN SOLARIS 8/9, HP UNIX and Red Hat Enterprise Linux.
• Maintaining data integrity and tune database for optimum performance and availability. Excellent in troubleshooting Oracle Network issues. Quick learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Designed a solution with timelines by planning the Data Center Migration using standby configuration.
• Data Center Migration options used are Export/Import with DataPump, Cross-Platform Transportable Table space and Application specific methodology to capture changes and replay.
• Ability to move a group of databases within the same downtime window.
• Installation, Configuration and Automation of Oracle DBA Monitoring Tools. Ability to support and work within standard software development life cycle (SDLC) practices. Applying Patches for Database& Upgrading Database Versions.
• Implemented Graceful Switchover and Switchback between Production and Standby Databases. Ability to handle Projects and worked efficiently with other team members, Project managers, System Administrators & Application Developers. Also refreshing Database as per the requirements of the clients (CLONING).
• Implemented Disaster Recovery for Oracle Databases in Production.
• Evaluated and ensured the efficiency of application database backup and recovery procedures.
• Ensure that the database systems are well documented and that documentation is maintained in a timely fashion Develop and publish database administration best practices.
• Ability to perform database code migration, change management and data management through the various stages of the development life cycle.
• Ability to independently investigate, analyze and troubleshoot problems, to determine and provide accurate resolution and root cause.
• Good experience in 24/7 Production Environment Support.
• Excellent communication skill & Interpersonal skill.

TECHNICAL SKILLS

Database: Oracle 8i/9i/10g/11g with Real Application Clusters, Dataguard

Application Server: Oracle 8i, 9i, 10g,11g, MS Access, (DBA admin) Oracle - Advanced Database, Backup Recovery, Database Architecture, System Architecture, Server Manager, (Tools) SQL, Exports/Imports

Oracle Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, TKPROF and STATSPACK, AWR, ADDM, OEM, ODM, Datagrid control, Dataguard, RAC, STATAPACK, TKPROOF, Replication, export, import, Datapump, Transportable tablespaces

ERP: Oracle DBA, Business Analyst, SAP - Business One Module

Languages: SQL, PL/SQL

Backup Tools: Cold, Hot, Export/Import, RMAN

Operating System: Linux, UNIX, Solaris and Windows 2003/2008, XP, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential, IL

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Worked on database performance tuning, data backup, recovery, architecture, security processes / procedures and Oracle Auditing in compliance with SOX/PCI policies.
• Defined, documented and automated maintenance procedures to be used by offshore team in support of the environments.
• Shared rotating on-call responsibilities for incident escalations, peer reviews and approving tasks prior to implementation.
• Performed some continuous capacity planning and analysis of existing infrastructure usage as it pertains to both physical and logical CPU memory and storage.
• Worked with remote and on-site resources in the planning and coordination of project implementation tasks.
• Was responsible for incident management, identification, documentation and resolution while in an on-call rotation.
• Accountable for partnering for application development and support teams on company project initiatives and is responsible for the project estimation review, capacity analysis, design, validation of standards and successful implementation of core responsibilities in a timely manner by even supporting internal technical support teams to design, implement and support database disaster recovery plans.
• Performed Database upgrade patching including the planning, testing and analysis using SQL Performance Analyzer to determine execution plan changes with 11g.
• Involved in strategic planning of upgrades and CPU/PSU patch rollouts across the enterprise.
• Used Datapump Export/Import Utilities for User migration, Tables, Databases, etc.
• Configured and done tuning of the Oracle RAC infrastructure using ASM in accordance to cluster configuration.
• Ability to configure cluster databases and worked extensively with cluster configuration standards and an ability to troubleshoot RAC related OS and network integration issues on Linux and/or Solaris platforms.
• Also, worked on cluster cloning from binary backups.
• Implemented RMAN - including cloning, recovery with and without catalog, catalog maintenance, archive management and catalog reporting.
• Also, held accountable for Virtual Tape libraries and the configuration requirements and monitoring of RMAN using Net Backup.
• Worked on OEM - agent management, application-tier management and configuration Gateways - Configuration and management.
• Implemented Dataguard/Standby database both logical and physical.
• Performed Disaster Recovery on a quarterly basis in integration to other environments in the company.

Environment: Oracle 11g/10g/9i, UNIX, Linux, Sun Solaris, Toad, SQL Developer, ASM, Dataguard, Disaster Recovery, Grid Control, SDLC, SOX/PCI Audit, Audit Vault.

Confidential, Wilmington, DE

Oracle DBA

Responsibilities:

• 24/7 support for 200+ Production/Development/Testing databases.
• Worked on Database upgrades from 10g to 11g for 30 database in span of 3 months. Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Creating new databases, configuring backups and maintaining the databases. Tune the databases and SQL queries. Backups using vendor specific tools and Oracle utilities like RMAN. The tuning and indexing the database and schema for efficient query execution plan.
• Provide Primary CARE DBA support for Oracle Administration, Configuration and Maintenance of RAC (Real Application Cluster) and Non-RAC Databases. Work within the production support team and maintain operational consistency and efficiency.
• Provide input to the Project and Enhancement teams to define database storage structures (tablespaces) after application developers have designed an application. Implementation of reviewed changes to the production databases. Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Used Export/Import to do table level and full database defragmentation. Provided on-call production database support. Creating Indexes and Monitoring Performance. Data loading using SQL Loader (from Text files to Database). Perform Daily Logical backups using exp.
• Extensive testing of all mission critical databases at different level (unit, system, integration)
• OEM 10g Grid Implementation for Production Monitoring.
• Application of Oracle 11g upgrade for OEM Grid.
• Oracle Enterprise 11g R2 installation and configuration in Linux.
• Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC. Performed SQL Tuning by using explain plan and TKPROOF.
• Daily Monitoring Database and Tablespaces Growth and Monitoring Space Availability at operating System.

Environment: Red Hat Linux, Sun Solaris 9.0, RHEL 5.2, PL/SQL Developer V6, TOAD, ERWIN 7.x, ASM, Dataguard, Oracle 11g/10g/9i RAC, Oracle 11g, Auto-sys, SDLC, Plan view, SQL*PLUS, OEM, Grid Control.

Confidential, Boston, MA

Oracle DBA

Responsibilities:

• Primary DBA for production, development and testing databases. Install and configuring Oracle database 9i, 10g, Linux. Implemented 10g flashback database features. Extensively worked on SQL Tuning using AWR, ADDM, ASH and tuning advisor in Oracle 10g.
• Cluster Database Installations and Upgrades (9i to 10g, 10.1.0.2 Patchset to 10.1.0.4 Patchset, 10.1.0.4 Patchset to 10.1.0.4.2/10.1.0.5 Patchset and 10.1.0.4.2 Patchset to 10.2.0.0 Patchset). Handling Critical, Emergency Issues in All Production Environments and On Call Support over the weekend (24X7 assistance).
• Oracle) Upgrades from 9i to 10g and Maintenance of Application Server Components like Email, Files, Content, I-meeting etc. Maintaining and Administer Oracle Databases and Applications.
• Oracle Enterprise Manager (OEM 10g) installation, configuration and implementation.
• Maintaining the existing OEM and customize monitoring environment.
• Monitoring and performance tuning.
• Supporting, monitoring & tuning the database subsystems & instances, this includes starting and stopping the instances, listeners.
• Carrying out application performance tuning and testing.
• Review SQL performance and Tuning.
• Critical Patch Update on all Oracle Components in every quarter. Capacity planning for all the Production and Stage Servers (Performance Analysis, Storage Growth and Automatic Storage Management and Grid Implementation).
• Gather Database and User Level Statistics and Analyze Overall System Performance. New Production/Stage RAC (Real Application Clusters) and Non-RAC Database Environment Setups, configurations, maintenance and administration. Applying Database patches.
• SQL/Database Instance Tuning by running AWR/ADDM reports, Using SQL trace and analyzing trace files generated with trace events (High level of tracing of Optimizer and SQL performance with events 10053 and 10046 etc.), recommend any changes required.
• Database Backup/Recovery - Monitoring hot backups and Monitoring Archive log Destinations (Setup RMAN Repository and writing Backup and Recovery Scripts). High Availability - RAC, Standby Setups. Logical and Physical Database Design (Structural Design of Databases).
• Tablespace Management, objects creation and user management.

Environment: Oracle 10g/9i, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, Stats pack, SQL* LOADER, Windows 2003.

Confidential, Herndon, VA

Oracle DBA

Responsibilities:

• Responsible for 24 X 7 Production database administrations, support and monitoring. Coordinate and work closely with the Application team, gather requirements from application team. Design database storage layout plans based on requirements of application team for databases.
• Tweak databases for performance and tuning using Explain Plan, hints, AWR/ STATSPACK and Enterprise Manager. Moved database Schema changes to stage or production. Planned, tested and implemented backup strategies using RMAN, Oracle Utilities (Export/Import) and OS methods.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables. Created and configured an OLTP replication database for disaster recovery purpose.
• Troubleshooting and Tuning of production & RAC databases.
• Configure listener and local service names to use load balancing, failover, dynamic service registration and multi-threaded architecture for shared servers, RAC and dataguard databases. Also use naming servers, hostname and service name resolutions depending on the connections requests.
• Worked extensively on 10G grid control especially monitoring the database, configuration of different notifications, installing and configuring agent, listener and databases and adding them to the grid control. Worked on setting up off Oracle dataguard for the production database.
• Worked with backup team and was responsible for configuration and implementation of backup strategies using RMAN. Monitoring of file system, Tablespaces and OEM during ETL loading. Most recently Implemented Apps 11i and 10g as Portal integration. Proficient in using Oracle Enterprise Manager.
• Evaluated new features and enhancements in later versions of Oracle (10g) for possible implementations like Data Pump (EXPDP/IMPDP), Transportable Tablespaces, External Tables and Partitions.
• Worked on Database Resetting and Database Cloning. Cloning of various databases using various methods including create control file, RMAN. Define, enforce, document & track standards for managing databases in terms of capacity, integrity, security, performance and version control.

Environment: SQL, TOAD, RMAN, TKPROF, STATSPACK, SQL* LOADER, Windows 2003, DBCA, Dataguard, HTML, Java, XML, Load Runner 8.0, TOAD 8.1, UNIX, Linux 4.0.

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Participated in design discussions to support project and baseline work. Worked with application development staff to develop database architectures. Installing, configuring and managing Oracle 10gRACcluster and ASM. Intensively worked on OEM Grid.
• Installation of patches and performed server software upgrades to latest releases of Oracle 9i. Plan database capacity and growth. Created and configured Datagaurd. Designed and implemented a failover solution based on an Oracle 9.2.0.7 standby database and developed scripts to monitor the transfer of archived redo logs.
• Installing and setting up management server and enterprise manager. Generate and analyze STATSPACK reports and monitoring statistics for performance tuning of databases. Development support, coding standards, application n& database tuning. Used OMS to gather the statistics highly efficiently.
• Used AWR&ADDM for database performance and statistics. Managed day-to-day production databases. Created and managed users, roles and profiles, audited and monitored databases and user access. Created database objects, managed partitioned tables, managed tablespaces.
• Monitored and tuned the Shared Pool, Database Buffer Cache and Redo Log Buffers for best performance. Troubleshooting and Recovery of Database from Data file losses. Backup and Recovery involving archiving, redo logs, data files using RMAN.
• Performing regular DBA Activities such as Backups, Modifying Database Structures, Managing Database Storage, Maintaining System Security, Profiles and Roles. Loading flat file data into tables using SQL*loader. Extensively used Exp, imp and data pump utilities to build changes.

Environment: Red Hat Linux, Sun Solaris 9.0, RHEL 5.2, PL/SQL Developer V6, TOAD, Erwin 7.x, ASM, Dataguard, Oracle 10g/9i.