SUMMARY

• Over 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 wif 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 wif 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 wif ability to develop proficiency and adapt to new technologies and methods in a short period of time.
• Designed a solution wif timelines by planning teh Data Center Migration using standby configuration.
• Data Center Migration options used is Export/Import wif DataPump, Cross-Platform Transportable Table space and Application specific methodology to capture changes and replay.
• Ability to move a group of databases wifin teh same downtime window.
• Installation, Configuration and Automation of Oracle DBA Monitoring Tools. Ability to support and work wifin 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 wif other team members, Project managers, System Administrators & Application Developers. Also refreshing Database as per teh requirements of teh clients (CLONING).
• Implemented Disaster Recovery for Oracle Databases in Production.
• Evaluated and ensured teh efficiency of application database backup and recovery procedures.
• Ensure that teh 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 teh various stages of teh 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 wif 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, Connecticut, 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 wif SOX/PCI policies.
• Defined, documented and automated maintenance procedures to be used by offshore team in support of teh 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 wif remote and on-site resources in teh 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 teh 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 teh planning, testing and analysis using SQL Performance Analyzer to determine execution plan changes wif 11g.
• Involved in strategic planning of upgrades and CPU/PSU patch rollouts across teh enterprise.
• Used Datapump Export/Import Utilities for User migration, Tables, Databases, etc.
• Configured and done tuning of teh Oracle RAC infrastructure using ASM in accordance to cluster configuration.
• Ability to configure cluster databases and worked extensively wif 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 wif and wifout catalog, catalog maintenance, archive management and catalog reporting.
• Also, held accountable for Virtual Tape libraries and teh 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 teh 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 teh database, tables, tablespaces, data objects, setting privileges, indexes, user logins, password (security).
• Creating new databases, configuring backups and maintaining teh databases. Tune teh databases and SQL queries. Backups using vendor specific tools and Oracle utilities like RMAN. Teh tuning and indexing teh 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 wifin teh production support team and maintain operational consistency and efficiency.
• Provide input to teh Project and Enhancement teams to define database storage structures (tablespaces) after application developers has designed an application. Implementation of reviewed changes to teh 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 teh 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 teh 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 teh existing OEM and customize monitoring environment.
• Monitoring and performance tuning.
• Supporting, monitoring & tuning teh database subsystems & instances, dis includes starting and stopping teh 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 teh 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 wif trace events (High level of tracing of Optimizer and SQL performance wif 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).
• Tablespaces 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 wif teh 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 teh partner flat files into teh OLTP database. Also, developed teh T-SQL stored procedures/functions to process these data and populate them in teh 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 teh connections requests.
• Worked extensively on 10G grid control especially monitoring teh database, configuration of different notifications, installing and configuring agent, listener and databases and adding them to teh grid control. Worked on setting up off Oracle dataguard for teh production database.
• Worked wif 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 wif 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 teh 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 teh 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 teh 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.