Job Title: SQL Database Developer
Location: St. Paul, MN
Duration: 10+ months (Possible extension)
Seeking an experienced SQL Database Developer for Microsoft SQL Server to support recent efforts to address the technology obsolescence within the majority of the modules on Client’s system to better align the modules with current business, security, accessibility and legal requirements. Client desires their system modernization in a manner that results in a more secure, flexible, accessible and long- lived system. Business enhancements will also improve usability, align the system to current business practices, and make the system less expensive to maintain and support.
Must Have Skills
5 years’ experience as a SQL Developer (SQL Server).
4 years’ experience of Relational Database Data Modeling.
4 years’ experience of SQL Server Security and Permissions Configuration.
4 years’ experience of SSIS development and deployment.
4 years’ experience of SQL Server Query Performance Tuning.
Desired Skills
Experience in creating and maintaining complex T-SQL Queries, Tables, Views, Stored Procedures, Functions, Triggers and other SQL Objects.
Experience in Data Architecture.
Experience in Database Design.
Collaborative software development team experience up to at least 4-5 team members with separation between database development and application development teams.
Experience and continuous education in secure database development such as:
Participating in security trainings offered by various entities (e.g. OWASP, etc.) focusing on current secure database development best practices.
Participating in formal database security reviews.
Project Deliverables
The SQL database developer will:
Apply advanced SQL database development experience and skill for Microsoft SQL Server.
Provide technical leadership to team members. Work independently with minimal guidance while also participating on project teams.
Prepare and participate in release readiness for database development deployments to the TEST and PROD environments.
Prepare and participate in continuous process improvement efforts.
Provide clear, concise and honest communication.
Other database development, as needed. Provide knowledge transfer to Client and Staff
Project Environment
Each of the system modules will be executed as a sub-project under the overall Modernization project.
Each sub-project will have a team consisting of a PM, BA(s), Application and Database Developer(s), and QA(s) resources consisting of both internal resources and consultants. The size of the team depends on the complexity and size of the rewrite effort for each systems module.
Microsoft technologies will be used such as SQL Server (2008, 2012, 2014), T-SQL, SSIS, Team Foundation Server (TFS).