AFLIGO, a subsidiary of Systemax Inc., a Fortune 1000 company and recognized by customers and vendors alike as the leading direct marketer of computer electronics and industrial equipment. We make it easy for our customers, with our multi-faceted marketing and distribution that feature e-commerce websites, catalogs, retail stores direct sales representatives and comprehensive support services, AFLIGO offers rebates solutions that support client marketing programs, employee incentives and other business to consumer marketing programs. |
This is a MS SQL Server Developer role largely responsible for providing operational database services to the organization.
Develop and implement BI projects, reports and packages using SSIS, SSAS, SSRS, T-SQL and Microsoft database tools.
Overseeing the development and organization of the databases, assessment and implementation of new technologies.
It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible.
Experience with SSIS, SSAS, SSRS, T-SQL and Microsoft database tools.
Optimize SSIS/SSRS/SSAS code performance and processing methods.
Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.
Experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS
Define, develop, document and maintain SSIS/SSRS packages, packages configuration and logging,
Define, develop, document and maintain procedural and SQL programs
Provide input into standards and best practices for code development - preferred.
Experience in Database Administration in SQL Server ( 2005 and 2008 )
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues - preferred
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools - preferred .
SQL Development -- ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Documentation skills for processes and procedures
BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
Has 5+ years of experience in database development and support in MS SQL Server environments.
SQL Server 2005/2008
SSIS, SSAS, SSRS, T-SQL and Microsoft database tools.
Experience with parallel processing/partitioning in SSIS