SQL Data Warehouse Design & Architecture Industry Certification Such As MCTS MCP Or   Requirement id 47243 Job title Analyst Job location in Salem, OR Skills required DBMS Systems, SQL Server, Database Systems, Data Warehouse Design & Architecture Ind Open Date 10-Jul-2015 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: DBMS Systems, SQL Server, Database Systems, Data Warehouse Design & Architecture Ind Description: Reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures. Requires a bachelors degree in area of specialty and at least at least 8 years or equivalent experience in the field or in a related area. Demonstrates expertise in a variety of the fields concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. May provide consultation on complex projects and is considered to be the top level contributor or specialist. A wide degree of creativity and latitude is expected. The Contractor shall work at 500 Summer ST, Salem OR 97301. This contract position will provide expert SQL Server consulting and technical services for the DHS/OHA Office of Information Services OR-Kids System. OR-Kids is the States SACWIS. The level of contract support is anticipated to be approximate ½ time for a year, not to exceed 1040 hours. The types of services that will be provided are: • Manage and tune database query performance • Design and Implement security strategy • Create server and database audit specifications • Design indexes for existing applications, choosing when to add or remove indexes • Implement Replication near real-time processing, including system monitoring and scripts for modifications and upgrades • Design Storage Architecture, Partitioning and TempDB usage, including the implementation of compression techniques. • Review and ensure that new database code meets standards for readability, reliability, and performance • Provide developers with feedback regarding the most resource-intensive queries on the server and suggestions for ways to improve performance • Conduct SQL Server training sessions for application developers • Consult with developers on the most efficient database designs for all object types, including tables, data types, stored procedures, functions, etc. Required Skills: • At least 10 years experience with DBMS systems, and at least five years direct experience with SQL Server. • Experience architecting and monitoring high transaction, production database systems. • Expertise with data warehouse design and architecture. • Industry certification such as MCTS, MCP, or other DBMS, business intelligence, or data warehousing certifications.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 47243 while calling.   Other jobs in OR: Orange (1), Portland (22), Salem (38), Tigard (3), Wilsonville (2),         (Analyst: DBMS Systems, SQL Server, Database Systems, Data Warehouse Design & Architecture Ind in Salem, OR)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)