ResumeLogin
Search for: Jobs   Resumes
Keywords or title City, state or zip code

Senior DB2 DBA

Post jobs
Country: United States
Posted date: 4/22/2010   all resumes
Email: ia3f4w@r.postjobfree.com
Contact Info: ********@*********.***
Show Full Resume Send Message Free
Email me new resumes like this


Email
Resume Text:


Locksley F. Smith
** ****** ****
Edison NJ ***37
Phone:404-***-****
mailto:ia3f4w@r.postjobfree.com
Objective

DB2 UDB Database Administration on z/OS Windows AIX Pseries Solaris Linux including Database creation and configuration, backup and recovery performance and tuning and database replication using GoldenGate replication tool, DB2 HADR and QReplication.
To design, develop and support database applications.
To provide valuable services as a database administrator
Qualification Summary
Computer Information Professional presenting more than twenty-two years of solid experience in Information Systems. Demonstrated Database Administration skills including, but not limited to Database and it s Instance/Engine planning, configuration, implementation, troubleshooting, performance tuning, disaster prevention and recovery skills to over 30 client-customer companies, for short/SWAT, medium and long term assignments. Displays excellent leadership, listening, assessment and persuasion skills. Highly effect in communicating technical information and issues to technical and non-technical end-users alike. DB2 Database Administration and Architect expertise. Knowledgeable of HADR and GoldenGate Replication. Experienced AIX , SUSE LINUX and Z/OS, supported databases with capasity of over 10 terabytes in size. Proficient in Cognos Business Intelligence and Performance Management Tool.
Experience
Database Administration (DB2 Version 8 EE/EEE/WSE Windows Version 8 and Version 9 ESE- SuSe Linux and AIX Pseries, DB2 Version 6 - OS/390,Z/OS, IMS DB/DC

May 25, 2009 – Present DB2 UDB DBA Sapphire Technologies, Toronto, Ontario Ca
Sub-contracting for IBM Canada at Rogers Sport Net
• Provided primary database administrative and Architect support for DB2 UDB V9.5 databases in SuSe Linux version 10 using TSM.
• Installed and configured SuSe Linux
• Installed and configured DB2 V9.5 HADR environment.
• Trained Rogers Sports Net Engineers on how to performed failover recovery using HADR.
April 16, 2001 - April 2, 2009 DB2 UDB DBA Assurant Solutions Atlanta GA
• Provided primary administrative and Architect support for DB2 UDB V7, v8 and V9 databases in Linux and Windows and AIX P-SERIES, OLAP environment
• Managed and resolved design issues during development stage and worked closely with developers
• Performed database backups using TSM for storage management
• Used Agile ECM (Enterprise Content Management) tool to deliver solutions rapidly to solve complex problems
• Moved database Schema changes to stage or production.
• Performed database tuning using Quest monitoring tool, Explain Plan and utlbstat/utlestat
• Performed Database Replication on LDAP servers using HADR
• Performed Database Replication on Linux Servers using GoldenGate
• Created databases and database objects
• Modified and enhanced existing databases
• Performed backups recoveries and reorganizations of databases
• Replicated mainframe databases to new mainframe databases and AIX P-SERIES
• Replicated database updates using Replication Center
• Created Data Warehouse sources and processes using Data Warehouse Center
• Created and setup database audit procedure on Linux, AIX Z/OS Platform for SOX’S Compliance.
• Created database reports
• Configured ODBC connection to databases for use by Microsoft Access (EE only)
• Performed database migrations
• Provided ongoing database support including performance enhancement maintenance and end-user education
• Performed DB2 installation and configuration
• Installed upgraded and patched DB2 software and associated applications.
• Worked remotely from home
• Installed Java version 1.4, SuSe 9 Linux, Quest Spotlight software, DBARTISAN
• Created Shell and Rexx scripts to automate database operation

March 1997 – April 2001 DB2 UDB DBA /System Programmer Fujitsu DMR Atlanta GA
• Created databases and database objects
• Provided administrative support for SAP/R3 ABAP/4 as a backup in Windows NT environment
• Modified and enhanced existing databases
• Performed backups recoveries and reorganizations of databases
• Replicated mainframe databases to new mainframe databases and AIX
• Replicated database updates using Replication Center
• Created Data Warehouse sources and processes using Data Warehouse Center
• Created database reports
• Configured ODBC connection to databases for use by Microsoft Access (EE only)
• Performed database migrations
• Provided ongoing database support including performance enhancement maintenance and end-user education
• Performed DB2 installation and configuration
• Developed implemented and tested disaster recovery plans
• Installed upgraded and patched DB2 software and associated applications.
• Worked remotely from home
• Installed Java version 1.2, TELON, SQR / TMON, MVS for OS/390 and Micro Focus Revolve 2000 tool
• Created Shell scripts to automate database operation
• Created DBD and PSB GENS
• Worked on HDAM, PHDAM, HISAM and SHISAM databases.
January 1996 – March 1997 DB2 DBA IBM Atlanta GA
• Performed database migrations
• Provided ongoing database support including performance enhancement maintenance and end-user education
• Performed DB2 installation and configuration on OS/390 Mainframe platform
• Installed upgraded and patched DB2 software and associated applications.
• Created Rexx scripts to automate database operation
September 1984 – January 1996 DB2 System DBA AT&T Atlanta GA
• Installed and configured QMF, SPUFI, VISUAL EXPLAIN, DB2 CONNECT, OMEGAMON FOR DB2/CICS/MVS, CICS TS 1.3, CWS, CSP, SDF II, TSO/ISPF, COBTEST, XPEDITER, ABEND-AID, VSAM, JCLCHECK, JES2, JES3, CA7, SDSF, FLASHER, AVERS, RACF, ABR, SYNCSORT, ADMVS, MF-WORKBENCH, ANIMATOR, INTERTEST, FILE-AID
Development
• Developed shell script to monitor DMS table space usage
• Developed REXX script to take snapshot of db2 databases
• Developed shell script to perform snapshot backup and restore of databases using NetAppliance Filer (NetApp).
• Used HPU to performed data migration
• Developed shell script to perform database audit
• Developed Validated Inter Entity Transaction Error Correction System (VITS) using CICS command level and TELON lower case tool.

Technical Skills
Programming Languages
• Hardware: IBM ES/9000, IBM/3090, PC/LAN Environment
• Operating System: MVS OS/390, MVS/ESA, MVS/XA, UNIX, OS/2, LINUX, MS-DOS, WINDOWS
• Databases: DB2, DATACOM/DB, XDB, ORACLE, FOX PRO, MS ACCESS
• Language: VS COBOL II, ASSEMBLER,DATACOM/IDEAL, DATAQUERY, SQL, PL/SQL,REXX, CLIST, JCL, C, PX Partition Expert, RC/Query, RC/MIGRATOR, RC/ Update, RC/Secure, RC/Extract CA ENDEVOR for DB2
• Case Tool: TELON, ADW Key 4.0 , DESIGN/1, TURBO ANALYST
• Software: BMC TOOLS FOR DB2 CHANGE MANAGER, CATALOG MANAGER, DASD MANAGER, QUEST SPOTLIGHT,RECOVERY MANAGER , ERWIN 4.0, PLATINUM TOOLS, QMF, SPUFI, VISUAL EXPLAIN, DB2 CONNECT, OMEGAMON FOR DB2/CICS/MVS, CICS TS 1.3, CWS, CSP, SDF II, TSO/ISPF, COBTEST, XPEDITER, ABEND-AID, VSAM, JCLCHECK, JES2, JES3, CA7, SDSF, FLASHER, AVERS, RACF, ABR, SYNCSORT, ADMVS, MF-WORKBENCH, ANIMATOR, INTERTEST, FILE-AID, PRO-EDIT, IMS/DC, PANAPT, PANVALET, ENDEVOR, PVCS, LOAD RUNNER stress test , WIN-RUNNER regression test , SSA, BPF 4.4.2, AFP, CICS IBM utilities: CDB Universal Client, VisualAge Interspace, LOTUS NOTES, MS OUTLOOK, File-Aid for DB2 QMF Platinum tools and Omegamon, High Performance Unload (HPU) and HADR
Professional Employment
• DB2 UDB DBA Assurant Solutions Atlanta GA 2001 to Present
• DB2 UDB DBA /System Programmer Fujitsu DMR Atlanta GA 1997-2001
• DB2 DBA IBM Atlanta GA 1996-1997
• DB2 System DBA AT&T Atlanta GA 1984-1996
Awards/Recognition
• Disaster Recovery Testing Award – Assurant Solutions
• Team Excellence Award – DMR
• Quality Recognition Award – IBM
• Contribution in developing Watts/800 Billing System – AT&T
EDUCATION:
Enrolled in Systems and Advanced Programming, Herzing College Montreal Que, Canada
Enrolled in SAP FICO Certification Program, Emory University, Atlanta, GA
BS Electrical Engineering, University of Stratford, England

Similar Resumes

DB2 DBA
Woodbridge, NJ - smp, opc, v9, racf, bac, dba, data migration,...

Customer Service Management Business Project Java
Newark, NJ - web services, telecoms, cart, hibernate, jax,...

DB2 UDB DBA
Camp Hill, PA - dba, programmer, db2, etl, linux,...

DB2 DBA
Baltimore, MD - le, dba, sas, architect, cdl, etl, db2,...

DB2 z/OS DBA and DB2 z/OS Systems
Hermitage, TN - smp, unicode, v9, dba, it specialist, adm,...

Jeffrey Benner, DB2 Database Administrator
United States - dba, developer, db2, offshore,...

db2 udb dba
United States - dba, informatica, etl, java, websphere, db2, j2ee,...

DB2 DBA
United States - dba, developer, es, java, websphere, db2, mining,...

Oracle DBA and Oracle Fusion Middleware 11g Admin
India, Hyderabad, AP - dba, oracle, oracle dba, pvt ltd, apps, admin,...

Project Manager Management Software Maintenance
Glen Burnie, MD - willis, sg, unisys, unload, programmer analyst,...



©2014  PostJobFree.com - Home - Latest Resumes - - Update or Delete my resume