JOBSEARCHER

SQL Developer

Hiring: Senior SQL Developer
Location: Irvine, CA (On-site)
Required Technical Skills: Microsoft SQL Server & T-SQL: 5+ years of hands-on experience in SQL Server development, advanced T-SQL programming, and complex query optimization. Advanced SQL Development: Strong expertise in set-based T-SQL, window functions (ROW_NUMBER, RANK, DENSE_RANK), Common Table Expressions (CTEs), data deduplication, latest-record-per-key logic, and conditional aggregation. Candidates must be comfortable completing a hands-on SQL coding exercise. SQL Server Agent: Experience building, scheduling, monitoring, and troubleshooting SQL Server Agent jobs and job chains in production environments. SQL Server Integration Services (SSIS): Hands-on experience developing, maintaining, debugging, and troubleshooting SSIS packages, including failures in deployed production packages. Azure Databricks: Mandatory hands-on experience with Databricks notebooks, jobs, workflows, Spark SQL and/or PySpark, and Delta Lake. MuleSoft API Integration: Experience developing and maintaining MuleSoft integrations, including Mule flows, DataWeave transformations, error handling, deployment, and production monitoring. AI-Assisted Development: Practical experience using AI-powered coding tools such as Claude Code, Databricks Genie, OpenRouter, or Cursor to develop, refactor, debug, and document code. Candidates must demonstrate the ability to review, test, and validate AI-generated code before deploying it to production. SQL Performance Tuning: Expertise in execution plan analysis, index design, statistics maintenance, query optimization, and troubleshooting performance regressions in production. Production Support: Experience managing production incidents, troubleshooting technical issues, meeting service-level expectations, and communicating incident status and resolution clearly. Communication Skills: Strong written and verbal English communication skills, with the ability to explain technical issues, root causes, and business impacts to non-technical stakeholders.
Key Expectations: Demonstrate strong hands-on SQL development and problem-solving skills. Work effectively with existing codebases and troubleshoot complex data integration issues. Use AI-assisted development tools responsibly to improve engineering productivity. Maintain reliable data processing workflows and production integrations. Communicate technical findings clearly to business stakeholders.
Note: Azure Databricks and hands-on MuleSoft development experience are firm requirements, not optional skills. Apply: Himavanth@suntekcorporations.com