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 Banking and Finance.
• 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.

TrainingS: Oracle 9i Database Administrator 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.
• 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
• 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