What are the responsibilities and job description for the Senior SQL Database Administrator position at Evoke Technologies?
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
Salary : $50 - $60