Soumya
Roy Choudhury
SUMMARY:
- More
than 7 years of experience in IT industry.
- Wide
exposure to Oracle 8i/8.x/7.x.
- Over
3 years of experience as an Oracle DBA.
- Experience
in Oracle Support Services.
- Experienced
in Database Administration of VLDB (size 1 Terabyte), which
includes Re-organization, Tuning, Capacity Planning and overall
Monitoring.
- Oracle
Database Administration involving Installation and Configuration of
databases, Tuning, Client/Server connectivity, Query Optimization and
post-installation Troubleshooting.
- Sun
Sparc Solaris (2.6/ 8) System Administration.
- Experience
in implementing Unix OS backup strategy for Sun Sparc Solaris 2.6/8
in Enterprise Servers including Remote Backup to DLT drives using
autochanger/jukebox.
- Implementation
of Remote and Local Oracle database backups using RMAN.
- Upgrade
of Oracle 8.0.x databases to 8.1.6 (8i).
- Migration
of Oracle 7.3.x database to Oracle 8.0.x.
- Strong
in UNIX shells and C programming.
- Good
knowledge of HTML.
- Passed
Test 1 (1Z0-001) of Oracle 8i OCP DBA track with 95% score.
- Passed
Test 2 (1Z0-023) of Oracle 8i OCP DBA track with 95% score.
SKILLS PROFILE:
|
Hardware:
|
Sun ES5000, Sun ES4500, IBM NUMA-Q Dynix, RS/6000, Compaq
Prosignia
|
|
Operating System:
|
Solaris 8/2.6, Dynix 4.4.6, AIX 4.2, HP-UX 10.x, DG/UX,
SCO UNIX V5 Open System, SGI-IRIX, Windows 2000, Windows NT 4.0/3.51, Windows
98, Novell Netware 4.x, UnixWare, DOS
|
|
Languages:
|
Unix shell programming, PL/SQL, C, HTML, Pro*C
|
|
Special Software:
|
Solstice Backup 6.0, Legato Networker Module for Oracle
3.0, Solstice Module for Oracle 2.1, Applixware 4.3/4.1, DFTK
|
|
Tools:
|
Developer 2000, Oracle Enterprise Manager, SQL* Plus
|
WORK DETAILS:
AT&T Research, Florham Park, NJ, USA Mar 01 – Present
Oracle Database Administrator and Sun Solaris Administrator
Responsibilities:
- Solely
responsible for the Oracle Database administration on two SUN
ES4500 Servers and other small-scale servers and Solaris backups on
five SUN Enterprise Servers.
- Installation
of Oracle 8i (8.1.6) software in separate ORACLE HOME in the same server
housing Oracle 8.0.4, and gradually upgrading one database at a time.
- Creating
Oracle databases in compliance with the OFA and spanning across multiple
physical disks.
- Installation
and configuration of Oracle Web Application Server 4.0.8.2.
- Configuring
and automating the hot and cold Oracle backups for the databases
(archivelog mode and no-archivelog mode) in both 8.1.6 & 8.0.4 and
running backups for both the versions in parallel using Solstice Module
for Oracle 2.1 to DLT drives having autochanger and 32
slot. Also configured volume pools for separating backups of
Oracle databases from UNIX backups.
- Creating
and configuring multiple Oracle recovery catalogs for
local and remote Oracle backups.
- Configuring
a new Sun Enterprise Server to run Oracle 8.1.6 and creating databases
in that server.
- Configuring
remote Oracle RMAN backups involving three Sun ES4500 Servers.
- Restoration
of Oracle databases in the event of physical disk failure.
- Monitoring
the Oracle databases and estimating the space requirement
and allocating the resources for the databases.
- Using
various OS utilities for monitoring the health of the database servers.
- Automating
database backups using Export/Import utilities in compressed
format.
- Working
with Oracle Support Team and Sun Support Team and raising
TARs for different Oracle and Solaris issues.
- Assisting
the developers for tuning application queries using various features of
Oracle 8i.
- Upgrading
and configuring the resources for the Solstice Backup
software for UNIX backups from different versions to SBU 6.0.2/6.0.1
on four Sun Enterprise Servers.
- Configuring
and implementing the remote UNIX backup for Sun
Enterprise Server to the DLT pool of remote Enterprise Server using DLT
pool and autochanger.
- Restoration
of UNIX OS files in the
case of file deletion etc.
- Hands-on
learning the new features of Oracle 8i.
- Gaining
theoretical knowledge about Oracle 9i.
- Preparing
for the OCP 8i DBA Track.
Environment: Oracle 8.1.6, 8.0.4, Solstice Backup
Software 6.0.2, Legato Networker Module for Oracle 3.0 on Sun Solaris 8,2.6
(SUN ES 4500).
SONY Electronics Ltd, Park Ridge, NJ, USA Jan 01 – March 01
Oracle DBA Consultation
Responsibilities:
- Study
of the production and development system Oracle databases in the HRD
department.
- Creating
analysis report of the environment, identifying the various
issues/shortfalls of the system and recommending the processes
necessary for the betterment of the overall system.
Environment: Oracle 7.3.2 on HP-UX 10.2.
GE Capital, Leeds, UK Dec 99 – Nov
00
Oracle Database Administration and Onsite Co-ordination
Responsibilities:
- Managing
and supporting a 1 TB sized production database comprising of 1245
datafiles (VLDB). This database is considered to be the largest
marketing database in Europe.
- Database
support and maintenance.
- Tuning
and Optimization of SQL scripts, queries (including distributed)
written by developers, using various hints etc.
- Maintenance
of database objects, written various scripts for tablespace reorganization,
export/import to/from compressed format files, tracking and
monitoring day-to-day data loading.
- Recovery
of a table truncated from the production environment, without
sufficient disk space in the test environment.
- Calling
Oracle Support to discuss different database related issues/problems
and raising TARs through Oracle Metalink and/or 24 hour customer
support hotline.
- Export
and import of tablespace/schemas.
- Analyzing
tables and indexes to assist the optimizer and to validate structure.
- Day-to-day
maintenance of database and help to developers and end-users.
- Co-ordination
between the onsite and the offshore team.
Environment: Oracle 8.0.4 on Dynix/ptx 4.4.6 (IBM
NUMA DYNIX).
F. Van Lanschot Bankiers N.V., Netherlands Dec 98 – Nov 99
Oracle Database Administration
Responsibilities:
- Installation
of Oracle software and creation of database.
- Database
re-organization.
- Managing
of 6 Oracle databases in development and testing environment.
- Created
shell scripts for various operations.
- Database
backups and restoration.
- Tuning
and optimization of SQL scripts, queries written by developers.
- Creation
of database stored procedures, packages and triggers.
Environment: Oracle 8.0.4 on AIX 4.2 (RS/6000).
Oracle Support Group, Tata Consultancy Services, India
Jan 98 – Dec 99
Oracle Database Administration
Responsibilities:
- Installation
and creation of Oracle 7.3.4 and Oracle 8.0 databases.
- Installation
of different tools like Developer 2000, Designer 2000.
- Configuring
of SQL*Net and Net 8.
- Troubleshooting
of Oracle database and different tools.
- Providing
Oracle Support Services to various clients.
- Interaction
with the Oracle Support Group from Oracle Corp, India.
- Creation
of users, tablespaces, rollback segments, profiles etc. and maintenance of
the same.
- Using
export/import for taking database backups.
- Managing
of data files, log files, control files and archive log files.
- Performing
database recovery in archivelog mode.
- Monitoring
Oracle databases and tuning through init<sid>.ora parameters and UNIX
kernel parameters.
- Installation
and configuration of Oracle Web Application Server.
Environment: Oracle 7.x, 8.0.3, Oracle*Forms 4.5.5.0,
Oracle Reports 2.5.3.0, Oracle Graphics 2.5/3.0, SQL*Net 2.x, Net 8, Oracle Web
Server 3.0 on different UNIX platforms – SCO UNIX, SVR 4.2, Solaris 2.5, DG-UX,
AIX 4.2, HP-UX 10.2, SG-IRIX 6.4 & Windows NT.
NASDAQ, Maryland, USA Jun 96 – Dec 97
Technical Team Leader and Database Administrator/Support
Responsibilities:
- Support
of Oracle databases.
- Using export/import
for taking database backups.
- Using
SQL*Loader for data loading.
- Maintenance
of database and help to developers and end-users.
- Assisting
in database upgrade.
- Development,
enhancement and maintenance of the application software.
- Assisting
the Quality Assurance Group.
Environment: Oracle 7.3/7.2 on Sun Solaris 2.6/2.5
(Sun Sparc 2000).
J Kalachand & Co. Ltd, Mauritius
Dec 95 – May 96
Oracle Developer
Responsibilities:
- Development
of application software using Oracle Developer 2000.
- Creation
of database stored procedures using PL/SQL.
- Testing
of programs and defect logging.
- Assisting
the Quality Assurance Group.
Environment: Oracle 7.1, Developer 2000 on Novell
Netware 4.1 and Windows 95.
White Industries Australia Limited, Sydney, Australia Nov 94 – Dec 95
Oracle Developer
Responsibilities:
- Development
of programs using SQL*Forms 3.0, SQL*Reportwriter 1.1 and Pro*C 1.5.
- Creation
of database stored procedures using PL/SQL.
- Testing
of front end programs and database stored procedures and defect logging.
- Rectification
of errors and defect log closure.
- Internal
Quality Assurance.
- Implementation
and acceptance.
Environment: Oracle 7.0, SQL*Forms 3.0,
SQL*Reportwriter 1,1, Pro*C 1.5 on SCO UNIX.
EDUCATION: BS in Computer Science.
