SQL Database Administrator - Richardson, TX / Chicago, IL

Ztek Consulting

Chicago, IL, United States

about 1 month ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$111,000.0 - $186,700.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Computer Programming Databases Data Recovery Disaster Recovery Failover Clustering Log Shipping Microsoft SQL Server SQL Azure Windows Servers Performance Tuning Windows PowerShell Query Optimization

+12 more

Release Management Cloud Services Sqlprofiler SQL Databases SQL Server Agent Transact-SQL System Availability Database Migration Amazon Relational Database Service Database Mirroring SQL Server Management Studio (SSMS) Database Backup

Job description

Install, configure, upgrade, and patch SQL Server instances.
Manage database backup, restore, and disaster recovery processes.
Configure and support High Availability (HA) and Disaster Recovery (DR) solutions such as:
Always On Availability Groups
Log Shipping
Replication
Database Mirroring
Failover Clustering
DAG
Transparent Data Encryption
Monitor database health, performance, and availability.
Troubleshoot performance issues, blocking, deadlocks, and replication failures.
Perform query tuning, index optimization, and database maintenance activities.
Manage security, including logins, users, roles, permissions, encryption, and compliance requirements.
Monitor SQL Agent Jobs, Alerts, Maintenance Plans, and backups.
Conduct capacity planning for CPU, memory, storage, and database growth.
Support database migrations, upgrades, and cloud deployments (Azure SQL/AWS RDS).
Create automation scripts using T-SQL and PowerShell.
Work with application teams during releases, deployments, and production incidents.
Provide 24x7 production support and participate in on-call rotations as needed.

Requirements

Microsoft SQL Server 2016/2019/2022 Administration
T-SQL Programming
Performance Tuning & Troubleshooting
Backup & Recovery
Always On, Replication, Mirroring, Log Shipping, DAG & TDE
SSMS, SQL Profiler, DMV Analysis
Windows Server Administration
Azure SQL Database / Managed Instance (preferred)Incident, Change, and Release Management (ITIL)