SQL Developer – AI Prompting & Context Engineering

Bromcom Computers Plc

United States

Remote

USD 110,000 - 170,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Bromcom Computers Plc is seeking an engineer who blends AI-assisted development with strong SQL Server data migration experience. You’ll help design agents, orchestrate multi-agent workflows, and ensure safe, scalable data handling across internal systems and APIs.

You will work closely with the Software Manager in a role combining AI tooling, code generation, and SQL optimization. Apply careful judgment to AI outputs and mentor teammates in best practices.

Qualifications

  • Hands-on AI-assisted development experience with prompts and workflows.
  • Strong SQL Server T-SQL development and performance tuning.
  • Experience with data migration projects and data modelling.

Responsibilities

  • Use AI coding assistants across the development lifecycle: generate, refactor, test, document and review code.
  • Design and orchestrate AI agents and multi-agent workflows with human-in-the-loop checkpoints.
  • Connect agents to internal systems, databases and APIs and evaluate output for accuracy and latency.
  • Plan and prioritise work, collaborate with the Data Migration Team, and coordinate with third parties.
  • Ensure data privacy, security, and compliance in AI-assisted processes.
  • Provide coaching and best-practice sharing to colleagues on AI adoption.
  • Design scalable SQL Server solutions for data cleansing and migration.

Skills

AI-assisted development
Prompts & AI tools
SQL Server
Data migration
Git version control
Python
LLM APIs

Education

Bachelor's degree in CS or related field

Tools

Claude Code
GitHub Copilot

Job description

This is a dual role, split between approximately 60% AI-assisted development and agent orchestration, and 40% SQL Server development supporting large-scale data migration. You’ll work within the development team and report to the Software Manager, combining practical AI skills with strong SQL expertise to deliver reliable, efficient solutions.

Key Responsibilities

AI-Assisted Development & Agent Orchestration (c. 60%)

  • Use AI coding assistants, such as Claude Code or GitHub Copilot, across the development lifecycle, including code generation, refactoring, testing, documentation and review.

  • Build and maintain effective prompts, system instructions, reusable skills and context to produce consistent, reliable AI outputs.

  • Design and orchestrate agents and multi-agent workflows, including task decomposition, tool use, agent hand-offs and human-in-the-loop checkpoints.

  • Connect agents to internal systems, databases and APIs, for example through MCP or function calling.

  • Evaluate AI output for accuracy, regression, cost and latency, and refine workflows based on results.

  • Apply appropriate safeguards for data privacy, security and hallucination risk, particularly when customer or school data is involved.

  • Identify and prototype opportunities to apply AI to development and data migration, and share best practice by supporting and coaching colleagues.

SQL Server & Data Migration (c. 40%)

  • Design, develop and maintain scalable SQL Server T-SQL solutions and related tools for data cleansing, migration and reconciliation.

  • Provide database performance-tuning expertise for internal and third-party systems, using AI tooling where appropriate.

  • Define technical requirements with non-technical colleagues in the Data Migration Team, and work with third parties to understand their software and support migration projects.

  • Manage SQL Server database environments used for data migration, including backup and recovery in test environments.

  • Prepare and expose data safely for agents and AI workflows, using AI to support SQL query generation, code review and optimisation.

  • Plan and prioritise work independently, managing tasks against project timelines and requirements.

The Ideal Candidate

  • You’ll combine hands-on AI-assisted development skills with substantial SQL Server experience. You’ll be curious and adaptable, communicate clearly, and use good judgement to assess AI-generated output rather than accepting it uncritically.

  • Demonstrable experience using AI coding tools and writing effective prompts, with practical examples of workflows or agents you have built.

  • Substantial SQL programming experience and strong knowledge of the techniques and capabilities of Microsoft SQL Server 2017 or later.

  • A strong grounding in data modelling, data management and data manipulation, alongside Git, version control and attention to detail.

  • The ability to investigate problems independently, collaborate with colleagues and communicate clearly in writing and in person.

Essential Skills

Practical experience with AI coding assistants and strong prompting skills, supported by examples.

Strong SQL Server T-SQL development and performance tuning, including experience supporting SQL Server in a large-scale environment.

Experience with Git and version control.

Excellent teamwork, communication and documentation skills.

Desirable Skills

Experience building agents or multi-agent workflows using Claude Code, MCP or similar frameworks.

Familiarity with LLM APIs, evaluation approaches and prompt testing.

Scripting or programming experience in Python or a similar language.

Awareness of AI data protection and security considerations.

A reasonable understanding of operating systems, infrastructure and networking.


Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

1216 | Senior SQL Developer (AI Workflows)
1216 | Senior SQL Developer (AI Workflows)

Intetics • Naples (FL)

On-site
USD 90,000 - 140,000
Senior SQL Developer (AI Workflows)
Senior SQL Developer (AI Workflows)

Intetics • United States

Remote
USD 120,000 - 160,000
Applications Developer
Applications Developer

vibehackers • Phoenix (AZ)

Hybrid
USD 110,000 - 170,000
Senior AI-Native Software Engineer
Senior AI-Native Software Engineer

EPAM Systems • United States

Remote
USD 140,000 - 210,000
SQL Engineer
SQL Engineer

Joinkeywork • United States

Remote
USD 83,000 - 165,000
ZR_3024_JOB
ZR_3024_JOB

Simple Solutions • Dallas (TX)

Hybrid
USD 110,000 - 170,000
AI Engineer
AI Engineer

Remotestar Team • United States

Remote
USD 120,000 - 180,000
Forward Deployed AI Engineer-Anthropic-UK
Forward Deployed AI Engineer-Anthropic-UK

highmetric • United States

Remote
USD 180,000 - 240,000
Senior .NET Software Engineer with strong AI Engineering experience
Senior .NET Software Engineer with strong AI Engineering experience

EPAM Systems • United States

Remote
USD 140,000 - 180,000
Generative AI Engineer
Generative AI Engineer

TRUSYS, Inc. • Dallas (TX)

On-site
USD 120,000 - 170,000