Consulting Training
DB2-LUW
  • Preparation of operating system for DB2® operation (file system, ports, users, groups, passwords, directories, scripts)
  • Installation of required software
  • Installation of DB2® instances
  • Setup of maintenance jobs like Backup, Runstats, Reorg
  • Implementation of security concepts, Roles, FGAC, RCAC, LBAC, Trusted Contexts
  • Assignment of required rights to users, groups, roles
  • Setting up Spectrum Protect® (TSM® Client) for database backup and log archiving
  • Installation of fix packs andMajor release of db2® software
  • Setting up monitoring software, threshold values, alerting methods
  • Analysis and processing of tickets
  • Preparation and implementation of software updates with DB changes
  • Backup and disaster recovery
  • Development of shell scripts for repetitive tasks, job control or automation
  • Execution of PoCs, implementation, documentation and training
  • Setup, monitoring and maintenance of Q-Replication® and SQL-Replication®
  • Setting up PowerHA® on AIX® for highly available DB2® instances (HADR or active/passive via shared storage)
  • Setup and customizing of TSAMP® or PaceMaker® Cluster (HADR or Active/Passive via Shared Disk)
  • Setup and customizing of PaceMaker Cluster
  • Setup of Federated Database
  • Data movement, export, import, loading of data
  • Adaptation DDL, buffer pool, tablespaces, data movement, DBM CFG, DB CFG
  • Detection of resource bottlenecks with db2pd®, db2top®, dsmtop®, logs, top, topas, nmon, event monitor, trace files.
  • Cause interpretation for error messages in application logs, mostly JDBC
  • Tuning and performance analysis, index suggestions, SQL rewrite suggestions, benchmarking and implementation of best practices
  • Syntax checking of SQL, correction of incorrect SQLs
  • Complex environment migrations, e.g. between BigEndian <-> LittleEndian platforms like AIX to RedHat
  • Planning and creation of CoP for complex conversion work, where several areas are involved
  • Working with system administrators for standardization
  • Creation of automation scripts for orchestration software
  • Creation and tracking of service requests software manufacturers
  • Cooperation and support of software developers
  • Automation and self-service solutions using Ansible®, Docker®, OpenShift®
Red Hat Enterprise Linux
  • RHCSA Level
  • Only available in german
Automation
  • Developing Ansible Playbooks
  • Developing Ansible Custom Modules in Bash and Python
  • Administration and configuration of Ansible Automation Platform®
  • Development of scripts due to Orchestration and Scheduling
  • Automation of various tasks for operating databases
  • Implementation of my In-House solution for DB2-LUW Automation via Ansible
Red Hat Ansible
  • RHCE Level
  • Only available in german
Data Engineering
  • development of data pipelines and ETL routes with Python®, Apache Nifi®, Apache Airflow®
  • ETL/Data engineering via IBM Infosphere DataStage®
DB2-LUW Basics
  • Fundamentals Level
  • Only available in german
Data Visualization
  • Kibana®
  • Tableau®
  • python
DB2-LUW Advanced
  • Admin Level
  • Only available in german
Other Services
  • Administration and maintenance of IBM Puredata System for Analytics®
  • Administration and maintenance of standalone MySQL® databases
  • Administration and maintenance of standalone PostgreSQL® databases
  • Administration and maintenance of standalone and replicaset MongoDB® databases, Ops Manager®
  • Application of agile methods and collaboration (Scrum, DevOps, Kanban, Jira®, Confluece®)
DB2-LUW Performance & Tuning
  • Only available in german
 
DB2-LUW Q-Replication
  • Only available in german

 

 

Self assessment of skills
MIN=1 ; MAX=10
Database Management Systems
  •  DB2-LUW® -> 10
  • SQL Server 2008 R2® -> 6
  • MongoDB® -> 7
  • elasticsearch® -> 6
  • Apache Cassandra® -> 4
    Oracle Database® -> 5
  • MySQL® -> 5
  • MariaDB® -> 5
  • PostgreSQL® -> 8
  • IBM Pure Data System for Analytics® -> 8
  • RDS -> 8
  • Aurora -> 8
  • Dynamodb -> 8
High Availability
  • DB2 HADR® -> 10
  • IBM PowerHA SystemMirror® -> 8
  • DB2 Automation with PaceMaker® -> 7
  • TSAMP® -> 10
  • Qlik Replicate (Attunity)® -> 6
Programming languages
  • Java® -> 7
  • VBA® -> 6
  • C++® -> 6
  • sh/ksh® -> 9
    Powershell® -> 5
  • SQL® -> 8
  • PL/SQL® -> 6
  • Python® -> 4
  • JavaScript® -> 6
Operating Systems
  • IBM AIX 7.2® -> 8
  • Red Hat Enterprise Linux® 6/7/8/9 -> 9
  • SLES® 12/15 -> 7
  • Windows Server 2019® -> 7
  • Sun Solaris® -> 5
Automation
  • BMC Control-M® -> 8
  • Rundeck® -> 8
  • Jenkins® -> 6
  • Docker® -> 8
  • Red Hat OpenShift® -> 6
  • Red Hat Ansible® -> 10
ETL/Data Engineering
  • IBM® Data Replication CDC -> 6
  • IBM® Q-Replication® -> 10
  • IBM® SQL-Replication® -> 7
  • Apache NiFi® -> 8
  • Apache Airflow® -> 4
  • Apache Kafka® -> 5
  • Apache Spark® -> 4
  • ksqlDB -> 4
  • Data Engineering with Python® -> 5
  • IBM Infosphere DataStage® -> 6
Data Visualization
  • Kibana® -> 7
  • Tableau® -> 6
  • python -> 4
Monitoring
  • Foglight® -> 8
  • Spotlight® -> 8
  • BMC PARTOL® -> 8
  • Nagios®/Icinga® -> 8
  • SpeedGain for DB2 -> 7
  • IBM Data Server Manager® -> 8
Familiar Tools
  • Postgres Enterprise Manager® -> 6
  • pgAdmin® -> 6
  • Ansible® Automation Platform -> 9
  • Jira® -> 8
  • Confluence® -> 8
  • Joomla® -> 7
  • iskv_21c -> 7
  • ITSM® -> 8
  • Quest Toad® for DB2® -> 10
  • IBM Replication Center® -> 10
  • IBM Control Desk® -> 7
  • SAP PowerDesigner® -> 6
  • IBM Data Studio® -> 9
  • IBM InfoSphere Data
  • Replication Dashboard® -> 10
Other topics/technologies
  • DB-Development/Design -> 7
  • DB2® Performance tuning/Monitoring -> 10
  • DB2® Security -> 10
  • DB2® DWH/BLU® -> 7
  • DB2® on cloud -> 8
  • DB2® as docker® container -> 8
  • Google Cloud Platform® -> 6
  • IBM Websphere Application Server® -> 8
  • IBM Spectrum Protect (TSM)® -> 7
  • IBM MQ-Series® -> 8
  • IBM DB2 z/OS® -> 4
  • EMC NetWorker -> 8
  • IBM SVC® -> 6
  • IBM Cognos BI (Database)® -> 8
  • IBM Tivoli Directory Server® -> 8
  • IBM Advanced Copy Services® -> 8
  • IBM Tivoli Storage Flashcopy Manager® -> 7
  • IBM Secure directory server® -> 8
  • IBM Tivoli Directory Server® -> 8
  • DB2® Migration -> 9
  • Federated Database -> 8
  • System Administration (AIX®/Redhat®/Windows®) -> 7
  • Scrum/Agile Methods -> 7
  • Project Management -> 8
  • Jboss Application Server® -> 6
  • Networking -> 10
  • Active Directory® -> 7
  • Telematik -> 7
  • Apache Tomcat® -> 8

 
© 2021 Ali Hadji Karimi Weiter zur IT-Haftpflicht von Ali Hadji Karimi, Hamburg