Job Description :
SQL Server Developer

Location: Sacramento, CA

Duration: 6+Months

Rate: Market

Mandatory Passport Number For Submission Of Profile

Position Is:

· database engineer consisting of database design and development

· SQL – TransAct which is Microsoft’s version

· Stored procedures

· Database optimization

· Position is NOT:

o Database administration

o Creating

o Server administration

· Understanding:

o Current SIS environment of Agile/SCRUM approach

· Needed Skills

o Openness

o Flexibility

o Collaborative

o Partnership

o Good attitude

o Adaptability

Start Date: ASAP



Position Description:

The senior database developer’s 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.





Essential Functions & Summary of Responsibilities:

· Work with development leads, staff and business users to perform analysis of specifications and design, and implement robust, maintainable database 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 Transact SQL stored procedures.

· Create SSIS packages to import/export data, and load and process data.

· Maintain a current awareness of technological developments and trends as it relates to databases, development methodologies and tools.

· Prepare design documents and technical specifications explaining and motivating the approaches to be taken in the deployment of solutions.

· 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.

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.


.
             

Similar Jobs you may be interested in ..