SQL Software Engineer

Job title: SQL Software Engineer

Company: The Access Group


Job description: 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 blended approach to office working, encouraging you to collaborate and connect in one of our thriving offices. 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:
You are a hard working individual, who is looking to work as an important member of the team to support the development and support of the product. You are someone who wants to maintain high coding standards and thrives in a challenging environment ready to build your knowledge. You are someone that is self-driven, pro-active and has an enthusiastic attribute who is willing to contribute to the conversation and happy to challenge the norm in order to bring new ideas to the department and team and help us maintain a culture of continuous improvement.
As a senior member of our team, you will embrace responsibility and have a strong desire to take ownership of problems and support your team to be the best they can be.Day-to-day, you will:

• Developing and supporting our Reports Repository product for our Mosaic case management system.
• Designing and maintaining relational databases.
• Optimizing database performance and ensuring data integrity.
• Writing complex queries, procedures, and triggers.
• Ensuring compliance with data protection regulations.
• Working in a cross functional team in an agile methodology.
• Working with global teams across different time zones.
• Take on responsibility in the technical design approach and reviewing work of other members of the team
• Helping to refine and size up stories, work and projects. Taking ownership of larger project pieces from design to sizing.
• Developing unit tests alongside our code and following our quality gates and ever improving automated scans and checks.
• Working and learning new technologies to modernise our legacy product (helping to create a new product potentially within Microsoft Fabric).
• Embracing and contributing to our automated pipelines and jobs.
• Learning about our Mosaic system and the domain of Social Care.

As a skilled Developer, your Skills and Experiences likely include:

• Expert-level knowledge of SQL for querying, optimization, and data manipulation.
• Experience with advanced SQL functions like window functions, CTEs, and dynamic SQL.
• Proficiency in database platforms such as Microsoft SQL Server, Oracle, MySQL, or PostgreSQL.
• Experience in designing, implementing, and managing complex databases and schemas.
• Expertise in query optimization, indexing strategies, and troubleshooting performance bottlenecks.
• Understanding of data encryption, backup, and recovery strategies.
• Familiarity with CI/CD pipelines for database deployment.
• Experience of version control systems like Git, Github etc for managing database code changes.
• Experience in agile methodology
• Excellent communication and written skills
• Strong analytical and problem-solving skills.
• Ability to communicate effectively with technical and non-technical stakeholders.

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.

Expected salary:

Location: Kuala Lumpur

Job date: Sat, 11 Jan 2025 05:01:33 GMT

To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.pro) you saw this job posting.Thanks&Good Luck