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 Rental Man (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.

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

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

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

Pay Rate: $70 - $75 / Hour

If hired, you will enjoy the following ECLARO Benefits:

• 401k Retirement Savings Plan administered by Merrill Lynch
• Commuter Check Pretax Commuter Benefits
• Eligibility to purchase Medical, Dental & Vision Insurance through ECLARO

Progress on your journey to success! ECLARO is currently recruiting for a Senior SQL Developer in the Fort Mills, SC area for one of our clients. ECLARO's client is a leading provider of healthcare workforce software and solutions. If you're up to the challenge, then take a chance at this rewarding opportunity!