SQL Server Architect/Database

SQL Server Architect/Database

Job Code: 0096
Job Location: Madison, Wisconsin
Zip Code: 53705
Job Category/Title: Database Architect
Employment Category: Contract - Corp-to-Corp, Contract - Independent, Contract - W2
Position Type: Senior Level
Travel Required: No
Interview Type: In-person
Education: Associate Degree
Experience: 5-10 year(s)
Required IT Skills: SQL
Job Description:



• Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Must be able to design, develop and manipulate database management systems, data warehouses and multidimensional databases. Requires a depth and breadth of database knowledge that will help with formal design of relational databases and provides insight into strategic data manipulation. Database Architect capabilities with 6+ years of experience, independently designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Familiar with a variety of the field's concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected.


• Qualification (Must Have):


• Information Technology - Database Design

• Database Tuning and Maintenance to assure highest level of system availability and performance

• Information Technology – Databases

• Basic knowledge of databases and skills with database queries

• Create database objects

• Data analysis

• Database design

• Database links and multiple database instances

• Database monitoring tools

• Database security

• Data Conversion

• Data flow and structure modelling

• Data flow diagramming

• Data Warehouse - Experience in requirements gathering for data warehouse
• Data Warehouse - Performance tuning
• Data warehousing

• Data warehousing and data mining

• Develop workflows from relational databases

• Experience in Data Conversion projects

• Leading database design reviews and enforcing standards

• Logical database design

• Microsoft SQL Server 2008 and 2012
• MS SQL Server

• MS SQL Server Enterprise Mgr.

• Physical database design

• SQL 2012
• SQL Client tools

• SQL Server

• Information Technology - Design
• Database logical design
• Information Technology - Languages/Tools
• Creating and reviewing SQL scripting

• Microsoft SQL Server Reporting Services
• SQL Analysis Services

• Information Technology - Monitoring
• Performance monitoring and tuning of application SQL statements

• Information Technology - Testing
• Develop sample test data




Duration: 12 Month(s)
No. of Posts: 1
Job Expiry Date: February 13, 2016
Telecommute: No
Contact Information Login To View