Hudson IT
Hudson IT

Senior Database Developer

West Chester, OH, US • Posted 1 day ago • Updated 10 hours ago
Full Time
On-site
USD $60.00 - 65.00 per hour
Fitment

Dice Job Match Score™

⏳ Almost there, hang tight...

Job Details

Skills

  • Writing
  • Stored Procedures
  • Application Development
  • Code Review
  • Packet Analysis
  • Dynamic Management Views
  • SQL
  • Performance Monitoring
  • Collaboration
  • Migration
  • Backup
  • Recovery
  • Transact-SQL
  • Database Design
  • Statistics
  • Optimization
  • RDBMS
  • Normalization
  • SQL Azure
  • Cloud Computing
  • Database
  • Extract
  • Transform
  • Load
  • Data Integration
  • High Availability
  • Disaster Recovery
  • Microsoft SQL Server
  • Insurance

Summary

About the Role

Seeking a SQL Server Database Developer to design, build, and tune relational database solutions in support of a fast-moving application development environment. You'll own the database design and development side of the house - schemas, stored procedures, and data models - while also digging into execution plans and indexing strategies to keep production workloads running fast and reliable. This role works closely with application developers, DBAs, and infrastructure teams, so you'll need to be just as comfortable writing clean T-SQL as you are explaining why a query plan went sideways.

Location: West Chester Township, OH On-site, | Long Term of Contract

What You'll Do
  • Design databases
  • Design and develop relational database structures, schemas, tables, views, and stored procedures.
  • Build data models: Create logical and physical data models to support business requirements.
  • Write T-SQL: Develop and maintain T-SQL code, stored procedures, functions, and triggers.
  • Support application teams. Partner with application development teams on database design and data access strategies.
  • Review code: review database code and ensure adherence to best practices.
  • Optimize performance: Analyze SQL Server execution plans to identify performance bottlenecks, and recommend and implement indexing strategies.
  • Troubleshoot: Diagnose slow-running queries, resource-intensive workloads, blocking, deadlocks, parameter sniffing, and inefficient query patterns.
  • Use the toolset: Work with Query Store, Extended Events, Dynamic Management Views (DMVs), SQL Profiler, and Performance Monitor to pinpoint and resolve issues.
  • Collaborate on platform support: Work with DBAs and infrastructure teams to support production environments, deployments, upgrades, migrations, backup/recovery, and high-availability solutions.

What You'll Need
  • 5+ years of SQL Server database development experience.
  • Strong expertise in T-SQL and database design.
  • Experience in analyzing execution plans and query performance.
  • Knowledge of indexing strategies, statistics, and SQL Server optimization techniques.
  • Experience with Query Store, DMVs, Extended Events, and SQL Server monitoring tools.
  • Strong understanding of relational database concepts and normalization.
  • Ability to troubleshoot complex data and performance issues.

Bonus Points
  • Experience with SQL Server 2019/2022.
  • Knowledge of Azure SQL and cloud database platforms.
  • Experience with ETL tools and data integration.
  • Understanding of SQL Server high availability and disaster recovery concepts.
  • Microsoft SQL Server certifications.

What You'll Get
  • Competitive base salary
  • Medical, dental & vision coverage
  • Optional life & disability insurance
  • 401(k) with company match
  • Paid vacation time
  • Paid bench time
  • Referral bonus eligibility
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91134517
  • Position Id: 8faedc2ac12de3de57410420eafe0190
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior SQL Database Administrator

Cincinnati, Ohio

•

4d ago

Easy Apply

Contract, Third Party

50 - 60

Senior Database Consultant

Cincinnati, Ohio

•

4d ago

Easy Apply

Contract

Depends on Experience

SQL Server Database Developer

Cincinnati, Ohio

•

4d ago

Easy Apply

Third Party, Contract

65 - 70

SQL Database Developer

South Carolina

•

Today

Easy Apply

Full-time

Search all similar jobs
More jobs at Hudson IT in West Chester, OH