Microsoft SQL Server Developer

$100,000 - $120,000/Yr

Kforce - Weston, FL

Full-time - Mid Level

Weston, FL

Administrative and Support Services

About the position

The Microsoft SQL Server Developer role at Kforce is a contract-to-hire position focused on constructing, updating, and overseeing SQL Server databases. The developer will work closely with cross-functional teams to translate business requirements into effective database structures, ensuring optimal performance and integration with applications. This position requires advanced T-SQL skills and experience with SSIS and SSRS for data movement and reporting.

Responsibilities

• Construct, update, and oversee SQL Server databases, including the creation of tables, views, and stored procedures.
• Showcase advanced T-SQL skills by formulating intricate queries that retrieve and manipulate data.
• Enhance query performance using techniques such as indexing, query plan analysis, and query rewriting.
• Collaborate with developers to ensure seamless integration of databases with applications using linked servers.
• Translate business requirements into tangible database structures in collaboration with cross-functional teams.
• Proactively identify and resolve database performance issues through query tuning and optimization.
• Develop comprehensive documentation outlining database design, data dictionaries, and functional elements.
• Utilize SSIS for efficient data movement, transformation, and integration across data stores.
• Design, maintain, and evolve insightful reports using SSRS to provide a clear view of critical business data.
• Stay updated on SQL Server tools and methodologies, applying best practices to maintain robust database systems.
• Participate in code reviews to enhance code quality and efficiency.
• Strategically plan database structures for growth and scalability.

Requirements

• Minimum 3 years of experience as a MS SQL Developer.
• Proficiency in SQL Server with mastery of advanced T-SQL scripting and understanding of window functions, grouping, and aggregate functions.
• Familiarity with dynamic queries and building adaptable data retrieval processes.
• Experience with linked servers for accessing data across different environments.
• Proven track record in query optimization, including query plan analysis and index optimization.
• Experience with SSIS for creating efficient data movement and transformation solutions.
• Proficiency in using SSRS to design impactful reports.
• Understanding of database security measures to ensure data integrity and protection.
• Strong problem-solving skills and attention to detail for diagnosing complex issues.
• Collaborative team player capable of multitasking in a fast-paced environment.

Benefits

• Health savings account
• AD&D insurance
• Health insurance
• Dental insurance
• 401(k)
• Flexible spending account
• Paid time off
• Vision insurance
• Paid sick time