jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 15 years 10 years versatile db2 database administration zos mainframe linux platforms install configure design maintain test integrate deploy largescale ibm db2 databases using cobol jcl vsam experience smpe ibm data growth db2 archive bmc ca platinum tools omegamon tracer preference fastaccess idms natural adabas predict working mainframeslinuxunixwindows operating systems oversee entire database lifecycle develop disaster recovery strategies performs installation configuration implementation db2 software across various platforms operating systems support problem resolution backup recovery db2 databases develops detailed procedural documentation installation maintenance testing project manages databases across systems life cycle coordinate db2 software changes life cycle involves improving sql programming provides performance monitoring tuning recommendations estimates cost based client requirement highly motivated dba professional strong commitment quality customer service skills db2 mainframe zos linux db2 luw omegamon db2 smpe db2 connect java erwin databases db2 zos linux languages java jcl sql cobol natural adabas tools caidms asgtracer asgfastaccess sumtotalpreference ibifocus work history 032013 102016 senior db2 database administrator atos 072012 022013 db2 database administrator asrc federal holding company 072008 072012 db2 database administrator asrc federal holding company 022008 062008 db2 database administrator asrc federal holding company 062006 012007 systems engineer veeam 012003 042006 db2 database administrator asrc federal holding company 2001 012002 systems analyst archer daniels midland company 062000 2001 systems analyst archer daniels midland company 051997 052000 software engineer bgc partners 082012 current senior mainframe db2adabs database administrator archer daniels midland company brookston involve administring db2 databases zos linux production support maintenance existing db2 system infrastructure databases involved migration configuration db2 subsystems executing dr exercises setting daily copy backup utilities monitoring jobs running online standalone ibm utilities ie unloading loading reorg etc collecting statistics processes reviewing updating system parameters optimal performance binding plans db2 dependant productsmaintaining rd fsa db2 subsystems analyze data develop execute appropriate ddls support projects create db2 instances configure update licences performing system dba activities national institute technolgy centre nitc installing configuring db2 products mvs using smpe installation procedure like recieve apply accept install configure admin caidms asgtracer asgfastaccess sumtotalpreference ibifocus natural adabas faa environment 072008 072012 db2 dba lead consultant ust global involve administering db2 databases zos linux monitoring daily db2 jobs fixing issues create db2 objects like databases provide appropriate access rights db2 users fix db2 problems faced developers solve locking conflicts provide authorization privileges db2 access check database status monitor daily monthly batch cycle resolve job abends production environment responsible database integrity database backup recovery involve design db2 objects various projects zurich environment 022008 062008 db2 udb dba lt infotech involve administring db2 databases linux zos environments remove restriction pending status db2 objects backup recovery db2 objects data refresh maintenance remove restrictions pending status db2 objects provide change management documentation database changes set db2 instances development test environments create maintain db2 objects databases involve performance tuning db2 instances running linux take backups restore databases development test production design database etcps transunion application apply fixpacks design component design activities database component design set development environment etcps application implement database design use erwin tool physical logical database design environment 062006 012008 systems analyst lt infotech 052004 052006 db2 dba project lead involve providing support projects unload load database reorganize collect statistics processes reorganization table space collecting statistics using runstats remove restriction pending status db2 objects running online standalone ibm utilities backup recovery db2 objects involve project plan reviews test reviews document preparation involve performance tuning db2 sub system running aix attend db2 associated internal training programs database admin including backup recovery installation db2 database configuring instances set db2 databases environment db2 zos aix db2 ibm candle corporation chennai db2 dba product development ibm performance expert db2 product responsibilities products supported ibm omegamon xe db2 ibm performance expert db2 perform extensive dba activities recreatesetup test environmentsituation perform dba functions like archiving providing user object privileges execute recovery operation backup procedures test products various versions db2 like ver 8 9 test product various types db2 like datasharing ddf new function mode etc develop test programs testing product features like performance stored procedures user defined functions distributed database threads distributed allied threads cics ims threads tso batch threads etc usage operator commands db2 commands appropriate times active participation fagan inspection process code document inspection execute db2 utilities like fullcopy increametal copy image copies loadunload runstats reorg set test environments include following activities installing configuring db2 products mvs using icat uses smpe installation procedure like recieve apply accept installing necessary components windows like db2 connect cnpcnps configuring installing needed fixpacksptfs defects testing appropriate version product developing test plans defining testcases test tracking tool lotus notes database running smf gtf traces producing reports report defects using ibm cmvc following progress update current status defects defect tracking database experience relational dimensional data modeling creating logical physical design database er diagrams using erwin tool environment zos aix db2 udb db2 connect ims jcl vsam cobol java ibm candle corporation chennai 022003 042004 dba product development omegamon db2 products supported omegamon ii db2 omegamon xe db2 dbexplain testing termed function test involves function testing performance testing regression testing system testing responsibilities preparation test plans test schedule analysis defect records recreation situation involve fagan inspection process setting test environment installing products necessary ptfs fixpacks distributed environment developing programs creating necessary db2 objects testing defining tasks allocating task team members interacting onsite team get information defect records preparation testdata testcases executing testcases preparation test results deliverables environment zos aix db2 udb java db2 connect wlm datasharing ddf cobol 082001 022003 java consultant lt infotech city state project involved developing java beans jsp customer contact center responsibilities configure weblogic server set properties file handling file uploading though ftp design development java beans jsp user inputs jsp reports connect oracle database retrieves data database formatting reports per user requirements coding session management jsp page pass form values one page another create jdbc connection database connecting database though jsp create java beans specified requirements accessing jsp write client side validation using javascript code scriplets jsp handle specified tasks writing server side includes dynamic page generation write test cases java programs jsp generating test results unit test environment java jsp j2ee oracle 022001 072001 java consultant metlife inc city state project business intranet development project involved creating new internal business projects maintaining project status creating reports responsibilities design coding testing java programs jsp reports connect oracle database code session management jsp pass form values one page another create jdbc connection database connecting database retrieve data tables design oracle database write stored procedures migrate data data warehouse tables local intranet application tables create java beans specified requirements accessing jsp write client side validation using javascript code scriplets jsp handle specified tasks writing server side includes dynamic page generation write test cases java programs jsp generating test results unit test environment java jsp j2ee oracle 072000 012001 java consultant price waterhouse coopers pwc city state digital identity identity hosting service enables people institutions securely execute legally binding transactions online provides secure channel deliver authenticated information documents responsibilities develop ui registration center using jsp javascript java beans using weblogic server windows 2000 platform design develop ui netcertainty system administrators view update maintain information identities using ui ejb updating database provide capability administrators change status users enable disable accounts open close accounts develop ui register corporate accounts using jsp java beans netcertainty security area develop online secure area netcertainty users log using username password using jsp javascript java beans personalize site creating filing cabinet user displaying signedunsigned documents updating personal information credentials via security area interface ejb updated object database netcertainty identity recovery devise implement algorithm users recover forgottenstolen credentials based personal secret information using jsp interface ejb queries updates database perform unit test system test acceptance test unit tests ensure constituent components act acceptance tests ensure toplevel functionality system appears user write unit test scripts check behavior components environment java jsp j2ee 031999 062000 mainframe consultant ge power systems city state project transportation system legacy system logically divided different modules like finance po transportation etc transportation system keeps track details shipment container cartons transportation footwear apparel factory customers responsibilties module management offshore client interaction onsite maintaining deliverables cmm level 5 standards involved maintenance enhancement legacy system mainframe using cobol jcl db2 cics xpediter involved unit regression testing environment cobol db2 jcl cics 031998 021999 mainframe consultant netcertainty inc city state amms advanced material management systems accounts payable ap supports ap module amms amms ap module used process invoices regulated uswc purchases made amms procurement system invoices amms purchases received amms ap office directly vendor upon input ims system threeway match done po receipt invoice prior amms ap approves invoice payment amms utilizes upfront accounting edits common tax module insure transactions sent tax calculations free accounting errors correct sales taxes applied responsibilties develop new programs making new changesreports offsiteonsite coordination involved design development quality assurance specification coding testing involved maintenance enhancement system mainframe using cobol jcl vsam cics xpediter environment cobol db2 jcl cics us fidelity guaranty fg 061997 021998 mainframe programmer y2k impact analysis reports generated tcs developed tool affected date fields code amended y2k conversion make y2k compliant responsibilties analyze identify y2k date impacted programs quality assurance specification coding testing environment cobol vsam jcl page 6 6 interests online standalone ibm utilities high risk security clearance us fedaral clients education master engineering mit anna university chennai additional information utilities online standalone ibm utilities high risk security clearance us fedaral clients