Database Architect

send resumes to selva@jjcpl.net

Location      :   Augusta, ME

 Duration      : 12 Month

Complete Description: The position will be responsible for collecting user requirements, creating the physical & logical data models,  creating/testing the Extract/Transform/Load (ETL) process and aiding in validation of the data mart & reports. Database Architects are familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and rely on experience and judgment to plan and accomplish goals. Database Architects are able to perform a variety of complicated tasks with minimal or no direct supervision. They assist in defining system and application architecture and provide vision, problem anticipation, and problem solving ability to organization. They consult with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization. SDA1 Years of Relevant Experience: 8 plus years of database architecture experience Preferred Education: 4 year college degree in computer science or related field with advanced study preferred. Role Description: •Possesses extensive knowledge of one or more database systems, and is capable of hands-on work in all phases of database design and management. •Designs, develops, and implements infrastructure to provide highly-complex, reliable, and scalable database to meet the organization's objectives and requirements. •Analyzes organization's business requirements for database design, and implements changes to database as required. •Performs systems analysis on database, and resolves performance, capacity, and replication issues as necessary. •Provides detailed design and specification documentation, including flowcharts, for all aspects of the database. •Works with database analysts to develop methodologies, report views, queries, and table replications •Ensures that all the data is in the proper format. •Participates in the identification, prioritization, and development of technical initiatives and strategies. •Develops and maintains database standards and naming conventions. •Keeps up-to-date on emerging database architectures, technologies, and methodologies, and attends training classes as necessary.

PLEASE FILL THE SKILL MATRIX TABLE WITH YOUR YEAR WISE EXPERINCE Skill Required Years Available Strong Comm/Interpersonal skills 0 Years Required PL/SQL 6 Years Required Oracle 9-11g 6 Years Required SQL Server 2 Years Required Data Warehousing 3 Years Required Exp creating Physical & Logical data models 3 Years Required Requirements & Design 6 Years Required Dimensional DBs 3 Years Required OBIEE (Oracle Business Intelligence Enterprise Edition) 3 Years Highly Desired ETL utilizing PL/SQL as primary ETL tool 3 Years Highly Desired SAS 1 Years Nice to have Database - mixed platform 3 Years Desired PLEASE ANSWER THE FOLLOWING QUESTIONS Question 1: Please submit three professional references (name, contact number, and email). Question 2: Client is open to phone or in person interviews; however, an person interview will be required prior to final selection. Question 3: Work site is Augusta Maine. Please confirm your candidate is comfortable with working in Augusta for the length of engagement.