SQL Server Developer

Readerlink Distribution Services•Oak Brook, IL

6d•$115,000 - $140,000•Onsite

About The Position

ReaderLink is North America’s largest book distributor and is seeking a SQL Server Developer for its corporate headquarters in Oak Brook, Illinois. The role involves developing and supporting SQL Server database solutions, ETL/ELT processes, and enterprise data warehouse initiatives. The ideal candidate will possess strong SQL development and data integration skills to deliver reliable and scalable data solutions. The position will also provide backup DBA support, with opportunities to work with Databricks and modern cloud data platforms.

Requirements

Bachelor's degree (Information Technology, Computer Science, or related field) or equivalent experience is required.
Five (5) to eight (8) years of MS SQL Server development experience is required.
Strong T-SQL programming experience, including complex queries, joins, views, stored procedures, functions, and query optimization are required.
Strong experience developing and supporting ETL/ELT processes and enterprise data integrations is required.
Experience with data ingestion, incremental loading, data validation, and data quality processes is required.
Experience with enterprise data warehousing and dimensional modeling is required.
Ability to independently analyze, troubleshoot, and resolve SQL, ETL, data, and production-related issues is required.
Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required.
Excellent analytical, critical-thinking, and problem-solving skills, with the ability to anticipate and proactively address issues.
Ability to effectively present technical concepts and information to non-technical audiences.
Strong verbal and written communication and organizational skills are essential.
Must have excellent communication skills, both written and verbal.
Ability to speak with all levels of the organization and outside partners.
Ability to communicate complicated information to others.
Ability to prepare concise yet sufficiently detailed written communications, including documentation, deployment plans, status reports, and meeting notes, for both technical and non-technical audiences.
Must be proficient in basic mathematics: addition, subtraction, multiplication, and division.
Ability to do algebra, calculate figures and amounts, and apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.
A methodical and organized approach to problem-solving.

Nice To Haves

Experience with SQL Server performance tuning, indexes, index management, and optimization is preferred.
Experience with Databricks, Spark SQL, Delta Lake, and modern cloud data platforms is preferred.
Experience with PowerShell scripting and automation is preferred.
Experience with SQL Server administration, security, backup/recovery, and maintenance is preferred.
Experience with MS Azure is preferred.

Responsibilities

Develop, maintain, and optimize SQL Server stored procedures, views, functions, and advanced T-SQL solutions.
Design, develop, and support ETL/ELT processes for enterprise data integration and transformation.
Build and maintain data ingestion, incremental load, reconciliation, data validation, and data quality processes.
Independently analyze, solve, and correct data, ETL, and database-related issues, providing end-to-end problem resolution.
Maintain database objects, schema changes, and scripts using version control systems such as Azure DevOps.
Follow established team standards. For any gap, recommend new or updated standards and proactively identify areas for improvement.
Document and update technical documentation, operational procedures, and support runbooks when appropriate.
Take ownership, support, and follow-through of assigned deliverables, adjusting well to changes in priority.
Demonstrate a willingness and commitment to learn.
Develop accurate estimates of effort and timelines.
Ensure that all assignments are completed accurately and within approved delivery schedules.
Support enterprise data warehouse development, including dimensional modeling, reporting solutions, and data integration initiatives.
Assist with query tuning, performance optimization, and schema refinement.
Support Databricks data engineering initiatives, including data pipeline development, testing, and deployment activities.
Assist with SQL Server database administration activities, including monitoring, maintenance, security, backup verification, and troubleshooting.
Serve as a backup resource for database administration support during planned absences, vacations, and off-hours support rotations.
Work closely and effectively with business and technical teams in a cross-functional and cross-matrixed business and technical environment.
Support release deployment activities, testing, and production implementations as required.
Other duties may be assigned, directed, or requested.