DB2, Oracle, Informix, MS SQL, MY SQL, MS Access
Data Warehousing and Business Intelligent Systems
Database Designing and Performance Tuning
Data Recovery and Repair
Logical and physical design and implementation of transactional and reporting database systems. Maintenance, performance tuning, troubleshooting of DB2 for z/OS, DB2 for LUW. Redirected restores, backups, reorg, runstats, install/upgrade DB2 v8, v9.1, v9.5, v9.7 scripting various DBA tasks, performance analysis, root cause investigation including opening PMR w/ IBM, event monitor and snapshot analysis, HADR.
Implementation, maintenance, performance tuning, troubleshooting of database replication. Unidirectional and bidirectional Q-replication. Tools: IBM InfoSphere Replication Server, IBM DB2 and IBM MQSeries.
Data modeling for data warehouse, dimensional modeling. Platform and tools: IBM Cognos BI 8(Framework Manager, Analysis Studio, Report Studio, Query Studio) Database migration, data export, import and tra