SUMMARY

• 7 years of experience as an Oracle DBA in very large Production, Test, Design and Development environments in diversified domains.
• Experience in Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Capacity Planning, Backup & Recovery, Disaster Recovery, Performance Tuning.
• Experience in configuration, implementation of Oracle 10g RAC/11g RAC.
• Experience in Multi Node RAC cluster design, administration and support.
• Experience in Oracle 9i, Oracle 10g, Oracle 11g software installation and configuration and cloned Oracle Databases for development and testing.
• Experience in design and implementation of Backup & Recovery procedures and used new features/technologies to optimize system maintenance and extensive knowledge on Partitions and Oracle Streams.
• Proficient in implementation, maintenance of Database Security (Users, Roles, Privileges), space management of logical structures (i.e. table spaces, rollback segments) and responsible for setting and managing user accounts, granting required privileges to users.
• Proficient in using Oracle utilities like export/import Data Pump, Flash Back Recovery, Data Guard, ASM and OEM.
• Customization and development of Korn shell scripts.
• Experience in the management of schemas, de - fragmentation and partitioning the tables & indexes to improve the performance.
• Experience in managing Very Large OLTP and Data warehouse databases of size multiple TB
• Experience in Oracle Admin Server and in upgrading databases to Oracle 10g, Oracle 11g.
• Experience in using RMAN for Backup and Recovery. Experience in designing and implementing Hot, Cold and Logical backup plans.
• Knowledge on Oracle Support processes for technical requests with Metalink/Oracle support.
• Result oriented, self-motivated, Team player, ability to work independently.
• Excellent analytical and problem-solving skills and excellent written and verbal communication skills

TECHNICAL SKILLS

Operating systems: Sun Solaris 8&9, IBM AIX 4.3.3, Red Hat Linux 4x, 5x, Windows NT 4.0, XP and 2000 servers.

RDBMS/Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i.

Database Tools: Oracle Enterprise Manager (OEM), Oracle Database Configuration Assistant (DBCA, RMAN, Rapid clone, RAC, Data Guard, Oracle 10g Grid, ASM, SQL*Plus, Export/Import, Data pump, Security, Backup & Storage Manager, Oracle Trace, TOAD, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Oracle Database Administrator

Responsibilities:

• Daily database administration tasks including scheduling backup, verifying night backups and recovery through RMAN.
• Performed data transfer using Exp/Imp and Data Pump.
• Regular Instance Level Performance Tuning for the critical Production database servers.
• Performed troubleshooting of database using AWR and ADDM reports for 10g.
• Successfully implemented backup/ recovery strategies including RMAN usage.
• Monitoring and optimizing the performance of the databases.
• Created number of Linux shell scripts for various administration tasks.
• Troubleshooting through examining Oracle Alert logs, Trace files and Routine maintenance.
• Created database objects like tables, indexes, synonyms, views etc.
• Monitored indexes and analyzed their status for performance tuning and query optimization.
• Creating, enrolling users and maintaining system security.
• Controlling and monitoring user access to the database for new and existing databases.
• Refresh test database from production using Recovery Manager (RMAN).
• Space Management which includes table space creation, adding new data files.
• Configuration, Upgrade, patching.
• Worked on large database of 6TB.
• Experienced in Oracle Support (raising SR) processes for technical requests

Environment: Oracle 10g, Windows, TOAD 8.6, MS Office, Import/Export, Data pump, RMAN.

Confidential, Indianapolis, IN

Oracle Database Administrator

Responsibilities:

• Involved in the installation and administration of Oracle 11gR1 RAC on a 2-node cluster and configuration of ASM in Test and Production environment.
• Build databases, performed testing, create schemas, objects, maintenance, & control of organization's relational databases across various platforms and environments.
• Daily database administration tasks including scheduling backup, verifying night backups and recovery through RMAN as well as using a Storage Area Network (SAN).
• Performed data transfer using Exp/Imp and Data Pump in command line as well as in interactive mode.
• Cloned/Refreshed testing, development and environments from Production using RMAN.
• Experienced in configuring Data guard in Oracle 10g and 11g with Physical Standby Database
• Managed database security by creating and assigning appropriate roles and privileges to users depending on user activity. Applied patches and upgrades to the database as required.
• Used Log Miner to extract the information from redo logs. Raised Service Request (SR), Technical Assistant Request’s (TAR) in case of severe problems. Performance tuning of Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR and ADDM.
• Tuned memory structures such as the database buffer cache, shared pool, and library cache.
• Performed backup and recovery of OCR, Voting Disk, and ASM and RAC.
• Installed Oracle binaries, build databases on new servers, refreshing databases between environments.
• Created number of Linux shell scripts for various administration tasks on AIX 6.1 like nightly backups of critical file, incremental backup.
• Configured RMAN as per the business requirement and scheduling backups for RAC databases in the clustering environment.
• Worked closely with application developers & system administrators to ensure that all database needs are being maintained.
• Established and managed the Standby database by Data Guard.
• Experience in implementing, configuring and maintaining 10g/11gOracleData Guard.
• Experience in adding SAN to the ASM Disk groups and performed rebalancing operation. Experience in adding Disk groups, Removing Disk groups in ASM. Managed and configured 10g and 11g Data Guard in both Stand-alone and RAC environments.
• Individual queries from applications using tools like 10046 trace.
• Setup Active-Active configuration using Golden Gate 11.1.
• Installed and Configured Golden gate extracted and replicated the data across various topologies.
• Performed read-only materialized views replication, Oracle streams and golden gate replication.

Environment: Oracle 10g/11g, AIX 5.3/6.1, SAN Storage, RMAN, TKPROF, RAC and ASM, Shell Scripting, and SQL *PLUS, Golden Gate.

Confidential, Scottsdale, AZ

Oracle DBA

Responsibilities:

• Experience with 24x7 production support.
• Support has been provided for the critical OLTP databases, Data warehouse and development databases.
• Upgraded oracle databases from 9i to 10g.
• Worked on RAC on Red Hat Linux Advanced Server with 4 nodes.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Implemented a series of monitor programs to check Database, table space growth, extent growth, de-fragmentation, examining row cache activity, eliminate chained rows, and index analysis.
• Monitored the data fragmentation on data files, rollback segments and performed periodic export and import to avoid fragmentation.
• Monitored the databases using tools like Oracle Enterprise Manager, TOAD and spread data among several disks to balance the I/O.
• Extensively used new features of DATAPUMP utility for export / import of 10g databases.
• Moved database Schema changes to stage or production using data pump / exp utilities.
• Wrote shell scripts for implementing routine checks on alert logs and trace files, reporting deadlocks in PROD databases to ORACLE DBA team.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually.
• Recovered critical databases from failures with minimum downtime.
• Planned, tested and implemented different backup and recovery strategies for 9i and 10g databases using RMAN utility.
• Performed troubleshooting of database using AWR and ADDM reports for 10g, stats pack for 9i databases.
• Experience in job scheduling for UNIX (crontab), and Enterprise Manager.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database...
• Involved in partitioning large tables (Tables contain more than 80 million records) to improve the performance
• Designed and Implemented database security using Oracle roles and privileges.
• Communicated and coordinated with Oracle using SR system for major database issues/ problems; apply the required patches, test and roll out and implement the patches into production.
• Worked on Large Databases of 1TB and over.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, RHEL 4.0, RMAN, Import & Export, Data pump, Data guard, ASM, TOAD etc.

Confidential, NY

Oracle Database Administrator

Responsibilities:

• Act as a Production and development support DBA for 24 x 7 critical productions Server and test development Server.
• Regular Instance Level Performance Tuning for the critical Production database servers.
• Worked with the SQL Developers, to create logical and physical database design.
• Troubleshooting, Monitoring and Tuning the Server for optimum performance.
• Successfully implemented backup/ recovery strategies including RMAN usage.
• Managing and configuring database user accounts and permissions.
• Creating primary database storage structures (table spaces) once developers have designed an application.
• Modifying the database structure, as necessary, from information given by application developers.
• Creating, enrolling users and maintaining system security.
• Controlling and monitoring user access to the database for new and existing databases.
• Monitoring and optimizing the performance of the databases.
• Involved in recovering the Server in recovery configurations.
• Performing scheduled Restoration drills by bringing down a test database in different scenarios.
• Backing and restoring the database using RMAN utilities, Data pump.
• Designed and implemented hot backups using a combination of incremental, differential and full backups using RMAN.
• Creation, maintenance and administration of databases under UNIX and Windows environments.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Creating primary storage structure and the objects.
• Experienced with improving the Server using various packages to monitor and improve the server performance and database performance-using database tuning methods.
• Successfully created SQL traces as per the business rules requirements.
• Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Successfully used tools like TKPROF, DBMS STATS, trace events for monitoring and tuning.
• Gave front-end support in Oracle Forms & Reports.
• Creating database back-ups, upgrade and maintenance schedules.

Environment: Oracle 9i, Windows XP/NT, Solaris, TOAD, MS Office, Import/Export, Data pump, OEM, RMAN.

Confidential, Cheshire, CT

Oracle Database Administrator

Responsibilities:

• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.
• Configured and maintained 2 node RAC cluster.
• Setting the parameters, maintaining Data Files, Control Files, Redo Log Files, managing Table spaces, segments, extents, indexes and managing Undo Data.
• Carrying out EXPORT and IMPORT operations on Oracle Database using the DATAPUMP utility.
• Monitoring the performance of the database using of OEM (Oracle Enterprise Manager).
• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.
• Upgraded from Oracle 10g R2 to Oracle 11g R1 database.
• Installed, configured and implemented 10g Data guard as a physical standby database.
• Developed backup and recovery strategies with the use of incremental cumulative and differential backups using RMAN
• Used Automatic Workload Repository (AWR) for analyzing the database performance.
• Automating the routine DBA tasks through CRON
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles for user actions in the database.
• Communicated with Oracle support via the Metalink in order to troubleshoot important issues.

Environment: Oracle 10g, Toad 8.5, Windows XP, RHEL 4, Data Guard, OEM, RMAN.

Confidential

Oracle Database Admin

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery.
• Involvement in all phases of the project life cycle.
• Responsible for troubleshooting hardware and software issues.
• Responsible for Operating System Installation and updates.
• Responsible for updating the database with the information received from various vendors.
• Analyzed the structures using Analyze command.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloned Environments to create Patch Test, Development and QA Environments.
• Partitioned large tables to increase the performance.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Resolving technical issues and Troubleshooting.

Environment: Windows 98/XP/NT, UNIX, Oracle 9i, RMAN, Data Guard, CRONJOB, TKPROF, EXPLAIN PLAN, MS Office.