Lead SQL Server Developer

12 hours ago

Bengaluru Karnataka India, Karnataka Aezion, Inc Full time

Lead Database Developer – OLTP Product Engineering

Fulltime

Bengaluru


Role Summary

We are seeking a Lead Database Developer to oversee all database-related activities for our OLTP product engineering team. This role combines deep technical expertise in SQL Server with leadership responsibilities, ensuring robust design, development, performance optimization, and operational excellence for high-volume transactional systems.


Key Responsibilities

  • Database Design & Development
  • Architect and implement efficient OLTP database schemas for high-performance transactional workloads.
  • Develop and optimize stored procedures, functions, triggers, and views using T-SQL.
  • Collaborate with product engineering teams to ensure database solutions meet scalability and reliability requirements.
  • Performance Optimization
  • Analyze and tune queries, indexes, and execution plans for optimal performance.
  • Implement strategies for concurrency control, locking, and transaction management.
  • Proactively identify and resolve performance bottlenecks in production environments.
  • Leadership & Collaboration
  • Act as the primary database expert for product engineering teams.
  • Mentor developers on SQL Server best practices and data modeling.
  • Define and enforce coding standards and database development guidelines.
  • Deployment & Delivery
  • Oversee database changes through development, testing, and production environments.
  • Work closely with DevOps teams to integrate database changes into CI/CD pipelines.
  • Training & Documentation
  • Conduct training sessions for developers and QA teams on database design and optimization.
  • Maintain detailed documentation of database architecture and operational procedures.
  • Production System Monitoring
  • Monitor database health, availability, and performance using SQL Server features.
  • Set up alerts and dashboards for proactive issue detection.
  • Troubleshoot and resolve production incidents quickly to minimize downtime.
  • Backup & Recovery Strategies
  • Design and implement robust backup and recovery plans for mission-critical OLTP systems.
  • Test and validate disaster recovery procedures regularly.
  • Ensure compliance with data retention and security policies.


Required Skills

  • Advanced expertise in Microsoft SQL Server (2016/2022 or higher).
  • Strong proficiency in T-SQL, query optimization, and indexing strategies.
  • Deep understanding of OLTP systems, ACID principles, and concurrency control.
  • Experience with performance tuning, monitoring, and backup/recovery for high-volume environments.
  • Familiarity with CI/CD for database deployments and version control tools.


Preferred

  • Experience in product engineering for large-scale transactional applications.
  • Knowledge of SSIS, SSRS, and data modeling tools.
  • Microsoft certifications (e.g., Azure Database Administrator Associate or Database Developer).

  • SQL Server DBA

    12 hours ago

    Bengaluru, Karnataka, India, Karnataka Litmus7 Full time

    Job DescriptionRole Overview:We are looking for a dynamic and detail-oriented SQL Server-focused DBA with experience in Oracle as a secondary skill. The ideal candidate will handle the administration, performance tuning, monitoring, and support of SQL Server environments primarily, while also assisting in Oracle environments when needed. This role is part of...

  • SQL Server Developer

    1 week ago

    Bengaluru, Karnataka, India Sun Technologies Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Job Title: Senior SQL Server DeveloperExperience: 6+ yearsMandatory Skills: MS SQL Server, Stored Procedures, T-SQL, Database DesignDesired Skills: ETL, Linux shell scripting, SAP Crystal ReportsLocation: BangaloreJob Type: Permanent, Full-timeWork Mode: Work From Office (WFO)Shift Details: IST Shift (2:00 PM to 11:00 PM IST)Roles and Responsibilities:Manage...

  • DBA (MS SQL server)

    3 days ago

    Bengaluru, Karnataka, India PradeepIT Consulting Services Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Location: BangaloreStart Date: ImmediateDuration: 1 yearNumber of positions: 1Experience: 2-5 yearsWorking shift timing: Normal India ShiftSelection Process: 2 roundsJob Description: Please find belowPrimary skill: Microsoft SQL ServerSecondary skill: AzureAdminister and maintain SQL Server database systems.Monitor SQL Server health, diagnose and resolve...

  • Senior SQL Server DBA

    1 week ago

    Bengaluru, Karnataka, India Version 1 Full time ₹ 8,00,000 - ₹ 18,00,000 per year

    Company DescriptionVersion 1 has celebrated over 28 years in Technology Services and continues to be trusted by global brands to deliver solutions that drive customer success. Version 1 has several strategic technology partners including Microsoft, AWS, Oracle, Red Hat, OutSystems and Snowflake. We're also an award-winning employer reflecting how employees...

  • Senior SQL Server DBA

    1 week ago

    Bengaluru, Karnataka, India Version 1 Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Company Description Version 1 has celebrated over 28 years in Technology Services and continues to be trusted by global brands to deliver solutions that drive customer success. Version 1 has several strategic technology partners including Microsoft, AWS, Oracle, Red Hat, OutSystems and Snowflake. We're also an award-winning employer reflecting how employees...

  • SQL Developer

    2 weeks ago

    Bengaluru, Karnataka, India NTT DATA Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Analyze existing MS Access databases to understand data structures, relationships, queries, forms, reports, and VBA code. Design and implement optimized SQL Server database schemas, including tables, views, stored procedures, and functions, to replace Access functionality. Develop and execute data migration strategies, including ETL (Extract, Transform,...

  • MS SQL DBA

    12 hours ago

    Bengaluru, Karnataka, India, Karnataka Tata Consultancy Services Full time

    Must-Have4+ years of strong experience as a Seniors/Lead SQL Server DBA in a production(Cluster & Standalone) environment.Good knowledge of SQL Server 2012, 2014, 2016, 2017, and 2019 versions.Good understanding of Install, configure, and maintain SQL Server instances on-premises.Design, develop, and maintain databases, tables, indexes, views, stored...

  • SQL Developer

    5 days ago

    Bengaluru, Karnataka, India Talent Worx Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Requirements: 4+ years of experience in programming in Microsoft SQL Server. Understand and analyze data tables and formulate queries to transform and extract data Write SQL queries and Stored Procedures to extract and manipulate data for specified objectives End to end technical design, development, stabilization and enhancement of SQL...

  • SQL Developer

    2 weeks ago

    Bengaluru, Karnataka, India Innova AM Tech Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    We are seeking an experienced SQL Developer with expertise in SQL Server Analysis Services (SSAS) and AWS to join our growing team. The successful candidate will be responsible for designing, developing, and maintaining SQL Server-based OLAP cubes and SSAS models for business intelligence purposes. You will work with multiple data sources, ensuring data...

  • Azure SQL DBA

    12 hours ago

    Bengaluru, Karnataka, India, Karnataka Sonata Software Full time

    Sonata Software OverviewIn today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers.As a leading Modernization Engineering company, we aim to deliver modernization-driven...