Senior SQL Developer / Database Architect Position Summary

We are seeking a highly skilled Senior SQL Developer / Database Architect with 10+ years of experience in designing, developing, optimizing, and architecting enterprise-grade database solutions. The ideal candidate will possess deep expertise in Microsoft SQL Server, relational database design, data modeling, performance tuning, and large-scale data processing.

This role is responsible for defining database architecture standards, designing scalable data models, developing high-performance SQL solutions, and ensuring data integrity across mission-critical applications. The position requires a strong technical leader who can collaborate with development teams, guide best practices, and drive database excellence across the organization.

Key Responsibilities Database Architecture & Design

• Design and architect scalable, secure, and high-performing database solutions for enterprise applications.
• Develop conceptual, logical, and physical data models aligned with business and technical requirements.
• Define database standards, naming conventions, design patterns, and development best practices.
• Lead database schema design, normalization, denormalization, partitioning, and data governance initiatives.
• Evaluate and recommend database architecture improvements to support business growth and scalability.
• Conduct database design reviews and provide technical leadership to development teams.

Core SQL Development

• Design, develop, optimize, and maintain complex T-SQL queries, stored procedures, functions, views, and triggers.
• Build efficient and scalable database logic to support transactional and analytical applications.
• Translate complex business requirements into high-performing SQL solutions.
• Refactor existing SQL code to improve performance, maintainability, and readability.
• Develop reusable database components and frameworks to accelerate development.

Query Performance & Optimization

• Analyze execution plans and identify performance bottlenecks.
• Design and implement indexing strategies to improve application performance.
• Optimize high-volume transactional and reporting workloads.
• Monitor database performance metrics and proactively recommend enhancements.
• Improve query response times, throughput, and overall database efficiency.

Data Modeling & Data Management

• Design robust relational data models for enterprise systems.
• Ensure data integrity, consistency, and accuracy across databases.
• Establish and maintain data relationships, constraints, and referential integrity.
• Support master data management and data governance initiatives.
• Create and maintain comprehensive database documentation and data dictionaries.

Data Processing & ETL

• Design and develop SQL-based ETL processes and data transformation workflows.
• Build scalable data pipelines to support reporting, analytics, integrations, and downstream applications.
• Optimize data loading and transformation processes for performance and reliability.
• Ensure data quality through validation, reconciliation, and exception handling.

Troubleshooting & Production Support

• Diagnose and resolve SQL-related production issues and performance problems.
• Investigate data inconsistencies and implement corrective actions.
• Support mission-critical applications with timely issue resolution.
• Perform root cause analysis and recommend long-term solutions.

Collaboration & Leadership

• Partner with Product Managers, Architects, Developers, and Business Analysts to deliver data-driven solutions.
• Participate in architecture reviews, code reviews, and design discussions.
• Mentor junior and mid-level SQL developers on database design and SQL best practices.
• Contribute to Agile planning, estimation, and sprint execution activities.
• Promote continuous improvement in database development processes and standards.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 10+ years of hands-on experience in Microsoft SQL Server development and database architecture.
• Expert-level proficiency in T-SQL, stored procedures, functions, triggers, views, and complex query development.
• Strong experience in relational database design, normalization, and data modeling.
• Extensive experience with query optimization, indexing strategies, and execution plan analysis.
• Proven experience designing and supporting high-volume transactional databases.
• Deep understanding of database scalability, performance tuning, and data integrity principles.
• Experience developing SQL-based ETL and data transformation solutions.
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience working within Agile/Scrum development environments.

Preferred Qualifications

• Experience with SSIS or comparable ETL platforms.
• Exposure to Power BI, SSRS, Tableau, or other reporting and analytics tools.
• Experience with Azure SQL Database, Azure Data Factory, or cloud-based data platforms.
• Knowledge of Data Warehousing, Star Schema, and Dimensional Modeling concepts.
• Familiarity with CI/CD pipelines and database deployment automation.
• Experience with database security, auditing, and compliance best practices.

Technical SkillsDatabase Technologies

• Microsoft SQL Server (2016/2019/2022)
• Azure SQL Database (Preferred)

SQL Development

• T-SQL
• Stored Procedures
• Functions
• Triggers
• Views
• Query Optimization
• Indexing Strategies
• Execution Plan Analysis

Data Architecture

• Database Design
• Data Modeling
• Normalization & Denormalization
• Data Warehousing Concepts
• Data Governance

ETL & Reporting

• SSIS (Preferred)
• Power BI (Preferred)
• SSRS (Preferred)

What This Role Is Not

• Not a Database Administrator (DBA) role focused on server administration.
• Not responsible for SQL Server installation, patching, backups, or infrastructure management.
• Not focused on hardware, networking, or operating system administration.
• Primarily focused on database architecture, SQL development, performance optimization, and data solutions.

Pay: ₹2,000,000.00 - ₹3,000,000.00 per year

Benefits:

• Provident Fund

Work Location: Remote