Sql server developer Jobs in USA

Description

ReaderLink. We Link. Publishers. Books. Retailers. Customers.

We are North America’s largest book distributor, with over 70,000 customer store locations. We move over 325,000,000 books annually and work with over 700 retailers and 500 publishers. If you want to end every day knowing that you helped deliver a book to readers across America, let’s talk. We are recruiting for a SQL Server Developerrole based out of our corporate headquarters in Oak Brook, Illinois.

The SQL Server Developer will develop and support SQL Server database solutions, ETL/ELT processes, and enterprise data warehouse initiatives. This role requires strong SQL development and data integration skills to deliver reliable and scalable data solutions. The position will also assist with SQL Server administration, provide backup DBA support as needed, and have opportunities to work with Databricks and modern cloud data platforms.

What You Will Be Doing:

• 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.
• Create, document, and execute test plans, including white-box testing, black-box testing, positive and negative testing.
• Other duties may be assigned, directed, or requested.

What You Will Need:

• 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.
• 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.
• 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.
• A methodical and organized approach to problem-solving.
• The work performed is in an office environment.
• The noise level in the work environment is usually moderate at low decibels.
• Must be able to work in a fast-paced, team environment.
• Other duties may be assigned, directed, or requested.

Salary: $115,000 - $140,000.

Employee Benefits Include But Are Not Limited To:Health Plans - Medical, Dental & PrescriptionFlexible Spending Accounts -Health & Dependent CareLife and Accident InsuranceVacation Pay & Paid Holidays401(k) with Company MatchAuthor EventsPublisher-sponsored Book Club