Manager Oracle
Resume:
Title:Enterprise Manager, Server Manager
*********@*******.***
Document
Source below
NAME: GIREESH GANGADHARAN
ADDRESS:
CITY: Rochester
STATE/PROVINCE: NY
ZIP/POSTAL CODE: 14623
COUNTRY: USA
EMAIL: *********@*******.***
PHONE: 000*******
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
Gireesh Gangadharan
298 East Square Dr., #4
Rochester, NY 14623
*********@*******.***
EXPERIENCE SUMMARY
Expert in Oracle Database Administration of High Availability
Databases, Backup, Recovery, Managing Users, Tuning and Installation
under SUN Solaris, Digital UNIX, AIX and HP-UX.
Expert in Administering Oracle Parallel Server, Data warehouse
applications, Symmetrically Replicated Databases and other databases.
Familiar with Oracle 8
Around Four Years of experience as Oracle DBA and more than Three
years of Application Development experience under various hardware and
software platforms.
Expertise in Oracle Back-end programming in PL/SQL 2.3, Writing Stored
packages,Stored procedures and triggers in a Client Server
environment.
Expertise in Unix Shell programming.
Expertise in programming with Developer 2000 (Oracle Forms 4.5),ProC
2.0, SQL Forms 3.0, PL/SQL and C.
Familiar with UNIX System Administration.
Familiar with Designer 2000.
Expertise in SDLC concepts and software development methodologies.
OPERATING SYSTEMS & LANGUAGES
SUN Solaris 2.5, Digital UNIX, AIX 4.2, HP-UX, UNIX V, Windows NT, X
Windows, Novell Netware, MS-DOS, C, Unix shell programming, Perl
RDBMS Oracle 7.3.3/7.2.2/7.1.6
GUI Developer 2000, Oracle Forms 4.5/4.0, Enterprise Manager, Server
Manager, Powerbuilder 4.0,Designer 2000, Oracle Reports 2.5/2.0
TOOLS SQLForms 3.0, Enterprise Manager, PL/SQL 2.3, PROC 2.0, SQL
Reportwriter 1.1
HARDWARE DEC Alpha, HP-9000, IBM RS6000, SUN SPARC, Unysis U6000, IBM
PC-486
PROJECT EXPERIENCE
01
-98To Eastman Kodak Company, Rochester NY Present DBA Hardware: Sun
SPARC OS: Sun Solaris 2.5 Software: Oracle 7.3.3/7.2.2/7.1.6,
Enterprise Manager, Server Manager, SQLPlus
Oracle Database Administration: Primary DBA for Wordwide
Transportation Services, Health imaging systems, Office imaging
systems and PPI order entry databases. The transportation services
database is a data warehouse type application, mainly used for
decision support activities. The size of the database is 20 GB and
there are 5 tables with more than 4 Million rows. The other databases
are OLTP applications with about 75-100 online users. I am the Primary
DBA for 9 Production and 12 Test/Dev/Train databases.
Responsibilities: Estimating the size of the database and database
objects. Installing Oracle software on the server and Initial Creation
of the database. Administering and Tuning the Production, Training,
Test and Development Databases. Support 100 Online Production database
Users. Writting SQL and UNIX Shell scripts for monitoring the
database. Make the Production Database Changes for the new release of
the software. Rebuilding the database for improving performance.
07
-97To SPRINT Corporation, KS 12-97 DBA Hardware: DEC alpha,
HP-9000, IBM PC Software: Oracle 7.3/7.1, Enterprise Manager, Server
Manager, SQLPlus
Oracle Database Administration: Primary DBA for the SPRINT Conference
Line and Telecommunication Relay Services Production Databases. SCL
database is a Oracle Parallel Server Architecture with Two instances
from Two different machines accessing the same database. The primary
instance was having 170 users and the secondary instance was having 80
users. TRS database is a symmetrically replicated database with a
master definition site and a master site. The changes between the
replicated databases are propagated asynchronously.
Responsibilities: Administering and Tuning the Production, Training,
Test and Development Databases. Support 250 Online Production database
Users. Support the Development team of 30 Users. Make the Production
Database Changes for the new release of the software. Installation of
Oracle tools.
04-97 To Digital Equipment Corporation, MA 07-97 DBA Hardware: DEC
alpha, IBM PC Software: Oracle 7.3, Unix Shell Programs, Server
Manager, SQLPlus Oracle Disaster Recovery System: (ODR) ODR is a high
availability database solution from Oracle Consulting Services. It
automates the creation of standby databases. The standby database will
be in recovery mode, applying the redo logs transferred from the
primary. If the primary fails, the standby database is opened and
becomes the new primary database. The switch over time from the
primary to secondary is minimal. There are provisions for creating
multiple standby databases. Reporting databases can also be created
from the secondary.
Responsibilities: Design and development of the ODR system. Migrated
the production database from 7.2.3 to 7.3.2 Administering and tuning
the 120 GB high availability production database.
08
-96To International Computers Ltd - Fujitsu ( UK) 01-97Developer
DBA Hardware: IBM RS 6000, IBM PC Software: Oracle 7.2, Server
Manager, PL/SQL 2.0, Developer 2000, C, ProC, Motif
Integrated Crew Management System (ICMS)ICMS is used for managing the
cabin and technical crews of the airline. Crews are assigned to the
flights based on some rules. There is a complex set of rules to be
followed while doing the rostering. This package has provisions for
maintaining crews, fleets, flights, Airports, Ground duties etc. It
allows the user to automatically assign the crews to the fleet. Also
there are provisions for manual assignment.
Responsibilities: Oracle Database Administration. Creating the
database, creating tablespaces, creating datafiles, help users in
creating database objects, enrolling users, security, backup, recovery
and tuning. Unix system administration. Creating users, system
security, creating storage space, backup, recovery etc. Used NFS and
NIS features of AIX for sharing resources. Developed programs in
oracle forms 4.5 for maintaining crews.
03-96 To British Telecommunications PLC (UK) 07-96 Developer DBA
Hardware: DEC alpha, PC 486 Software: Oracle 7.1, PL/SQL 2.0, SQLPlus,
Visual Basic 3.0
Sales and Marketing System. This system was part of the global sales
and marketing system of the company. It has provisions for creating
and maintaining users, creating and maintaining customers, creating
sales accounts, creating customer sales account relations, and for
reporting the changes made.
Responsibilities: oding and testing of the system. Developed stored
packages for creating and maintaining customers and sales account
relations. These packages are called from Visual Basic front end.
Oracle features like Stored procedures, packages and database triggers
are used in the development. Responsible for the administration of the
development database.
11-95 To AVALON Software (UK) 01-96 Software Developer Hardware: Sun
SPARC, PC AT 486 Software: Oracle 7.1, Oracle Forms 4.5, Oracle
Reports 2.5, PL/SQL, SQLLoader
Purchasing system This system is a module of the AVALON system. AVALON
system has all the modules required for the computerization of a
company. It include modules like Financial accounting, Inventory
control, Purchasing, sales and marketing, etc.
Responsibilities: Coding, testing and implementation of the system.
Customize the system as per the user requirements. Developed forms for
creating and maintaining purchasing requisitions, Approve the
requisition etc.
05
-95To HBO & Company ( UK) 10-95Developer - DBA Hardware: RS 6000,
PC AT 486 Software: Oracle 7.1, ProC, PL/SQL, Oracle Forms 4.0
Human Resource Management System Computer Assisted Management of
Employees in Organizations (CAMEO). This system is used for
maintaining information about employees in hospitals.
Responsibilities: Designing and development of the system. Responsible
for the administration of the oracle database. Developed forms for
entering personnel details, maintaining individual appointments,
terminations, and changes to personnel details.
10
-93To Birla Consultancy & Software Services04-95DBA -
Programmer/Analyst
Hardware: U-6000, PC/AT486 Software: Oracle7.0,
Powerbuilder 4.0, PL/SQL 2.0
Plant Maintenance System This system is used for recording the
maintenance activities of the plant. The system will automatically
generate work orders and has provisions for manpower of the
maintenance activities.
Responsibilities: Designing and coding of the system Responsible for
the oracle database administration Developed forms for maintaining
maintenance activities & work order
Project Monitoring System Project monitoring system is used to plan
and monitor all projects undertaken by the company. Costs and time for
each project are monitored at modules, phases and activity levels.
Provisions for entering schedules at various levels are made.
Responsibilities: Designing coding, and testing of the system
Responsible for the oracle database administration Developed forms for
maintaining maintenance activities & work order Payroll and HRD System
This system mainly incorporates Personnel, HRD, and Payroll
proceedings. Details include monthly salary processing, TDS
calculations, Income Tax projection, bonuses, employee history, and
man power planning.
Responsibilities: Designing and coding of the system Responsible for
the oracle database administration Developed numerous forms for
maintaining employee details, Pay scale, Grade, Departments etc.
Developed back end procedures for the calculation of the monthly pay.
Warehouse Coding and Billing System This system design involves coding
of goods, advance reservation of space for storage receipt of goods,
delivery of goods, and preparation of bills.
Responsibilities: Coding, and testing of the system. Developed
programs for reservation of space and preparation of the bill.
03-91 To IBPS 09-93 Developer Hardware: HP-9000, HP-1000 Software:
ALLBASE
Library Management System This system handles all facets of library
management which are transaction based. This includes the membership
system, and return of the books.
Responsibilities: Coding of the system. Developed programs for
enrolling users, issue of books, return of books advance reservation,
and recording complaints.
EDUCATION
Bachelor of Engineering
in Computer Science
Contact this candidate