j2 l technology_otherconcepts_recruiting

32
1. Understanding of Technologies 2. Sourcing Skills - Different ways & Methods 3. Market Knowledge 4. Sales & Negotiation Skills Essential Skills for Technical Recruitment Professional

Upload: grace-ruhland

Post on 07-Nov-2014

537 views

Category:

Technology


1 download

DESCRIPTION

 

TRANSCRIPT

Page 1: J2 l technology_otherconcepts_recruiting

1.

Un

ders

tan

din

g o

f T

ech

no

log

ies

2.

So

urc

ing

Skills

-D

iffe

ren

t w

ays &

Meth

od

s

3.

Mark

et

Kn

ow

led

ge

4.

Sale

s &

Neg

oti

ati

on

Skills

Essen

tial S

kills

fo

r T

ech

nic

al R

ecru

itm

en

t P

rofe

ssio

nal

Page 2: J2 l technology_otherconcepts_recruiting

1.

Un

ders

tan

din

g T

ech

no

log

ies

Page 3: J2 l technology_otherconcepts_recruiting

�������������� ��������������������������������������

�������������

�������������������������������� ���!!� ���������"�����������#� �$������������� �

%��������&��������� ������������!�����'� �������� �������(�)�*����*�+��� ���

�(�,��"���������$�-��./�0�1��$�"���$�����&�����2���������$�+�! ���$���

�� ����

��� 3������"2����!!���� ��

�-��

��������

44������������������0�����������������5!���6�����������%�*4����1

�3$�$��������

������$���������

���

��������������

.��7�������� ������������.�����$����������

������

8������ ������������'� ���9��

����� �����������1��$�����1

������ �����'���

�����������������

+���:���;���&�)�6�8��.�3����%�! ��������� ���1���$����<"4=

���������� ��!������

4,��>�$������-��.����7�( ��?������(��.,�����8������%������.

@"���������� ���

��$$����?�A�����/�!����/����%��$-�����������$��!�/����%��$-��������./,��-��

+��������,�$���$$��/���������������������� ��;� ���������

�#$"�����������

���%������������!!�����������?� �����������,�������������4!

!�������

�������������������������$

"�����������

'� ���)�&�8�&��9�*����5;B�����)�6� (((�����5;���$����5;

)�&�/, �4���$�4�-�!

�&��

��� �$$�����$�

"���%��

>�$�����������@�6�>�$������������"0%��44����(�6�9���

�����&� ��!�������

. 00��.���������$��.����./C������#���B$ ������ ��=�;������$�����/��%�����:���������

5���D�

���#��� ��!�������

�����1$�"%���(�*� (((����'�<��&�������$�8�6�9�������1$�9�*98����B/'���������

�� ����$���+�����;���&������

;���&�:B<=��4=

��������������

Dif

fere

nt

So

ftw

are

Tech

no

log

ies

Page 4: J2 l technology_otherconcepts_recruiting

:%�;��/:%�;��=�;

�����'�������

��������;��������%�$��/�� ���5%�4,�+������������%�$������������3�%�$�����3�

�-�!

��

����� ���

4,��;���$����$��� �$�-��'�����3��

��0& ������$����0�����

��� �����������&�����

/� �!����!

������� ��������� ���

>����$>���!���������0���������� !

"�#

�$� �

������� ���

/�������� (((�?�!

$�@�*���*��(

6�+����$� ���*�7�(�*;�5;*�E�;����*�'� ����

��/,

*�.��������*�'� ���+���� ����������*'� ��������*��F��

������������

4�-�!

��� �������$�,�$���$$�'�#� �$�:�������/���$�����'� ���/����������01

���

"�������!�����

�����������-������+��'� ����+�������$�-�

�+��>������

��

%�� ��$���������>������

��!�����$��� �������=4�%�&����

��(� �))������

01

���7��� ��%'�/�)�7��4,��/�$��������/�������7�( ��.���������.%����;�$�������

���;���$����+����$���������

��!��

����

�� �$�-���#� �� (((��+��������+�$���C��������

� ��� �!�����

���*��� ���������

Dif

fere

nt

So

ftw

are

Tech

no

log

ies

Page 5: J2 l technology_otherconcepts_recruiting

Gen

era

l

Sta

nd

ard

Hie

rarc

hy a

nd

Resp

on

sib

ilit

ies in

an

y o

rgan

izati

on

Deli

very

Man

ag

er

Clie

nt M

anagem

ent ,B

udgets

stu

dy, ensure

the d

eadlin

e ,com

munic

ating w

ith th

e c

lients

Pra

cti

ce H

ead

Managin

g the technolo

gy , to d

o the r

esourc

e m

anagem

ent , to

tra

ck the r

esourc

e p

ool,

resourc

e p

lan.

Sr.

Pro

ject

man

ag

er

Managin

g m

ultip

le p

roje

cts

& team

managers

Pro

ject

Man

ag

er

(PM

)

More

of m

anagem

ent ro

le a

nd d

esig

nin

g the p

roje

cts

(Arc

hitect

is a

lso in the s

am

e level)

Team

Lead

(T

L)

Team

Managem

ent, A

ssessin

g the r

esponsib

ilities,

Dis

trib

ution o

fw

ork

.

Sen

ior

So

ftw

are

En

gin

eer

(SS

E)

Develo

pm

ent and C

ritical w

ork

in the p

roje

cts

So

ftw

are

En

gin

eer(

SE

) (o

r) J

r. D

evelo

per

Com

ple

tely

in c

odin

g/p

rogra

mm

ing a

nd d

evelo

pm

ent

Page 6: J2 l technology_otherconcepts_recruiting

Ente

rprise r

esourc

e p

lannin

g s

oftw

are

, or

ER

P,

doesn't

live u

p t

o i

ts a

cro

nym

. F

org

et

about

pla

nnin

g—

it

doesn't

do m

uch o

f th

at—

and f

org

et

about

resourc

e,

a t

hro

wa

wa

y t

erm

. B

ut

rem

em

ber

the e

nte

rprise p

art

. T

his

is E

RP

's t

rue a

mbitio

n.

It a

ttem

pts

to inte

gra

te a

ll depart

ments

and f

unctions a

cro

ss a

com

pany o

nto

a s

ingle

com

pute

r syste

m that can s

erv

e a

ll th

ose d

iffe

rent depart

ments

' part

icula

r needs.

That

is a

tall

ord

er,

build

ing a

sin

gle

softw

are

pro

gra

m t

hat

serv

es t

he n

eeds o

f people

in f

inance a

s w

ell

as it

does t

he p

eople

in h

um

an r

esourc

es a

nd in t

he w

are

house.

Each o

f th

ose d

epart

ments

typic

ally

has

its o

wn c

om

pute

r syste

m o

ptim

ized f

or

the p

art

icula

r w

ays t

hat

the d

epart

ment

does i

ts w

ork

. B

ut

ER

P

com

bin

es t

hem

all

togeth

er

into

a s

ingle

, in

tegra

ted s

oftw

are

pro

gra

m t

hat

runs o

ff a

sin

gle

data

base s

o

that

the v

arious d

epart

ments

can m

ore

easily

share

info

rmation a

nd c

om

munic

ate

with e

ach o

ther.

That

inte

gra

ted a

ppro

ach c

an h

ave a

tre

mendous p

ayback if com

panie

s insta

ll th

e s

oftw

are

corr

ectly.

Take a

custo

mer

ord

er,

for

exam

ple

. T

ypic

ally

, w

hen a

custo

mer

pla

ces a

n o

rder,

that

ord

er

begin

s a

m

ostly paper-

based jo

urn

ey fr

om

in

-basket

to in

-basket

aro

und th

e com

pany,

often bein

g keyed and

rekeyed in

to diffe

rent

depart

ments

' com

pute

r syste

ms alo

ng th

e w

ay.

All

that

loungin

g aro

und in

in

-baskets

causes d

ela

ys a

nd l

ost

ord

ers

, and a

ll th

e k

eyin

g i

nto

diffe

rent

com

pute

r syste

ms i

nvites e

rrors

. M

eanw

hile

, no o

ne in t

he c

om

pany t

ruly

know

s w

hat

the s

tatu

s o

f th

e o

rder

is a

t any g

iven p

oin

t because

there

is n

o w

ay f

or

the f

inance d

epart

ment, f

or

exam

ple

, to

get

into

the w

are

house's

com

pute

r syste

m t

o

see w

heth

er

the ite

m h

as b

een s

hip

ped.

"You'll

have t

o c

all

the w

are

house"

is t

he f

am

iliar

refr

ain

heard

by

frustr

ate

d c

usto

mers

.E

RP

vanquis

hes t

he o

ld s

tandalo

ne c

om

pute

r syste

ms in f

inance,

HR

, m

anufa

ctu

ring a

nd t

he w

are

house,

and r

epla

ces t

hem

w

ith a

sin

gle

unifie

d softw

are

pro

gra

m div

ided

into

softw

are

m

odule

s t

hat

roughly

appro

xim

ate

the o

ld s

tandalo

ne s

yste

ms.

Fin

ance,

manufa

ctu

ring a

nd t

he w

are

house a

ll still

get

their o

wn

softw

are

, except

now

th

e softw

are

is

lin

ked to

geth

er

so th

at

som

eone in

finance can lo

ok in

to th

e

ware

house s

oftw

are

to s

ee if

an o

rder

has b

een s

hip

ped.

Most

vendors

' E

RP

softw

are

is f

lexib

le e

nough

that

you c

an insta

ll som

e m

odule

s w

ithout

buyin

g t

he w

hole

package.

Many c

om

panie

s,

for

exam

ple

, w

ill

just

insta

ll an E

RP

fin

ance o

r H

R m

odule

and leave the r

est of th

e functions for

anoth

er

day.

Wh

at

is E

RP

(E

nte

rpri

ses R

eso

urc

e P

lan

nin

g)?

Page 7: J2 l technology_otherconcepts_recruiting

Ind

ustr

y

ER

P(S

oft

ware

Packag

e)

Big

ER

P’s

Sm

all

ER

P’s

SA

P

Ora

cle

Ap

ps

Peo

ple

So

ft

JD

Ed

ward

s

BA

AN

Na

vis

ion

MF

G/P

ro

BP

CS

B2B

Ram

co

Exam

ple

…..

Page 8: J2 l technology_otherconcepts_recruiting

"����

���%�&'�

(�$���

�)�

!��(%�(���

�� ��

!��(

*�

+,�-

.��

� �

��+,

�-.��

/�

���0 �

���� ��%

�&'�

���0 �

'���

1�

2��

� ���

��0

���

����%�&'�

2��

� ���

00

��

'����

3%�3���

���

'��

4�

�����������

����������

�����

Dif

fere

nt

ER

P P

rod

ucts

Page 9: J2 l technology_otherconcepts_recruiting

Do

cu

men

tation

fo

r fu

ture

refe

ren

ce

& f

or

en

d u

se

r tr

ain

ing

Define

Se

tup

( H

ow

doe

s a

da

ta

ap

plic

ation

will

wo

rk )

Re

qu

irem

en

ts g

ath

ering ,

A

na

lysis

, U

se

r

Inte

ractio

n ,

De

sig

n a

wo

rk f

low

Ga

p A

na

lysis

, H

e s

ho

uld

ha

ve

do

ma

in

kn

ow

led

ge

.

Ora

cle

DB

A–

Ba

ckup

, R

eco

ve

ry,

Pe

rfo

rma

nce

Tun

ing

Who c

an

wo

rk o

n

the

RIC

E C

om

po

nen

ts

(Re

po

rts,

Inte

rfa

ce

s,

Con

ve

rsio

n &

Exte

nsio

n)

To

Pre

pa

re

the

flo

w c

ha

rt

Po

we

r U

se

r

End

Use

r

Ora

cle

Ap

ps

DB

A :

Activitie

s p

erf

orm

ing o

n

App

lica

tion

sid

e.

Pa

tch

ing P

erf

orm

ance

tun

ing

Clo

nin

g –

is f

or

testin

g p

urp

ose

Ma

inte

na

nce

De

ve

lopm

en

ts &

C

usto

miz

ation

of

the

fo

rms &

Repo

rts

1)

Who w

ill d

o th

e

AS

–IS

Stu

dy –

Exis

tin

g s

yste

m (

Actu

al R

equ

irem

en

t

stu

dy o

f L

ega

cy s

yste

m,

wh

ich

can

be

in

an

y f

orm

viz

. M

an

ua

l S

yste

m o

r u

sin

g

an

y t

echno

logy)

Use

rE

RP

Ad

min

istr

ato

rsT

ec

hn

ica

lC

on

su

lta

nt

Fu

nc

tio

na

l C

on

su

lta

ntP

art

icip

an

ts in

ER

P Im

ple

men

tati

on

Page 10: J2 l technology_otherconcepts_recruiting

2$��$

��.��

��'��

Page 11: J2 l technology_otherconcepts_recruiting

SA

P

Fu

nc

tio

nal

Te

ch

nic

al

DB

A/A

dm

inis

tra

tor

AB

AP

(AB

AP

ER

)F

I-C

OB

AS

IS(B

as

is A

dm

inis

tra

tor)

MM

SD

PP

PS

PM

HR

QM

WM

SM

/CS

Page 12: J2 l technology_otherconcepts_recruiting

AB

AP

:-A

dvance B

usin

ess A

pplic

ation P

rog

ram

min

g

FI-

CO

:-F

I =

Fin

ance,

CO

= C

ontr

olli

ng

MM

:-M

ate

rial M

anag

em

ent

SD

:-S

ale

s &

Dis

trib

utio

n

PP

: -

Pro

duction P

lann

ing

PM

: -

Pla

nt

Main

tena

nce

PS

:-P

roje

ct

Syste

m

HR

: -

Hum

an R

esourc

e

QM

: -

Qualit

y M

anag

em

ent

WM

: -

Ware

ho

use M

ana

gem

ent

SM

/CS

: -

Serv

ice M

anag

em

ent/

Custo

mer

Serv

ices

Glo

ssary

Of

SA

P

Page 13: J2 l technology_otherconcepts_recruiting

Wh

at

do

es a

n A

BA

Per

do

(T

ech

nic

al

Co

nsu

lta

nt

in S

AP

)

AB

AP

is a

n p

rog

ram

min

g language w

hic

h is u

sed b

e S

AP

to d

evelo

p the p

rog

ram

s.

So a

pro

gra

mm

er

(AB

AP

er)

develo

ps s

oft

wa

re p

ackage b

y

usin

g v

arious technolo

gie

s lik

e A

LE

,

IDO

C, B

AP

I, B

DC

, LS

MW

, D

ialo

g P

rog

ram

min

g,

Module

Pool P

rogra

mm

ing, R

eport

s,

SA

P

Scripts

etc

.

ALE

-A

pplic

ation L

ink E

nablin

g

IDO

C-

Inte

rfacin

g D

ocum

ents

BA

PI

-B

atc

h A

pplic

ation P

rogra

mm

ing I

nte

rfaces

BD

C-

Batc

h D

ata

Com

munic

ation

Wh

at

do

es a

n F

un

cti

on

al C

on

su

ltan

t d

o (

Fu

ncti

on

al

Co

nsu

ltan

t in

SA

P)

�A

S-I

S-S

tud

y.

�T

O-B

E-A

naly

sis

�U

ser

Inte

raction

�P

reparing u

ser

manuals

for

end

user

train

ing

�T

rain

ing e

nd u

sers

and P

ow

er

users

Resp

on

sib

ilit

ies o

f T

ech

nic

al &

Fu

ncti

on

al C

on

su

lta

nt

in S

AP

Page 14: J2 l technology_otherconcepts_recruiting

For specific

industr

ies S

AP

AG

, G

erm

an

y h

as d

evelo

ped n

ew

custo

miz

ed p

roduct

under

the

bra

nd n

am

e o

f S

AP

. T

hese N

ew

Dim

ensio

n P

roducts

are

diffe

ren

t fr

om

SA

P S

tandard

vers

ion that is

SA

P R

3 &

in e

ach n

ew

dim

ensio

n m

odule

there

are

Technic

al as w

ell

as

Functional P

rofe

ssio

nals

lik

e S

AP

R3.

Fo

r S

up

ply

Ch

ain

In

du

str

y:

-

AP

O:-

Advanced P

lannin

g &

Optim

ization

DP

: -

De

mand P

lannin

g.

SN

MP

: -

Supply

netw

ork

managem

ent

pla

nnin

g.

PP

DS

: -

Pro

duction P

lannin

g &

Deta

iled S

chedulin

g.

GA

TP

: -

Glo

bal availa

ble

to p

rom

ise.

Fo

r O

il In

du

str

y:

-IS

-OIL

Fo

r A

uto

mo

bile

In

du

str

y:

-IS

-Auto

Fo

r M

ed

ia In

du

str

y:

-IS

-Media

Fo

r re

tail

In

du

str

y:

-IS

-Re

tail

Fo

r C

us

tom

er

Care

In

du

str

y:

-IS

U-C

CS

Fo

r C

RM

In

du

str

y:

-S

AP

CR

M

Fo

r B

us

iness W

are

ho

usin

g:

-S

AP

BW

/BIW

SA

P N

ew

Dim

en

sio

n M

od

ule

s

Page 15: J2 l technology_otherconcepts_recruiting

SA

PD

iffe

ren

t V

ers

ion

s:-

R2

, R

3 (

4.6

B, 4

.6c),

CIN

(C

oun

try I

nd

ia V

ers

ion

)

Te

chn

ica

l:-

AB

AP

(A

dva

nce

d B

usin

ess A

pp

lica

tion

Pro

gra

mm

ing)

Fu

nctiona

l:-

HR

, F

I-C

O,

SD

, M

M,

PP

, P

S,

PM

, Q

M

SA

P A

dm

in/D

BA

:-B

AS

IS

Ora

cle

Ap

ps

Diffe

ren

t V

ers

ion

s:-

Ora

cle

Ap

plic

ation

s 1

1i

Te

chn

ica

l:-

PL

/SQ

L,

Fo

rms,

Re

po

rts,

Inte

rfa

ce

s,

Con

vers

ion

, E

xte

nsio

ns (

RIC

E C

om

ponen

ts)

Fu

nctiona

l:-

HR

MS

(P

ayro

ll, A

dvan

ced

Benefits

), M

FG

(B

OM

, W

IP),

FIN

(A

R,

AP

,G

L),

DIS

T (

INV

, P

O,

OM

)

DB

A/A

dm

inis

tra

tor

:-A

pp

s D

BA

Peo

ple

So

ft

Diffe

ren

t V

ers

ion

s:-

Te

chn

ica

l:-

Pe

op

lecod

e, P

eop

le to

ols

, P

S Q

ue

ry

Fu

nctiona

l:-

HR

MS

, M

FG

, F

IN

DB

A/A

dm

inis

tra

tor

:-P

eop

lesoft

Ad

min

/DB

A

JD

Ed

ward

s

Diffe

ren

t V

ers

ion

s:-

Wo

rld

Soft

, O

neW

orld

, O

neW

orld

XE

Te

chn

ica

l:-

JD

Ed

wa

rds P

rogra

mm

er

Fu

nctiona

l:-

HR

, M

FG

, F

IN

DB

A/A

dm

inis

tra

tors

:-C

NC

Ad

min

istr

ato

r

BA

AN

Diffe

ren

t V

ers

ion

s:-

Te

chn

ica

l:-

BA

AN

Too

ls

Fu

nctiona

l:-

FIN

, M

FG

DB

A/A

dm

inis

tra

tors

:-B

AA

N A

dm

inis

tra

tors

Bri

ef

ab

ou

t d

iffe

ren

t E

RP

’s

Page 16: J2 l technology_otherconcepts_recruiting

Ove

rvie

w o

f

Ora

cle

Ap

pli

cati

on

s

Page 17: J2 l technology_otherconcepts_recruiting

Ora

cle

Ap

plicati

on

s O

verv

iew

Ora

cle

11i is

the r

ele

ase v

ers

ion.

Curr

en

t V

ers

ion o

f O

racle

is O

racle

11.5

.10.2

.

Curr

en

t availa

ble

Vers

ions a

re 1

1.5

.7 ,

11.5

.9 a

nd

11.5

.10.2

.

Ora

cle

6i, 8

i, 9

i th

ese a

re a

ll th

e d

ata

bases (

where

we c

an s

tore

the

data

)

1)

Fro

nt

En

d-

form

s –

to e

nte

r th

e d

ata

, re

port

s –

to c

reate

various t

ype

of

repo

rts

2)

Back E

nd

-ta

ble

s (

8i, 9

i, 6

i) t

o feed (

sto

re)

the

data

Page 18: J2 l technology_otherconcepts_recruiting

Dif

fere

nt

mo

du

les in

O

racle

Ap

ps

1)

Fin

an

ce

-A

R (

Accounts

Receiv

able

s )

, A

P (

Accounts

payable

), G

L (

Genera

l Ledger)

,CM

( C

ash

Managem

ent)

, F

A(F

ixed A

ssets

)

No

te:

All

are

In

div

idu

al M

od

ule

s.

GL

in

terf

ace is im

po

rtan

t

In F

inance F

unctional –

1)

P2P

(P

-P

) –

Pro

cure

ment to

pay c

ycle

–th

at in

clu

des the c

om

bin

ation o

f a

ll these m

odule

s

PO

+A

P+

GL

2)

O2C

(O

-C

) –

Ord

er

to C

ash C

ycle

–th

at in

clu

des the c

om

bin

ation o

f a

ll these m

odule

s O

M+

AR

+G

L

2)

Man

ufa

ctu

rin

g: W

IP (W

ork

In P

rogre

ss),

BO

M (

Bill

Of M

ate

rials

)

3)

Dis

trib

uti

on

:IN

V (

Invento

ry),

PO

(P

urc

hase O

rder)

, O

M (

Ord

er

Managem

ent)

4)

HR

MS

:P

ay R

olls

Advance B

enefits

, C

ore

HR

5)

CR

M:

Tele

Serv

ice, F

ield

Serv

ice, S

erv

ice C

ontr

acts

.

Page 19: J2 l technology_otherconcepts_recruiting

Pro

gra

mm

er

Tech

nic

al co

nsu

ltan

t

He

will

write

th

e c

od

e in

pl/sql

He

will

in

vo

lve

in

the

de

ve

lopm

en

t of

Fo

rms

an

d R

ICE

Co

mpon

en

ts t

o e

nsu

re the

bu

sin

ess

fun

ctiona

lity.

D2

K (

Dev

elo

per

20

00

)A

pp

s

He

ha

s to

de

ve

lop

all

form

an

d r

ep

ort

s

ER

P h

as s

tan

da

rd f

orm

s a

nd

repo

rts

(Bu

ilt in

)

Lo

t of

co

de

to

be

writt

en

fo

r th

e b

usin

ess

fun

ctiona

lity.

In b

uilt

bu

sin

ess fun

ction

alit

y

No

t re

com

mend

ed

fo

r la

rge

dis

trib

ute

d

en

viro

nm

en

tD

esig

ned

to

mana

ge

la

rge

en

terp

rise

s

en

viro

nm

en

ts

Betw

een

a P

rog

ram

mer

an

d a T

ech

nic

al C

on

su

ltan

t in

Ora

cle

Ap

ps.

Betw

een

D2K

an

d 1

1i?

Co

mp

ari

so

n…

……

……

..

Page 20: J2 l technology_otherconcepts_recruiting

Majo

r p

layers

of

Ora

cle

Ap

ps a

re :

Ora

cle

NA

IO, In

telli

gro

up, D

ello

itte

, In

fosys, IB

M, T

CS

, G

E,

HC

L,

Sapie

nt, R

apid

gm

, X

ansa,

Birla

S

oft, A

lliance C

onsultin

g,

Bahav-o

ne C

yber

Tech, S

ierr

a A

tlantic,

Solix

, S

aty

am

Fo

llo

win

g q

ueri

es w

e c

an

ask f

rom

can

did

ate

s:

1)

Ask w

heth

er

He/S

he is a

Tech o

r F

unctional C

onsultant?

2)

What are

the m

odule

s H

e/S

he w

ork

ed?

3)

How

may f

orm

s O

r R

eport

s that

He/S

he c

usto

miz

ed in p

art

icula

r P

roje

ct?

4)

Whic

h v

ers

ion

of fo

rms that H

e/S

he w

ork

ing?

5)

Ask w

heth

er

he w

ork

ed o

n IN

TE

RF

AC

ES

or

Not?

6)

How

many I

mple

menta

tions H

e/S

he d

id?

7)

Is H

e/S

he is in s

upport

pro

ject or

imple

menta

tion p

roje

ct?

8)

Why there

is a

need o

f custo

miz

ation?

Evalu

ati

on

……

……

……

.

Page 21: J2 l technology_otherconcepts_recruiting

DB

A D

eve

lop

er

–D

eve

lop

me

nt

DB

A -

Pro

du

cti

on

Who w

ork

on S

tore

d P

rocedure

sB

ack-u

p, re

covery

, P

erf

orm

ance tunin

g,

Trigg

ers

Mig

ration, U

pgra

dation, P

atc

hin

g

User

cre

ation m

anag

em

ent

Reg

ula

r M

ain

tenance

Table

space M

anag

em

ent

Desig

nin

g T

able

Writing c

ode in p

l/sq

l

Ora

cle

DB

AO

rac

le A

pp

s D

BA

Insta

llation ,

Back-u

p, re

covery

, P

erf

orm

ance

tunin

g, M

igra

tion, U

pgra

dation, P

atc

hin

g

Insta

llation,

Clo

nin

g, M

igra

tion, U

pgra

dation,

Patc

hin

g,

Work

on B

ackend –

Data

base s

ide

Work

on A

pplic

ation s

ide

Majo

r d

iffe

ren

ces b

etw

een

Ora

cle

DB

A a

nd

Ora

cle

Ap

ps D

BA

Majo

r d

iffe

ren

ces b

etw

een

DB

A –

Develo

pm

en

t an

d D

BA

–P

rod

ucti

on

Ora

cle

DB

A

Page 22: J2 l technology_otherconcepts_recruiting

The job o

f th

e D

BA

seem

s to b

e e

very

thin

g that every

one e

lse e

ither

doesn't

want to

do, or

doesn't

have the

abili

ty to d

o. D

BA

s g

et th

e e

nvia

ble

task o

f figuring o

ut all

ofth

e thin

gs n

o o

ne e

lse c

an fig

ure

out. M

ore

seriously

though, here

is a

lis

t of ty

pic

al D

BA

responsib

ilities:

•Insta

llation, configura

tion a

nd u

pgra

din

g o

f O

racle

serv

er

softw

are

and r

ela

ted p

roducts

•Evalu

ate

Ora

cle

featu

res a

nd O

racle

rela

ted p

roducts

•Esta

blis

h a

nd m

ain

tain

sound b

ackup a

nd r

ecovery

polic

ies a

nd p

rocedure

s

•Take c

are

of th

e D

ata

base d

esig

n a

nd im

ple

menta

tion

•Im

ple

ment and m

ain

tain

data

base s

ecurity

(cre

ate

and m

ain

tain

users

and r

ole

s, assig

n p

rivile

ges)

•Perf

orm

data

base tunin

g a

nd p

erf

orm

ance m

onitoring

•Perf

orm

applic

ation tunin

g a

nd p

erf

orm

ance m

onitoring

•Setu

p a

nd m

ain

tain

docum

enta

tion a

nd s

tandard

s

•Pla

n g

row

th a

nd c

hanges (

capacity p

lannin

g)

•Work

as p

art

of a team

and p

rovid

e 7

x24 s

upport

when r

equired

•Perf

orm

genera

l te

chnic

al tr

ouble

shooting a

nd g

ive c

onsultation

to d

evelo

pm

ent te

am

s

Inte

rface w

ith O

racle

Corp

ora

tion for

technic

al support

.

DB

A R

esp

on

sib

ilit

ies

Page 23: J2 l technology_otherconcepts_recruiting

•Good u

nders

tandin

g o

f th

e O

racle

data

base, re

late

d u

tilit

ies a

nd

tools

•A g

ood u

nders

tandin

g o

f th

e u

nderlyin

g o

pera

ting s

yste

m

•A g

ood k

now

ledge o

f th

e p

hysic

al data

base d

esig

n

•Abili

ty t

o p

erf

orm

both

Ora

cle

and o

pera

ting s

yste

m p

erf

orm

ance tunin

g a

nd m

onitoring

•Know

ledge o

f A

LL O

racle

backup a

nd r

ecovery

scenarios

•A g

ood k

now

ledge o

f O

racle

security

managem

ent

•A g

ood k

now

ledge o

f how

Ora

cle

acquires a

nd m

anages r

esourc

es

•A g

ood k

now

ledge O

racle

data

inte

grity

•Sound k

now

ledge o

f th

e im

ple

mente

d a

pplic

ation s

yste

ms

•Experience in c

ode m

igra

tion, data

base c

hange m

anagem

ent and d

ata

managem

ent th

rough the v

arious

sta

ges o

f th

e d

evelo

pm

ent

life c

ycle

•A s

ound k

now

ledge o

f both

data

base a

nd s

yste

m p

erf

orm

ance tunin

g

•A D

BA

should

have s

ound c

om

munic

ation s

kill

s w

ith m

anagem

ent, d

evelo

pm

ent te

am

s, vendors

and

syste

ms a

dm

inis

trato

rs

•Pro

vid

e a

str

ate

gic

data

base d

irection for

the o

rganiz

ation

•A D

BA

should

have the a

bili

ty to h

andle

multip

le p

roje

cts

and d

eadlin

es

A D

BA

should

possess a

sound u

nders

tandin

g o

f th

e b

usin

ess

Req

uir

ed

Skills

fo

r D

BA

Page 24: J2 l technology_otherconcepts_recruiting

J2

EE

(Ja

va

2E

nte

rprise

Ed

itio

n)

J2

SE

( J

ava

2S

tan

da

rd E

ditio

n )

J2

ME

( J

ava

2M

icro

Ed

itio

n)

Web b

ased

& D

eskto

p A

pp

lica

tion

sF

or

On

line

gam

ing

Fo

r M

ob

ile a

pplic

ations

Co

re J

ava

J2

EE

Sw

ings –

Writin

g t

he

form

sJS

P(

Ja

va

Se

rve

r P

age

s),

EJB

(En

terp

rise

Java

B

ean

s),

Se

rvle

ts

On

ly t

o d

esig

n t

he

d

esk

top

ap

pli

ca

tio

ns

Dis

trib

ute

d e

nte

rprise

s a

pp

lica

tion

It is W

eb

ba

se

dand

Des

kto

p b

ase

da

pp

licati

on

s

Mo

st

imp

ort

an

t q

ue

sti

on

s y

ou

ha

ve

to

ask

th

e c

an

did

ate

s:

1)

What

is th

e I

DE

(In

tegra

ted

De

ve

lopm

ent

En

viro

nm

en

t) t

ha

t he

/she

is u

sin

g?

Lik

e E

clip

se

, N

etb

ea

ns,

Jde

ve

lop

er,

JB

uild

er,

2)

Ho

w m

an

y J

SP

s h

e/s

he

ha

s w

ritt

en

?

3)

What

typ

e o

f E

JB

s y

ou

ha

ve

writt

en

? a

) E

ntity

Bea

ns b

) se

ssio

n B

ea

ns.

4)

What m

eth

od

yo

u h

ave

fo

llow

ed

and

ask f

or

SD

LC

?

5)

Are

you

com

fort

on

Se

rvle

ts?

Se

rvle

tsis

wh

ich

ru

ns in

Se

rve

r an

d it

is a

red

ire

cto

r.

Su

n T

ech

no

log

ies:

JA

VA

/ J

2E

E

Th

ree d

iffe

ren

t V

ers

ion

s o

f J

AV

A 2

Dif

fere

nce b

etw

een

Co

re J

AV

A &

J2E

E

Page 25: J2 l technology_otherconcepts_recruiting

IBM

Tech

no

log

ies

&��5�6

��

�2

0���

�����'

��

��

!"

�� 7

�00 ��

������'

��$

���8�

���

���

�����#

���

�� �

��

9�60

����

�'���

'��

�����"

������

#�$� �

',���#

��

:������ �#��

"�� �

"������

����'���.���

����

�(���

�00 ��

������,

�$� �

0�

���

�'8/

;;

�00 ��

������,

�$� �

0�

���

"���

����

��������

����������

Page 26: J2 l technology_otherconcepts_recruiting

In M

ain

fram

es

we u

se :

1)

Co

bo

las the p

rogra

mm

ing language

Ab

ou

t C

OB

OL

Acro

nym

for

Co

mm

on B

usin

ess O

riente

d L

anguage. D

evelo

ped in the late

1950s a

nd e

arly 1

960s, C

OB

OL

is the s

econd-o

ldest hig

h-level pro

gra

mm

ing language (

FO

RT

RA

N is the o

ldest)

. It is p

art

icula

rly p

opula

r fo

r busin

ess a

pplic

ations that ru

n o

n larg

e c

om

pute

rs.

CO

BO

L i

s a

word

y l

anguage;

pro

gra

ms w

ritten i

n C

OB

OL t

end t

o b

e m

uch l

onger

than t

he s

am

e p

rogra

ms

writt

en i

n o

ther

languages.

This

can b

e a

nnoyin

g w

hen y

ou p

rogra

m in C

OB

OL,

but

the w

ord

iness m

akes i

t easy t

o u

nders

tand p

rogra

ms b

ecause e

very

thin

g is s

pelle

d o

ut. A

lthough d

ispara

ged b

y m

any p

rogra

mm

ers

fo

r bein

g o

utd

ate

d, C

OB

OL is s

till

the m

ost w

idely

used p

rogra

mm

ing language in the w

orld.

CIC

Sas a

backend tool :

2)

Ab

ou

t C

ICS

Short

for

Custo

mer

Info

rmation C

ontr

ol S

yste

m, a T

P m

onitor

from

IB

M that

was o

rigin

ally

develo

ped to

pro

vid

e tra

nsaction p

rocessin

g for

IBM

main

fram

es. It c

ontr

ols

the inte

raction b

etw

een a

pplic

ations a

nd u

sers

and lets

pro

gra

mm

ers

develo

p s

cre

en d

ispla

ys w

ithout deta

iled k

now

ledge o

f th

e term

inals

bein

g u

sed.

CIC

S is a

lso a

vaila

ble

on n

on-m

ain

fram

e p

latform

s inclu

din

g the R

S/6

000, A

S/4

00 a

nd O

S/2

-based P

Cs.

Main

fram

es

Page 27: J2 l technology_otherconcepts_recruiting

3)

DB

2as a

Data

base:

Ab

ou

t D

B2:

Short

for

Data

base 2

,a fam

ily o

f re

lati

on

al d

ata

base

pro

du

cts

offere

d b

y I

BM

. D

B2 p

rovid

es a

n o

pen

d

ata

base e

nvir

on

men

tth

at ru

ns o

n a

wid

e v

ariety

of com

puting p

latform

s. A

DB

2 d

ata

base c

an

g

row

fro

m a

sm

all s

ing

le-u

ser

ap

plicati

on

to

a larg

e m

ult

i-u

ser

syste

m. U

sin

g S

QL, users

can

obta

in d

ata

sim

ultaneously

fro

m D

B2 a

nd o

ther

data

bases.

DB

2 inclu

des a

range o

f applic

ation

develo

pm

ent and m

anagem

ent to

ols

. D

B2 s

up

po

rts M

ain

fram

e a

s w

ell a

s U

NIX

en

vir

on

men

t

4)

MV

S, O

S/3

90

are

the o

pera

ting s

yste

ms for

Main

fram

es

i) A

bo

ut

VS

AM

:

Virtu

al S

tora

ge A

ccess M

eth

od,a f

ile m

anagem

ent syste

m u

sed o

n IB

M m

ain

fram

es. V

SA

M s

peeds u

paccess to d

ata

in file

s b

y u

sin

g a

n invert

ed index (

calle

d a

B+

tree)

of all

record

s a

dded to e

ach file

. M

any legacy s

oftw

are

syste

ms u

se V

SA

M to im

ple

ment data

base s

yste

ms (

calle

d d

ata

sets

).

ii)

Ab

ou

t M

VS

Short

for

Multip

le V

irtu

al S

tora

ge,th

e o

pera

ting s

yste

m for

old

er

IBM

main

fram

es. M

VS

was f

irst in

troduced

in 1

974 a

nd c

ontinues to b

e u

sed, th

ough it has b

een larg

ely

supers

eded b

y I

BM

's n

ew

er

opera

ting

syste

m, O

S/3

90.

Main

fram

e A

dm

inis

trato

rs:

1.

OS

/390 A

dm

inis

trato

r

2.

RA

CF

Adm

inis

trato

r (R

esourc

e A

ccess C

ontr

ol F

acili

ty)

Page 28: J2 l technology_otherconcepts_recruiting

AS

/400

AS

/400 (

Applic

ation S

yste

m/4

00,a lin

e o

f IB

M m

inic

om

pute

rs intr

oduced in 1

988.)

is a

Environm

ent and p

latform

and in this

we u

se :

CO

BO

L/4

00, C

L/4

00

as a

Pro

gra

mm

ing

Lan

gu

ag

e

DB

2/4

00

as a

Data

base

OS

/400 a

s a

n O

pera

tin

g s

yste

m

Majo

rly u

sed in B

ankin

g &

Fin

ance Industr

y

Page 29: J2 l technology_otherconcepts_recruiting

����

,���

�����

������

��0��

<���

:������ �'�,�

������

���"

������

���

:������ �������

���"

������

"��

���

����=����

���

:������ �������

#��

������� ���

��:�� ���

�8�

�6�������

�� �

���

:������ �#��

�:�� ���

#��

�"������

����#��

:������ �#��

�"������

>����

���� �?�'

��

��

�#��

���

:������ �:�6��

!���#

���=

����#

��

:������ �� �

��@

���

A��

�����

����� �8��������"

������

���

:������ �� �

���

��

"�� ��

��#

��

:������ �:��

�7,-

���

<���

�,����

:������ �:��

:�B�����

����3���

������?

���� ��

:������ �:�B�������

��

IBM

Rati

on

al T

oo

ls

To

Man

ag

e t

he c

om

ple

te S

oft

ware

De

velo

pm

en

t L

ife C

ycle

Dif

fere

nt

ph

ase

s:

1.

Re

q.

Ga

theri

ng

& A

na

lys

is

2

. D

es

ign

th

e p

roje

ct

3.

Co

din

g &

Im

ple

me

nta

tio

n

4.

Tes

tin

g

5.

Ch

an

ge

Ma

na

ge

me

nt

6

. M

ain

ten

an

ce

&D

oc

um

en

tati

on

Page 30: J2 l technology_otherconcepts_recruiting

Data

ware

ho

usin

g T

oo

ls

ET

L T

ools

: W

hic

h p

erf

orm

s E

xtr

action, T

ransfo

rmation, L

oadin

g o

pera

tions o

n d

ata

OLA

P T

ools

: W

hic

h p

erf

orm

s O

n-L

ine A

naly

tical P

rocessin

g o

n d

ata

Mic

roS

tart

eg

y

Cogn

os

Ab I

nitio

Hyperi

on E

ssb

ase

Info

rmatica

Busin

ess O

bje

cts

Ascential D

ata

Sta

ge

OL

AP

To

ols

ET

L T

oo

ls

For

More

Deta

ils o

n D

ata

ware

housin

g v

isit:

http://w

ww

.1keydata

.com

/data

ware

housin

g/d

ata

ware

house.h

tml

Page 31: J2 l technology_otherconcepts_recruiting

2.

So

urc

ing

Skills

-D

iffe

ren

t w

ays &

M

eth

od

s

Page 32: J2 l technology_otherconcepts_recruiting

1.

Job P

ort

als

-N

aukri.c

om

-Jobsahead.c

om

-M

onste

rindia

.com

-Jobstr

eet.co

m

-T

imesjo

bs.c

om

2.

Onlin

e G

roups &

Dis

cussio

n B

oard

s

-http:/

/gro

ups.y

ah

oo.c

om

-http:/

/gro

ups.g

oo

gle

.com

3. H

um

an

Netw

ork

ing

4. H

eadhunting &

Refe

rences

5. S

earc

h e

ngin

es –

Google

, Y

ah

oo, A

ltaV

ista

etc

So

urc

es…

……