About the Job

We are seeking a dedicated MS SQL developer to join our engineering team in a Full-time, OnSite capacity. The ideal candidate will design, develop, and maintain robust database solutions using MS SQL Server, ensuring high performance, data integrity, and scalability for critical business applications. This role involves close collaboration with application developers, business analysts, and operations to translate requirements into efficient database designs, implement stored procedures, optimize queries, and establish reliable backup and recovery practices. If you take pride in delivering clean, maintainable SQL code and enjoy diagnosing and resolving complex data issues, you’ll thrive in this position.

Roles & Responsibilities

• Design, implement, and maintain database schemas, tables, and relationships using MS SQL Server.
• Write, review, and optimize complex T-SQL queries, stored procedures, functions, and triggers for high-performance applications.
• Perform regular performance tuning and query optimization to reduce execution time and resource usage.
• Implement and manage backup, restore, and disaster recovery strategies to ensure data availability and integrity.
• Collaborate with developers and product owners to translate business requirements into scalable database solutions and ETL processes.
• Monitor database health and proactively address issues related to locking, blocking, and long-running transactions.
• Conduct code reviews and enforce best practices for naming, indexing, and query structure to maintain code quality.
• Create and maintain documentation for database designs, procedures, deployment steps, and maintenance tasks.
• Participate in release planning, deployment activities, and post-deployment validation to ensure smooth rollouts.
• Troubleshoot production incidents and perform root cause analysis, implementing fixes and preventive measures.

Required Skills & Qualifications

• Proven experience as an MS SQL developer working with MS SQL Server in production environments.
• Strong proficiency in T-SQL, stored procedures, views, functions, and triggers.
• Deep understanding of indexing, query plans, and techniques for query optimization.
• Experience with backup/restore, recovery models, and database maintenance plans.
• Familiarity with performance monitoring tools, execution plans, and diagnosing locking/blocking issues.
• Good knowledge of data modeling, normalization, and schema design best practices.
• Ability to work collaboratively in an OnSite team environment and communicate technical concepts clearly.
• Strong problem-solving skills, attention to detail, and commitment to writing maintainable, testable SQL code.