*Hi Partners,* *Greetings,* ** *Hope you are doing Well!!!!!!!!!!!!!!!* ** *Please forward a profiles to **shan...@techconsultinc.com*<shan...@techconsultinc.com> ** *Here are the requirement details* ** *Location: Minneapolis,MN* ** *Length : 6Months* **
As a Database Administrator on the DBA DB2 Team, you will assist with projects for Data Warehouse/Business Intelligence initiatives. Your primary focus will be to monitor, manage and maintain the DB2 Database for Business Intelligence framework in a very large database (VLDB) environment. You will be responsible for maintaining and improving overall stability proactively through continuous monitoring and tuning of application databases. Required Experience: Experienced DB2 V9 Data Warehousing DBA -Participate in 7x24 on-call rotation -Improving the quality of the operational environment by monitoring, reducing or eliminating unplanned outages, defects, and problems, and by increasing reliability, availability and performance -Proven ability to create, administer, migrate and effectively performance tune high availability DB2 databases -Aptitude towards proactive systems monitoring -Experience Writing and Tuning simple and complex SQL statements -Experience with logical to physical data model conversion -Must possess working knowledge and hands-on experience in following: Data movement in DB2 (load, import, move) Database recovery (backups & restores) Performance Tuning (Reorgs, Indexing, runstats, SQL tuning) Database Upgrades (Full version and fixpaks) Problem Identification (Snapshots, db2explain, db2diag.log, db2pd) Performance Tuning of complex SQL statements -Good understanding of DB2 configuration parameters Db2 Registry variables DB2 Explain Query Performance Tuning Kornshell scripting Desired Experience: -Previous experience in following technologies will be a plus DB2 Database Partitioning Feature Materialized Query Tables Multi Dimensional Clustering Query Patroller DB2 Governor DB2 Compression DB2 Secure Shell (SSH) configuration Erwin Datastage ETL jobs tuning Thanks Shankar 248-522-6879 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to SAP-ABAP@googlegroups.com To unsubscribe from this group, send email to sap-abap+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/SAP-ABAP -~----------~----~----~----~------~----~------~--~---