Resume
Login
Email

Senior DB2 DBA

Location:
United States
Posted:
April 22, 2010   all resumes
Email:
ia3f4w@r.postjobfree.com
Contact Info:
********@*********.***


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