Job Title

About usThoughtVerve 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 RoleWe 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 ResponsibilitiesDatabase Architecture & DesignDesign and implement scalable, high-availability SQL Server database architectureDefine data models, schema standards, and database design best practicesLead database strategy for performance, scalability, and reliabilityArchitect solutions for OLTP, data integration, and reporting workloadsEstablish governance standards for database development and deploymentSQL DevelopmentDevelop and optimize complex T-SQL queries, stored procedures, triggers, and functionsDesign efficient indexing strategies and query optimization techniquesBuild data pipelines and ETL processes using SQL Server toolsTroubleshoot and resolve performance bottlenecks and production issuesImplement data validation and integrity mechanismsPerformance OptimizationMonitor and optimize query execution plans, indexing, and database performanceImplement partitioning, indexing strategies, and caching mechanismsConduct database tuning and capacity planningEnsure optimal performance for large-scale transactional systemsData Integration & AutomationDesign and maintain ETL/ELT processesIntegrate databases with enterprise applications and APIsImplement automation for database maintenance, monitoring, and deploymentsSupport data migration and modernization initiativesSecurity & GovernanceImplement database security best practicesManage access control, encryption, and auditingEnsure compliance with enterprise data governance policiesCollaboration & LeadershipCollaborate with application developers, architects, and DevOps teamsProvide technical leadership and mentoring for SQL developersParticipate in architecture reviews and system design discussionsSupport Agile development teams and CI/CD data workflowsRequired Qualifications8+ years of experience in SQL Server development and database architectureDeep expertise in T-SQL, stored procedures, indexing, and query optimizationStrong experience with database design and data modelingExperience managing large-scale enterprise databasesProficiency in SQL Server performance tuning and troubleshootingExperience with ETL processes and data integrationKnowledge of high availability, disaster recovery, and database replicationStrong understanding of database security and governancePreferred QualificationsExperience with SQL Server Integration Services (SSIS)Familiarity with SQL Server Reporting Services (SSRS) or BI toolsExperience working in cloud environments (Azure SQL, Azure Data Services)Exposure to DevOps practices and CI/CD pipelinesExperience supporting large enterprise platforms or high-volume transactional systemsKey SkillsMicrosoft SQL ServerT-SQL DevelopmentDatabase ArchitectureQuery Optimization & Performance TuningData ModelingETL & Data IntegrationHigh Availability & Disaster RecoveryDatabase SecurityData GovernanceAgile / DevOps Collaboration