SQL Developer

• Seeking an experienced Senior SQL Developer to join our team.
• The ideal consultant will have a deep understanding of SQL Server, SSIS (SQL Server Integration Services), and familiarity with Rental Management systems like RentalMan (WYNND).
• The consultant will be responsible for managing and supporting a complex SQL Server environment with 180 SQL instances and multiple SQL clusters.
• The Senior SQL Developer will also work on troubleshooting, triaging, and resolving issues related to SQL, APIs, and interconnected applications.

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.
• RentalMan (WYNNE) Integration:
• Db2 on the backend, SQL systems integrate with it via OPENQUERY and SSIS.
• Develop and maintain integrations between SQL Server and RentalMan (WYNNE), ensuring seamless data exchange and system reliability.
• Troubleshoot and resolve issues specific to the RentalMan system and its SQL database integrations.

• 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.
• 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).
• 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.

Preferred Skills:

• Knowledge of RentalMan (WYNND) or similar Rental Management systems.
• Certifications: Microsoft Certified: Azure Data Engineer Associate or Microsoft Certified: SQL Server Database Administrator Certifications.
• Experience: Familiarity with cloud-based database services (e.g., Azure SQL, Amazon RDS).

ECLARO’s client is a leading technology solutions provider, collaborating with customers to manage their needs and achieve success in their business goals. If you’re up to the challenge, then take a chance at this rewarding opportunity!