SQL Developer - System Integrator

A fast-growing technology services provider is seeking a skilled SQL Developer to join its expanding data team. This role is ideal for someone with a strong background in database development, performance tuning, and complex query design especially in business-critical environments. If you're passionate about turning data into actionable insights and thrive in a collaborative, tech-forward team, apply now to take the next step in your SQL career. Key Responsibilities: SQL Server Management & Optimization: Maintain and optimize 160+ SQL Server instances, ensuring high performance and reliability. Manage several SQL Server clusters, ensuring they are properly configured, scalable, and high availability. Perform database performance tuning, query optimization, and index management to ensure optimal performance across all instances. Design, implement, and monitor backups, disaster recovery, and high availability solutions. ETL Development & SSIS: Develop, deploy, and maintain complex SSIS packages for ETL processes to ensure data is efficiently integrated from various sources into SQL Server databases. Troubleshoot and optimize SSIS packages to improve performance and reduce processing time. Ensure SSIS processes are executed on schedule and meet operational requirements. Troubleshooting & Support: Provide troubleshooting and root-cause analysis for performance issues, SQL errors, and system outages in SQL databases and applications. Analyze and resolve issues with interconnected applications and APIs that interact with the SQL Server databases. Work with stakeholders across teams to investigate and resolve system performance and data integrity issues. API and Interconnected Systems Management: Troubleshoot and resolve issues related to API integration with SQL databases and other internal systems. Collaborate with development teams to ensure seamless communication between SQL databases and interconnected applications. Ensure APIs are performant and are correctly integrated with the backend SQL architecture. Collaboration & Documentation: Work closely with cross-functional teams, including software development, network administration, and business analysts, to design and implement solutions. Provide mentorship and guidance to junior SQL developers, sharing best practices for development, troubleshooting, and system optimization. Maintain clear and thorough documentation of SQL server configurations, procedures, and troubleshooting steps. Rental Man (WYNNE) Integration: DB2 on the backend, SQL systems integrate with it via OPENQUERY and SSIS. Develop and maintain integrations between SQL Server and Rental Man (WYNNE), ensuring seamless data exchange and system reliability. Troubleshoot and resolve issues specific to the Rental Man system and its SQL database integrations. Skills/Must have: Experience: 5+ years of experience in SQL Server development and administration, including working with SQL Server instances, clusters, and performance tuning. Hands-on experience with SSIS for building ETL processes and integration workflows. Extensive experience troubleshooting and triaging issues across SQL databases, APIs, and interconnected applications. Knowledge of Rental Man (WYNND) or similar rental management systems is highly preferred. Technical Skills: Strong proficiency in T-SQL for querying, stored procedures, triggers, and script development. Familiarity with SQL Server Clustering and high availability solutions (Always On Availability Groups, Failover Clustering, etc.). Expertise in API integration with backend SQL databases. Strong knowledge of performance tuning, indexing strategies, and query optimization. Proficiency in PowerShell or other scripting languages for automation and administrative tasks. Experience with database security best practices (e.g., encryption, user access control). Soft Skills: Excellent troubleshooting and problem-solving skills. Strong communication skills, both verbal and written, with the ability to explain technical concepts to non-technical stakeholders. Ability to manage multiple priorities in a fast-paced environment. Strong attention to detail and commitment to delivering high-quality solutions. Salary: $110ph #J-18808-Ljbffr