SUMMARY

• 4+ years of experience in Oracle 11g/10g/9i DBA and worked in all phases of Software Development Life Cycle.
• Database software installations, patch and upgrades.
• Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments
• Hands on experience in oracle 11gR1/R2 and good knowledge of new features.
• Hands on experience in planning backup and recovery operations using RMAN & User - Managed.
• Experience in analyzing AWR, ADDM, Stats pack reports.
• Hands on experience in performing logical backup using DATAPUMP for non-production database, schema refreshes.
• Frequent interaction with development, network, system and storage teams.
• Modify database structures as required by developers per the business or application requirements, clone development databases for testing and training.
• Hands on experience on Automatic Storage Management (ASM)
• Hands on experience in using SQL * Loader and Log Miner Utility
• Creation and configuration of Duplicate database by using RMAN utility
• Oracle Table Partitioning, Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Hands on experience on SQL Server installations, Managed backups and Data Migrations from older versions
• Good understanding of the business, follow the ITIL process and adhere to customer’s SLA’s.
• Interface with ORACLE SUPPORT for technical assistance.
• Ability to learn new technologies and adapt to a dynamic environment.
• Successful in meeting new technical challenges and finding solutions to meet the needs of the customer.

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, OEL and windows 98/ME/NT/2000/XP

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

Tools: and Utilities: RMAN, OEM, TOAD, SQL*Loader, Erwin, Export/Import, Data pump,SQL Tuning/Access Advisor, SQL Performance Analyzer, MS Office .

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting,Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Others: Cron

Web Technology: BMC Remedy, HP Quality Center, Ruby on Rails

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Installed and Created databases on Oracle 11g, upgraded databases from 10g to 11g R2. and applied patches.
• Setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM).
• Worked on database sizing, performance monitoring and tuning
• 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.
• Worked on creating and maintaining database users and roles.
• Implement and maintain database security by assigning privileges accordingly.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
• Supported data transfer operations - import/export, SQL*Loader and data pump
• Create or clone the Oracle Instance/Databases on ASM. Perform database cloning and re-location activities.
• Worked extensively on SQL, PL/SQL, and Shell Scripting.
• Optimizing SQL statements using TKPROF, EXPLAIN PLAN, and STATSPACK.
• Managed and maintained hosted production, development/test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Performed backups, restores, cloning, or refreshing databases and applications.
• Documented and complied with company policies and standard operating procedures.
• Managed and resolved design issues during development.
• Developed automation scripts for database monitoring. .
• Created materialized views.
• Tickets and Incident management using BMC Remedy
• Active participation in all team meetings and group meetings to meet the business requirements.

Confidential

Oracle DBA

Responsibilities:

• Create databases, configuring them to meet developer and user requirements..
• Upgraded the application database from 10.2.0.5 to 11.2.0.1.0 and applied patches.
• Co-ordinate with UNIX Administrators for space management on various servers and help in Oracle installation, upgrading according to the standards & Quality assurance.
• Tune database to ensure acceptable level of performance and availability.
• Install client side of Oracle on developers and end-users PC and configuring them with network connections.
• Extending the database storage capacity by creating new table space, adding data files to table space.
• Manages and maintains the data dictionaries.
• Monitors database activity and file usage, and ensures necessary resources are present so that databases function properly by removing or deleting old or obsolete files.
• Managing Users, Privileges and Roles.
• Cloned Production databases using RMAN, hot and cold backups
• Automating the routine DBA tasks through the Crontabs
• Good understanding of the business, follow the ITIL process and adhere to customer’s SLA’s.
• Extensive experience in handling different kinds of ORA errors.
• 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.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Supported Oracle 9i, 10g databases on 24X7 shifts.