Send resumes to [email protected] <http://www.prudentconsulting.com/> * Job Title: DB2 DBA Location: NYC, NY Duration: 1 year Start: Immediate* * Essential Functions/Responsibilities:* 1. 6 + years (Level 3) of relevant experience as Z/OS mainframe DB2 DBA. 2. Good Database Design and Implementation exposure- Design objects, Able to analyze performance implications, Perform partitioning, Understand impacts of different encoding schemes 3. Proficient with Operation and Recovery - Monitor and manage threads (distributed, local), Monitor utilities, Identify and respond to advisory/restrictive statuses on objects, Develop backup scenarios (tables spaces; indexes; full pack; hardware; Flash copies; full, incremental, reference update; copy-to-copy, non-data objects; catalog) and recovery scenarios (table spaces, indexes, roll forward, roll back, current point in time, prior point in time, system point in time copy and restore, catalog and directory), Establish timely checkpoints (checkpoint frequencies) 4. Good exposure to Security and Auditing - Protect DB2 objects Establish security profile (define authorization roles), Identify the appropriate DB2 privileges required for access to DB2 resources, Define and implement authorization and privileges on user and system database objects (revokes, grants) 5. Good Performance Tuning skills- Plan for performance monitoring by setting up and running monitoring procedures, Identify and respond to critical performance metrics (excessive I/O wait times, lock-latch waits and CPU waits; deadlocks, timeouts, RID failures), Review and tune SQL, Interpret EXPLAIN output (HINTs & Visual Explain, index advisor), Analyze access paths (query parallelism; index able, stage 1, and stage 2 predicate types; join methods; block fetching Dynamic SQL considerations (caching, parameter markers, reopt, identification, DSN statement cache tables, OSC), Explain the performance impact of multi-row functionality (multi-row insert scenario, multi-row fetch, reordered row format) 6. Solid exposure to Installation and Migration / Upgrade - Run catalog health checks using queries and utilities, Identify the critical ZPARMs (database-, object- and application-oriented), Identify the migration/upgrade modes (feature availability, mode descriptions, migration paths), Identify & explain Data sharing components. 7. Very good communication and customer facing skills.
-- Regards, -------------------- Prabhu Sekhar Symbioun Technologies, Inc. Direct: 770-408-0334 [email protected] <http://www.prudentconsulting.com/> <[email protected]> -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.
