Senior SQL Server Developer position available to create a very complex database backend in SQL Server 2008 using and Integration Services (SSIS), ETL, data transformation services as part of an enterprise-level financial application. You will be exposed to some talented team members and best-in-class financial applications and SQL developers in the Dallas area, with an outstanding record of achievement. We are seeking an innovator and a high-level thinker to design and implement a “greenfield” database application system. This will be a very challenging and enjoyable role!
Large and complex SSIS, ETL enhancements, SQL design, SQL development, TSQL coding, performance tuning, SSRS, reporting services. Design and Code SQL and T-SQL to run very fast. Quality Assurance is a must and performance levels must remain high for these large ETL and SSIS enhancements. Use agile development and agile testing techniques. Use Visual Studio 2010 for SSIS manipulation and TFS for test and bug purposes.
Demonstrable knowledge SQL Server 2008 or 2012 development features at an intermediate to advanced level: TSQL, SSIS, SSAS. Experience creating data models and applying them at physical level. Good understanding of SQL server internals and its relationship with the Windows Server Operating System and hardware (Windows Server 2008 or higher preferred). Knowledge of various optimization approaches and the trade-offs involved. General experience in a data warehouse environment (hub & spoke model). Experience creating data-marts for specific querying requirements. Familiar with various ETL tools for large data transfer across platforms. Understanding the large data allocation and partition to maximize throughput within different storage tiers. Good knowledge of message queuing service and in-memory data store.
Bachelor’s degree in Computer Science or related degree, or equivalent experience plus 5-10+ years SQL Server design, development, coding and architecture. Strong SQL Server T-SQL experience including SSAS, data warehousing, data models, and SSIS, data transformations, extract transfer and load, ETL. Experience with high performance enterprise SQL Server applications development and coding. Experience with DTS and SSIS or SQL Server Integration Services is required. SQL Server, TSQL performance tuning, optimization, and troubleshooting. SSRS.
.NET, Visual Studio (for SSIS manipulation), TFS, team foundation server for testing and bug tracking purposes. SQL Server DBA experience.
Employment Type: Regular Full-Time
Compensation: $100,000 to $125,000 per year
Benefits: life, health, dental, vision, 401(k) matching, ADD, short-term disability, paid-vacation, paid-sick time off
Location: Plano, Texas
No H1-B sponsorships. US Citizens and US greencard holders, highly preferred. Principals only. No consulting firms or contractors. Direct hires only.
Please email resume in MS Word format, or as text.
To inquire, or to inform us of your resume submittal, or to discuss, please call (Dallas toll-free) 817-424-1411.