SUMMARY:

• Confidential is a highly motivated result - driven certified Oracle 10g DBA professional with 8.9 years of experience in Oracle database (8i, 9i, 10g,11g) installation, administration, performance tuning, backup and recovery especially on Linux platform. In addition she has proven ability of providing production support for 24x7 on multiple databases. She possesses excellent analytical, problem solving, communication and interpersonal skills. Details of her skills -
• Extensive Experience in Oracle 9i/10g/11g Architecture, RMAN backups, Crash Recovery, Optimization, Performance Tuning, Troubleshooting.
• Experienced in installing Oracle patches, Migrating database across releases.
• Diverse industry experience including Confidential .
• Designed and developed plans to achieve high availability, scalability, recoverability of the Oracle RDBMS servers.
• Responsible for upgrading databases to Oracle 11g.
• Expert in Database Administration, Performance Tuning.
• Hands on experience of managing Very Large Databases (VLDB) in the range of 500 GB to 1 TB.
• Implemented FLASHBACK technology. Experienced on various flashback technology features introduced in Oracle Database 10g.
• Extensive experience in designing databases using Erwin tool.
• Setup and configure oracle 9i/10g database (OLTP) for development and staging environment.
• Extensive experience on Automatic Workload Repository and Automatic Database Diagnostic Monitor (ADDM) in Oracle 10g (10.1.0.2).
• Involved in upgrading the database servers to 10g in OLTP environment.
• Created Partition Table (List, Range, and Hash) to improve query performance.
• Expert in Oracle Database 10g (10.2) Real Application Cluster implementation with ASM and Cluster Management.
• Setup and configured Oracle Data Guard using a physical standby database
• Extensive experience with DATA PUMP feature of Oracle 10g to transfer the data amongst databases.
• Generated Materialized views to cache data that was frequently needed, to improve performance.
• Excellent experience working with FTP, SCP using SSH protocol.

TECHNICAL SKILLS:

RDBMS: Oracle 8.1.7, Oracle Database 9i, Oracle Database 10g(10.2.0.4),Oracle Database 11g(11.1.0.7)

Tools: Erwin 4.1.4,Toad, Putty, Oracle 9i/10g Oracle Enterprise Manager, Database Configuration Assistant,Net configuration assistant

Operating Systems: Red Hat Linux 3.1, Red Hat Linux 2.1,AIX 5.3, HP-UX 11.11,Solaris 10,Windows XP Professional, Windows 2003 Professional.

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Oracle Database Administrator

Responsibilities:

• Refresh the non - production environment from production databases using oracle utilities like data pump, export/import over the network link so as to facilitate Application team with test environment .
• Implement nightly production changes.
• Replicate the data amongst three databases using materialized views.
• Release monthly reports on user management and resource usage of production hosts to the appropriate teams.
• Implemented Oracle Streams.

Environment: Oracle Database 11g(11.1.0.7), Oracle Database 10g(10.2.0.4), AIX 5.3, Solaris 10

Confidential, Lincoln, RI

Oracle Database Administrator

Responsibilities:

• Involved in the Installation, Database design, Administration, implementation, customization & system support on AIX 5.3.
• Used Expdp, Impdp utility to transfer the data between databases.
• Involved in applying CPU patches and project specific patching on databases.
• Database export/import, hot backup and cold backup setup and evaluating the backup and recovery procedure periodically.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Creation and maintenance of table spaces and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Monitoring alert log/system log.
• Carried out the setting up of RMAN back up schedules of databases.

Environment: Oracle Database 11g(11.1.0.7), Oracle Database 10g(10.2.0.4), AIX 5.3, Solaris 10

Confidential, Cranston, RI

Oracle Database Administrator

Responsibilities:

• Involved in the Installation, Database design, Administration, implementation, customization & system support on Solaris 10.
• Used Expdp, Impdp utility to transfer the data between databases.
• Implemented 2 node Oracle 10g RAC on RHEL 4.0. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring High Availability Features for RAC.
• Responsible for maintaining Oracle 10.2.0.4 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Responsible for upgrading databases to Oracle 11g(11.1.0.7).
• Creating Logical Data Model and Physical Data Model in order to knock out the design phase using ERwin.
• Providing mapping document from source files to target tables (implemented in the database) to the Ab Initio and Cognos Reporting team.
• Tuned frequently used Oracle SQL Statements and PL/SQL blocks using Oracle Enterprise Manager, TKPROF and Explain Plan.
• Database export/import, hot backup and cold backup setup and evaluating the backup and recovery procedure periodically.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Creation and maintenance of table spaces and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Monitoring alert log/system log.
• Carried out the setting up of RMAN back up schedules of databases.

Environment: Oracle Database 9i(9.2.0.8), Oracle Database 10g(10.2.0.4), Oracle Database 11g(11.1.0.7),HP-UX 11.11,AIX 5.3, Solaris 10

Confidential, Columbus, OH

Oracle Database Administrator

Responsibilities:

• Involved in the Installation, Database design, Administration, implementation, customization & system support on Solaris 10.
• Used Expdp, Impdp utility to transfer the data between databases.
• Implemented 2 node Oracle 10g RAC on RHEL 4.0. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring High Availability Features for RAC.
• Responsible for maintaining Oracle 10.2.0.4 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Responsible for upgrading databases to Oracle 11g.
• Tuned frequently used Oracle SQL Statements and PL/SQL blocks using Oracle Enterprise Manager, TKPROF and Explain Plan.
• Database export/import, hot backup and cold backup setup and evaluating the backup and recovery procedure periodically.
• Creating Logical Data Model and Physical Data Model in order to knock out the design phase using Erwin.
• Providing mapping document from source files to target tables (implemented in the database) to the Ab Initio and Cognos Reporting team.
• Defragmentation of tables and indexes for improved performance and efficiency.
• Creation and maintenance of table spaces, rollback segments and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Monitoring alert log/system log.
• Provided production support for 24X7 database availability for VLDB(very large databases) of more than a terabyte size.
• Carried out the setting up of RMAN back up schedules of databases.

Environment: Oracle Database 9i(9.2.0.8), Oracle Database 10g(10.2.0.4), HP-UX 11.11,, Solaris 10

Confidential, Blue Ash, OH

Database Administrator/Data Modeler

Responsibilities:

• Involved in the Installation, Database design, Administration, implementation, customization & system support.
• Involved in the normalization of the Data Models for the application.
• Hands on experience in writing & debugging Stored Procedures and triggers, Troubleshooting database issues.
• Experienced in Creating Databases based on Functional Requirements and System Design.
• Installed Data Guard Primary and Standby database on 10g .
• Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives of various projects.
• Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Responsible to schedule backups through RMAN.
• Tuned frequently used Oracle SQL Statements and PL/SQL blocks using TKPROF and Explain Plan.
• Implemented 2 node Oracle 10g RAC on RHEL 4.0. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring High Availability Features for RAC.
• Responsible for maintaining Oracle 10.2.0.4 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Used Expdp, Impdp utility to transfer the data between databases.
• Creating Logical Data Model and Physical Data Model in order to knock out the design phase.
• Providing mapping document from source files to target tables (implemented in the database) to the Ab Initio and Cognos Reporting team.
• Responsible for writing Shell scrips for Backup operations of the database.
• Responsible for generating and providing DDLs to DBA for all the objects in data model that need to be implemented in the database.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Comparing Data Model and database.
• Experience with reverse engineering technique to develop model from existing database.
• Hands on experience on the Modelmart feature of Erwin 4 tool.
• Generate Erwin 4 reports in different formats like .html, .rtf, .txt.
• Comparing different versions of the data model in Erwin 4.

Environment: Oracle Database 10g(10.1.0.2),Red Hat Linux 4, HP-UX 11.11,Erwin 4.1.4, Teradata 7.1, Windows XP Professional, Windows 2003 Professional.

Confidential

Oracle DBA

Responsibilities:

• Implemented Oracle 10g (10.1.3.0.0 ) Application Server.
• Implemented 2 node Oracle 10g RAC on RHEL 4.0. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring High Availability Features for RAC.
• Carried out the setting up of RMAN back up schedules of databases.
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Writing SQL* Loader control files and PL/SQL Procedures.
• Database export/import, hot backup and cold backup setup and evaluating the backup and recovery procedure periodically.
• Back up and Archiving Strategy of Solution have been given to spell out Confidential each location
• Primary DBA support for establishing, upgrading and maintaining OLTP Oracle database environment
• Defragmentation of tables and indexes for improved performance and efficiency.
• Creation and maintenance of table spaces, rollback segments and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Monitoring alert log/system log.
• Provided production support for 24X7 database availability.
• Formulated & implemented best practice guidelines for Oracle Database.

Environment: Oracle Database 10g RAC (10.1.0.2), Oracle 10g Application Server, Oracle Enterprise Manager (9i,10g), Oracle Sql *Plus, Oracle 9i Net configuration Assistant, Oracle Application Server 10g, HP-UX 11.11.

Confidential

Oracle Applications DBA

Responsibilities:

• Responsible for writing shell scripts to monitor Hard Disk and Database space regularly.
• Responsible for writing shell scripts for Backup and Recovery, processes/listener/oracle alerts monitoring
• Taking Database Hot & Cold backup and adopting appropriate recovery procedures
• Oracle Application 11.5.8 Installation and configuration ·
• Solving technical issues related to Application and database including patch management and dealing with Oracle Support for many production and test/development databases.
• Cloning the Test & Dev instance with PROD database.
• Configuring backup strategy through RMAN.
• Perform upgrades via family packs, patch sets of Apps 11i Financial & Manufacturing modules, new releases every three months incorporating new functionalities and patches to upgrade Applications
• Work with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches, code movements)
• Identifying and developing UNIX and sql scripts for the smooth functioning of database and applications related issues.
• Creating and maintaining documentation for the various existing processes.
• Managing Concurrent Managers ·
• Worked on "ad" utilities · Printer Configuration ·
• User Access Administration

Environment: Oracle Applications 11.5.8, Toad, Putty, Red Hat Linux 2.1,Oracle database 8.1.7

Confidential

Oracle DBA

Responsibilities:

• Designing, creating, operating, maintaining and troubleshooting of Oracle databases
• Implemented 2 node Oracle 10g RAC on RHEL 4.0. Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, Configuring High Availability Features for RAC.
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Implemented FLASHBACK technology. Experienced on various flashback technology features introduced in Oracle Database 10g.
• Extensive experience on Automatic Workload Repository feature of Oracle Database 10g.
• Writing SQL* Loader control files and PL/SQL Procedures
• Backup and recovery utilizing RMAN.
• Implemented materialized views.
• Setup standby database via Data Guard for database disaster recovery
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.
• Responsible for optimizing data access and performance by tuning indexes and Oracle performance tuner/optimizer tools like Explain Plan, stats pack, Sql Trace.
• Defragmentation of tables and indexes for improved performance and efficiency..
• Creation and maintenance of table spaces, rollback segments and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Worked on Oracle 9i OEM for regular database management.
• Monitoring alert log/system log.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.
• Tuning SGA, Rollback segments, Latch contention Issues, Optimize Sort Operation
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment

Environment: Oracle 10g(10.1.0.2) Oracle Enterprise Manager, Oracle Sql *Plus, Net configuration Assistant, PL/SQL Developer, Red Hat Linux 3.1

Confidential

Oracle DBA/Oracle Developer

Responsibilities:

• Responsible for designing, creating, operating, maintaining and troubleshooting of Oracle databases.
• Worked with SQL* Loader control files and PL/SQL Procedures.
• Implemented Database export/import, hot backup and cold backup setup for all the clients.
• Discoursed the tips on evaluating the backup and recovery procedure periodically.
• Back up and Archiving Strategy of Solution have been given to spell out to each client.
• Capacity planning and storage management.
• Defragmentation of tables and indexes for improve performance and efficiency..
• Creation and maintenance of table spaces, rollback segments and data objects.
• Creation and maintenance of control files, redo log files and data files.
• Monitoring alert log/system log.
• Oracle installation, creation of database, which includes physical and logical design.
• Assisted developers in Creating stored procedures, Triggers, Functions, Cursors and Packages.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc,). Responsible for memory and Application tuning of the database. Oracle utilities like OEM, GRID SQL Trace, TK Prof and Explain Plan,

Environment: Oracle 8i(8.1.7), Oracle 9i(9.0.2),Oracle Enterprise Manager, Oracle 9i SQL *Plus, Oracle 9i Net configuration Assistant, Oracle 9i PL/SQL Developer, SQL Server 7.1,Red Hat Linux 3.1