Posted by on January 29, 19102 at 09:56:16:
RESUME
SUMMARY OF QUALIFICATIONS
Over 4 years of experience in Information Technology out of which over 1.5 years as ORACLE DBA on SUN-SOLARIS,LINUX & Windows NT (Production and Development).
Brain Bench Certified DBA for Oracle 8 and Oracle 8i (Beta Test) and RDBMS Concepts.
Experience in Oracle Database Administration, operated by multiple users and multiple databases.
Expertise in installation and configuration of Oracle and large databases.
Experience in planning, Testing and Implementation of backup & recovery strategies.
Experience of Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, redo mechanisms.
Expert in usage of tools such as OEM 2.0 (Oracle Enterprise Manager) to administer the multiple databases.
Experience in Installation, Configuration of OAS 4.0 (Oracle Application Server).
Experience in System Study, Design, Development, Testing and Implementation phases of Software Development Life Cycle (SDLC).
CERTIFICATIONS:
APPEARED FOR ORACLE CERTIFIED PROFESSIONAL (OCP - DBA 8.0)
Introduction to Oracle: SQL and PL/SQL
BRAINBENCH Inc. USA
Oracle 8 DBA
Oracle 8i DBA (Beta Test)
RDBMS Concepts.
TRAINING TAKEN
Oracle 7.x, Developer 2000 (Forms 4.5, Report 2.5) at Informatics Computer Institute.
TECHNICAL PROFICIENCY
Operating Systems :LINUX 7 (Red-Hat),Sun-Solaris-Sparc(5.7),Windows NT 4.0, MS-WINDOWS’ 95, MS-DOS V6.2
RDBMS/ORDBMS :Oracle 8i,ORACLE 8.0,ORACLE 7.x
Middle Tier :OEM 2.0 (Oracle Enterprise Manager), OAS 4.x (Oracle Application Server)
Tools Of Oracle :Developer/2000(Forms, Report Writer, SQL *Plus), Server Manager,Import/Export, Enterprise Manager, SQL Loader, Net 8 Assistant
Languages Known :C and COBOL
Packages / DBMS :Familiar with JAVA-2, FoxPro, dBase , MS-Office '97/2000
Employment History :
Working with Net4Nuts Limited, Ahmedabad, from 21-November-00 as a Oracle DBA (Database Administrator).
Worked with Applitech Solution Limited, Ahmedabad, from November-97 as a “Trainee Programmer” and absorbed as Programmer/Analyst from February-98. I worked as a project Leader from June-99 to October-99.
Worked with Semaphore software, Ahmedabad from Feb-96 to July-96 as a programmer.
PROFESSIONAL EXPERIENCE
From 11-2000 To to Till date in Net4Nuts Limited as Oracle DBA
PRODUCT DEVELOPMENT
OS : Sun-Solaris (5.7),Linux (Red-Hat,7) and Windows NT.
ORDBMS : Oracle 8i (8.1.7)
Middle Tier : OEM 2.0 (Oracle Enterprise Manager), BEA Web-Logic as Application Server and Apache as Web-Server.
Front End : JAVA
My responsibilities as Oracle DBA includes the following :
Supporting 2 production databases. Supporting 30+ developers
Establishing and maintenance of 24 X 7 need of database
Oracle Server & Client Installation and Upgrade
Installation of Oracle 8i through telnet(Remote installation) in silent mode and configuration of database.
Implementing Oracle on RAID-5 compliend database.
Logical and Physical Database Design
Disk Storage Planning for ORACLE Physical Structures such as Data files, Redo Log Files and Control Files
Deciding on Logical Structures such as Tablespaces, Number and Size of Rollback Segments
Security Administration, Resource Management
Monitoring and maintaining long running jobs
Experience in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using Export/Import
Features:
The services of Net4Nuts extend beyond the realm of integrating the services, to providing the content over smart devices.
We at Net4Nuts are in the process of enabling this convergence of services to central point, be it your browser or your smart device
Its proprietary solution, the Activity Hub, enables two or more different services on the Internet can collaborate with each other, to provide services across any medium.
The services of Net4Nuts extend beyond the realm of integrating the services, to providing the content over smart devices. Using our proprietary technology, we can enable for enterprises to make their wired content available over wireless devices.The Activity Hub is designed to be a device and location agnostic solution that enables enterprises to deliver their content on any device. It has been built using cutting edge technologies like EJB and XML. The Activity Hub integrates services like e-mail, fax, calendar and portfolio from different vendors seamlessly into one personalized service for the customer.
The Activity Hub is designed as a server-side, Java-based solution
09-00 To 11-2000 in APPLITECH SOLUTION LIMITED as Oracle DBA
Business Application Sofware
Client : Pec-Tech Engineering Ltd (April group).
ORDBMS : Oracle 8i (8.1.6)
Front End : Developer 2000 (Release 6).
My responsibilities as Oracle DBA and Analysis, Design, Development and Implementation of the following Systems.
Supporting one production and one-development databases.
Oracle Server & Client Installation and Upgrade
Logical and Physical Database Design
Disk Storage Planning for ORACLE Physical Structures such as Datafiles, Redo Log Files and Control Files
Deciding on Logical Structures such as Tablespaces, Number and Size of Rollback Segments
Monitoring and maintaining long running jobs
Working and supporting 24 x 7 environment
Tuning SQL Statements using EXPLAIN PLAN Utilities.
Tuning of Library Cache, Data Dictionary Cache and Database Buffer Cache.
Re-Usable Code through Stored Procedures - to avoid parsing overhead.
Pinning the large procedures in Library Cache.
Optimizing the size of Database Buffer Cache
Tuning of I/O
Separation of tables and indexes on different disks
Keeping Data files and Redo Log files on diff. disks
Experience in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using Export/Import
02-00 To 09-00 in APPLITECH SOLUTION LIMITED as Sr. Programmer
Television Management System (TMS).
Client : Sony Entertainment Televison India Ltd.
Hardware : Pentium workstations
Software : Oracle 8i (8.1.6), Developer 2000 (Forms-6,Report-6)
Features : Company is Sony Entertainment Television which has private channels like AXN, SETMAX. Applitech Solution Ltd has already developed certain modules name “sales and distribution”, “Accounts and Receivable”,”Capsuling”,“Promo Scheduling” and “Finance” module is under development which has integration with Capsuling module. It’s a complete web enabled software, which will be used by singapore and mumbai office.
Responsibilities: Junior DBA, Analysis, Design, Development and Testing
11-99 To 02-00 in APPLITECH SOLUTION LIMITED as System Analyst
Traffic Management System
Client : Kandla Port Trust
Hardware : Pentium workstations
Software : Oracle 8i (8.1.6), Developer 2000 (Forms-6,Report-6)
Role : System Analyst
Responsibillity : System Requirement Study and Database Design
The ERP comprises of the following modules:
Financial Accounting System Personnel Management system
Material Management System Cargo Management System
Gate Regulation System Vessel Berthing System
Hospital Management System Estate Management System
11-97 to 02-98 as Programmer/Analyst
06-99 to 10-99 as Project Leader
APPLITECH SOLUTION LIMITED Sr. Programmer
Garment Export System
Client :Vogue Garment Export, Delhi.
Hardware :Pentium workstations
Software :Oracle 7.3, Developer 2000 (Forms-4.5,Report-2.5)
Features :Total solution for vogue, garment export company covering modules likes sampling,work-order,shipment and documentation and tailoring
Responsibilities:Analysis, Design, Development and Testing and reporting to management and lead the team ,Interaction with client.
12-98 To 08-99 in APPLITECH SOLUTION LIMITED as Programmer/Analyst
Automated Frequency Management System
Client : Argentina Government
Hardware : Pentium workstations
Software : Oracle 8, Developer 2000 (Forms-5,Report-3)
Features : Company is developing this project as a base of frequency management system. There are going to use it to develop customized product for different end users. This software is prepared is to deal with the validation of the frequency related data and to deal with providing license to the client for the company. Modules name as “Radio operator”, ”Radio Amateur” and “Spectrum Users”
Responsibilities: Programmer/Analyst
07-98 To 12-98 in APPLITECH SOLUTION LIMITED as Programmer/Analyst
Crew Managing Information System
Client : Maritime and Port Authority ,Singapore
Hardware : Pentium workstations
Software : Sybase 11.9 as RDBMS (back-end), Power-J (ver 2.5).
Features : This system incorporates all the different procedures followed by Maritime and port authority of Singapore in managing crew on the ship. The main features include “Article of agreement”, “Issue of safe Manning Certificate and various exemption certificates and cash collection
Responsibilities: Programmer/Analyst
02-96 To 07-96 in SEMAPHORE SOFWARE as Programmer
Financial Accounting System
Client : Shishir Trading Private. Ltd
Software : Fox Pro 2.5
Features :This system incorporates all the different transactions like sales voucher, purchase voucher, cash payment ,bank payment and all the receipts, credit/debit note and journal voucher. All the reports like general ledger, Balance sheet, Profit and loss account, Trail Balance etc.
Responsibilities: Programmer
EDUCATION
D.E.E (Diploma Electrical Engineering) , Oct-92 (Government Polytechnic,Gujarat).
Bachelor of Arts , Oct-93 (Osmania University, Andhra Pradesh).
Others:
I had passed C.D.S.E (Combined Defense services Examination) conducted by Indian government named as Union Public Service Commission.
I prepared for above quoted examination From Jan-94 to May-96.
PERSONAL DETAILS
Name : Viral I Dave
Address : C / 4-12, Jineshwar Nagar-2,Janatanagar Road,Ghatlodia, Ahmedabad-380061
Phone No : 91 -79 -7481562(R)
E-mail : v_s_dave@yahoo.com, viraldave@indiatimes.com, v_i_dave@hotmail.com
Passport No. : A-5841657