About us

ThoughtVerve provides tailored software & technology solutions to clients across the globe for decisive outcomes. Headquartered in Bangalore, we are committed to long-term partnerships with our clients pivoted around sustainable, top-of-industry practices. We commit to be with our clients every step of the way starting from conception through their evolution.

About the Role

We are seeking an experienced Senior SQL Developer & Database Architect to lead the design, development, optimization, and governance of enterprise-scale Microsoft SQL Server database environments. This role will be responsible for architecting high-performance data solutions, optimizing complex queries, and supporting mission-critical applications across large-scale systems.

The ideal candidate combines deep SQL development expertise with strong database architecture experience, enabling scalable, secure, and high-performing data platforms that support business-critical applications.

Key Responsibilities

Database Architecture & Design

Design and implement scalable, high-availability SQL Server database architecture
Define data models, schema standards, and database design best practices
Lead database strategy for performance, scalability, and reliability
Architect solutions for OLTP, data integration, and reporting workloads
Establish governance standards for database development and deployment

SQL Development

Develop and optimize complex T-SQL queries, stored procedures, triggers, and functions
Design efficient indexing strategies and query optimization techniques
Build data pipelines and ETL processes using SQL Server tools
Troubleshoot and resolve performance bottlenecks and production issues
Implement data validation and integrity mechanisms

Performance Optimization

Monitor and optimize query execution plans, indexing, and database performance
Implement partitioning, indexing strategies, and caching mechanisms
Conduct database tuning and capacity planning
Ensure optimal performance for large-scale transactional systems

Data Integration & Automation

Design and maintain ETL/ELT processes
Integrate databases with enterprise applications and APIs
Implement automation for database maintenance, monitoring, and deployments
Support data migration and modernization initiatives

Security & Governance

Implement database security best practices
Manage access control, encryption, and auditing
Ensure compliance with enterprise data governance policies

Collaboration & Leadership

Collaborate with application developers, architects, and DevOps teams
Provide technical leadership and mentoring for SQL developers
Participate in architecture reviews and system design discussions
Support Agile development teams and CI/CD data workflows

Required Qualifications

8+ years of experience in SQL Server development and database architecture
Deep expertise in T-SQL, stored procedures, indexing, and query optimization
Strong experience with database design and data modeling
Experience managing large-scale enterprise databases
Proficiency in SQL Server performance tuning and troubleshooting
Experience with ETL processes and data integration
Knowledge of high availability, disaster recovery, and database replication
Strong understanding of database security and governance

Preferred Qualifications

Experience with SQL Server Integration Services (SSIS)
Familiarity with SQL Server Reporting Services (SSRS) or BI tools
Experience working in cloud environments (Azure SQL, Azure Data Services)
Exposure to DevOps practices and CI/CD pipelines
Experience supporting large enterprise platforms or high-volume transactional systems

Key Skills

Microsoft SQL Server
T-SQL Development
Database Architecture
Query Optimization & Performance Tuning
Data Modeling
ETL & Data Integration
High Availability & Disaster Recovery
Database Security
Data Governance
Agile / DevOps Collaboration

Sr. SQL Developer & Database Architect (MS SQL Server)