SUMMARY

• An astute Oracle DBA with around 8 years IT experience in Oracle products, both production and development environments spanning several industries: health care, financials and high - tech .
• Extensive knowledge on database administration for Oracle 8i, 9i,10g,&11g with experience within very large scale database environment .
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQLNet, V$ and DBA views.
• Extensive knowledge of STANDBY creation and maintenance.
• 2.5 years of RAC (9i,10g&11g) with proficiency in setting up and administering 9i,10g&11g RAC.
• Expertise in upgrading Oracle Development and Production databases from 9i to 10g & 11g.
• Implementing Oracle GOLDENGATE
• Expertise in supporting client server GUI software and Operating system.
• Extensive knowledge in Dataguard, Grid control, streams, replication.
• Experience in a variety of hardware and software platforms including; MS-Windows 2000, 2003, UNIX/Linux, Sun Solaris, HP-UX & AIX
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like Statspack, Tkpfof, Explain plan, Analyze AWR and ADDM
• Performance tuning and diagnosing DBMS and individual database.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS)
• Expertise in Oracle Enterprise Manager (OEM), Grid Control.
• Extensive knowledge on database backup/recovery strategy (RMAN), VERITAS Net Backup, Import/Export & Datapump, Replication (Streams) standby databases using Netapp filer/Snap Mirror, Oracle configuration management, Dataguard, database cloning, refresh and patch management.
• Good at co-ordinating, communicating with system administrators, business data analysts and development teams.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8.x/, Oracle 10g Real Application Clusters (RAC)

GUI: SQL loader, sql * plus, TOAD

Languages: SQL, PL/SQL

Operating systems: LINUX Admin, UNIX Admin, Windows NT, 2002AS, 2003AS Admin.

Utility tools: PUTTY, F - Secure

Storage Technology: ASM, 10g RAC

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

Sr Oracle Database Administrator

Responsibilities:

• 24X7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation and Configurations of Oracle 9i, 10g, and 11g RAC on Linux.
• Working With Automatic Storage Management (ASM) ENVIRONMENTS.
• Proactive database monitoring using 10g grid monitoring tool.
• SQL tuning using stats pack and explain plan, tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation, Configuration and Maintenance of Stand by database
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading from Oracle development and production databases 9i to 10g & 11g.
• Applied patches to Oracle Databases.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implementing Hot, Cold and Logical backup plans.
• Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform all other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Active participation in Production maintenance

Environment: Linux 4.0, Windows 2003, Streams,GOLDENGATE ASM, Oracle 11g/10g/9i RAC, SQL*Plus, Grid Control, TOAD.

Confidential, PA

Sr Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Have worked as a team lead in a team of 7 DBA’s and have done performance evaluation for team members and coordinating meetings and provide solutions to mission critical relational databases.
• Installation and Configurations of Oracle 10g and 9i RAC on Linux.
• Migration Oracle databases from windows to linux.
• Database patching using opatch.pl perl script.
• Proactive database monitoring using 10g grid monitoring tool.
• SQL tunning using statspack and explain plan,tkprof.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation, Configuration and Maintenance of Stand by database
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 10g.
• Applied patches to Oracle Databases .
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Linux 4.0, Windows 2003, Streams, ASM, Oracle 10g/9i RAC, SQL*Plus, Grid Control, TOAD 9.4, IBM RSA.

Confidential, Minneapolis,Minnesota

Oracle Database Administrator

Responsibilities:

• 24x7 Production Database Administration and support
• The work involves overall maintenance of Oracle database, performance, tuning, backup, recoveries and other database related activities.
• The work also involves system administrator tasks like creation of users, file systems, volume groups and logical volumes etc.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviours
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database
• Handling day-to-day activities.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles
• Space management
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)

Environment: Oracle 9i,Sun Solaris, HP-Unix, UNIX, Linux 4.0.,RMAN, DBCA, DataGuard, EXPLAIN PLAN Clonig,OEM,STATSPACK, TKPROF

Confidential

Oracle Database Administrator

Responsibilities:

• Setup new database servers including the following tasks: Evaluated the database server hardware, designed table space layout based on Optimal Flexible architecture, installed Oracle, created Oracle database, configured the Net8 on different nodes.
• Monitoring Alert Log Report and system Error Logs.
• Performing backup and recovery procedures
• Resolving Hardware and Network problems. Providing Support solutions to a site consisting of nearly 60 users. The work involves planning, designing and implementing of LAN connectivity.

Environment: Oracle8i/9i/10g,UNIX,Linux4.0.,RMAN,DBCA,DataGuard,OEM,STATSPACK, TKPROF, EXPLAIN PLAN

Confidential

Jr Oracle Database Administrator

Responsibilities:

• Installation, Implementation and maintenance the Oracle database
• Created and managing the database objects such as tables, indexes and views
• Create the users and roles
• Created and managing the database storage structures which includes data table spaces, index table spaces, rollback table spaces and rollback segments
• Loading the database with SQL*Loader
• To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval and processing of queries used for retrieving the data
• Performing the logical and physical structure of tables, indexes, modeling, normalization and foreign key constraints
• Database maintaining including backups, recovery, imports/exports
• Monitoring the database daily activities
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL

Environment: Oracle8i/9i/10g,UNIX,Linux4.0.,RMAN,DBCA,DataGuard,OEM,STATSPACK, TKPROF, EXPLAIN PLAN