Senior SQL Database Administrator

Cincinnati, OH, US • Posted 5 hours ago • Updated 5 hours ago
Contract W2
Contract Corp To Corp
Contract Independent
12 Months
No Travel Required
On-site
$50 - $60/hr
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • Application Development
  • Cloud Computing
  • Data Integration
  • Migration
  • SQL Azure
  • SQL
  • Storage
  • Transact-SQL
  • RDBMS
  • Microsoft SQL Server
  • Extract, Transform, Load
  • Dynamic Management Views
  • Database
  • Database Design
  • Disaster Recovery
  • Collaboration
  • Recovery
  • Stored Procedures

Summary

Title: SQL Server DBA

Location: Cincinnati, OH
Duration: Long-Term

 

Responsibilities

Database Design & Development

    • Design and develop relational database structures, schemas, tables, views, and stored procedures.
    • Create logical and physical data models to support business requirements.
    • Develop and maintain T-SQL code, stored procedures, functions, and triggers.
    • Support application development teams with database design and data access strategies.
    • Review database code and ensure adherence to best practices.

Performance Optimization

    • Analyze SQL Server execution plans to identify performance bottlenecks.
    • Recommend and implement indexing strategies.
    • Troubleshoot slow-running queries and resource-intensive workloads.
    • Utilize SQL Server tools such as Query Store, Extended Events, Dynamic Management Views (DMVs), SQL Profiler, and Performance Monitor.
    • Identify blocking, deadlocks, parameter sniffing, and inefficient query patterns.
    • Work with developers to optimize database interactions and application performance.

SQL Server Platform Support

    • Understand SQL Server architecture, memory management, storage, and server configuration.
    • Collaborate with DBAs and infrastructure teams to support production environments.
    • Assist with database deployments, upgrades, and migrations.
    • Support backup and recovery processes and high-availability solutions.

Required Qualifications

    • 5+ years of SQL Server database development experience.
    • Strong expertise in T-SQL and database design.
    • Experience 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.

Preferred Qualifications

    • 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 preferred.

Technical Skills

    • Microsoft SQL Server
    • T-SQL
    • Query Store
    • Execution Plan Analysis
    • Index Design & Optimization
    • Dynamic Management Views (DMVs)
    • Extended Events
    • SQL Profiler
    • Performance Monitoring
    • Data Modeling
    • Database Design
    • Azure SQL
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: 10124918
  • Position Id: 9008415
  • Posted 5 hours ago
Contact the job poster
GP

Gowtham Pampana

Recruiter @ Evoke Technologies
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Cincinnati, Ohio

Today

Full-time

Remote or California

Today

Full-time

Remote

Today

Easy Apply

Third Party, Contract

Depends on Experience

Remote

Yesterday

Easy Apply

Contract

Depends on Experience

Search all similar jobs