Previous Job
Previous
Data Architect with SQL
Ref No.: 16-10492
Location: Irving, Texas
Mandatory Technical Skills

· 11+ years of experience with expert competence in architecting, designing and developing database solution in SQL Server 2008/2012/2014/2016
· Worked with the application development teams throughout the development life cycle
· Evaluate new Business Intelligence technologies, features, and products
· Lead or participate in Proof-of-Concept projects
· Ability to take initiative and ownership on tasks
· Able to create SQL Server preliminary and detail design document based on the business requirement
· Explain complex design items through documents and white-board sessions
· T-SQL knowledge and performance tuning experience needed
· Understand and translate business needs into data models, work strongly with application development team to implement data strategies, build Dimensional models and flows
· Strategically design and architecture on conceptual, logical and physical data models optimize models to support new project which incorporate the best practice and reflect scalability for future extension
· Display architectural capabilities in building a SQL Server Architecture solution to handle large volumes of data
· Should possess exhaustive knowledge and experience in SQL Server BI Solution include SSIS,SSAS & SSRS
· Single point of contact to attend and answer all SQL Server BI related client queries
· Capability to develop and tune complex queries, stored procedures
· Technical team management experience including offshore team members
· Excellent personal communication, leadership, and organizational skills
· Good in written and oral communication
Desirable Technical / Functional Skills:
· Experience with PDW, PolyBase, Azure SQL DW would be plus point