Senior Database Engineer

ABOUT SONATA SOFTWARE Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency, and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services. Sonata’s AI-led modernization is enabled by a powerful suite of proprietary tools and assets. At the core is the Harmoni.
AI Enterprise Platform, which includes AgentBridge-a governance and observability framework; AgentBuilder-a development toolkit for fungible agents integrated into enterprise systems; and the Agent Marketplace-an internal ecosystem for modular, reusable agents. Headquartered in Bengaluru, India, Sonata Software has a strong global presence, including key regions US, UK, India, Malaysia, Mexico, Australia, DACH (Germany/Switzerland) & Nordics (Finland). We are a trusted partner of Fortune 500 companies in Banking, Financial Services and Insurance; Healthcare and Lifesciences; Telecom, Media, and Technology; and Retail, Manufacturing and Distribution space. Deep collaborations with partners like Microsoft, AWS, Salesforce, and Snowflake strengthen our ability to deliver cutting-edge AI solutions. Our 30+years of partnership with Microsoft, and being part of the elite Microsoft Inner Circle, places us among the top 1% of global Microsoft partners. Sonata is now among the first companies to earn the Microsoft Frontier Partner Badge Also; Sonata Software is proud to achieve AWS Premier Tier Status in the AWS Partner Network.

Job Description
Senior Database Engineer – AI

Location:
Brazil (Remote) Ideal Experience
• 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. Required 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.
• Mortgage knowledge is a Plus Why join Sonata Software? At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next. 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.