SQL Server Development Engineer

ZON Multimédia is seeking a SQL Server Developer to focus on T-SQL development, production support, and performance optimization. This role involves managing database performance and supporting a mission-critical healthcare application.

Responsibilities:

• Act as the primary point of contact for our hosting provider
• Investigate and respond to tickets regarding high CPU, RAM contention, and disk space alerts
• Perform standard DBA tasks, including restoring backups for development or troubleshooting, monitoring log shipping status, and ensuring the health of all SQL Agent jobs
• Monitor disk space usage and track fast-growing or exceptionally large tables to prevent storage-related outages
• Manage Windows Task Scheduler and troubleshoot file or folder permission issues within the Windows Server 2025 environment
• Maintain and run PowerShell scripts for automation, specifically utilizing dbaTools and SQLServerDsc
• Monitor Jenkins console log output to identify and resolve environment-specific build failures

Requirements:

• 5+ years of hands-on SQL development preferably with two or more companies/departments
• Proficiency in writing and debugging complex stored procedures, managing transactions, rollbacks, and deadlocks
• Experience with Git/GitHub is highly desired
• Experience using SQL Profiler and analyzing execution plans to tune complex queries
• Familiarity with tSQLt or Test-Driven Development (TDD) is a significant advantage
• Experience installing and configuring SQL Server on a local machine for development and troubleshooting
• Exceptional written communication skills in American English are required for Jira tickets, Slack/Google Chat, and code documentation
• Must be available for daily 9:00 AM ET team meeting
• You must adhere to HIPAA regulations
• Experience with dbaTools and SQLServerDsc
• Experience monitoring Jenkins console log output to identify and resolve environment-specific build failures