Database Engineer – AI

Database Engineer – AI Location: Brazil (Remote) Experience: 8+ Years Technology Stack : Microsoft SQL Server, Azure SQL Managed Instance, T-SQL, AI/LLM Integration About the role: We are looking for a Senior Database Engineer with 8+ years of experience and deep expertise in Microsoft SQL Server, database performance tuning, stored procedures, dependency analysis, and Azure SQL Managed Instance. The ideal candidate will contribute to enhancing AI-powered SQL agents and ensure the correctness, performance, security, and safety of AI-generated database queries, scripts, and changes.

About Sonata Software

Mortgage knowledge is a Plus ABOUT SONATA SOFTWARE Sonata Software is an AI-first modernization engineering company that helps enterprises transform legacy systems into intelligent, scalable business platforms.

Powered by its Platformation™ framework and platform, Sonata delivers AI-led modernization across cloud, data, AI, Dynamics, test automation, and managed services.

Headquartered in Bengaluru, India, Sonata has more than $1.2 billion in revenue and 6,400+ AI engineers supporting global delivery across regions including the US, UK, India, Malaysia, Mexico, Australia, DACH, and the Nordics.

With deep partnerships across Microsoft, AWS, Salesforce, and Snowflake, Sonata helps Fortune 500 enterprises accelerate innovation, improve efficiency, and drive sustainable growth.

Responsibilities

• Design, develop, and maintain complex SQL queries, stored procedures, functions, views, triggers, indexes, and database objects.
• Perform advanced SQL performance tuning, execution plan analysis, indexing optimization, deadlock investigation, and database bottleneck resolution.
• Analyze database schemas, object dependencies, relationships, and business logic to assess the impact of database changes.
• Manage and optimize databases on Azure SQL Managed Instance, including performance monitoring, troubleshooting, migration, and deployment.
• Enhance AI-powered SQL agents to improve SQL generation, schema understanding, query optimization, and database workflow automation.
• Validate AI-generated SQL for syntactic correctness, business logic accuracy, performance, data integrity, and compatibility with the target environment.
• Implement safety controls to prevent destructive SQL operations, unauthorized data access, unintended data modifications, and production-impacting changes.
• Develop automated evaluation and testing frameworks to measure SQL agent accuracy, reliability, execution correctness, and safety.
• Collaborate with AI and backend engineers to improve agent context retrieval, error handling, feedback mechanisms, and database metadata integration.
• Establish database security, auditing, backup, recovery, version control, and deployment practices aligned with enterprise standards.

Requirements

• Skills and Qualifications 8+ years of hands-on experience in database engineering, with deep expertise in Microsoft SQL Server and T-SQL.
• Strong experience developing and optimizing complex stored procedures, functions, views, triggers, indexes, and queries.
• Expertise in SQL performance tuning, execution plans, query optimization, deadlock analysis, and troubleshooting.
• Strong understanding of database architecture, schema design, object dependencies, transactions, and data integrity.
• Hands-on experience with Azure SQL Managed Instance, including performance optimization and operational support.
• Experience reviewing and validating database scripts and assessing the impact of database changes across dependent objects and applications.
• Strong understanding of database security, access controls, auditing, SQL injection prevention, and safe execution practices.
• Practical exposure to AI/LLM-powered applications, text-to-SQL solutions, AI coding assistants, or AI-driven database automation.
• Ability to identify hallucinated database objects, incorrect business logic, inefficient queries, and unsafe operations in AI-generated SQL.
• Experience with database testing, version control, CI/CD pipelines, and controlled database deployments.

For more information, please visit

Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law