Princeton Information is seeking a Sr. Data Modeler who should be able to: Understand the differences between a Conceptual, Logical and Physical Model Create a logical model from a set of business and/or functional requirements Create a Physical model from a Logical one Hand-on experience with Oracle RDBMS (10g and 11g are required) Perform SQL optimization and tuning - understand cost-based optimizations, how Oracle uses statistics to pick a plan, and the role of analyze and DBMS_STATS to affect the plan chosen Understand the role of partitioning including the different types allowed, their purpose, and what it is appropriate and when it isn't Read and understand the results of Explain Plan Proficiency with PL/SQL and stored procedure development Understand PL/SQL including packages and procedures and be able to write and test them The Senior Data Modeler should be able to lead requirements gathering sessions and to take the results of the requirements gathering sessions and produce a logical model Be able to mentor/lead more junior data modelers Can effectively document their design and the design of others Read the results of Explain Plan and TKPROF to optimize SQL Understand PL/SQL including packages and procedures and be able to write, debug and test them Understand the different components in an Oracle installation including RAC, DataGuard, Streams, ASM Understand Configuration Management, different types of testing, conceptual knowledge of Data Architecture. Understand and implement processes around meta-data to ensure an integrated definition of data for enterprise information, and to ensure the accuracy, validity, and reusability of meta-data. Drive development of consistent definitions for common reference data Deep understanding of Data Flows and relevant Data Repositories Understand and document business data and its uses and retention Define and drive new database releases and in-depth analysis of migration impacts. Princeton Information is one of the nation's top five privately-held IT consulting firms, in business since 1985. Princeton Information services a clientele of primarily Fortune 500 companies nationwide. With annual revenues over $120 million, Princeton Information operates across the US from multiple regional offices. Our Commitment to Our Consultants As a privately held company, Princeton Information is solely committed to the success of clients and consultants - not to any shareholders. PI's success is grounded in the relationships we build with our consultants. We seek the best people; provide career path counseling; as well as the most challenging opportunities in business and in IT. As part of its culture of loyalty and commitment to its consultants, Princeton Information is committed to doing all we can to ensure our consultants have the best possible search, placement and work experience possible. Our Services Working with one Princeton Recruiter will gain you access to over 500 open requirements with the top clients in the US across all industries (finance, insurance, pharmaceutical, commercial, telecom, media, manufacturing) nationwide. Our local recruiters have in-depth knowledge of our clients and opportunities. They will work with you to find you the best possible opportunities for you and your career. Our Relationships Our relationships with our clients, as well as our consultants, are critical to our success! We have a robust sales organization that ensures that Princeton has the inside track on what attributes a person needs in order to be successfully placed and engaged at our clients. We know the technical and non-technical skills that our clients are looking for and we ensure that you are educated about the client prior to your interview with them. Princeton is committed to going above and beyond to ensure that each meeting you have with a client is a successful one!