SQL Server Database Administrator

Isoftech Inc

Los Angeles, United States

11 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Cloud Computing Data Recovery Data Retrieval Disaster Recovery Failover Clustering Microsoft SQL Server SQL Azure Windows Servers Performance Tuning Windows PowerShell Transact-SQL System Availability

+3 more

HybridCloud Information Technology Performance Monitor

Job description

Database Management: Install, configure, and maintain MS SQL Server instances across development, test, and production environments.
High Availability (HA) & Disaster Recovery (DR): Deploy and monitor SQL Server Always On Availability Groups and failover clustering to ensure 24/7 uptime for rail operations.
Performance Tuning: Troubleshoot blocking, deadlocks, and slow-running T-SQL queries to optimize data retrieval speeds.
Backup & Recovery: Implement robust backup strategies and run regular recovery and restore drills to meet strict RPO (Recovery Point Objective) and RTO (Recovery Time Objective) targets.
Security & Compliance: Enforce user access controls, role-based security, and data encryption standards.
Automation: Write PowerShell or T-SQL scripts to automate routine maintenance tasks and alerts.

Requirements

Experience: 5 to 8+ years of hands-on MS SQL Server DBA experience in a large enterprise or public sector environment.
Cloud Knowledge: Familiarity with Azure SQL Database or hybrid cloud infrastructure.
Core Skills: Advanced T-SQL, Index tuning, performance monitoring tools, and Windows Server administration.
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.