We are seeking a highly skilled SQL Server Developer with advanced T-SQL expertise, a strong background in performance optimization, and a knack for creating efficient process automation solutions. This role is pivotal in ensuring our SQL Server environment operates at peak efficiency, delivering reliable automation and maintaining high data integrity.
Key Responsibilities:

    Performance Optimization:
        Review and refactor existing T-SQL procedures to enhance performance and efficiency.
        Refactor complex query logic using set-based approaches to improve processing speed and resource utilization.

    Process Automation:
        Design and implement automated processes using SQL Server Agent, ensuring reliability and minimal overhead.
        Create and maintain stored procedures, functions, and scripts to automate daily tasks.

    Notification Management:
        Configure and manage Database Mail for automated notifications of critical tasks.
        Ensure reliable notifications for failures, delays, and other issues in scheduled processes.

    Job Scheduling and Monitoring:
        Manage and monitor SQL Server Agent Jobs, ensuring minimal failures and downtime.
        Troubleshoot and resolve issues promptly to maintain system reliability.

    Performance Tuning:
        Diagnose and resolve performance bottlenecks using indexing strategies, execution plans, and advanced query optimization techniques.
        Replace cursor-based solutions with efficient alternatives.

Required Expertise:

    T-SQL Mastery:
        Proficient in advanced T-SQL development, with a strong focus on writing efficient and optimized queries.
        Experienced in automating processes using stored procedures and functions.