Database Engineer

About the Job

Company: Trida Labs
Location: Bengaluru, Karnataka, India
Work Model: On-site
Employment Type: Full-time
Experience: 3–5 Years

About Trida Labs

Trida Labs builds products for enterprise data, analytics, and intelligent applications.

Our products include TridaPad, a platform for querying, analyzing, and visualizing enterprise data; AgentSQL, which enables natural-language interaction with enterprise data; and TridaPad MCP Server, which connects AI assistants and MCP-compatible clients with TridaPad capabilities.

About the Role

We are looking for a Database Engineer to build and maintain the database systems that support Trida Labs products.

You will work primarily with PostgreSQL, SQL, and Python, with responsibilities across data modeling, query performance, database migrations, data-source connectivity, and production troubleshooting. You will also contribute to the data and metadata layer supporting AgentSQL's natural-language-to-SQL workflows.

What You'll Do

Database Development

• Design and maintain PostgreSQL schemas, tables, indexes, constraints, and relationships.

• Write and review SQL used across the application and data workflows.

• Maintain organization-level data separation as schemas and application workflows evolve.

• Manage the growth of high-volume tables, including cached query results and event logs, with appropriate retention and cleanup.

Query Performance

• Analyze query execution plans and identify performance bottlenecks.

• Optimize queries, indexes, joins, and transactions.

• Work with Backend engineers to improve SQLAlchemy queries and database access patterns.

• Troubleshoot slow queries, connection issues, locks, and other database performance problems.

• Tune query execution timeouts and Redis-backed query execution jobs where required.

Data Source Connectivity

• Maintain and extend Python-based connectors used by TridaPad to query more than 70 data sources.

• Work with databases and data platforms such as Snowflake, BigQuery, Databricks, ClickHouse, and MySQL.

• Improve schema discovery, data-type mapping, authentication, and query execution across different database systems.

• Troubleshoot database-specific issues and handle large result sets.

AI & Text-to-SQL

• Improve the schema metadata used by AgentSQL for SQL generation, including table and column information.

• Contribute to SQL validation and safeguards for generated queries.

• Help identify database-specific issues affecting generated SQL.

• Build test cases to evaluate SQL generation across different databases and schemas.

Migrations & Production Support

• Design and execute database schema and data migrations.

• Contribute to the migration from SQLAlchemy 1.3 to SQLAlchemy 2.x.

• Support database backup, recovery, and PostgreSQL upgrade activities.

• Investigate production database issues and identify and fix root causes.

Ownership

You'll own database changes from design through production support, working closely with Backend, AI, Data, and DevOps teams.

What You'll Bring

• 3–5 years of professional experience in database, backend, or data engineering.

• Strong PostgreSQL and SQL skills, including data modeling, indexing, transactions, and constraints.

• Experience analyzing query execution plans and optimizing production queries.

• Experience with database schema migrations and production database changes.

• Working proficiency in Python.

• Experience with an ORM, preferably SQLAlchemy.

• Understanding of data integrity, backup, and recovery practices.

Preferred Qualifications

• Experience with Alembic or a similar database migration tool.

• Experience with Snowflake, BigQuery, Databricks, Trino, ClickHouse, or other analytical databases.

• Experience with MySQL, SQL Server, MongoDB, or Elasticsearch.

• Experience with Redis and background job systems.

• Experience building database connectors or working with multiple database engines.

• Experience with text-to-SQL, SQL validation, or LLM-generated queries.

• Familiarity with Docker and cloud-based database deployments.

Why Join Trida Labs?

A typical workflow starts with a user asking a question in natural language. AgentSQL generates SQL, TridaPad executes it against the customer's data source, and the results are returned for analysis and visualization.

You'll work on the schema metadata, connectors, and databases behind each of those steps.

Equal Opportunity

Trida Labs is an equal opportunity employer. We value diversity and are committed to creating an inclusive and respectful workplace for everyone.

You do not need to match every requirement listed above. If you have strong database fundamentals and believe you can contribute to the role, we encourage you to apply.