Sr. Database Developer
Sacramento, CA
6 month, contact
Client is Social Interest Solutions
 
Additional Notes:
Database engineer
Development of Database
SQL TransAct (Microsoft version)
Stored procedures
Database optimization
Position Description:
The senior database developers primary job function is to analyze, design, develop, test, tune, and maintain database software design and components in support of business requirements. This includes database and data warehouse database schemas and related artifacts (referential integrity, indexes, etc.) as well as Transact SQL stored procedures. He/she will write detailed technical specifications, so must possess excellent technical writing skills. The developer will work closely with a broader team of full-stack solution developers, and so must have excellent communication and collaboration skills.
Skills/Level:
10 years of overall software development experience
5 years of recent and relevant experience as a database designer and developer working on large-scale applications.
Expert knowledge of Microsoft Transact SQL and advanced general SQL to include DDL and DML functions.
Database tuning and optimization experience to include partitioning, indexing, de-normalization etc.
Solid grasp of data structures, object oriented design and systems / applications programming.
Understanding of NoSQL databases and associated fundamentals
Hands-on experience working with Message Queues Ex: RabbitMQ, MicrosoftMQ etc.
Transact SQL / stored procedure optimization skills to include a working knowledge of Query Execution Plans and Execution Statistics
Expert in data modeling approaches (to include star schemas, snowflake schemas, etc.) and related documentation/diagramming techniques
Knowledge of newer database architectures, tools and best practices for Microsoft SQL Server including ORM mapping tools, including but not limited to NoSQL, BigData, Analytics etc.
Significant programming experience in writing complex Stored Procedures, Views, User Defined Functions, Cursors and Common Table Expressions
Experience in creating master and child packages, package configurations, logging and in using variables and expressions in packages.
Experience developing ETL solutions utilizing SSIS / SSRS
Experience with Tableau is a plus.
Familiarity with Agile / Scrum development methodology.
VSTS/Team Foundation Server experience preferred.