Consulting
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 and Major 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®
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
Data Engineering
- Development of data pipelines and ETL routes with Python®, Apache Nifi®, Apache Airflow®
- ETL/Data engineering via IBM Infosphere DataStage®
Data Visualization
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®, Confluence®)
Training
Red Hat Enterprise Linux
- RHCSA Level
- Only available in German
Red Hat Ansible
- RHCE Level
- Only available in German
DB2-LUW Basics
- Fundamentals Level
- Only available in German
DB2-LUW Advanced
- Admin Level
- Only available in German
DB2-LUW Performance & Tuning
DB2-LUW Q-Replication
© 2021– Ali Hadji Karimi 
