Your Name
|
Your
Address: |
Work: 091-040-7612214,6501081Mobile:Email:
xyz@wilshiresoft.com |
Objective: A challenging position as an ORACLE DBA
|
Experience: |
Oracle DbA & Systems Administrator Wilshire
Software Technologies, Hyd, India. |
Dec 1999 – Present
|
In-House responsibilities:
·
Installed Solaris 7 on Sun SPARC Server, configured Filesystem and Raw-Devices.
·
Configured SCSI controllers for SCSI-Disks and backup tape
drive for nightly backups.
·
Installed X-Windows (emulation) on Win-95 using third party
software Reflections.
·
Configured Terminal Servers & Print Servers with TCP/IP
address.
·
Implemented Oracle 8i databases on SAN (Storage Area
Network) environment.
·
Installed Oracle 8.1.5 (8i) on Sun SPARC, 8.1.6 on LINUX and created customized database.
·
Implemented TCP/IP based network on Oracle Database Server
with NET8 option.
·
Configured Raw Devices in Solaris for enhanced Oracle’s
database I/O performance.
·
Configured Multi-Threaded Server (MTS) architecture for
optimum usage of system resources.
·
Designed & developed database structures using Erwin Case Tools (Tables, Indexes,
Views, Triggers to implement Business Rules, Procedures etc).
·
Implemented new features of Oracle 8i like LogMiner,
Transportable Tablespaces, Locally Managed Tablespaces, Hot Standby Databases
for fail-over situations, Multiple Archive-Log Destinations that support Hot
Standby Databases, Advanced Indexing etc.
Client Responsibilities:
Implementation
of Automated Bus Pass Generation for APSRTC, using Oracle 8.0.5 on Windows NT.
·
Installed
Oracle 8.0.5 on Windows NT Server (HP LC 2000, P-III 700MHz, 512 MB RAM)
·
Established
Oracle database connection for Visual Basic application using ODBC Drivers
& Net8 based on TCP/IP.
·
Designed
& developed database structures using Erwin Case Tools (Tables, Indexes,
Views, Triggers to implement Business Rules, Procedures, etc).
·
Created
databases for different applications keeping in view space & performance
requirements for coming months.
·
Implemented
Oracle’s software striping on tablespaces for optimal performance using
different disk drives.
·
Trained
developers to optimize PL*SQL Procedures and SQL queries.
·
Designed
proper indexing strategy on transaction
tables for optimal performance.
·
Implemented
Recovery Manager utility (RMAN) for easier and well-managed recovery
procedures.
·
Suggested
the management in purchasing of licensed Oracle Software.
·
Implemented
Advanced Replication (Multi Master) across seven different geographical
locations spread across the twin cities for high availability of data without
compromising the performance.
·
Tuned
the SGA (init.ora parameters) keeping in view the Replication requirements.
·
Implemented
the usage of various reporting scripts to resolve conflicts during Replication.
·
Trained
professionals to manage Replication (Administrators & Operators).
·
Documented
the Backup Procedures and Replication Environment.
Implementation
& Performance Tuning for B2B Web-based database at Goldengate Technologies.
·
Performance
tuning of Oracle 8i database on Sun SPARC
(includes optimization of UNIX kernel, Oracle init.ora, Oracle SGA, I/O
balancing and memory tuning.
·
Converted
very slow and complicated views to tables and implemented database triggers to
update them automatically.
·
Implemented
nightly backup routines, which include database exports, tape backup and
copying database files to the development server for precautionary measures.
·
Implemented
Hot Standby database for fail over situations.
·
Implemented
multiple ARCHIVELOG destinations to archive redo logs to the development server
to support immediate database recovery.
Implementation
& Performance Tuning for Corporate database at VOLTAS India Limited.
·
Performance
tuning of Oracle 8.0.4 database on HP-Unix (includes Oracle init.ora, Oracle
SGA, I/O balancing and memory tuning.
·
Suggested
Backup Strategies for implementation of nightly backups using Unix Cron Jobs.
·
Customized
the SGA (two init.ora files) for different types of requirements during the
days & nights.
Computer Skills:
|
Hardware |
: |
Sun SPARC, HP-9000, Intel Pentiums (II, III) RAID
servers. |
|
Operating Systems |
: |
Solaris 7, Linux (5.2, 6.2), Win NT 4.0, Win 98. |
Databases
|
:
|
Oracle 8i Enterprise edition, SQL-Server, MS-Access.
|
Tools
|
:
|
Oracle’s OEM, ERWin, DBArtisan, DataJunction.
|
Languages
|
:
|
SQL, PL/SQL, C, UNIX Shell Programming.
|
Networking
|
:
|
TCP/IP, NetBEUI Protocols.
|
Education:
·
M.S.
in Computer Science, George Mason University, Washington D.C. (June1997).
·
B.S.
in Computer Engineering, Osmania University, Andhra Pradesh (March 1995).
Honors & Activities:
·
Represented
State level Basket Ball Team.
·
Organized
Blood Donation Camp
·
Enjoy
playing Ping-Pong (table tennis), badminton and cricket.
References will be furnished upon request / Willing to Relocate.
 |