Job Description :
Job Title: Consultant, - Senior SQL Database Developer
City, State: San Diego, CA
Duration Fulltime
the Senior SQL Database Developer with relevant experience in global enterprise-class database development. Experience in all aspects of database design, stored procedure development, integration services development, and reporting services development is a must. The ideal candidate will be comfortable working in an Agile environment with multi-million row datasets and focused on developing solutions to address complex database design and content delivery challenges. We are engaged in continuous optimization and refactoring.
The ideal candidate will design and maintain T-SQL stored procedures in support of enterprise data management operations including ETL processes and content delivery via SSRS. In addition, he/she will create and maintain complex SSRS reports, assist in database modeling, design and optimization for new and existing functionality. The incumbent will design tools to manage company data using T-SQL, SSIS, and .NET technology and identify issues and improvements to existing SQL procedures for optimal performance.
Required/Preferred Skills, Work Experience and Education:
Expertise in Microsoft SQL Server 2014 (and greater) tools and technologies
Strong understanding of database concepts and project lifecycle management
6+ years of extensive experience designing and writing complex T-SQL queries, stored procedures and functions
4+ years of experience in SQL Reporting Services designing and maintaining reports
Experience with Visual Studio and protocols for managing code changes in a structured manner
BS in Computer Science, Information Systems or related field or equivalent work experience. Advanced degree preferred
MS Dynamics GP 2015, SharePoint 2014 database structures strongly preferred.
Experience in .NET, VB.NET or C# is a plus, as applied to SQL Development.
Experience in data warehousing methodology