Sql Server System
Resume:
M athews Emmanuel Ster l i ng, VA 20164
abmbv1@r.postjobfree.com
SU M M ARY
Senior Da tabase Adm in ist ra to r w i t h over 17+ years of exper ience as Sybase da tabase
a dm in ist ra to r (DBA) and suppor t special is t w i t h exper ience i n Repl icat ion Server,
E n te rp r ise Connect Da ta Access, KS H and Perl Shel l scr ip t i ng, DB2 U DB database,DB2
Federa ted servers for Sybase da ta access . A lso, k nowledgeable i n al l aspects of database
a dm in ist ra t ion and archi tectu re. Has p roven abi l i t y i n t u n ing and opt im iz ing databases
a nd proven p roject and people leadersh ip.
T E C H N I C A L SK I L LS
H a rd wa re
I B M 370, I n tel Pen t ium PC systems, SUN V880, RS 6000, S/390
•
RISC(SUN 290*-****-**** E10K 5100 4500 etc..)
•
Vax 750, Vax 780, AT &T, 3B2/500, Ha r r is m in icompu te rs
•
L a ng u ages a n d Sof t w a r e P ac k ages
DB-L ib, SQL, T ransact SQL, C, For t ran, Pascal, 68000 Assembly La nguage, KS H,
•
Perl,
B asic, TCP/ IP, U DP, PC-N FS, U N I X 4.3 BSD Socket L ib ra ry, Power Bu i lder.
•
D a t a bases
•
Sybase (4.9, 10&11), Adap t ive Server (12.0 -15.0.3), Repl icat ion Server(10.0-15.5),
•
E CDA (12.5 -15.0), DB2 U DB (8.2 F ix pack 12, 9.5F ix Pack 3), MS SQL Server 2005.
•
•
O pe r a t i ng Syste ms
Sola r is, U l t r i x, V MS, U N I X system V, A I X
•
EXPER IE NCE
Dec 2001- June 2010
Lead D BA
F reddie Mac, McLean, VA
Provided 24X7 product ion suppor t for Sybase and db2 udb da tabases.
•
Managed t i mely complet ion of F reddie Mac upg rade of more t han 100+ Sybase
•
A SE 12.5.3 to version 15.0.2 and addressed many chal lenges encoun tered due to
change i n behavior of ASE 15 opt i m izer
Designed and imp lemen ted rep l ica t ion solu t ions for H igh Avai lab i l i t y
•
F reddie Mac Sybase Pla t fo rm Lead
•
o Completed Cer t i f ica t ions and created checkl is ts
•
o D id Upg rades and m ig ra t ions
•
o Establ ished standards
•
o Ensu red Proof of concepts
•
o Provided archi tectu re solu t ions to appl ica t ions
•
o Found solu t ions to major aud i t f i nd ings
•
o Designed & developed rep l ica t ion solu t ions
•
o D id setup homogenous and heterogeneous rep l ica t ion systems
•
Worked w i t h App l icat ion suppor t and developmen t team to f ix
•
a ppl ica t ion/da tabase rela ted issues.
Suppor ted reg ression test ing team i n iden t i fy i ng perfo rmance p roblem before
•
p roduct ion deploymen t.
I mp lemen ted En te rp r ise Connect Da ta Access (ECDA) to rep l ica te Sybase da ta to
•
I B M ma inf rame
Cer t i f ied Sybase rep l ica t ion server upgrade f rom 12.6 to 15.5 for F reddie Mac.
•
I mp lemen ted En te rp r ise Connect Da ta Access (ECDA) to I B M ma inf rame
•
Designed and imp lemen ted au toma ted da ta archiva l & pu rge p rocesses
•
I mp lemen ted Baseline Secu r i t y Conf igu ra t ions based on i ndust r y best p ract ices
•
Au toma ted al l database ma in tenance jobs using Au tosys (dump/load reorg dbcc
•
u pda te sta t is t ics etc..)
I ns ta l led / Upgraded al l versions ASE (15.x 12.5.x 12.x. 11.9.x ..) and RS (15.x
•
1 2.6.x 12.x) Apply ing la test EBFs on Sybase.
•
Designed and imp lemen ted DR solu t ions using Sybase rep l icat ion for Loan
•
P rospector appl icat ion
Suppor ted single fam i ly developmen t act iv i t ies and product ion ro l l out
•
P r ima ry DBA fo r h igh avai labi l i t y Loan Prospector System
•
I mp lemen ted DB2 federa ted servers for accessing Sybase data f rom db2 U DB
•
d a tabase
Upg raded db2 U DB 8.2 f i x pack 12 to db2 U DB 9.5 f i x pack 3
•
Suppor ted comple te developmen t of RDS p roject, imp lemen ted M DC’s, and
•
compression I mp lemen ted SRDF fai lover capabi l i t y for h igh avai lab i l i ty.
I ns tance and da tabase creat ion, conf igu ra t ion and t u n i ng exper ience i n db2 udb
•
Da tabase ma in tenance exper ience w i t h Reorg, Runsta ts, Rebind, Expo r t, I mpo r t,
•
L oad, Au to-load, Backup and Restore u t i l i t ies
D a tabase moni to r i ng and t u n i ng exper ience using DB2’s Perfo rmance Mon i tor,
•
S napshot Mon i tor, Even t Mon i tor, V isual Exp la in, and I ndex Advisor perfo rmance
t ools.
Suppor ted SQL Server 2005
•
M en to red j u n io r DBA’s
M ay 1993-Dec 2001
DBA
I n te r na t ional Sof twa re Solu t ions I nc., He r ndon, VA
Worked at t he customer si tes below.
Jan 1997- Dec 2001
S ybase P r od uc t ion Suppo r t D B A (Consu l t a n t )
F reddie Mac, McLean, VA
Responsib le for h igh avai labi l i t y ASE for loan p rocessing w i t h repl icat ion and wa r m
s tandby.
Server/Da tabase perfo rmance t u n ing, database backup disaster recovery, p roact ive
act ion fo r keeping t he da tabases avai lable, C IS, on-call suppor t, Shel l p rogramm ing,
u pg rades, and t he i nsta l la t ion of EBFs etc.
Sybase D B A Dec 1993- Dec 1996
No rwest Mo r tgage, Des Mo ines, I A
Provided p roduct ion suppo r t for severa l Sybase servers and Repl icat ion servers.
I mp lemen ted p roduct ion rol lou ts, upg rades, and capaci ty plann ing for Sybase servers.
Proact ive mon i to r i ng of al l p roduct ion serves.
A u toma ted rou t i ne main tenance p rocedu res w i t h scr ip ts dump and loads (ksh and per l)
Sybase sof twa re i ns ta l la t ion and server conf igu ra t ion,
S uppor ted developmen t team i n Perfo rmance Tun ing & T roub le Shoot ing.
Ref reshed mon t h ly data f rom t h i rd pa r t y
Sybase Deve lope r Sep 1993- Nov 1993
I n te l Corpora t ion, Beaver ton, OR
Developed for a customer suppor t system using Power Bu i lder and Sybase for I n te l
Corpora t ion.
U sed M ic rosof t SQL Server on OS/2 pla tfo rm
I nvolved i n t he benchmar k i ng of Sybase t ransact ions and response requ i remen ts, and
t he developmen t of DB-L ib ra ry p rog rams to load test da ta.
Responsible for ha rdwa re and sof twa re i ns ta l la t ion and ma in tenance, system
a dm in ist ra t ion, st ress test i ng, and au tomat ion of system admin is t ra t ion act iv i t ies.
( Pla t fo rm: Sybase, Sun, PC, NCR 3450)
Systems p rog r a m me r Ju ly 1993- Aug 1993
Cray Commun icat ions, Annapol is Junct ion, M D
Developer on embedded system using Mo to rola assembly and C language for a
commun icat ion appl ica t ion using emula to rs.
Sybase D B A D eve lope r May 1993- June 1993
Fann ie Mae, Washing ton D.C.
M ember of team modify ing and recommend ing changes to a tax managemen t system.
( Pla t fo rm: Sybase, APT, APT SQL, Developer WorkBench)
System/ Ne t wo r k Ad m i n ist r a to r M a rch 1993- Ap r i l 1993
I B M, Aust i n, Texas
Perfo rmed A I X system adm in ist ra t ion for commun ica t ion ver i f icat ion labora to ry at I B M,
A ust i n, Texas. (Pla t fo rms managed: RISC 6000, A I X, TCP/ IP networ k using Token Ring,
E t he rnet, FDD I, N FS, N IS. Used SM I T tool for system admi n is t ra t ion)
P a r t-T i me G r a d u a te Assista n t M ay 1991-Jan 1993
Moorhead Sta te Compu te r Science Depa r t men t, Moorhead, M N
System adm in is t ra tor/manager for al l phases of clien t/server SunOS envi ronmen t,
i nclud ing sof twa re p rocuremen t f rom Open Sof twa re Foundat ion, ha rdwa re and sof twa re
i ns ta l la t ion and admin ist ra t ion, networ k i ng (E the rnet, N FS, N IS, Ema i l), bu i ld i ng new
k e rnels, i nsta l l i ng patches, user managemen t, and help desk f unct ions.
DBA May 1990- Sept. 1990
Me rcan t i le Sof twa re Systems, Piscataway, N J
Developed p rograms for f ron t-end of Sybase 4.2 appl ica t ion.
U sed DB-L ib ra ry, C, T ransact SQL i n developing a t rademar k tex t and i mage search
a ppl ica t ion.
D BA (instal l i ng server, adding logins and users, backup, recovery, consistency checking).
I nvolved i n creat i ng da tabases, sto r i ng p rocedu res, t r iggers, and other server-rela ted
act iv i t ies.
W rote p rograms for upda t i ng ASC I I t rade mar k i n fo rma t ion f rom tape i n to Sybase
t ab les. (Pla t fo rm: Sybase, T ransact SQL, DB-L ib ra ry, JA M)
L ec t u r e r J uly 1981- Ju ly 1987
Hasa r ima l Somani Col lege, Bombay, I n d ia
Teaching Physics to di fferen t college level classes.
L ec t u r e r Aug 1980- June 1981
Ramna ra in Ruia College, Bombay I nd ia
Teaching Vocat ional E lect ron ics to Jun io r college classes.
E D U CA T I O N
May 1993
M oo r he a d Sta te U n i ve rs i t y
M oorhead, M i nnesota
M.S., Compu te r Science
•
U n i ve rs i t y of Bombay
•
M ay 1987
Bombay, I n d i a
•
D.C. M (Dip loma i n Compu te r Managemen t)
•
Dec 1980
Sa r d a r P a t e l U n i ve rs i t y
Guja ra t, I nd ia
M.S., Physics
•
Contact this candidate