SQL Server 2005 DBA/Database Developer - 6114 in Chicago, IL
SQL Server 2005 DBA/Database DeveloperNeeded: Senior SQL Server 2005 DBA/Database Developer*MUST be a US Citizen or a Green Card Holder no sponsorship*Horizon Technology Partners has an immediate FULL-TIME, PERMANENT opening for a Sr. SQL Server 2005 DBA/Database Developer-Engineer with strong T-SQL and ETL (SSIS) for a FT position for our client downtown Chicago, IL. In this role you will split you time between functioning as an Operational SQL Server 2005 DBA (50%) and a Database Developer. While at the client site you will function as a DBA for a database intensive analytics Web application built on a Microsoft SQL2005 backbone. The client utilizes the entire SQL2K5 technology stack (including the enterprise capabilities of the database server, Analysis Services for OLAP, SSIS for ETL and data integration, and Reporting Services for building reports). The successful candidate will be a member of the core platform team and responsible for the design and implementation of application and data tier functionality leveraging the above-mentioned technology components. As a member of a small team delivering an online software as a service offering, all DB engineers on the team are also expected to have some production support responsibilities.The ideal candidate is an will have a solid background in relational database modeling and experience building high performance database-intensive transactional applications is required. The candidate must be able to analyze SQL queries for performance bottlenecks and optimize such queries with a structured approach. Specific experience on the SQL2K5 platform is required. (YOU SHOULD BE FAMILIAR and ready to discuss new features added to SQL Server in the SQL2005 release. Familiarity with OLAP and data warehousing concepts and OLAP modeling is a plus. Experience with advanced SQL server capabilities such as partitioning, replication, and service broker and the ability to use these features to scale out data intensive applications is a strong plus. Strong T-SQL development skills are a must!The following skills are required* Strong grounding in relational database concepts and data modeling on the SQL Server 2005 platform.* Strong understanding of transaction processing concepts* SQL query execution fundamentals and query optimization principles.* Data integration and ETL * Strong SSIS background is required* Advanced SQL/T-SQL skills on SQL2005 platform.Familiarity with the following is desired* Analytical schema design and OLAP * Prior experience with Analysis Services is a strong plus.Interested candidates should forward their resumes to: (see below) (see below) Travel required: noneTelecommute: noShaun KirkwoodHorizon Technology Partners, Inc1250 W Northwest HighwaySuite 200Palatine, IL 60067Phone: 202-3242 ext: 106Web: To Apply to this job go to http://www.GadBall.com or click here