Adv SQL Knowledge SQL Source Control Systems TFS Or Similar To Maintain A History   Requirement id 54989 Job title Architect Job location in Lansing, MI Skills required .NET And C#, MS-SQL DBA Experience, Database Architect Developing Solution Architecture, Adv SQL Knowledge SQL Source Control Sys Open Date 18-Jul-2016 Close Date Job type Not specified Duration 10 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: .NET And C#, MS-SQL DBA Experience, Database Architect Developing Solution Architecture, Adv SQL Knowledge SQL Source Control Sys Description: The project is to refresh the current architecture and software platform to a supported DTMB application standard and update the user interface. It is also to make sure that the current vendor support is a sustainable model for QVF system with its suite of applications such as QVF, QVF-GUI, QVF-Lite, E-Wizard, Street Index and Electronic Poll Book along with hardware and database components. Directly from Manager: "I am looking for a DBA that has done design, development and implementation of databases. ...Not a maintenance DBA that adjusts tables. The ETL is critical – skill to convert data from an older fragmented design to a new streamlined design." This request is for a SQL DBA with modeling and database conversion skills to work on the Qualified Voter File Project. A high level architecture has been defined that will meet client objectives and support the clerks. The application will have 2 components – a web based and a client based. The client based will have a local database that is message synced with the central database. It is being written in web technologies using .net, C# communicating and MS/SQL database. The Senior Database Consultant, under State direction, will be responsible for database work related to the solution. They will help to perform design and review tasks related to the QVF web portal with focus on database, back end query access data recovery and infrastructure components. They will do initial data conversion between the current QVF database (Oracle) and the QVF Refresh database (SQL). They will also use a software tool (TBD), which will be used to keep the production databases in synch, close to real-time as possible, during the rollout phase of the project. Required Skills: * Experience working in web development with .NET and C# * MS-SQL DBA experience - including creating models, designing DB objects (tables, indexes, etc.), writing DB procedures functions, and triggers * Experience as database architect developing solution architecture from business requirements, information architecture and technical architecture. * Adv SQL knowledge: writing and maintainin lrg complex stored procedures, tuning SQL for optimum perf and creating and maintaining proper indexes * Data Modeling: Experience translating business requirements into a logical and physical data model * Version Control: Using a Source Control Systems (TFS or similar) to maintain a history * Monitor application related jobs and data replication activities * Experience with MVC 4.0 or higher, the Entity Framework, Razor, JQuery and related .NET technologies and frameworks * Experience with software configuration and setup of the SQL translations needed between the Legacy and Refresh database * ETL: Experience translating and transforming datasets based on bus requirements, * ETL: Run real-time extract to retrieve and store the incremental changed data from the Oracle tables Desired Skills: * SQL Server Integration Services transformation experience   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 54989 while calling.   Other jobs in MI: Ann Arbor (5), Detroit (2), Dimondale (1), Lansing (29), Pontiac (1), Southfield (1), TROY (1), Warren (1),    .NET And C# job openings in other states Jobs List PennDOT-TAS2A4 SC2 (Senior Application Developer) (739158) Create date: 29-May-2024 No of submissions : 2 Start date :07/01/2024 End date :07/01/2025 Submission deadline : 06/03/2024 Client info : PennDOT *Note : *This requisition will feature a virtual pre-screen via Teams and then may have final in-person interview onsite at The Keystone Building.* *C.... (This job is for - IT Experience Jobs in PA DauphinCounty Developer - (in Dauphin County, PA)) .NET Lead - 36396 Create date: 10-Jul-2018 Candidate must be our W2 Employee Candidates RTR form should be only on the name of APEX Systems Job Description : .net and C# experience SQL backend experience (writing queeries, understanding of data structure) Data reporting using SSRS or cloud reporting– if they are sharp he can train.... (This job is for - SSRS Jobs in NC Charlotte Developer - (in Charlotte, NC)) ITS63Cat1.NETApplicationDeveloper Create date: 01-Nov-2016 Note: Submission Deadline 11-7-2016 8AM EST Client Name: Executive Office Energy and Environmental Affairs This position is with our State of MA client and will provide analysis, design, development, and implementation of information system solutions for EEA T Applications. The developer will develop web based applications and.... (This job is for - job Jobs in MA Boston Developer - (in Boston, MA))     (Architect: .NET And C#, MS-SQL DBA Experience, Database Architect Developing Solution Architecture, Adv SQL Knowledge SQL Source Control Sys in Lansing, MI)

Featured Jobs Data Analyst (Jobs in Madison, Wisconsin) Customer Analyst (Jobs in COLUMBIA, South Carolina) Network Architect (Jobs in Richmond, Virginia) LMS Manager (Jobs in Madison, Wisconsin) Cybersecurity FISMA MARS Analyst (Jobs in Columbia, South Carolina) Problem Analyst (Jobs in Chelsea, Massachusetts) SQL PostgreSQL Analyst (Jobs in Atlanta, Georgia) PEOPLESOFT Customer Analyst (Jobs in Atlanta, Georgia) Z/Os Specialist (Jobs in Raleigh, North Carolina) Email Supervision Administrator (Jobs in Nashville, Tennessee)