Oracle Engineer
Resume:
TARA CHARI
*********@*****.***
WORK STATUS : US CITIZEN
Summary:
0. Over 8 years of experience in the areas of database programming,
implementation, migrations/upgrades, maintenance and administration in
different phases like PROD, Dev and Testing.
1. Expertise in Oracle Databases (8i, 9i RAC, 10G & 11g) and proficient
with SQL, PL/SQL, Shell Scripting, Backup & Recovery policies,
Performance Tuning, Oracle Network Administration, Oracle Advanced
Replication, Shareplex Replication, OEM, Oracle Server Installations,
Migrations, DataGuard, 10g Grid Control, FogLight and DBFlash/Ignite.
Technical Skills:
Operating Systems Red Hat Linux AS4, Sun Solaris 8,
AIX 5.3, Windows NT
Languages SQL, PL/SQL, and Shell Scripting(Sed, Awk etc.)
Databases Oracle 8i/9i/10G (RAC)/11g, SQL Server 2000, and
MySql
Hardware Sun ULTRAs, SunFire 6800, 4800, Sun-E6500, E420R,
E450, AIX RS6000, Linux RH Intel/AMD based
servers, NetApps.
Case & G.U.I. Tools Erwin 3.5, Data Junction, VB 6.0,
Informatica, TOAD, PHP,
Developer 2000, Ignite, SQL Developer, Shareplex, Foglight,
Spotlight, OEM, 10G Grid Control, Weblogic
Oracle tools and utilities RMAN, SQL*Loader, Oracle DataGuard, RAC,
OFS,
StandbyDB, Net8, Management packs (OEM),
SQLDesigner, Expdp & Impdp, TKProf & Explain Plan
Professional Experience
Willam Sonoma, Inc. San Francisco Mar
2008 - Dec 2010
Oracle PRODUCTION DBA
Responsibilities:
. Evaluated the hardware requirements and installed Oracle (9.2.0.8,10g &
11g) on Unix servers(AIX & Solaris) and Windows Server as well and
migrated the database schemas as per the business requirements in
production and testing environments. Re-linked and applied the relevant
patches for the production databases on upgraded Operating Systems and
mapped the applications on the newly created databases.
. Upgraded the database from version 9.2.0.5 to 10.2.0.3.
. Installation of CPU patches periodically.
. Extensively worked on Performance Tuning in different methods like
partitioning & analysis, SQL Hints, tuning the initialization and
storage parameters, creating and maintaining various types of indexes,
reorganizing tables, implementation of statspack/AWR, dbms_stats, Row
Chaining, locking issues, comparing schema objects, cached tables,
rebuilding tables/indexes, Memory/CPU/Disk IO utilization at DB level,
identifying the hung processes, checking network bottlenecks and
rollback segments, Deadlock contention, Rewriting the poorly running
Sqls/Plsql etc.
. Assisted in the migration of the RMAN catalog from Windows server to
Oracle Server and re-synced the databases. Configured RMAN backup for the
newly built databases. Automated export and import backups for
development servers using datapump. Created an auxiliary database using
RMAN..
. Set up the monitoring for the db activities like DB startup&shutdown,
Lsnr up&running, Compress Log, Space issues at database as well as OS
level etc.
. Used expdp/impdp utilities to migrate the data between the prod
servers. Migrated the perfstat schema to another database and analyzed
the reports by using exp/imp in order to release the space on
production systems.
. Installed 10g grid control on production systems for monitoring the
performance issues and experimented with features like cloning
databases etc.
. Was involved in the creation of a physical standby database in the
dataguard environment and automated the recover process as per the
business requirements.
. Responsible for preparing the documents on the completed assignments.
. Participated on on-call rotation for 24/7 and proficient with
troubleshooting and resolving various oracle issues and communcation
with Oracle support.
. Environment: Hardware RS6000, OS AIX 4.3,5.1 & 5.3, Solaris 2.8,
Oracle 9i/10g/11g, 10g grid control, Net backup, Windows Server 2003
with SP1.
Schaferlabs, Sunol Mar
2007 - Jan 2008
ORACLE Database Administrator
. Evaluated the hardware requirements and installed Oracle (10g) on
Linux and Windows Servers. Migrated the database schemas as per the
business requirements in production and testing environments.
Re-linked and applied the relevant patches for the production
databases on upgraded Operating Systems and mapped the applications on
the newly created databases. The database was upgraded from version 8i
to
10.2.0.3.
. As a backup programmer, assisted in converting more than thirty
legacy programs written in Fortran to PHP 5.0 to help the transition
from command line interface utilities to web applications.
WebEx Communications, Inc. San Jose, CA Mar 2005 - Jan 2007
ORACLE Database Engineer
Responsibilities:
2. Oracle 8i/9i(RAC) installation on Solaris 2.8 and proficient with HP,
Linux Systems (both 32 bit & 64 bit)
3. Experience in 10GR2 RAC installation on a three node Linux AS 4.0 with
ASM in a test environment.
4. Evaluated and configured DBFlash, a third party tool for performance
bottlenecks like identifying the top SQLs, oracle events, users etc.
5. Configured Shareplex replication channels for production and test
databases with 4.5 and 5.1 versions and involved in fixing day to day
issues like capture, post, export, import processes etc.
6. Maintaining high availability of various applications running on
terabyte databases. Configured Oracle Advanced Replication
(Materialized views)
7. Gained knowledge on MySql databases and Quest Foglight Tool.
. Participated in the weekly capacity planning meeting to improve and
proactively monitor the current/future requirements.
8. Involved in Standby db configuration on Solaris 2.8 for Oracle 9i and
fixed issues like lagging behind archives, adding datafiles etc.
9. Gained knowledge on configuring web servers for daily reports on the
databases.
10. Fixing the Remedy Tickets created for db level issues like dml
operations, adding new schemas, granting privileges, exp & imp dmp
file, deploying new scripts, creating test dbs etc.
11. Migrated the report database from 8i to 9i and mapped to the
environment.
12. Developed shell scripts for automation of db statistics, archiving log
files, trapping Ora errors, system load etc. Extensively used LogMiner
to recover DML operations.
13. Worked on oncall rotation for 24/7 support to fix various types of day
to day production issues.
Environment: Oracle 8i/9i/10g(RAC), Sun E3500/420R, RedHat Linux AS4,
Solaris 2.5/6, Hp-UX 11.0, Windows NT 4.0, RMAN, Shareplex 4.5&5.1
Wilshire Software Technologies, India Jan 2000 - Oct
2002
Database Administrator
Wilshire Software Technologies is involved in maintenance and support of
client-server applications and has Training and Development Organization
which provides Oracle Database Administration and Unix Administration
services to the clients.
Responsibilities:
14. Installed Oracle 8.x, 8.1.6 (8i) on Linux 6.2, Solaris 2.7, and
Windows NT and created customized databases.
15. Implemented TCP/IP based network on Oracle Database Server with NET8
software for client server and distributed database environments.
16. Configured Multi-Threaded Server (MTS) architecture for optimum usage
of system resources.
17. Designed & developed database models using Erwin Case Tools (Tables,
Indexes, Views, Triggers to implement Business Rules, Procedures etc).
18. Implemented LogMiner and transportable Tablespaces and Locally Managed
Tablespaces.
19. Implemented Hot Standby Databases for fail-over situations.
20. Implemented basic Replication (Multi Master) across multiple operating
systems.
21. Performance tuning of Oracle 8i database on Linux 6.2 (includes
optimization of Oracle init.ora, I/O balancing and memory tuning).
22. Configured Intelligent Agent for OEM. Implemented oracle Enterprise
Manager on a NT box to monitor all databases and perform advanced
diagnostics and tuning.
23. Periodic Exports and Imports to reorganize the database and to move
database from one to other database.
24. Implemented Oracle's software striping on tablespaces for optimal
performance using different disk drives.
25. Designed proper indexing strategy on transaction tables for optimal
performance.
Environment: Oracle 8.1.7, 9.x databases, Solaris, Linux, Windows NT/2000.
Education:
Post Graduate Diploma in Computer Applications, NIIT, India.
. Masters in Personnel Management, Osmania University, Hyderabad, India.
References:
Provided upon request.
OCP: Partially done.
Contact this candidate