SQL Developer - System Integrator - Hamilton Barnes Associates Limited : Job Details

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