|
System
Administrator
·
Handling more than 50
terminals.
·
Consulting with
administrative and technical staff.
·
Determining system
definations.
·
Software requirement
specification, collection and analysis.
·
Daily database backup
(SQL).
·
Controling system access
and security.
·
Providing voice and text
transmition.
·
Coordinating protocols for
operation.
·
Monitoring and optimising
system performance.
·
System failures.
·
Data backup.
·
Testing new equipments and
systems.
·
Validating error solving
in ERP.
·
Managing Report Generation
with Crystal 8.5.
·
Software installation such
as Windows Server 2003, SQL Server 2000, Windows XP, Windows NT.
·
Hardware installation such
as printer, modem, scanner, network card.
·
Interacting with the end
user for continuous improvement in the project of ERP.
·
Collecting software
requirement specification (SRS).
·
Database handling, give
user rights on system.
·
Systems Maintenance.
·
Purchasing raw materials
like carbon seamless tubes and pipes from overseas countries such as Germany
and China.
·
Prepararing invoice to
customers.
·
Interfacing with external implementation resources for all
planning and implementation efforts.
·
Interfacing
with Software Project Supplier regarding improvement of the project and
coordinating the result of the progress in progress report.
·
Coordinating
with the software engineers from the project supplier.
·
Handling
Database – DBA (Database Administrator).
·
Considering
to risk factor, we take daily database backup in evening on writable CD. So,
that in case of failure we can recover our database. The database is written
in .ldf and .mdf form. Sometimes it also needed to restore other database.
·
Following
all the operation to maintain database:
o
Table
generation.
o
Granting
and revoking the permission.
o
Running
SQL query analyzer to obtain defined result.
o
Managing
relationship.
o
Add-remove
constraint
o
Prepare
foreign key relationship.
o
Create
new database user.
o
Maintain
lease line of 64 Kbps to transfer the online data from marketing office.
·
Working
with the functional leaders to define the implementation processes and
milestone:
o
The
milestone gives the clear idea for project stage and when it will complete.
This milestone is represented to management for clear view of project. The
Format we are using for Project milestone is as below.
·
Leading
the effort in support of management to define and create report using Crystal 8.5:
o
Periodic
reporting requirements
o
Metrics
measurement
o
Alerts
to transactions falling outside of expected results
o
Field
Exporter
o
Sections
of report header, detail and footer
·
Administrate
user rights (granting and revoking permissions)
·
We
are using purchase, production, FAS (Financial Accounting System), inventory,
human resources, Sales.
·
Responsible
in granting the right to user and at the same time to maintain company’s
information securely.
·
Responding
to questions regarding the system and capabilities of the current technology
and systems in use.
·
Training
end-user on computers and ERP:
o
Weekly:
weekly training is given to all users for continuous improvement in their
field. The end-user comes with the problem at the entry time, suggestion,
complain.
o
When
amendment comes: after getting any amendment in project i.e. updated EXE then
it becomes necessary to train the end-user.
o
When
new employee joins: the new user requires the training to understand the
whole system and work efficiently.
·
Setting
up, troubleshooting and monitoring current and new computer networks both
internal and in remote location (lease line)
·
Currently
using Realtek RTL8139D, Intel RC8254DEM network card and installing the
network cards in new system as well as in old when where replacement needed.
·
Communicating
with Network engineer in installation and troubleshooting.
·
Using
D-Link cable for networking, the network is connected through 16 Bit Switch
or D-Link.
·
Lease
line is maintained daily, currently using routers and modem for connectivity
of lease line. The router of Tec route 2000 and CYGNUS 606SS Base band modem
for connectivity. The router is put up at four premises: BSNL (Bharat Sanchar
Nigam Ltd), Mehnana to Ahmedabad BSNL’s and the company. All this four modem
for connectivity has to be well-maintained. If connectivity breaks up then we
have to set the status of LOCAL, REMOTE, DIG AND PATTERN to continue lease
line.
·
Preparing project guidelines for end user’s
troubleshooting and give remote access.
·
Projecting guidelines help to end user regarding
defination of the function, its description, and guidelines of that module in
ERP and giving the remote access to users
|
