Principal DB2 Consultant
Resume:
OSMAN ÇAYLI
Emek Mah. Ordu Cad. AdaPark Evleri N Blok D: 33
Sancaktepe / İstanbul
acq5vp@r.postjobfree.com
SUMMARY
A hardworking, highly experienced IT Professional skilled in systems and database administration and focused on improving in the field of database administration. Strongly results oriented with a positive and innovative approach to work, a very successful team player. Extensive and deep experience in DB2 for zOS and DB2 for z/OS Utilities and products. Good knowledge and experience with IBM DB2 Tools (Omegamon For DB2, High Performance Unload, Log Analysis Tool, Administration Tool For DB2) and also BMC DB2 Tools (BMC SQL Explorer for DB2, APPTUNE for DB2, Pool Advisor for DB2, BMC Main View for DB2, Log Master for DB2, Recovery+ for DB2 ).
I have been IBM authorized trainer since 2010, and I work as instructor of this Information Management Products DB2 and DB2 Tools.
IBM CERTIFIED System Administrator / DB2 10 FOR z/OS IBM CERTIFIED Database Administrator / DB2 10 FOR z/OS IBM CERTIFIED Database Administrator / DB2 9 FOR z/OS IBM CERTIFIED InfoSphere Change Data Capture Technical Professional PERSONAL INFORMATION
Date of Birth : 12.02.1982
Place of Birth : Denizli / TURKEY
Military Service : Completed
EXPERIENCE
2012-Present VBT VIZYON SOFTWARE CONSULTANCY INC. Istanbul, Turkey Principal DB2 Consultant, System and Data Management
Hands-on and on-call support DB2 for z/OS Clients
Management of database systems – DB2 for z/OS
DB2 for z/OS Installation, Customization, Maintenance and Support
Management and administration for 24 by 7 business continuity
Performance management and optimization for the DB2 Subsystems and applications
Architecture design for the database systems and application development
Change management and trouble-shooting for large infrastructure systems
Extensive and deep experience with BMC DB2 Tools (BMC SQL Explorer for DB2, APPTUNE for DB2, Pool Advisor for DB2, BMC Main View for DB2, Log Master for DB2, Recovery+ for DB2 )
Extensive and deep experience with IBM DB2 Utilities (LOAD, REBUILD, REORG, RUNSTATS, COPY, RECOVERY …etc)
Extensive and deep experience with IBM DB2 Tools (Log Analysis Tool, Administration Tool for DB2, Omegamon for DB2 )
Extensive and deep experience with z/OS Mainframe skills (TSO and ISPF, REXX, JCL, DFSORT,z/OS Utilities)
IBM DB2 for z/OS Tools Installation, Customization and Support. Responsible for pre-sales activities and POC/POT of products
BMC Main View Tools Installation, Customization and Support. Responsible for pre-sales activities and POC/POT of products
BMC Control-M Installation, Customization and Support. Responsible for pre-sales activities and POC/POT of products
2006-2012 GARANTI TECHNOLOGY Istanbul, Turkey
Senior Specialist, System and Data Management
Management of database systems – DB2 for z/OS
DB2 for z/OS Installation, Customization, Maintenance and Support
Application performance tuning both in system level and application level
Performance management and optimization for the system and applications
Implementation of backup and recovery strategies
Implementation of the disaster recovery plans
Management and administration for 24 by 7 business continuity
Architecture design for the database systems and application development
Change management and trouble-shooting for large infrastructure systems
Extensive and deep experience with IBM DB2 Utilities (LOAD, REBUILD, REORG, RUNSTATS, COPY, RECOVERY …etc)
Extensive and deep experience with IBM DB2 Tools (Log Analysis Tool, Administration Tool for DB2, Omegamon for DB2 )
Extensive and deep experience with CA DB2 Tools (Detector for DB2, SubSystem Analyzer for DB2, Log Analyzer for DB2, FASTUNLOAD )
2003-2006 HACETTEPE UNIVERSITY Ankara, Turkey
Softeware Engineer, Graduate Project
Developed Vehicle Tracking and Automation System as a graduation project, which is Taxi reservation and tracking system (TaRT).
2005-2005 TURK TELEKOM Ankara, Turkey
Engineer, Summer School Intern
Design for the database systems and application development.
System administration
EDUCATION
June 2006 HACETTEPE UNIVERSITY Ankara
Computer Science and Engineering
Ranked 10th in the all of the 2006 graduates of Computer Science and Engineering Department
Concentration on database systems and performance of database systems, Architecture design for the database systems and application development June 2003 HACETTEPE UNIVERSITY Ankara
Chemical Engineering
Ranked 1st in the first year and honored to have a chance to change the department in engineering faculty. June 2000 ACIPAYAM ANADOLU HIGH SCHOOL Denizli
SKILLS AND ACTIVITIES
Languages
English (Professional working proficiency)
Turkish (Native or bilingual proficiency)
Skills
Management of database systems – DB2 for z/OS
DB2 for z/OS Installation, Customization, Maintenance and Support
Parallel SYSPLEX and DB2 data sharing
Extensive and deep experience with IBM DB2 Utilities (LOAD, REBUILD, REORG, RUNSTATS, COPY, RECOVERY …etc)
Extensive and deep experience with BMC DB2 Tools (BMC SQL Explorer for DB2, APPTUNE for DB2, Pool Advisor for DB2, BMC Main View for DB2, Log Master for DB2, Recovery+ for DB2 )
Extensive and deep experience with BMC Control-M
Extensive and deep experience with CA DB2 Tools (Detector for DB2, SubSystem Analyzer for DB2, Log Analyzer for DB2, FASTUNLOAD )
Extensive and deep experience with IBM DB2 Tools (Log Analysis Tool, Administration Tool for DB2, Omegamon for DB2 )
Extensive and deep experience with z/OS Mainframe skills (TSO and ISPF, REXX, JCL, DFSORT,z/OS Utilities)
Implementation of backup and recovery strategies
Database Administration
Database Backup and Recovery
Database Management, Database Design
Data Management, Data Modeling, Data Governance, Data Security, Data Quality
SQL Performance tuning, Application performance tuning Certifications
November 2014 IBM CERTIFIED System Administrator / DB2 10 FOR z/OS July 2014 IBM CERTIFIED Database Administrator / DB2 10 FOR z/OS July 2013 IBM CERTIFIED DATABASE ASSOCIATE / DB2 10 FUNDAMENTALS July 2011 IBM CERTIFIED DATABASE ASSOCIATE / DB2 9 FUNDAMENTALS July 2011 IBM CERTIFIED DATABASE ADMINISTRATOR / DB2 9 FOR Z/OS November 2013 IBM CERTIFIED BigData Fundamentals Technical Professional July 2013 IBM CERTIFIED Information Management DB2 10 Technical Professional February 2013 IBM CERTIFIED InfoSphere Guardium Technical Professional September 2012 IBM CERTIFIED InfoSphere Change Data Capture Technical Professional Courses
March 2007 DB2 8 for z/OS System Administration London
Training Center : IBM-UK
Course Code : CV850
Delivery Type : Classroom (Hands-on labs)
Duration : 5.0 days
April 2007 DB2 8 for z/OS Database Administration Workshop Part 1 London
Training Center : IBM-UK
Course Code : CV871
Delivery Type : Classroom (Hands-on labs)
Duration : 5.0 days
May 2008 DB2 8 for z/OS Database Administration Workshop Part 2 London
Training Center : IBM-UK
Course Code : CV841
Delivery Type : Classroom (Hands-on labs)
Duration : 5.0 days
June 2009 DB2 9 for z/OS Application Performance and Tuning London
Training Center : IBM-UK
Course Code : CV960
Delivery Type : Classroom (Hands-on labs)
Duration : 5.0 days
Projects
April 2015 BMC MainView POC
Customer Name : AKBAK
Project Team : Osman CAYLI (VBT), Akbak z/OS Team, Birol Basaran (VBT) Duration : 2 Month
Summary : We have planned and implemented MainView with team members. I have done the SMP/E installation and some parts of customization process. After the installation and customization finishes we show the customer how to use MV Products. We try to show them Business challenge February 2015 BMC Subzero POC
Customer Name : HALKBANK
Project Team : Osman CAYLI (VBT), Halkbak z/OS Team, Ramon Menendez(BMC), John Dormon (BMC), Birol Basaran (VBT)
Duration : 2 Month
Summary : We have planned and implemented SubZero process with team members. I have done the SMP/E installation and some parts of customization process. After the installation and customization finishes we solved the problems and make some changes according to customers’ needs. November 2014 BMC RECOVER PLUS & Log Master for DB2 11.1 Installation & Customization Customer Name : IS BANK
Project Team : Osman CAYLI (VBT)
Duration : 1 Week
Summary : I have installed and customized BMC RECOVER PLUS & Log Master for DB2 products at IS BANK. I have installed both in TEST and PRODUCTION Systems. October 2014 IBM DB2 for z/OS New Functions and Features in V10 Workshop (CV311) Customer Name : IS BANK
Project Team : Is Bank Mainframe Database Administration Team Duration : 5 Days
Summary : I have been IBM authorized trainer since 2012, and I was instructor of this CV311 Workshop which is organized for Mainframe Database Administration Team in Is Bank. October 2014 IBM DB2 for z/OS V10.1 Migration (Migration of both CM and NFM) Customer Name : IS BANK
Project Team : Mainframe Database Administration Team Duration : 1 Year
Summary : We have planned and implemented migration process with team members. All the migration steps tested many times before migration. I have worked hands on at migration of a Data Sharing Group which running on production in this project.
April 2014 IBM DB2 10 for z/OS Application Performance Tuning Workshop (CV962G) Customer Name : GARANTI TECHNOLOGY
Project Team : Osman CAYLI (VBT)
Duration : 5 Days
Summary : I have been IBM authorized trainer since 2012, and I was instractor of this Workshop which is organized for Application Development team in Garanti Technology. December 2013 BMC SQL Performance for DB2 11.1 Installation & Customization Customer Name : AKBANK
Project Team : Osman CAYLI(VBT), Birol BASARAN (VBT), Raymond BELL(BMC), Hakan SAHIN(AKBANK) Duration : 2 Weeks
Summary : We have installed and customized BMC SQL Performance for DB2 11.1 product at AKBANK. We have installed both in TEST and PRODUCTION Systems.
November 2013 BMC SQL Performance for DB2 11.1 Installation & Customization Customer Name : IS BANK
Project Team : Osman CAYLI (VBT), Aysen SOLAK (IS BANK) Duration : 2 Weeks
Summary : We have installed and customized BMC SQL Performance for DB2 11.1 product at IS BANK. We have installed both in TEST and PRODUCTION Systems.
October 2013 IBM DB2 9 for z/OS Application Programming Workshop (CV721) Customer Name : AKBANK
Project Team : Osman CAYLI (VBT)
Duration : 3 Days
Summary : I have been IBM authorized trainer since 2012, and I was instructor of this Workshop which is organized for Application Development team in AKBANK.
May 2012 IBM DB2 for z/OS V10.1 Migration (Migration of both CM and NFM) Customer Name : GARANTI TECHNOLOGY
Project Team : Mainframe Database Administration Team Duration : 1 Year
Summary : We have planned and implemented migration process with team members. All the migration steps tested many times before migration. I have worked hands on at migration of a Data Sharing Group which running on production in this project.
April 2012 IBM DB2 for z/OS New Functions and Features in V10 Workshop (CV311) Customer Name : GARANTI TECHNOLOGY
Project Team : Osman CAYLI (VBT)
Duration : 5 Days
Summary : I have been trainer and authorized DB2 Instructor at GARANTI TECHNOLOGY. June 2011 IBM DB2 9 for z/OS Application Programming Workshop (CV721) Customer Name : GARANTI TECHNOLOGY
Project Team : Osman CAYLI (VBT)
Duration : 3 Year
Summary : I have been trainer and authorized DB2 Instructor at GARANTI TECHNOLOGY. June 2010 IBM DB2 9 for z/OS Application Programming Workshop (CV721) Customer Name : GARANTI TECHNOLOGY
Project Team : Osman CAYLI (VBT)
Duration : 3 Year
Summary : I have been trainer and authorized DB2 Instructor at GARANTI TECHNOLOGY. May 2010 PCI-DSS Credit Card Number Encryption in Database Customer Name : GARANTI TECHNOLOGY
Project Team : Mainframe Database Administration Team Duration : 1 Year
Summary : We have installed and customized BMC SQL Performance for DB2 11.1 product at IS BANK We have installed both in TEST and PRODUCTION Systems.
August 2009 IBM DB2 for z/OS V9.1 Migration (Migration of both CM and NFM) Customer Name : GARANTI TECHNOLOGY
Project Team : Mainframe Database Administration Team Duration : 1 Year
Summary : We have planned and implemented migration process with team members. All the migration steps tested many times before migration. I have worked hands on at migration of a Data Sharing Group which is running on production in this project.
December 2008 IBM DB2 for z/OS Installation and Implementation Customer Name : GARANTI TECHNOLOGY
Project Team : Mainframe Database Administration Team Duration : 6 Months
Summary : We have installed a new DB2 Data Sharing Group in TEST and PRODUCTION systems. This new system is installed for Quality Assurance tests. We also had migrated the DDLs and DMLs from production system and implemented to this new system.
July 2007 IBM DB2 for z/OS V8.1 Migration (Migration of both CM and NFM) Customer Name : GARANTI TECHNOLOGY
Project Team : Mainframe Database Administration Team Duration : 2 Years
Summary : We have planned and implemented migration process with team members. All the migration steps tested many times before migration. I was very young and new graduate DB2 DBA in GARANTI TECHNOLOGY Mainframe Database Administration Team in this project and worked to find out the accesspath changes between V7 and V8
February 2007 IBM DB2 for z/OS Code Page Conversion Customer Name : GARANTI TECHNOLOGY
Project Team : Mainframe Database Administration Team Duration : 2 Years
Summary : We have done code page conversion in our TEST and PRODUCTION DB2 SubSystems. REFERENCES
Available upon request
Contact this candidate