Anusha Meghan

SUMMARY

*+ years of experience as Oracle Data Base Administrator, providing 24/7 support for both development and production 11g/10g/9i/8i databases on Various Platforms.

Extensive experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g in UNIX/LINUX, IBM-AIX, SOLARIS and Windows environment.

Experience in Installation, configuration and administration of 11gRAC, 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.

Effective in troubleshooting of database and performance problems.

Good experience in SQL, PL/SQL.

Experience with Data Modeling, Logical and Physical database design.

Proactive Monitoring, identifying areas that need to be improved in the application and database using STATSPACK, AWR, ADDM, and 10g OEM Grid Monitoring

Used Grid Control, Oracle Enterprise Manager and command line SQL plus and 3rd party administrative tools including Toad.

Monitored and Detected Alert Log Files, Listener Log, Redo Log status, trace files and Locks for the database.

Experience in Data transfer between SQL Server and Oracle.

Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering Oracle Databases on Oracle 11g/10g/9i.

Periodic Backup and recovery, using Backup and Recovery Manager (RMAN) and Export/Import Utilities.

Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups.

Proficient in performance tuning using Explain Plan, STATSPACK, SQL_TRACE, TKPROF.

Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, Data Migrations using export/import, benchmarking using load testing tools

Experience in Migration of Database from 9i to 10g, 10g to 11g.

Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX), Autosys jobs, Scheduled Tasks (Windows).

Periodic Database CLONING from production to Development and QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.

Expertise in Oracle Golden Gate software.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, UNIX Shell scripting Java, C, C++, Perl, HTML, XHTML, JavaScript, VB scripts, XML

Database: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, MS-Access.

Application Tools: Oracle Grid control/Oracle Enterprise Manager, TOAD,

DBCA, TKPROF, RMAN, ASM, RAC, Import/Export, SQL loader,

SQLNET, Tuning packs, Load runner, VERITAS NetBackup, TSM,

Commvalut, EXPLAIN PLAN, ERWIN, SQL-Navigator, DBArtisian,

Data Guard, Data-Pump.

Development Tools: SQL*LOADER, PL/SQL, SQL*PLUS, T-SQL.

ETL Tool: Informatica 8.6, SQL Server Integration Services (SSIS)

Operating Systems: UNIX (Solaris 9, 10, AIX 5.3, HP-UX11), Windows 2000/2003

Windows 2000/XP, Linux Redhat 2.1, 3.x, 4.x, 5.x (32bit, 64bit)

Others: MS Office Suite, SSH, FileZilla

PROFESSIONAL EXPERIENCE

Consultant at Vmware, Palo Alto-CA May 2011 - Present

Senior Oracle DBA

Installed, Configured, Upgraded and Applied patches and bug fixes for Prod, Test and Dev Servers.

Upgraded databases, Oracle RDBMS on 10g Real Application Clusters (9ig RAC) on Linux to 11g Real Application clusters on Linux (10g RAC).

Responsible for configuration of 11g RAC, 10g RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS

Database upgrades and Datacenter Migrations of Oracle databases from 9i and 10g.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance

Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7) with over 5 TB in size

Experienced in the upgrade of the development and test instances to 11g (11.1.0.7)

Oracle Clusterware installed to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption

Creation and Maintenance of 20 Single Instances and 5 RAC Databases in Development, Test and Production servers. Coordinated with System Administrators for Server Support, NAS and SAN storage.

Performed Pre and Post installation tasks in Migration starting from Research on Initialization Parameters for Datamart Database and Database Links, Synonyms, Views and Roles for Different Databases which will be preferable to current environment.

Upgraded the development and test instances to Oracle 11g (11.1.0.7)

Experience in Replication of Data bases using Oracle Streams and Logical Standby.

Worked with Data Architect on dimensional modeling to optimize the already existing data-warehouse database using STAR Schema, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Monitoring Day-Day Backups, Log’s and recovering them as per the requirement. Utilized LOG MINER Technology and applied Application Database Transactions on other Databases.

Successfully implemented Backup and Recovery using RMAN which includes hot backups and Cold backups.

Experienced in configuration of 10gRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS and Veritas Netbackup as a media management layer.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.

Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.

Responsible for capacity planning, database security, recovery planning and installing patches

Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Worked on configuring Oracle Data Guard and EMC Symmetric Remote Data Facility on production server.

Environment: Oracle 10g RAC, 11g, UNIX, Solaris 10, Informatica, TOAD, VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN, Business Objects XI, DataGuard.

Consultant at Dell Inc. Philadelphia, PA Dec 2009 – April 2011

Oracle DBA

Provided 24x7 support of Production databases.

Performed day-to-day DBA jobs for managing over 30 Prod/Dev databases

Implemented data replication through Materialized Views, advanced replication and creating and refreshing materialized views.

Installed and Implemented Backup and Recovery procedures. Implement Hot, Cold and Logical backup plans.

Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery as well as to offload the running of huge reports.

Develop/customize UNIX shell scripts to automate routine DBA tasks of taking backups, exports, space usage monitoring and others.

Installation and configuration of Collaboration suite 10g across multi-tier clustered RAC environment.

Experience with production of Oracle 10gR2 with multi node RAC with ASM

Set up Oracle 10G RAC on AIX 5.3 for Development, test and Production environment. Upgraded the Databases and clusters from 10.2.0.1.0 to 10.2.0.4.0.

Configured EMC Legato networker for oracle (4.5) to backup the Database to tape using RMAN

Configured Oracle grid control to manage the entire database in single centralized location.

Worked on import/export, export data pump/import data pump and SQL- loader.

Replicated data for faster access, local access of shared data.

Applied database patches using Opatch utility and worked on conversion from single node to 2 Node RAC database for SIT and UAT systems

Automated the backup jobs using RMAN for all production databases.

Performance tuning for optimized results using tools including Explain Plan, SQL*Trace and TKPROF, AWR/STATSPACK.

Building Clone instances for SIT and UAT environments.

Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Load balancing, databases/schema/table re-organization for faster performance.

The size of the production databases between 500 GB and 3TB

Applying patches whenever required.

Upgrade and Migration of Database from 9i to 10g and 10g to 11g and applying patches whenever required.

Rebuilding of Indexes for better performance, maintenance of Oracle Database.

Upgraded SQL Server 2000 to 2005 and applied Service packs at database and OS level and Maintained Clustered servers to provide high availability.

Provided day–to-day administration tasks including space and log management in SQL serve2005.

Involved in Database Migration from Oracle database to SQL Server 2005 database using SSIS.

Data refresh from production to test and development using RMAN cloning or exp/imp utility.

Continuous Performance monitoring and Tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK etc

Providing Solutions to the Problem Faced by end Users Or Programmers

OS level activities including space monitoring of Mount points.

Provided on call support for Oracle database.

Environment: IBM AIX 5.3, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 9I/10g/11g, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0, Oracle 10g GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Guardium 6.0, Toad 8.6, Oracle Applications 11.5.8, Oracle Application server 10g, APEX 2.0/2.2,Sybase, SQL server

Consultant Wells Fargo, Charlotte NC June 2008 - Nov 2009

Oracle DBA

Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Redhat4

Installed RAC on Oracle 10g and worked on ASM feature of Oracle.

Created development, testing, staging, production for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Involved in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.

Managed DSS (Decision Support System) and OLTP (On Line Transaction Processing system) full life cycle projects with about 10 databases at one time, biggest database around 800 GB supporting both production developments on Unix and Windows NT/Windows 2000.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.

Responsible for migration of PeopleSoft applications from DB2 on MVS to Oracle on AIX.

Created the RACF System Security reports and Audit programs for all processors on the IBM Information Network

Research and apply PeopleSoft patches and product updates posted on PeopleSoft Customer Connection and PeopleSoft Applications.

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.

Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.

Capture, Propagation, Apply using Golden Gate.

Managed the migration of SQL Server 2005 databases to Oracle 11g.

Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency check, and index defragmentation.

Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

Worked on Automatic Storage Management (ASM) for managing data in SAN.

Performed Bi-Directional Schema Level Streams for Oracle 10g.

Created scripts and documented the Operational guide for Streams.

Created and Managed Jobs using AutoSys Job Scheduler.

Performed Uni-Directional, Bi- Directional Streams from HP-UX Boxes to Suse Linux Boxes.

Performed Table level Streams.

Extensive UNIX Shell scripting in csh, Pro*C.

Migrated database from 8i to 9i and 10g supporting various incremental releases.

Configured RAC 9R2 and 10g from HP-UX boxes to Win 2003 Boxes.

Configured, migrated and tuned of Oracle 9R2 RAC and 10g RAC.

Data Modeling, Database Design and Creation.

Involved in the Dimensional Data Modeling and populating the business rules using mappings into

the Repository for Data management.

Reverse engineering and forward engineering using Erwin.

Used Informatica as a Data Cleansing tool to correct the data before loading into the staging area.

Migrated database from Oracle 8i to 10g from Solaris 5 to Win 2003 and configured 10g RAC.

Maintaining the version control of the source code using Clearcase.

Design, review and maintenance of database structures.

Performance assessment, SQL scripts, stored procedures, functions and transactions analysis

Oracle Grid Control Management Server Installation.

Provided 24X7 support for production Databases.

Database backup and Database tuning for real time and batch systems

Assisting customer setup, tune and maintain Oracle database.

Proven expertise in object-oriented design and client/server application systems development.

Performed Performance tuning by using STATSPACK, TKPROF, AWR and ADDM and SQL Trace and TKPROF and Explain plan and Analyze and estimate on object level and schema level.

Data extraction from various sources, transformation and loading into the target Oracle database using Informatica Power Mart.

Experience in Data Modeling concepts including Data Vault, and also in Advance security including DB Auditing, Labeling.

Configured Physical Standby Database for Disaster Recovery using Datagaurd.

Documented the steps of installing and configuring the Crystal Enterprise for the networking department built the servers when we have releases.

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD, Foglight and Oracle Enterprise Manager.

Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Perform Oracle replication (advanced Queues, materialized views etc)

Devised and Implemented backup strategies using hot, cold, and exports based on the business requirements.

Implemented Backup-using RMAN (Recovery Manager) as a media management layer.

Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.

Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Developed UNIX shell scripts to perform the above tasks efficiently.

Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: Windows NT/2003/2008, HP-UX, AIX, Solaris and Linux, Oracle 9i and 10g/11g, SQL Server 2000/2005, Toad, RMAN, PL/SQL,SQL*Loader, SQL*Plus, PeopleSoft, Golden Gate 9.5, Informatica Power Centre 7.2, Erwin, Clearcase, Foglight, Autosys, SQL Backtrack, BMC Patrol, Aqua Data Studio 3.7,Query Analyzer, Oracle Fail Safe, Linux on NFS, blade system from HP.

Consultant Helen Of Troy www.hotus.com, El Paso, TX, USA Oct 2007 - May 2008

Oracle DBA

Review of Database logical and Physical design.

Install, upgrade, and maintain Oracle software products/versions for on Linux, Sun Solaris, and

HP-UX

Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.

Trouble shooting of various database performances by proper diagnosis at all levels including SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.

Configured Oracle Replication and Dataguard.

Performed incremental migration from Oracle 8i multi-master to Oracle 9i multi-master replication environment.

Installed RAC on Oracle 10g and worked on ASM feature of Oracle.

Migrated database Oracle 8i from Windows NT to Red Hat Linux with minimal downtime.

Administration, optimization, and maintenance of the Data Warehouse and Data Marts databases.

Worked with ETL tool Data Stage and Ware house tool Business Object.

Created and configured workflows, worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.

Worked on Informatica PowerCenter 7.1 tool – Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet and Transformations.

Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects

Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation

Implementing Database Security, Management of role-based security.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Used Oracle Advanced Queues feature to set up multi-master replication, dealt with conflict resolution and performance issues

Database Restore using RMAN, Cold Backup and Export.

Performed all systems and RACF Security Administration, including upgrades and installation.

Involved in Security (RACF) Administration.

Data Modeling, Database Design and Creation using Erwin.

Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.

Performing day-to-day database administration tasks including Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle

Corporation and installation of patches.

Used Triggers for database activities, including delete, update, and insert triggers for multi-master Replication.

Write and modify UNIX shell scripts to manage Oracle environment.

Problem analysis involving interactions/dependencies between UNIX and Oracle.

Production support for Oracle running on UNIX.

On-Call 24x7 DBA support for production databases.

OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM),

Data Migration as part of enterprise data warehouse project.

Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.

Cloning databases using scripts as well as RMAN. Installation, setup and configuration of DATA guard.

Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.

Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.

Providing for all RACF and DB2 authorities for new applications

Environment: Solaris 8.0/9.0/10.0, OAS 10g, Linux Red Hat, Windows 2000/2003/NT Oracle 8i (8.1.6/8.1.7), Oracle 9i/10gR1, RACF, Oracle Enterprise Manager, Oracle Partitioning, Informatica Power Center 7.1, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad, Erwin 7.2.

Lucent Technologies, Sunnyvale, CA, India July 2005 - Sept 2007

Oracle Database Administrator/ Developer

Installed and configured Oracle RDBMS on UNIX and Windows environments.

Performed Database upgrade of Oracle 9i from existing Oracle 8i system.

Involved in analysis of market risk and claims data.

Developed new PL/SQL programs – Triggers, Functions, Procedures and Packages to manage various business functionalities

Performing backups and recoveries using RMAN/conventional hot backups.

Other duties include applying Oracle database patches, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries, monitoring and optimizing database performance. Worked with DML SQL statements which were used to modify the client information in the current database tables.

Worked closely with senior DBA to understand the business and technical requirements.

Developed entity relationship, data flow and functional diagrams.

Designed database tables, implementing referential integrity.

Developed triggers which internally called procedures and functions.

Performed complex SQL query tuning, index reorganization, and Rollback.

Developed oracle forms and reports using oracle designer 2000.

Involved in all phases of the software development life cycle.

Designed and developed various UNIX Shell, PL/SQL and SQL scripts to monitor the database.

Designed appropriate backup and recovery procedures to meet the business requirements.

Involved in documenting the entire system architecture and data flow

Environment: Windows 98/NT/ 2000, UNIX, HP-UX, Oracle 9i/8i, TOAD, Database Tools/Utilities, Perl

Contact this candidate