Job Description :
Job Title: Database Development Lead/Architect
Location: Sacramento, CA
Duration: 6-12 months


Essential Functions & Summary of Responsibilities:
Work with other development leads, staff and business users to perform analysis of specifications and design, and implement robust, maintainable software solutions that meet the business requirements.
Participate in reviews and quality assurance processes to ensure that the data architectures and standards are being adhered to. Adhere to development team coding standards, policies and procedures.
Create and maintain conceptual, logical, and physical database models.
Develop and enhance stored procedures. Write ad-hoc SQL queries to support report requests.
Create SSIS packages to import/export data, and load and process data.
Design and develop meaningful business reports (BI), either web based or thick client.
Prepare data for job runs. Support jobs in process. Troubleshoot, analyze and repair job issues.
Maintain a current awareness of technological developments and trends as it relates to databases, development methodologies and tools.
Prepare design documents and technical specs explaining and motivating the approaches to be taken in the deployment of systems.
Document and share knowledge with larger development and architecture team.
Work in a team environment.
Clearly communicate problem/resolution process to project management in an Agile setting.
Perform other duties as assigned.

Skills/Level:
7+ (Sr. SWE) years of overall IT/software development experience
5+ (Sr. SWE) years of recent and relevant experience as an SQL Server developer or software engineer working on large-scale applications.
Strong knowledge of Transact/MS SQL and Advanced SQL querying techniques including Windowing Functions.
Must possess knowledge of how to tune and optimize SQL Server database and solutions including partitioning, indexing, de-normalization etc.
1+ years of experience in development of Elastic search applications.
Good knowledge and understanding of data structures, object oriented design and systems / applications programming.
A good understanding of NoSQL databases and fundamentals, including data storage, data modeling, and data access patterns.
Hands on experience working with Message Queues Ex: RabbitMQ, MicrosoftMQ etc.
Need to have working knowledge of Query Execution Plan and Execution Statistics
Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.
Excellent understanding of Entity-Relationship/Multidimensional Data Modeling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server Analysis Services (SSAS
Knowledge of newer database architectures, tools and best practices for SQL Server including ORM mapping tools, including but not limited to NoSQL, BigData, Analytics etc.
Excellent programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using MS/T-SQL, in terms of readability, consistency, adherence to standards, and performance, reuse, and ensures that the code is designed and implemented accordingly.
Experience in creating master and child packages, package configurations, logging and in using variables and expressions in packages.
Experience in a BI/Data Warehouse environment with involvement in design and architecture
Experience developing ETL solutions, Server 2012, utilizing SSIS / SSRS including Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
Experience with Tableau a plus.
Worked with tabular reports, matrix reports, parameterized reports according to business requirements in time restricted environment using SQL server reporting services (SSRS
Familiarity with SCRUM / Agile development methods.
Ability to work within tight deadlines and effectively prioritize and execute tasks in a high-pressure environment.
Highly committed, motivated and a natural team player with strong analytical ability.
Experience working with offsite teams preferred.
Experience writing technical specifications for work to be performed by other developers.
Development experience in Transact SQL / C# with good software methodology/practices.
VSTS/Team Foundation Server experience preferred.
Informatica experience helpful but not required.

Education Requirements:
Bachelor’s Degree in Computer Science or a related field is preferred or equivalent combination of education, training and experience