Dev Services Consultant We’re looking for people to join the Access family, who share our passion for believing in better, and who will help us continue to grow.   Love Work. Love Life. Be You. - is central to our success and how we give our customers the freedom to do more of what's important to them. What does Access offer you?  We offer a flexible, hybrid working environment where you can balance work and life while maintaining a strong office team-based culture. We deliver on what we say, taking the development of our people seriously. We’ll work with you to progress your success plan and provide opportunities to accelerate your career.  On top of a competitive salary, our wellbeing days taking you to 25 days leave a year and a health contribution, you’ll also be able to choose from a range of benefits to suit you. We’re an organisation that likes to give back, so you’ll also have three charity days allocated to support a cause that matters to you.   About you:  Job Title: Dev Services Consultant Job Description: We are seeking a detail-oriented and highly skilled Dev Services Consultant to join our team. The ideal candidate will have a strong understanding of API development and integration, as well as extensive experience with SQL, including writing complex queries and stored procedures. As a Dev Services Consultant, you will play a key role in building and creating middle ware solutions and services between systems, solving complex technical challenges, and ensuring the efficiency and reliability of our applications. Key Responsibilities: • API Development & Integration: o Design, develop, and maintain RESTful APIs and microservices to support application functionality. o Integrate third-party APIs and services, ensuring secure and efficient data exchange. o Optimize API performance and troubleshoot any issues related to API communication and data processing. • SQL Development: o Write complex SQL queries to retrieve, manipulate, and analyze data from relational databases. o Develop and optimize stored procedures, functions, and triggers to support application logic. o Perform database tuning and optimization to improve query performance and resource utilization. o Ensure data integrity, consistency, and security across all database operations. • Problem Solving & Debugging: o Analyze and resolve technical issues across the application stack, including backend services, APIs, and databases. o Collaborate with other developers and stakeholders to diagnose problems, identify root causes, and implement effective solutions. o Develop tools and scripts to automate repetitive tasks and improve system efficiency. • System Design & Documentation: o Participate in the design and architecture of backend systems, ensuring scalability and maintainability. o Create and maintain technical documentation, including API specifications, database schemas, and system workflows. o Provide technical input during the planning and scoping phases of projects to ensure feasible and efficient solutions. • Collaboration & Communication: o Work closely with front-end developers, DevOps, and QA teams to deliver high-quality software solutions. o Communicate technical concepts clearly and effectively to both technical and non-technical team members. o Participate in code reviews, providing constructive feedback to peers to maintain high coding standards. Required Skills & Qualifications: • API & Backend Development: o Strong experience with API design and development, including RESTful services. o Familiarity with JSON, XML, and other data interchange formats. o Understanding of authentication and authorization mechanisms (e.g., OAuth, JWT). • SQL & Database Management: o Proficiency in writing complex SQL queries for data retrieval and manipulation. o Extensive experience with stored procedures, functions, and triggers. o Knowledge of database design principles, indexing, and query optimization techniques. o Experience with relational database management systems such as MySQL, PostgreSQL, SQL Server, or Oracle. • Problem-Solving & Debugging: o Strong analytical and problem-solving skills, with a proactive approach to troubleshooting. o Ability to quickly identify and resolve performance bottlenecks and technical issues. o Experience using debugging tools and techniques to diagnose and fix issues in production and development environments. • Additional Skills: o Familiarity with version control systems like Git. o Basic understanding of DevOps practices and CI/CD pipelines. o Experience in building apps in React, with Typescript or C# with .NET o Ability to work independently and as part of a team, managing multiple tasks and projects. Preferred Qualifications: • Bachelor’s degree in Computer Science, Information Technology, or a related field. • Experience with cloud-based databases and services (e.g., AWS RDS, Azure SQL Database). • Knowledge of scripting languages like Python or Bash for automation tasks. • Experience with NoSQL databases (e.g., MongoDB, Cassandra) is a plus. What are we all about?  The Access Group is one of the largest UK-headquartered providers of business management software to small and mid-sized organisations in the UK, Ireland, USA and Asia Pacific. It helps more than 100,000 customers across commercial and non-profit sectors become more productive and efficient. Our products and solutions go beyond providing technology, we connect the right people with the right data, at the right time, through Access Workspace. At Access, we are committed to creating a welcoming and inclusive environment where everyone can thrive. If you're excited about this role, (even if your previous experience doesn't align perfectly), you might just be the perfect fit for us! We wholeheartedly believe in equality for all and the transformative power of diversity.   Why not join our vibrant team where you can love what you do, love how you live, and most importantly, be authentically you? Let's make a difference together.  Love Work. Love Life. Be You.