MS SQL Developer

Market, Inc.
Lorena, United States of America
18 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Shift work
Languages
English
Experience level
Intermediate
Compensation
$ 60K

Job location

Remote
Lorena, United States of America

Tech stack

Microsoft Windows
Big Data
Databases
Database Design
Microsoft SQL Server
Performance Tuning
Query Optimization
SQL Stored Procedures
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
Technical Data Management Systems
T-SQL
Web Applications
Enterprise Software Applications
Database Optimization
Information Technology

Job description

We are seeking an experienced SQL Database Developer to design, optimize, and support high-performance Microsoft SQL Server environments that power critical enterprise applications for a six months contract. This role is ideal for someone with deep expertise in SQL Server architecture, query optimization and indexing strategies. You'll work closely with development, infrastructure, and operations teams to ensure reliable and scalable database platforms.

Responsibilities

Design and optimize complex T-SQL queries, stored procedures, indexes, and database objects

Analyze execution plans and troubleshoot performance bottlenecks

Develop and maintain indexing strategies for high-volume transactional workloads

Resolve issues related to CPU, memory, I/O, blocking, deadlocks, and storage latency

Partner with engineering teams on schema design, query patterns, and database best practices

Investigate production incidents, identify root causes, and implement preventative improvements

Work with a team to design and develop databases, stored procedures, and other SQL Server Database objects to support web applications

Design, develop, and implement SQL Server databases based on business requirements with direction from Senior Manager

Create and maintain comprehensive documentation for database designs, queries, and procedures

Work closely with other developers, analysts, and stakeholders to understand data requirements and deliver effective solutions

All other duties as assigned

Requirements

Do you have experience in Windows?, Perspective applicants must be a US citizen or a legal resident of the US with authorization to work in the US and must reside in the US

Ability to work on a team; be a team player with a good attitude with limited supervision

Excellent verbal and written communication skills

Excellent listening skills and the ability to interpret technical data and system alerts accurately

Ability to collaborate effectively with both technical and non-technical teams

Willingness and ability to work non-traditional hours including nights and weekends

Teleworkers must be reachable while teleworking during the employee's regularly scheduled hours. Methods of communication include emai, voice calls, and other appropriate department tools and equipment. It is expected that teleworkers will attend all virtual scheduled meetings with their cameras on as much as possible. Additionally, any calls and/or voicemails will be answered in a timely manner. Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Technical Expertise:

Strong skills in SQL database maintenance, query optimization, and SSRS.

Demonstrated ability to design, implement, and support enterprise software solutions

Strong proficiency of Microsoft SQL Server, with the ability to write complex T-SQL queries, indexing strategies, experience with SSIS and perform performance tuning for large databases

Excellent analytical and problem-solving skills with the ability to troubleshoot complex database issues

Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience)

5+ years of hands-on experience with Microsoft SQL Server environments

Pay: $55,000.00 - $60,000.00 per year

Experience:

  • Server and Desktop Maintenance: 2 years (Required)
  • Windows: 2 years (Required)

Apply for this position