Lead SQL Server DBA

MATRIX

United States

about 1 month ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

C Sharp (Programming Language) Cluster Analysis Databases System Configuration Database Design Database Development Database Security Microsoft SQL Server Performance Tuning Windows PowerShell Query Optimization Software Engineering

+7 more

SQL Databases Transact-SQL Enterprise Data Management System Availability Database Optimization Database Mirroring SQL Server Management Studio (SSMS)

Job description

Partners with business analysts, database analysts, application development teams, and infrastructure teams to support the effective storage, security, and retrieval of enterprise data.
Demonstrates advanced knowledge of SQL Server architecture and a strong understanding of how applications transform data into business information.
Leads the implementation, administration, and maintenance of production and development database environments.
Investigates complex database issues, monitors system performance, oversees backup and recovery processes, and ensures high availability of SQL Server environments.
Provides technical leadership and guidance to development teams on database design, standards, and best practices.
Acts as the primary escalation point for database-related incidents and performance challenges.

Requirements

SQL Server Administration - Expert
SQL Server Performance Tuning - Advanced
High Availability & Disaster Recovery (HA/DR) - Advanced

Additional Skills;

SQL Language (T-SQL) - Advanced
SQL Programming - Advanced
PowerShell Scripting - Intermediate
Database Security & Maintenance - Advanced
Database Design & Data Modeling - Intermediate/Advanced, * Lead SQL Server DBA with strong experience in SQL Administration and SQL Development using complex T-SQL.
Extensive experience configuring, supporting, and troubleshooting Always on Availability Groups, SQL Clustering, and Database Mirroring.
Advanced experience with database performance tuning, query optimization, and troubleshooting server-related issues.
Strong knowledge of database security, monitoring, maintenance, backup, and recovery strategies.
Experience automating administrative tasks using PowerShell; C# experience is a plus.
Experience leading database upgrades, migrations, and implementation of database best practices.
Microsoft SQL Server certifications or equivalent credentials preferred.