T-SQL Developer: Performance & DB Design

Client Resources, Inc.; La Vista (NE); On-site; USD 85,000 - 115,000; Full time

Job summary

Client Resources, Inc. seeks an experienced T-SQL Developer to support and enhance custom applications while developing new database solutions. The role focuses on complex SQL development, troubleshooting, performance optimization, and solid database design.

Responsibilities include designing database structures, writing and tuning T-SQL, supporting existing solutions, and ensuring performance, security, and availability. Collaboration with cross-functional teams is essential.

Qualifications

• 3+ years of SQL Server development experience.
• Strong hands-on experience with T-SQL, including stored procedures, functions, and triggers.
• Experience with database design, data modeling, and normalization.
• Strong SQL query development and performance-tuning skills.
• Experience with SQL Server tools such as SSMS, Profiler, and DTA.
• Ability to design and implement database schemas.
• Understanding of data security and privacy principles.
• Strong troubleshooting, communication, and collaboration skills.
• Bachelor’s degree in Computer Science, Information Systems, or a related field preferred.

Responsibilities

• Design and develop database structures, including tables, indexes, views, functions, and stored procedures.
• Write, maintain, and optimize complex T-SQL queries, stored procedures, functions, and triggers.
• Troubleshoot and support existing custom applications and database solutions.
• Monitor and improve database performance, reliability, security, and availability.
• Support data extraction, transformation, and loading activities.
• Analyze existing SQL queries and database processes to identify performance improvements.
• Collaborate with product owners, business analysts, database teams, and developers to deliver solutions.
• Create technical documentation for database design, development, and testing.
• Identify database issues and provide timely solutions.

Skills

T-SQL

SQL Server development

Performance tuning

Database design

Data modeling

Normalization

Troubleshooting

Security principles

Education

Bachelor's degree in Computer Science / Information Systems

Tools

SSMS

Profiler

DTA

Job description

Client Resources, Inc. seeks an experienced T-SQL Developer to support and enhance custom applications while developing new database solutions. The role focuses on complex SQL development, troubleshooting, performance optimization, and solid database design.

Responsibilities include designing database structures, writing and tuning T-SQL, supporting existing solutions, and ensuring performance, security, and availability. Collaboration with cross-functional teams is essential.