Manager Oracle
Resume:
Title:Database Administrator
******@*******.***
Document
Source below
NAME: JOHN DURAI
ADDRESS:
CITY: LakeForest
STATE/PROVINCE: Ca
ZIP/POSTAL CODE: 92630
COUNTRY: USA
EMAIL: ******@*******.***
PHONE: 949-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
HOTSKILLS:
ESUME
JOHN BENEDICT DURAI
21641 Canada Rd,6J
LakeForest,Ca 92630
Res: 949-***-****
******@*******.***
Over 12 years of experience in the information technology industry
with over
six years as an Oracle DBAwith strong skills in Database
Administration and
Oracle tools & utilities. Over 2 years in Oracle based Web
administration&
development. Extensive Knowledge and experience in application like
Oracle
Server 7.3/8,Oracle Applications10.7, Designer2000,Developer2000,
CGI
application (Perl), Discoverer 3.1 . Hands on experience as an Oracle
DBA as
well.Administered and maintained at the maximum of 550 GB databases.
Sound
knowledge in performance tuning, application implementation back up
recovery
and other client developments.
Exposure:
Hardware:CDC, HP 9000, Sun Solaris E-4500, Sun ULTRA 60, Sequent NUMA1
Operating Systems:Windows NT 4, Windows 95, Sun Solaris Netra 2.6,
Novell
NetWare5, ScoUnix, HpUx10.20, Dynix 4.4.2, Solaris7,Netra 2.6
Languages:C, Pl/Sql, Perl,K shell, Borne shell (Unix shell
programming)
Web applicationCGI -Perl 5.0(DBI/DBD ), Html 3.0, Oracle Web Server
Application:Oracle Application 10.7, Clarify application
RDBMS:ORACLE Server7.3.4/8.0.5, Oracle Web Server 3.1, and SYBASE SQL
anywhere
RDBMS Tools:Developer/2000 (Forms 5.0, Reports 3,Graphics 3), PL/SQL
2.5,
SQL forms 3.0, SQL Plus 3.3, ProC 1.5,PowerBrowser, Procedure Builder,
Discoverer 3.1.,Legato Backup manager, ReflectionX (X-terminal)
DBA Tools:Sqldba,EnterpriseManager,ReplicationManager,SVRMGR,
Patrol
Case Tools:Power Designer, ER-Win, Data Architecht,Designer2000
Web Tools:Ms Visual InterDev, Internet Information server 4.0,
FrontPage 98,Netscape Enterprse Server.
DBA Skills
Performed the role of Database Administratorformultiple instances
with
very large volume of data .(VLDB)
Installation of Oracle databases and evaluation of the hardware for
the
database servers. Planning and designing databases including designing
logical
structures and forecasting future expansions
Tuningthe performance of thedatabases with respect to memory, I/O,
and
data contention
Tuning of Oracle Financial databases (monitoringConcurrent
managers).
Good knowledge of Oracle Web Server, many flavours of Unix O/S(Hp
Ux 10.20,
Dynix4.4.2, Solaris 7, Sco Unix)and datawarehousing.
Very good knowledge in Backup and Recovery of the Database
Very good knowledge on Snapshots( Symmetric Replication, Data
warehousing)
Creating Test instance and moving database objects from the
Production
Testing and Migration of the database to a newer version of RDBMS
Experienced with security administration, creation of roles and
granting the
necessary object/system privileges for users
Populating the Oracle Database Tables from Flat files using
SQLLoader
Replicating Data between Servers using Replication server option
Monitoring the growth of the database objects
Defragmenting the database objects
Export and Import of database objects
Deployment of applications on different client workstations.
Configuration of
distributed databases with SQLNet V2.0 for single community using
TCP/IP
Creation of database links to access data from remote databases
Having knowledge in Parallel Server Configuration and Multi-threaded
Architecture.
Good Coordination with system administrators and network
administrators to
achieve zero downtime and better server performance.
PROFESSIONAL EXPERIENCE (Specific projects)
Western Digital Corp: (an ISO 9001 Hard drive manf. Co.)Irvine CA
92618
Work Phone : 949-***-**** Residence : 949-***-****
Through :
Cap Gemini America
Title: Database Administrator
Duration: August98
- January 31st 1999
Hardware : HP 9000, Sun Solaris Enterprise 4500,Ultra 60,Sequent NUMA
1
Operating system : Hp Ux 10.20, Solaris 7, Dynix 4.4.2, Windows NT4,
WinFrame
Cluster
Rdbms : Oracle 7.3.4 / 8.0.5 with Parallel, Partition & Replication
Options.
Application: Oracle applications 10.7, Clarify 5.0,Oracle Enterprise
Manager.
Concurrent manager For Financial applications, BMCPatrol
Roles & Responsibility
Administer the Clarify(Oracle Server 7.3.4) & the Financial
application
database..
Creation of Development instance from the Production (Clarify
instance) for
Y2K test & development.
Creation& Maintenance ofFact tables (Universes of Inventory,
Invoice, BOM
) from multiple dimensions snapshots (for Datawarehousing Project)
using Oracle
Replication Manager from the ERP database tables (Oracle Financial).
Maintenance of Snapshot groups, refresh groups, mastersite log
refresh for
fast and complete refresh of snapshots (D. W. Project) from different
ERP
databases.
Involved in themaintenance (daily refresh) of Reporting (DRE)
database for
Oracle applications.
Monitoring Concurrent managers for Oracle Reports.(System
administration GUI,
Defining users. Scheduling, Creation of Data groups, Report sets,
Menus,
Printers . Resubmission ofJobs, Assigning different responsibilities
to
Oracle Users).
Analyzing & monitoring the problem areas of System idle time, System
RunQ,
Network, CM workers, CM running jobs, CM pending, Cm jobs completed,
Cm jobs
Erring out, Dump space, Applmgr common space, Archive log space,
Alert log,
locks, Session events, Latches, SQL Area& SQL cursors.
Written shell scripts toautomate page & emailalerts forspace &
memory
management .
Coordinate with SA'sin Backup & Refreshschedules for multiple
instances.
Migration ofOracle Financial reports & Forms to the Server(Unix) and
the
middle tier Winframe Cluster NT Box (Character based & GUI via NFS
mount) from
the development to test,integration &production environment.
Development ofSLAdatabase and monitoring database administration
activities via web ( http://sladba.wdc.com ) .
Apl Group Incorporated
., (EC/EDI development Company)
Software development Company
(1-800-***-****) Connecticut 06897
Duration : March 98
-August1998
)Reference: David Strong 1-800-***-**** ext 269 DBA
Database Administrator (Oracle)
Project Name : Vendorsite Development (Supply Chain Management);
Client : Pitney Bowes
Detail: VendorSite is a Internet Web site for Pitney Bowes that links
manufacturing companies and their suppliers into a trading community
where they
can conduct a variety of electronic commerce transactions covering the
full
supply chain management process. The projectconsists of3 different
phases
1. Vendorsite Web based EDI server hosted at AplGroup 2. VendorSite EC
delivery
services. 3. VendorSite annual maintenance and support. The overview
of the
VendorSite project is interchange of information about online material
transaction,planning schedule,automatic tracking of shipment
details,
online payment details, advanced shipment noticebetween Pitney Bowes
and
their reputed Vendors through EDI translators andworld wide web.
Roles & Responsibility:
Design & Development of Oracle database tables.
Installation and maintenance of Oracle 7.3 on Sun Solaris
Creation of tablespaces (datafiles),Segments,extentsand blocks
Adopting business rules, normalization and referential integrity
Process Modeling and Business Process Reengineering.
Administration of the physical database and the logical database
structures.
Wrote stored procedures and database triggers for symmetric
replication.
Altered of tablespaces and storage parameters.
Created the script forcronjob( Sun solaris shell script) for
schedule
backup and update database
Written the pl/sql scripts for loading data from flat file to oracle
database
tables.
Tuning of Sql statements Perl modules for optimal performance in the
web.
Embedding the sql statements in the cgi-perl scripts for accessing
the oracle
tables in the web.
Prototyping the project with productiondata at the test instance..
Publish the web pages inthe world wide web.
Implementation of the projecton web .
Hardware:Sun Solaris Netra 2.6Dual Processor, Compaq prolient 800
Software:Oracle 7.3.4 for Solaris, Developer 2000 v.2.1, Power
Designer, Oracle 8 for Windows NT
O/S:Sun Solaris 2.6, Windows NT,Windows 95
Languages:Forms5,Reports 3, CGI - Perl 5, Pl/Sql 2.5, HTML
3.0/4.0
Tools:Microsoft Front Page 98,VisualInterDev
Web ServerNetscapeEnterpriseServer3for Sun
Solaris,Internet Information Server 4.0 for Windows NT
Experty Holding Company, Bangkok, THAILAND
Duration: Jan 1997 to Feb 1998
Title: Database Adminstrator / Analyst
Project Details: Installation of Database, Creation of tablespaces and
datafiles (Logical segments, extents & blocks) Designing the database
models,
preparations of entity Relationship Diagram, Process Modeling,
Business Process
Reengineering, Generation of database and development of applications,
Data
conversion (Downsizing from db2, Upsizing from xbase). Making business
rules
and referential integrity to the tables
Involved in the Detail Design, Customization and Implementation of
Oracle
Applications 7.3 modules of Oracle Purchasing, Accounts Payables,
Accounts
Receivables and General Ledger. Involved in setting up of concurrent
manager to
run concurrent programs, printer setup, define accounting flexfields
and
descriptive flexfields, creation of value sets, setting up of calendar
periods
and various setup activities of Oracle applications using PL/SQL
procedures &
packages.
Roles & Responsibility:
Performance tuning of production instances
Installing and configuring ORACLE 8.0
Implementing the Symmetric Replication environment
Synchronization of Productionand the Staging instances
Recovery of Database Instances.
Deployment of various applications to Staging and Production
environments.
Creating necessary storage and data structures for the application
packages
Monitoring the System usage and growth of the Database objects
Fixing the fragmentation's in Tables and indexes
Analyzing tables and indexes and rebuilding indexes at regular
intervals.
Other Basic Database administration responsibilities.
Maintenance of Oracle Financial database tables.
Creation of tablespaces (datafiles),Segments,extentsand blocks
Adopting business rules, normalization and referential integrity
Process Modeling and Business Process Reengineering.
Administration of the physical database and the logical database
structures.
Wrote stored procedures and database triggers forreplication.
Altered of tablespaces and storage parameters.
Created the script forcronjobfor schedule backup and update database
Written the pl/sql scripts for loading data from flat file to oracle
database
tables.
Tuning of Sql statements Pl/sqlmodules for optimal performance in
the
client server environment.
Hardware:Compaq Prolient 800 Dual Processor
Software:Oracle 7.3.2 for NT / Novell, Oracle 7.3 /8.0 Sun Solaris
O/S:Windows NT, Novell Netware 4.11, Windows 95,Sun solaris
Languages:Developer2000, Oracle Enterprise Manager,Replication
Manager.
Samrong Hospitals
Bangkok, THAILAND
Duration:August 97
to October 97
Project Hospital Management system
Title: Database Administrator
Involved in the administration & development of hospital management
project
(Samrong Hospital, Bangkok) the responsibility is to change the data
and
application from VAX to oracle application for the whole Hospitals
management
application. Designing the database in power designer and developing
the
application in Forms 4.5,Graphics2.5 and report 2.5. Now I was
involved in
projects like Integrated Inventory control system, General ledger
application,
Elevator pricing and information system, Preparation of quotation &
invoicing.
Roles & Responsibility:
Administer andSupport 4 production, 4 staging and 6 development
instances.
Performance tuning of production instances
Implementing the Symmetric Replication environment
Synchronization of Productionand the Staging instances
Recovery of Database Instances.
Deployment of various applications to Staging and Production
environments.
Creating necessary storage and data structures for the application
packages
Monitoring the System usage and growth of the Database objects
Analyzing tables and indexes and rebuilding indexes at regular
intervals.
Hardware:Compaq Prolient 800 Dual Processor
Software:Oracle 7.3 for NT,7.1 for Novell
O/S:Windows NT, Novell NetWare 4.11, Windows 95
Languages:
PowerDesigner,ErWin,Discover,EnterpriseManager,Developer2000
M/s Northern Elevators, Bhd. Penang, Malaysia
Duration:April 97
to Oct 97
Project Elevator information system.
Title: Database Analyst/Database administrator
:
The details of the project are to automation of the service calls,
consolidation of client information, conversion of old data from Db2
to Oracle
Database engine. Creation of form modules such as data entry,
updating,
manipulation, calculation of client service charges, customer contract
information, contract period intimation, sending automatic renewal of
customer
contract, abstract about the customer calls, Material resource
planning about
the customer lifts. Material information system, Invoices update to
general
ledger.
Role and Responsibility:
Creation of Databases through Business process Reengineering in
Designer 2000;
Creation of Entity Relationship Diagrams through Process Analyst &
Data
Architect; Generation of (tables, views, synonyms and indexes) via
Designer
2000; Making business rules such as integrity constraints and
referential
integrity to tables; Creation of users and their roles in Oracle SQL
Plus;
Design of database triggers for tables; Initial design of screens and
giving
instructions to the developers for the creation of Form triggers
(event
triggers); Prototyping of database tables for feasibility.Checking and
testing the forms after the development stage; Implementation of
software in
clients site; Getting feedback from users and instruct the developers
to change
the forms appropriately.Maintenance of the whole software through
online
modem (connected from client's site to MIS center.)
Hardware:Compaq Proliant800 - 233
Software:Oracle database 7.3 for NT, Oracle Enterprise manager.
O/s:Windows NT
Package:Developer 2000 (Forms 4.5, Reports 2.5 Graphics 2.5)
Manali Petrochemicals LTD, Madras, INDIA
Duration:Dec 1993
- Dec 1996
Title: Senior Analyst/Database Administrator
Role and Responsibility:
Supporting 2 production, 2 testing and 1development environments,
and 70GB in
all with 200 users and 70 concurrent users with 24/7 configuration.
Database performance tuning and optimization.
Creating necessary storage and data structures for the application
packages.
2-way replication of Oracle 7.1.16 databases using REPLICATION
option.
Data loading using SQLLOADER and PROC
Sizing of data structures for the Production and Development
Environments.
Monitoring the System usage and growth of the Database objects and
Estimating
the Space requirement for the future growth of the Database objects.
Monitoring, Sizing and estimating the number of Rollback segments.
Configuration of Temporary Segments to minimize the I/O.
Designed and implemented the Backup scripts through Omnibackup
utility and
Monitoring the Oracle and Unix backup using Omnibackup utility.
Recovery of accidentally deleted user tables and Media recovery of
the
datafiles.
Monitoring the CPU usage using GLANCE and TOP utility.
Fixing fragmentations in the Tablespaces, Tables and Indexes and
Rebuilding
of Indexes at the regular intervals.
Exporting and importing of data across Instances.
Developed SQL scripts, Stored procedures and PROC codes for the easy
administration of the Database.
Configuring SQLNET version 2.
Creating Database links across instance for the distributed database
environment
Supported Users in tuning their application (EXPLAIN PLAN and
TKPROF)
Creation of Users and Roles and granting necessary roles and
privileges to
the users.
Hardware:Pentium PC, HP 9000
Software:Developer2000,Oracle 7.3 for NT
O/S:Windows 95, Novell NetWare 3.11, Sco UNIX,HP UX
Languages:SQL,SQLforms3.0,MFCOBOL, Visual Basic
Nulan System & Network, Madras, INDIA .Duration May 1993 - Nov 1993
Title: System & Datbase Administrator:
Role and Responsibility:
To maintain five databases spanning multiple machines.
Installation and maintenance of Oracle and Oracle Tools.
Planning and designing the logical and physical model of the
database.
Creation of database, storage structures (Data segments, temporary
segments,
rollback segments and Index segments) and schema objects (tables,
views,
indexes)
User Management (Creating users), Security management (Creating
roles,
granting and revoking of system and object privileges), Resource
Management
(Creating user profiles) and Auditing.
Creating Database link, loading data from flat file using SQLLOADER
Backup - Hot (Archiving and On-line), Cold (Off-line) and Export
Recovery - Instance Recovery, Media Recovery and Import
Installation, upgradation and Data migration of application
packages.
Database performance tuning and optimization. The optimization
technique
includes tuning of SQL statements, memory management, defragmentation
of data
and index segment, unchaining rows, reducing disk contention,
Replication of
data from other databases, configuring temporary segment setting.
Used UNIX scripts to execute various corn jobs. Also developed,
tested and
documented many database objects (Packages, stored procedures and
triggers) to
enforce business rules.
Hardware:HP 9000, HP Vectra
Software:Oracle 7
O/S:Novell NetWare 2.2, MSDOS
Languages:Cobol, SqlPlus 3.1, SQL Forms 3, Report 1.1
The Sri Ganapathy Mills, Madras, INDIADuration: October 1989 - April
1993
Title: System Administrator/Project Leader:
Designed, developed, and implemented an employee payroll system and a
deposit
management system.The employee payroll system maintained the
paymaster,
validated transactions, and processed monthly transactions, calculated
bonuses,
income taxes, and perks.The deposit management system integrated
maintenance
of the deposit master, loans against deposits, interest warrant
processing,
warrant issuance, deposit renewals, printing of receipts for fixed
deposits,
premature withdrawals, and regular follow-up correspondence.
Hardware:IBM PC 486,Zenith 486
Software:Oracle 6, Sqlplus
O/S:Novell NetWare 2.15, Unix
Languages:Cobol, SQL, Forms 2.3, Report 1.1
EDUCATION
University of Madurai,
India,
Master of Science
in Applied Mathematics
I.I.T. Kharagpur
M.C.A.T.T.P
(Computer Oriented Mathematical Methods)
Successfully Completed. (Cross Migration program, Sponsored by Dept of
Electronics, Govt. of India)
PROFESSIONAL TRAINING
1.Oracle Developer/2000 from Oracle Thailand -Bangkok
2.Advanced Visual Fox Pro training from Bangkok Computer Institute,
Thailand.
3.D.C.A.T.T.P (Data processing Techniques & Programming Method) in
SJCE,
India
Contact this candidate