*Position : Data Architect* *Location : GREENSBORO, North Carolina*
*Duration : 6 months * *Hourly rate: $40/hr* 1. BASIC PURPOSE. Give a brief statement of the overall principal purpose or function of this position. Support the development teams in analyzing system requirements to develop logical and physical entity relationship models and deploy modeled objects. Mentor other DBA team members when appropriate. Provide project team support for query optimization. 2. NATURE and SCOPE/PRINCIPAL ACCOUNTABILITIES. List the major duties, activities, responsibilities and end results for which this position exists. Database Modeler o Should be an expert in ER data modeling o Should be familiar or quickly learn Infosphere Data Architect o Should be able to work with Architects in Data Modeling standards definition o Should be able to design tables balancing normalization and performance. o Should be able to evaluate SQL code for performance o Should be able to identify need for Indices o Should be able to ensure data quality through modeling. o Should be able to participate in business projects and determine logical model. o Should be able to collaborate with developers in designing data models o Should be able to share on-call responsibilities. o Should be experienced in XML models o Should be familiar with XQuery, XPath o Should have experience in XML Schema and DTD design o Should be familiar in writing stored procedures in PL/SQL o Should be familiar in writing triggers o Design database objects (Logical and Physical) and processes in IDA o Communicate effectively with Project Leaders and team members in IT&S Department o Mentoring and Cross Training other DBA team members o Liaison between external resources and internal resources for database projects. o Create and implement database portions of project plans. o Provide project estimates for DBA skills to project managers. o CVS change management processes relating to IDA. 3. KNOWLEDGE, SKILL, EXPERIENCE and MINIMUM EDUCATION REQUIRED. State the minimum formal education and years of work experience required to satisfactorily perform the positions duties. Include specific educational requirements and list any positions, which may lead to this position. Relational Modeling Experience Experience with Infosphere Data Architect Experience with Oracle RAC Database preferred Experience with SQL/DDL Oracle environments. Experience with other Oracle Database objects Familiarity with Web Based Development Technologies and Web Applications Must be willing to work on all platforms and databases in use at United Guaranty Ability to adapt to a rapidly changing environment Experience mentoring and cross training Time management, planning, and organization skills. Excellent oral, written communication skills. General: AIX experience , Oracle 11g Additional Pluses: Oracle Administration experience Knowledge of J2EE and Java Takes high level business and functional requirements and maps to a logical and physical database design to support business functions. Understands key business relationships entities -- Thanks & Regards Sirisha Suryadevara Manager-sales &recruiting Mutex Systems, Inc 50 Cragwood Road ; Suite 224 ; South Plainfield, NJ 07080. Office: 732-993-4201 Fax: 908-822-8719 [email protected] www.mutexsystems.com Disclaimer: If you do not wish to receive these emails in the future, please reply with "REMOVE" in the subject line and include all email addresses to be removed in the message text. We apologize for the inconvenience -- You received this message because you are subscribed to the Google Groups "KNOW.IT" 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/know_it_az?hl=en.
