- *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.
- 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)
- T\-SQL
- Stored Procedures
- Functions
- Triggers
- Views
- Query Optimization
- Indexing Strategies
- Execution Plan Analysis
- Database Design
- Data Modeling
- Normalization \& Denormalization
- Data Warehousing Concepts
- Data Governance
- SSIS (Preferred)
- Power BI (Preferred)
- SSRS (Preferred)
- **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
Work Location: Remote