SQL Database Administrator II - Azure & On-Prem

Spirit Halloween; Egg Harbor Township (NJ); On-site; USD 80,000 - 95,000; Full time

Benefits offered by this job

Flexible work environment

Career advancement

Bonus opportunity

Vacation, Personal, Sick and Holiday

Medical, Dental, Vision, Disability,  

Life and AD&D insurance

401k with company match

30% merchandise discount

Job summary

Spirit Halloween is seeking a Database Administrator II in New Jersey to manage SQL Server environments across on-premises and Azure platforms. You will ensure reliability, optimize performance, and automate processes while supporting critical business systems.

The role requires 3–5 years of hands-on SQL Server experience, strong scripting ability with PowerShell and T-SQL, and a focus on security and recoverability in a fast-paced retail tech environment.

Qualifications

• Three to five years of hands-on Microsoft SQL Server administration experience.
• Strong knowledge of SQL Server installation, configuration, upgrades, patching, backups, recovery, security, and performance tuning.
• Experience with high availability and disaster recovery technologies such as Always On, failover clustering, log shipping, replication, and backup-based recovery.
• Proficiency with PowerShell, T-SQL, or similar scripting languages to automate administrative tasks, monitoring, reporting, and processes.
• Ability to document procedures, mentor team members, manage competing priorities, and work in a fast-paced environment.

Responsibilities

• Administer, monitor, and maintain SQL Server environments across development, QA, staging, and production in on‑premises and Azure cloud.
• Configure, patch, upgrade, secure, and support database servers with backups and maintenance activities.
• Troubleshoot and resolve issues related to performance, availability, storage, connectivity, failed jobs, and outages; provide root cause analysis.
• Collaborate with development teams to optimize queries, indexing, and schema design for better performance.
• Support high availability and disaster recovery solutions to ensure business continuity.
• Develop and enhance automation and monitoring using PowerShell and T-SQL for reporting and operations.
• Lead DBA initiatives, migrations, upgrades, patching projects, documentation, and 24x7 on-call rotation.

Skills

Strong communication

Collaboration

Mentoring

Education

Bachelor's degree required

Microsoft SQL Server / Azure certifications a plus

Tools

Microsoft SQL Server

Azure

SSIS

SSRS

SQL Agent

PowerShell

T-SQL

Windows Server

Active Directory

Job description

Spirit Halloween is seeking a Database Administrator II in New Jersey to manage SQL Server environments across on-premises and Azure platforms. You will ensure reliability, optimize performance, and automate processes while supporting critical business systems.

The role requires 3–5 years of hands-on SQL Server experience, strong scripting ability with PowerShell and T-SQL, and a focus on security and recoverability in a fast-paced retail tech environment.