Sign upLog in

Senior SQL Developer

ECLARO

Fort Mills, SC

Apply
JOB DETAILS
SALARY
$70–$75 Per Hour
SKILLS
Access Control, Administrative Skills, Amazon Relational Database Service (RDS), Application Programming Interface (API), Best Practices, Business Analysis, Cloud Computing, Clustering Software, Communication Skills, Consulting, Cross-Functional, Cryptography, Data Processing, Data Quality, Data Recovery, Database Extract Transform and Load (ETL), Database Technology, Database Triggers, Dental Insurance, Detail Oriented, Disaster Recovery, Diversity, Documentation, Failover, Genetics, Healthcare Providers, Healthcare Software, High Availability, High Reliability, IBM DB2, Identify Issues, Information/Data Security (InfoSec), Mentoring, Microsoft Certifications, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Multitasking, Network Administration/Management, Performance Analysis, Performance Management, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Query Optimization, Regulatory Compliance, Rentals, Root Cause Analysis, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Server Clusters, Software Development, Stored Procedures, System Integration (SI), Systems Administration/Management, Systems Reliability, Team Player, Testing, Time Management, Vision Plan, Windows PowerShell, Writing Skills
LOCATION
Fort Mills, SC
POSTED
1 day ago
Senior SQL Developer
Job Number: 26-00688

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!

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

Required Qualifications:
  • 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

If interested, you may contact:
Lisa Pelletier
Lisa.Pelletier@eclaro.com
646-695-2949

Equal Opportunity Employer: ECLARO values diversity and does not discriminate based on Race, Color, Religion, Sex, Sexual Orientation, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status, in compliance with all applicable laws.

About the Company

E

ECLARO

Eclaro is a Business and Technology Consulting Firm that connects top talent with opportunities nationwide. We have direct access to Hiring Managers from leading Fortune 1000 organizations in almost every industry segment, with particular expertise in:

• Technology and Business Consulting
• Financial Services and Insurance
• Pharmaceuticals and Life Sciences
• Consumer Products, Public Sector, and Utilities

Eclaro provides fully customizable, comprehensive talent acquisition and management of seasoned professionals through a number of business models, including:

• Consulting
• Professional Hiring
• Global Integrated Delivery™
• Managed Services

Eclaro recruits and manages a staff of highly skilled individuals in an array of specialized disciplines enabling our clients to leverage new opportunities, respond to increased and changing demands, and increase their profitability.

Eclaro’s Management Team averages over 25 years of experience in partnering with clients in technical, corporate operations and human capital solutions. We hold ISO 9001:2008 certification and have achieved SOC 2 Type 2 certification in Security, Availability and Confidentiality. Eclaro’s decades of expertise and collaborative practice have proven that The Right People are The Answer.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1999
WEBSITE
http://www.eclaroit.com