Microsoft SQL Server Developer

Kforce - Weston, FL

Full-time - Mid Level

Weston, FL

Administrative and Support Services

About the position

The Microsoft SQL Server Developer role at Kforce Inc involves constructing, updating, and overseeing SQL Server databases to support application functionality. The position requires advanced T-SQL skills for data manipulation and query optimization, as well as collaboration with developers to ensure seamless database integration. The developer will also be responsible for translating business requirements into database structures, resolving performance issues, and maintaining documentation for database design and functionality.

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 closely with fellow developers to ensure seamless integration of databases with applications.
• Translate business requirements into tangible database structures, working with cross-functional teams.
• Proactively identify and resolve database performance issues, employing skills in query tuning and optimization.
• Develop comprehensive documentation outlining database design, data dictionaries, and essential functional elements.
• Utilize SSIS to facilitate efficient data movement, transformation, and integration across diverse data stores.
• Harness SSRS to design, maintain, and evolve insightful reports that provide a clear view of critical business data.
• Stay updated on the latest advancements in SQL Server tools and methodologies.
• Participate in code reviews, offering valuable insights to enhance code quality and efficiency.
• Strategically plan database structures that accommodate growth and scalability.

Requirements

• Minimum 3 years of experience working as a MS SQL Developer.
• Proficiency in SQL Server, including mastery of advanced T-SQL scripting.
• Familiarity with dynamic queries and adaptable data retrieval processes.
• Experience in employing linked servers to access data across different environments.
• Proven track record in query optimization and index optimization techniques.
• Experience with SSIS for efficient data movement and transformation solutions.
• Proficiency in using SSRS to design impactful reports.
• Understanding of database security measures to ensure data integrity.
• Strong problem-solving skills and meticulous attention to detail.
• Collaborative team player, capable of multitasking in a fast-paced environment.

Benefits

• Medical, dental, and vision insurance
• Health Savings Account (HSA)
• Flexible Spending Account (FSA)
• 401(k) plan
• Life insurance
• Disability insurance
• Paid time off for salaried personnel
• Paid sick leave for hourly employees on Service Contract Act projects