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