Oracle Manager
Resume:
Varsha Dash
**********@*****.***
Current Location-San Jose,CA
Pay Rate-55$/hr
Employer-Saicon Inc
Senior Oracle DBA
Professional Summary
. 8+ years of experience, as an Oracle DBA with expertise in 8i/9i/10g/11g
installation, maintenance and administration including capacity planning,
database security, backup and recovery for oracle 8.x, 9.x, 10.x, 11.x
using RMAN.
. Worked on advanced queuing, developing disaster recovery strategy,
configuring oracle stream, performance tuning of OLTP databases.
. Experience in Oracle Parallel Server and Maximum Available Architecture
using Real Application Cluster and Golden Gate implementation.
. Expertise in technical consultation for the design, development and
implementation of enterprise data strategies, data warehouse and RDBMS
(Oracle 8i, 9i, 10g and 11g)
. Very strong experience in Physical and Logical Data Modeling, relational
data, Erwin, ETL.
. Thorough understanding of data warehouse principles, star schema
designing and deployment, designing summary layer to be used for
reporting tools like crystal reporting, transform database models and
entities into database objects.
. Experience in installing software, maintenance, backup and recovery for
Sybase ASE 12.5 and MS-SQL 7.0
. Pro active. . Motivated. Goal-oriented. Problem Solver.
. Excellent Team player, Strong leadership, A good Mentor, good
communication and interpersonal skills.
. Willingness to learn and adapt new emerging software technologies.
Education
Degrees
. BS. Electronics and Instrumentation from College of Engineering and
Technology, OUAT, India.
Certifications
. Oracle Certified Programmer, Feb 2007.
Training
. Oracle Apps 11i.
. Oracle Workflow and User Management.
. Oracle 9i RAC concepts.
. DR setup and implementation.
. Logical Modelling of OLTP and OLAP databases
. PCMM Level-5 process training.
Computer and Programming Skills
Languages -ASP,PL/SQL programming, Unix Shell Scripting
Oracle -Oracle 11i instances(1.5.5-11.5.10),10g discoverer, Oracle
Application Server 9iAS and Oracle Application Server 10g,Oraclr Release 12
RDBMS -Oracle 11g,10g,9i, 8.1.7, 8.0.6, Real Application Clusters (RAC) 9i-
11g, Data Guard, RMAN, HP Service Guard, VERITAS Cluster Server, Oracle
Failsafe, OID/LDAP, SQL Server 7.0.,
Modules- Oracle HRMS, Financials, Purchasing
Operating System - HP Unix 11I(11.11), Linux, AIX, Windows 2000
Professional, Windows NT, Sun Solaris 5.8, SCO-Unix, Windows NT/2000, UNIX
System Support
Hardware- HP Super Dome and HP L-Class Server and HP MCService Guard
Cluster
Tools:- Oracle Enterprise Manager (OEM), Oracle Statspack, Toad/SQL
Navigator, Quest Spotlight, Oracle Autoconfig and maintenance wizard,
Winrunner,
Config Mgmt- Visual Source Safe, Clear Case.
Experience
Title:Senior Oracle DBA
Client:Apple, Cupertino, CA
Dates:May 2010 - Till Date
Project:- Oracle Database Administration
. Installed and Upgraded multi terabyte oracle database from 10gR2 non-
RAC to 11g RAC on Red Hat Enterprise Linux and AIX for SAP
applications interfacing having multi million user interface.
. Planned and defined processes for new implementations.
. Analyzed rdbms patches and advised on course of action.
. Analyzed and advised application development team on query
optimization and overall performance enhancement.
. Responsible for Providing DBA support for mission critical and very
large (in Terabytes) 24/7 production instances, cloning test and
development instances from production environment, capacity planning
for existing production and non-production instances and forecasting
space requirements.
. Extensive experience in diagnosis, root cause analysis, impact
analysis and solutions for problems in production.
. Extensive knowledge and experience in performance tuning of oracle
9i,10g,11g non-RAC and RAC instances
. Was Responsible for crating a proven and tested plan to re-organize
database objects to optimize space utilization and performance
improvement
. Implemented 10g and 11g Data for critical production instances.
. Successfully implemented and maintained oracle grid control through
OEM 10.2.0.5
. Learnt SAP Basis Administration to understand the SAP interface tools
with oracle database like MOPatch,brtools, brbackup,brspace,brarchive
etc.
. Implemented Strategies for Backup and Recovery through RMAN for oracle
9i/10g and integrated with IBM Tivoli Storage Manager.
. Performed extensive research on Maximum Availability Architecture and
Exadata
. Migrated databases from clustered filesystem to ASM in 11gR2.
. Upgraded oracle database from 9.2 to 10gR2 RAC and converted to
UTF8(Unicode) characterset with CSSCAN and CSALTER.
. Installed, maintained and patching of GoldenGate products. Designed
and implemented backup and recovery policies for GoldenGate.
. As a senior DBA have been responsible to mentor junior dbas
Environment:
Oracle 9i /10g/11g database, Oracle 10g, Servers, AIX, Linux, RMAN,
Veritas Net backup, Export/Import,PL/SQL., Remedy,OEM
Title:Senior Oracle DBA Lead
Client: Cisco, Bangalore
Dates: Dec 2008 - April 2010
Project: Oracle Apps and Database Administration
. Successfully upgraded oracle database from 9.2 to 10gR2 and Oracle EBS
application from 11.5.10 to R12
. Upgraded and Migrated multi-terabyte(30+ TB) databases from Solaris to
Linux platform with character set conversion.
. Setup Oracle dataguard for Oracle 9i database..
. Performance tuning for optimized results using tools like EXPLAIN
PLAN, SQL*TRACE AND TKPROF, STATSPACK. AWR, ADDM
. Worked on implementing shared ApplTop and OATM tablespace migration.
. Migrated RAC databases to ASM.
. Implemented High Availability solutions with Oracle 10g RAC, Physical
and Logical Standby Databases (Data Guard) and Replication using
Oracle Streams.
. Experienced in Transportable Table spaces, SQL Tuning Advisor, Data
Pump, Flashback Table, Table space Management, Virtual Private
Database, Materialized Views, and Oracle Streams, partitioning of
tables and performance impact.
. Written user and technical documents on Sybase ASE 12.5
. Created multiple perl and shell scripts to automate Sybase
administration.
. Golden gate maintenance, administration and data replication.
Environment:
Oracle 9i /10g/11g database, Oracle 10g, Servers, AIX, Linux, RMAN,
Veritas Net backup, Export/Import,PL/SQL., Remedy,OEM
Title: Oracle DBA Lead
Client: Sony Electronics, Inc, San Diego, CA
Dates: Mar 2008 - Dec 2008
Project:
Oracle Apps and Database Administration
. Upgrading oracle database from 9.2 to 10gR2.
. Planning and defining processes for new implementations.
. Analyzing oracle application and rdbms patches.
. Involved in query optimization and performance tuning.
. Cloning development and test environments from production
environments.
. Providing DBA support for mission critical 24/7 production instances.
. Performance tuning of Oracle Parallel Server and Real Application
Clusters and Transparent Application Failure. Also tuning of massively
parallel oracle databases.
. Extensive performance tuning, instance tuning in Oracle 9i RAC and
SQL optimization.
. Regular database capacity planning related to database growth and
system utilization, trend analysis and predicting future database
requirements.
. Validated backup, recovery and disaster recovery plans.
. Data Modeling, Erwin, E/R studio, Data Warehousing, Extract Transform
and Load(ETL), Oracle Warehouse Builder.
. Responsible for Sybase Performance tuning for 30 Sybase Servers each
worth of 10 GB data.
. Designed new data models and reverse engineered existing schema using
perl/sybperl.
. Provided maintenance and enhancement programming for several
applications running on Sybase.
Environment:
Oracle 9i /8i database, Oracle 10g, Servers, Windows XP, Sun Solaris,
RMAN, Veritas Net backup, Export/Import,PL/SQL., Remedy
Title:Senior Oracle DBA Lead
Client: Cisco International, San Jose, CA
Dates: July 2007 - March 2008
Project:
Oracle Apps and Database Administration
. Cross Migration of environments across OS Platforms.
. Oracle Apps on 9i RAC database support and maintenance (Size 680G)
with avg 1000+ concurrent request processing per day for 3 separate
instance for North America, Europe & Asia-Pacific.
. RAC Implementation/migration for non-Apps Oracle Databases from shared
servers.
. Day to day administrative troubleshooting.
. Oracle database tuning for critical performance issues and Report
related issues, primarily directed towards optimizer behavior,
specific to RAC environment
. High end Performance Troubleshooting .
. Worked on standby databases for recovery.
. Responsible for Relational Database Design using Erwin and EOModeler.
. Unix Development, Staging and Production Environment setup.
. Backup/Restore Solaris, Linux, Windows, Oracle 9i/10g Database.
. Designed and setup the datamodel for Sybase 11.9. Installed,upgraded
and configured Sybase ASE 11.x and replication servers on Sun Solaris
and Windows NT.
. Involved in day-to-day monitoring,tuning,backup and refreshes of
Oracle and Sybase databases.
. Knowledge of the Oracle GoldenGate installation, configuration,
troubleshooting GG issues
Environment:
Oracle 9i /8i database, Oracle 10g,, Sun Enterprise Servers, Windows XP,
Sun Solaris, RMAN, Veritas Net backup, Export/Import,PL/SQL., Remedy
Title: Senior Oracle Database Administrator
Client: Lexmark International Inc, Lexington, KY
Dates: June 2006 - June2007
Project:
Oracle Database Administration
. Responsible for defining and implementing netbackup policy.
. Creation, cloning and upgradation of databases.
. Involved actively in schema management and performance tuning of
databases.
. SQL tuning of the application packages.
. Troubleshooting RMAN backup and recovery related issues.
. Troubleshooting performance loopholes.
. Developed backup strategy and validation, includes documentation of
backup processes, testing backup processes and validating successful
recovery from backup.
. Worked on integrating Veritas netbackup with the RMAN backup.
. Worked extensively with SOX auditors for the SOX level auditing of the
organization.
. Participated in data designing and modeling of schemas for baseline
projects.
. Involved in Disaster recovery planning and setup.
. Oracle 9i Real Application Cluster installation.
. Performance tuning for Oracle Real Application Clusters.
. RMAN implementation.
. Oracle backup and recovery solution design.
. Use of Statspack and explain analysis.
. Calculating the disk space and memory requirements.
. Designed databases using ERWIN.
. Planning Logical Volume (Raw device) allocation.
. Performance tuning, SQL tuning & Optimization using bit map indexes
and load balancing.
. Experience with use of Oracle Data Guard.
. Planning, Allocation and Monitoring of storage requirements.
. Maintained Oracle RAC systems, and reporting using Grid control.
. Exported data using export/import and SQL loader and usage of OEM
tools.
. Performed database and Peoplesoft application (SQR, SQL Plus, PL/SQL)
tuning; creating customized indexes to enhance data access as
required. * Gathered response timed statistics for various departments
and processes and performed database tuning.
. Experience resolving Peoplesoft application problems by
creating/analyzing Peoplesoft/Oracle 9i/10g trace files.
. Sybase 12.5 installation, configuration, tuning and backup.
Responsible for backup planning of database,Tran Log and Thresholds.
. Configured SQL server for maximum performance .
. Played key role for cross-platform migration of Sybase databases.
Environment:
Oracle 9i /8i database, Oracle 10g, Oracle ERP, 9iAS Application, Sun
Enterprise Servers, Windows XP, Sun Solaris, RMAN, Veritas Net backup,
Export/Import, PL/SQL., Remedy
Title: Senior Oracle Database Administrator
Client: Ashland Inc, Lexington, KY
Dates: Jan 2006 - June 2006
Project:
Oracle DBA Support for VIOC POS Data Migration
. Prepared strategy and plan for migrating data from one legacy system
to the other.
. Involved actively in schema management and performance tuning of
databases.
. SQL tuning of the packages used for migration of data.
. Rebuilding of indexes and Cost estimation of queries.
. Lock monitoring, diagnosing and troubleshooting performance loopholes.
. Developed backup strategy and validation, includes documentation of
backup processes, testing backup processes and validating successful
recovery from backup.
. Participated in design discussions to support project and baseline
work.
. Created and executed stored procedures and triggers with PL/SQL.
. Supported development effort by providing SQL statement tuning and
optimum data loading techniques.
. Migrated data from MS SQL Server database to Oracle database.
. Loading data using SQL Loader.
. Developed triggers to carry out advance validation.
. Performed database re-organization as required for performance
optimization.
. Database capacity planning by monitoring online storage, growth and
file system space.
. Installing and setting up management server and enterprise manager.
. Installing and configuring oracle on Unix and NT servers.
. Design, develop and maintain database integrity including
dictionaries, monitoring standards, access/security, performance and
server functionality.
. Installed and configured Oracle Enterprise manager for database
monitoring.
. Mentored the migration of Microsoft SQL Server 7.0 to Solaris Oracle
9i, doing schema re-engineering, conversion of TSQL stored procedure
to Oracle PL/SQL, transformation of all MS-SQL data tables to
Oracle.Knowledge and understanding of the P2ES architecture.
Environment:
Oracle 8i,9i,10g .SQL *Loader, Oracle RDBMS 10g, 9i, DBartisan, OEM,
SQL*Loader, Export/ Import, RMAN and PL/SQL, Unix shell sctipt.
Title: Oracle Database Administrator
Client: Telenor, Norway
Dates: Oct 2004 - Jan 2006
Project:
Oracle Database administration
. Preparing instance strategy and capacity planning.
. Recommended on infrastructure requirements.
. Oracle installation, configuration and performance tuning of 9i and
10g databases on Solaris server..
. Logical backups and hot backups using shell scripts and incremental
backups using recovery manager.
. SQL tuning, Memory tuning and I/O distribution were performed.
. Database cloning.
. Schema management and performance tuning of databases.
. RDBMS patch installation.
. System Administration of Oracle databases.
. Application of tools and database patches.
. Application of current level patches and upgraded the oracle database
and oracle applications.
. Managing concurrent programs and requests, monitoring concurrent
processing, setting priorities and determining the work shifts.
. Security classification of all the data related to HR and their
accessibility through responsibilities and roles.
. Prepared data masking script to be used as a post clone activity to
hide sensitive employee data.
. Worked extensively towards data security and data accessibility in
application as well as the database level.
. General troubleshooting, which includes resolving database-locking
conflicts, archiving and backup related problems. Solving problems
encountered in applying database patches.
. Implemented best practices on database monitoring, administration and
maintenance.
. Resolving issues related to Oracle databases processes and logging
iTAR with Oracle.
. Monitor database space usage, reorganizing the database files for
better performance.
. Tuning memory and I/O related problems. Tuning database buffers and
log buffers. Tuning archiving process.
. Overlaying different test instances with production data (refreshing
instances).
. Upgraded Oracle 8i to 9i as well as worked on converting database to
Unicode.
Environment:
Sun Solaris 5.8, Oracle 9i database, Oracle Application Server 10g, Oracle
E-Business Suite 11.5.10, Sun Solaris 5.8, 10g Portal, Oracle RDBMS 10g,
9i, OEM, SQL*Loader, Export/ Import, RMAN and PL/SQL, Oracle 10g
discoverer.
Title: Oracle Database Administrator/sysadmin
Client: Tata Consultancy Service, Mumbai
Dates: Dec 2002 - Oct 2004
Project: Oracle Applications & Database administration
. Oracle 8i and 9i installation, listener configuration, administration and
cloning .
. Customized APIs to suite the business needs.
. Developed shell scripts to automate the monitoring of services and
performance.
. Oracle Internet Directory set up, configuration and management.
. Managed user authentication, authorization and single sign on
implementation.
. Installation and administration of 9iAS Release 2(J2EE type
implementation).
. Oracle installation and migration to new releases.
. Database Backup and Recovery. Prepared strategy and plan for disaster
recovery site implementation.
. Created and maintained several standby oracle databases.
. Set up and manage physical database structures, tables, indexes, clusters
and partitions.
. Database cloning and Space Management
. Maintaining database security by creating roles, privileges, quotas and
passwords.
. Object maintenance by optimizing Storage Parameters and rebuilding
indexes.
. Monitoring and controlling the optimum use of rollback segments.
. Monitor and controlling user access to different database objects and
system resources.
. Tuned different applications for inefficient SQL statements.
. Troubleshooting and Technical Support on Oracle databases and Oracle
Applications.
. General troubleshooting, which includes resolving database-locking
conflicts, archiving and backup related problems. Solving problems
encountered in applying database and Oracle applications patches.
. Designing, deploying and maintaining data warehouse applications
including star schema designing and summary layer creation.
. Resolving issues related to Oracle Applications processes by System
Administration related setup, applying patch and logging iTAR with
Oracle.
. Monitor database space usage, reorganizing the database files for better
performance.
. Tuning memory and I/O related problems, database buffers, log buffers and
archiving process.
. Developed shell scripts to monitor the processes and database
performance.
. Overlaying different test instances with production data (refreshing
instances).
. SQL Server 7.0 configuration and administration. Preparing strategy for
the disaster recovery site implementation.
. Migration of 8i database from 32 bit to 64 bit.
. Experience in working with Oracle Corporation towards problem solving.
Developed pro-active Unix Shell scripts for Alerting for Run-out-of space
problems for tablespaces, Archive log's, House keeping, SQL Tuning.
Environment:
Oracle 8i/9i database, Oracle 9iAS, Oracle E-Business Suite 11.5.5, Windows
NT, Sun Solaris 2.7, HP-UX 9000 11.0, Enterprise Manager, Export/Import
Utilities and PL/SQL,MySQL
Title: Oracle Developer
Client: AppsLabs,Hyd
Dates: May 2002 - Dec 2002
Project:
. As an oracle developer involved in writing PL/SQL for the Oracle
application.
. Writing triggers and stored procedures to be used by the App
development team.
Involved in various levels of Testing starting from Unit, Assembly,
Integration and System, performance and stress testing.
Environment:
Oracle 81, PL/SQL, ASP
Contact this candidate