Hi Friends, Please send me some matching profiles and details immediately.
6 month project. $60/hr corp to corp Location; Philadelphia, PA General Project background: Starting with a fairly 'normalized' atomic data layer, this person will be a key participant in the design and implementation of a presentation data layer that will be utilized as the source for reporting applications and analytical (ad-hoc query) capabilities. A first phase of the presentation layer is already in place: heavily dependent on flat, wide denormalized tables. Our goal is to move away (as much as possible) from this approach and move towards a dimensional data layer approach. A series of application databases are also in place supporting subject-area specific database views. This person will work with Data Modelers, DBAs, ETL and BI developers, and Business System Analysts in Business/Functional Requirements review and Solution Design sessions. Mentoring and transfer of Teradata knowledge to current team members is a critical and absolute requirement. Required skills: * 5+ yrs recent Teradata experience as a DBA; focus is on application development DBA skills (physical database design), not as an operational DBA skills (backups, handling of day--to-day requests such as altering a table, capacity planning, general SQL tuning) * 10+ yrs overall IT experience * Near expert level related to Teradata physical database implementations (in-depth understanding of skew, , PPI, joins methods, data access paths, workload management) * Demonstrated experience in the design/build/implementation of Dimensional data layer (focus is on providing data to reporting applications and ad-hoc query capabilities) * Demonstrated experience in the effective use of Aggregate Join Indexes and PPI (Partitioning) * Teradata Certification * Near expert level related to SQL scripting/tuning * Technical Lead experience * Work with very large databases (multiple terabytes) * Crystal clear communications skills * Related Health Care subject matter experience would be a major benefit * Contract only - initial commitment is 3 months with possible extension * On-site interview is required prior to hiring of candidate * Bill rate is at Informatics DBA (Teradata) category * The ideal candidate most likely will have several years of experience as a DBA * A BI or ETL developer with some experience with physical database design or as a DBA is not a candidate that we would consider for this opportunity -- ~~~~~~~~~~~~~~~~~~~~~~~~~~ Thanks & Regards… Mahesh Atreyapurapu. StanSource Inc. Toll Free: 866 561 0351 x 3464. Direct : 703 879 3464. Fax : 866 594 4637. [email protected] www.StanSource.com Yahoo IM id : mahesh_stansource --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Mainframe1952" 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/mainframe1952?hl=en -~----------~----~----~----~------~----~------~--~---
