SQL Developer, Bromcom
Office located in Bromley, London
Cloud-managed information & finance for schools
Open for applications
Cloud-managed information & finance for schools
101-200 employees
Open for applications
Office located in Bromley, London
101-200 employees
Company mission
To provide a single robust and cost-effective solution that removes the need for costly bolt-on products.
Role
Who you are
- The ideal candidate will have substantial experience of SQL programming and an excellent knowledge of the techniques and the functionality and capabilities of MS SQL Server 2014 and above
- A strong background in data modelling, data management and data manipulation, code management and version control (GIT) is also important, as is having good attention to detail
- Capable of working through problems independently and liaising with team members to find quality solutions
- Knowledge of Azure Data Factory (ADF) would be a bonus
Desirable
- 3+ years of SQL Developer experience and administrating/supporting MS SQL Server Database infrastructures in large-scale environment
- Excellent teamwork, communication, and documentation skills
- Reasonable understanding of OS and Infrastructure / Network layer
- Experience of querying API end points (SOAP, REST)
- Good to have basic experience with programming (ASP.NET, XML, HTML, C#)
What the job involves
- Work within the development team reporting to the Software Manager
- Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server T-SQL and related tools to support and extend various large-scale data migration projects
- Provide database performance-tuning expertise for internal and third-party systems in SQL Server
- Provide technical knowhow on projects and work with third parties to understand how their software works to support data migration
- Responsibilities will include designing, developing, and maintaining appropriately scaled, effective solutions to support data cleansing, migration and reconciliation activity in Microsoft SQL Server T-SQL and related tools
- Defining technical requirements, working with non-technical members of the Data Migration Team
- The role requires you to manage MS SQL Server database environments that support data migration and backups and recoveries in test environments
- Demonstrating a logical and structured approach to time management and task prioritisation. Working within project timelines and requirements. Being able to organise own time, schedule tasks for completion and deliver work to that schedule
- Writing complex scripts for data manipulation and management report generation
- Export/Import of data
- Data conversion/migration
- Database object creation (Functions, Stored Procedures, Tables, etc)
- Performance tuning of new and existing code
- Analyse SQL code for potential flaws
- Optimization and maintenance of existing products
- Problem solving for actual customer data
Salary benchmarks
Our take
Bromcom has come some way since Founder Ali Guryen developed a wireless school attendance recording system in the early 1980s – then hailed as revolutionary. Nowadays, the company offers schools and multi-academy trusts (MATs) a range of cloud-based software solutions for attendance and assessment tracking, data management, finance, and budgeting.
While it would be presumptuous to label the company the leader in its field, its claim that 70% of the UK’s secondary schools use Bromcom for their cloud MIS is a serious indication of its position. Its landmark deal to supply its software to over 200 maintained schools in West Sussex is also testament to the company's scope.
The public sector – from which the majority of Bromcom’s customer base comes – has often been criticised for its slow digital transformation. However, the education sector has recently accelerated its migration to the cloud, which is good news for Bromcom which has been championing (and perhaps banking on) this move for a while.
Kirsty
Company Specialist
Insights
Company
Company HQ
Bromley, UK
Articles
Leadership
Ali Guryen
(Chairman & Managing Director)Has been involved in Computer Science, Software Engineering & Development since the early 1970s, founding Bromcom in 1986.
Share this job
View 7 more jobs at Bromcom