Lead design, optimization, and modernization of enterprise Microsoft SQL Server databases. Develop and tune complex SQL, design schemas and indexing strategies, resolve performance bottlenecks, support application integration, produce technical documentation, conduct architecture and code reviews, and mentor engineering teams to ensure scalable, secure, high-availability data platforms.
𝗧𝗵𝗶𝘀 𝗿𝗼𝗹𝗲 𝗶𝘀 𝗳𝗼𝗿 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗪𝗲𝗲𝗸𝗱𝗮𝘆'𝘀 𝗰𝗹𝗶𝗲𝗻𝘁𝘀
𝗦𝗮𝗹𝗮𝗿𝘆 𝗿𝗮𝗻𝗴𝗲: 𝗥𝘀 𝟯𝟬𝟬𝟬𝟬𝟬𝟬 - 𝗥𝘀 𝟲𝟬𝟬𝟬𝟬𝟬𝟬 (𝗶𝗲 𝗜𝗡𝗥 𝟯𝟬-𝟲𝟬 𝗟𝗣𝗔)
Experience: 18+ yrs
Location: kochi, Thiruvananthapuram, Kerala, India, Chennai, Tamil Nadu, India
Job Type: Full-time
We are seeking an experienced SQL Technical Architect to lead the design, optimization, and modernization of enterprise database solutions built on Microsoft SQL Server. This role is ideal for professionals with deep expertise in SQL development, database architecture, performance tuning, and enterprise application support, who are passionate about delivering scalable, secure, and high-performing data platforms.
As a SQL Technical Architect, you will work closely with business stakeholders, application development teams, and solution architects to design robust database solutions, optimize complex SQL workloads, and drive best practices across the data layer. You will play a key role in defining database architecture, improving application performance, mentoring engineering teams, and ensuring reliable, business-critical data operations in a large-scale enterprise environment.
RequirementsKey Responsibilities
- Design and maintain scalable database architectures using Microsoft SQL Server to support enterprise applications.
- Develop, optimize, and maintain complex stored procedures, functions, views, triggers, and SQL queries for high-performance applications.
- Design database schemas, indexing strategies, and data models that improve scalability, maintainability, and performance.
- Perform SQL query optimization, execution plan analysis, profiling, and performance tuning to resolve database bottlenecks.
- Analyze, troubleshoot, and resolve database, application, and data-related issues while ensuring system reliability.
- Collaborate with application development teams to design efficient database modules and support end-to-end solution delivery.
- Review database designs, SQL code, and implementation approaches to ensure adherence to architectural standards and best practices.
- Work closely with business stakeholders to understand requirements, support data analysis, and translate business needs into technical solutions.
- Prepare technical documentation, database mapping documents, and implementation guidelines while supporting system upgrades and enhancements.
- Mentor development teams, participate in architecture discussions, conduct technical design reviews, and drive continuous improvements in database engineering practices.
- 18+ years of experience working with Microsoft SQL Server, including 10+ years of hands-on SQL development experience.
- Strong expertise in SQL programming, stored procedures, functions, triggers, views, indexing, and advanced query optimization.
- Extensive experience in database architecture, schema design, performance tuning, execution plan analysis, and SQL profiling.
- Proven ability to troubleshoot complex database performance issues and implement scalable optimization strategies.
- Experience integrating databases with enterprise applications and third-party APIs.
- Strong understanding of database security, scalability, reliability, backup, recovery, and high-availability concepts.
- Experience conducting technical architecture reviews, code reviews, and mentoring database development teams.
- Excellent analytical, problem-solving, and stakeholder management skills with the ability to translate business requirements into technical solutions.
- Familiarity with enterprise application development environments and collaborative Agile delivery practices.
- Experience in the US Healthcare Payer domain or other highly regulated industries will be considered a strong advantage.
Similar Jobs
Cloud • Information Technology • Security • Software • Cybersecurity
Own technical relationships across the customer lifecycle: lead discovery, design bespoke architectures, run demos and PoCs across security, networking and developer platforms, drive adoption and expansion with quota responsibility, run technical QBRs, and leverage AI-augmented workflows to automate tasks and focus on strategic advisory.
Top Skills:
Ai AgentsApi ConnectorsCloud InfrastructureCloudflare Ai GatewayCloudflare WorkersDdos MitigationDnsJavaScriptLlm OrchestrationPrompt EngineeringPythonRetrieval-Augmented Generation (Rag)Routing (Bgp)Telemetry Monitoring
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Develop and maintain statistical and ML forecasting models for SKU-level demand using Python/PySpark and Databricks; analyze model performance (MAPE/bias), post-process outputs, collaborate with demand planners for explainability, produce dashboards and KPIs, and drive continuous improvement in forecasting and data models.
Top Skills:
DatabricksGoogle AdwordsGoogle AnalyticsGoogle Cloud PlatformGoogle Tag ManagerJuliaExcelPower BIPysparkPythonRSASSQLTableau
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Lead global access, pricing, and evidence-generation strategy for the Precision Medicine & Lung Cancer franchise. Generate payer insights, develop integrated value and access plans, advise senior leadership, coordinate cross-functional teams, support launch sequencing and pricing/reimbursement strategies, and influence clinical development and real-world evidence to optimize product value and market access.
Top Skills:
AI
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
