SQL Developer

Acestack; Charlotte (NC); On-site; USD 95,000 - 130,000; Full time

Job summary

Acestack in Charlotte, NC is seeking an experienced SQL Developer to design, implement, and optimize database solutions. You will work on complex SQL queries, stored procedures, and data modeling to support BI and analytics initiatives.

The role requires 5+ years in SQL development, hands-on experience with SQL Server, ETL processes, and collaboration with cross-functional teams. Knowledge of SSIS/SSRS/Power BI is a plus; cloud platforms like Azure SQL or AWS RDS are advantageous.

Qualifications

• 5+ years as an SQL Developer or Database Developer.
• Strong expertise in SQL Server, T-SQL, Stored Procedures, Functions, Triggers, and Views.
• Experience writing complex SQL queries and optimizing query performance.
• Knowledge of database design, normalization, indexing, and data modeling.
• Experience with ETL processes and data integration.
• Hands-on with SSIS, SSRS, or Power BI is a plus.
• Familiarity with database security, backup, recovery, and performance tuning.
• Experience working in Agile/Scrum environments.

Responsibilities

• Design, develop, and maintain SQL databases and objects.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and triggers.
• Analyze and improve database performance through indexing and query optimization.
• Support ETL processes and ensure data integrity across systems.
• Collaborate with developers, business analysts, and stakeholders on data requirements.
• Create and maintain database documentation, data dictionaries, and specs.
• Perform maintenance, monitoring, backup, and recovery activities.
• Troubleshoot production issues and provide timely resolutions.
• Ensure compliance with database security and best practices.

Skills

5+ years experience

SQL Server

T-SQL

Stored Procedures

Functions

Triggers

Views

Query optimization

ETL

SSIS

SSRS

Power BI

Database design

Data modeling

Agile/Scrum

Backup & recovery

Database security

Azure SQL Database

AWS RDS

Education

Bachelor's degree in Computer Science/IT or related field

Tools

Azure SQL Database

AWS RDS

Job description

Job Title: SQL Developer

Location: Charlotte, NC

Full Time

Job Description

Must-Have Technical Skills:

• 5+ years of experience as an SQL Developer or Database Developer.
• Strong expertise in SQL Server, T-SQL, Stored Procedures, Functions, Triggers, and Views.
• Experience writing complex SQL queries and optimizing query performance.
• Knowledge of database design, normalization, indexing, and data modeling.
• Experience with ETL processes and data integration.
• Hands-on experience with SSIS, SSRS, or Power BI is a plus.
• Familiarity with database security, backup, recovery, and performance tuning.
• Experience working in Agile/Scrum environments.

Roles & Responsibilities:

• Design, develop, and maintain SQL databases and database objects.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, functions, and triggers.
• Analyze and improve database performance through query optimization and indexing.
• Support ETL processes and ensure data integrity across multiple systems.
• Collaborate with application developers, business analysts, and stakeholders to understand data requirements.
• Create and maintain database documentation, data dictionaries, and technical specifications.
• Perform database maintenance, monitoring, backup, and recovery activities.
• Troubleshoot production issues and provide timely resolutions.
• Ensure compliance with database security and best practices.

Preferred Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Microsoft SQL Server certifications are a plus.
• Experience with Azure SQL Database, AWS RDS, or other cloud database platforms is an advantage.