MS SQL Database Developer - T-SQL, Query Optimization, Backup/Recovery & Data Security

Synechron; Bengaluru; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Synechron is seeking an MS SQL Developer to design, implement, maintain, and optimize database solutions that support business applications and technology initiatives. The role focuses on SQL Server development, performance optimization, data integrity, security, troubleshooting, and backup management.

The MS SQL Developer will collaborate with application, engineering, infrastructure, security, and business teams to deliver reliable and maintainable database solutions, improving performance,

Qualifications

• Experience with Microsoft SQL Server development and administration.
• Strong SQL/T-SQL skills for queries, procedures, views, and functions.
• Ability to design schemas, indexes, and data access structures.
• Experience with backup, recovery, and performance monitoring.
• Familiarity with Python or Java for automation.

Responsibilities

• Design, implement, maintain, and enhance Microsoft SQL Server databases and related database objects.
• Develop and optimize SQL queries, stored procedures, views, functions, indexes, and data-access solutions.
• Monitor database performance, identify bottlenecks, analyze execution plans, and implement query and database optimizations.
• Collaborate with cross-functional teams to support database-related initiatives, application enhancements, migrations, integrations, and releases.
• Ensure data integrity, availability, confidentiality, and appropriate access controls.
• Troubleshoot database issues involving performance, connectivity, data quality, capacity, configuration, and application integration.
• Implement, monitor, document, and test database backup and recovery processes.
• Participate in database design and implementation projects, including schema design, data modelling, migration, and deployment activities.
• Support database changes through appropriate development, testing, approval, release, and rollback processes.
• Document database structures, dependencies, operational procedures, performance findings, backup processes, and technical decisions.
• Collaborate with application developers, infrastructure teams, security teams, testing teams, and business stakeholders to understand and deliver data requirements.
• Identify opportunities to improve database reliability, maintainability, scalability, security, automation, and operational efficiency.
• Support sustainable technology practices by optimizing storage, reducing unnecessary processing, improving resource utilization, and maintaining efficient database solutions.
• Deliver database solutions that meet agreed requirements for performance, availability, security, data quality, and supportability.

Skills

SQL Server

T-SQL

Query optimization

Backup and recovery

Database security

Python

Java

Job description

Job Summary

Synechron is seeking an MS SQL Developer to design, implement, maintain, and optimize database solutions that support business applications and technology initiatives. The role focuses on SQL Server database development, performance optimization, data integrity, security, troubleshooting, and backup management.

The MS SQL Developer will collaborate with application, engineering, infrastructure, security, and business teams to deliver reliable and maintainable database solutions. The role contributes to business objectives by improving database performance, availability, data quality, security, and operational continuity.

Software Requirements

Required Software Skills

• Microsoft SQL Server: Practical experience with database development, administration support, query optimization, troubleshooting, backup, recovery, and performance monitoring.
• SQL/T‑SQL: Strong experience writing, reviewing, optimizing, and troubleshooting SQL queries, stored procedures, views, functions, and related database objects.
• Database management systems: Strong knowledge of database concepts and experience with SQL Server or comparable platforms.
• Database design: Experience designing tables, relationships, indexes, constraints, schemas, and data access structures.
• Performance optimization: Experience analyzing execution plans, identifying bottlenecks, optimizing queries, and improving database performance.
• Database security: Knowledge of access controls, authentication, authorization permissions, encryption, auditing, and secure data‑handling practices.
• Backup and recovery: Experience implementing, monitoring, testing, or supporting database backup and recovery processes.
• Programming languages: Familiarity with SQL and at least one additional language such as Python or Java.
• Tool versions: Experience working with the Microsoft SQL Server versions, database tools, operating systems, monitoring tools, and development environments used by the assigned Synechron project.

Preferred Software Skills

• Experience with Oracle or MySQL database platforms.
• Familiarity with database monitoring, performance‑management, reporting, and alerting tools.
• Experience with source control, deployment automation, database migration, and release‑management tools.
• Exposure to cloud database platforms and managed database services.
• Familiarity with high availability, disaster recovery, replication, clustering, or database scaling technologies.
• Experience with data integration, ETL, reporting, or business intelligence tools.
• Equivalent database platforms and tools may be considered where they provide comparable capabilities.

Overall Responsibilities

• Design, implement, maintain, and enhance Microsoft SQL Server databases and related database objects.
• Develop and optimize SQL queries, stored procedures, views, functions, indexes, and data‑access solutions.
• Monitor database performance, identify bottlenecks, analyze execution plans, and implement query and database optimizations.
• Collaborate with cross‑functional teams to support database‑related initiatives, application enhancements, migrations, integrations, and releases.
• Ensure data integrity, consistency, availability, confidentiality, and appropriate access controls.
• Troubleshoot database issues involving performance, connectivity, data quality, capacity, configuration, and application integration.
• Implement, monitor, document, and test database backup and recovery processes.
• Participate in database design and implementation projects, including schema design, data modelling, migration, and deployment activities.
• Support database changes through appropriate development, testing, approval, release, and rollback processes.
• Document database structures, dependencies, operational procedures, performance findings, backup processes, and technical decisions.
• Collaborate with application developers, infrastructure teams, security teams, testing teams, and business stakeholders to understand and deliver data requirements.
• Identify opportunities to improve database reliability, maintainability, scalability, security, automation, and operational efficiency.
• Support sustainable technology practices by optimizing storage, reducing unnecessary processing, improving resource utilization, and maintaining efficient database solutions.
• Deliver database solutions that meet agreed requirements for performance, availability, security, data quality, and supportability.

Technical Skills (By Category)

Programming Languages

Essential

• Strong proficiency in SQL and T‑SQL for Microsoft SQL Server development and database management.
• Ability to write maintainable and optimized queries, stored procedures, functions, and database scripts.
• Familiarity with programming concepts relevant to database integration and application support.
• Ability to analyze application‑to‑database interactions and troubleshoot data‑related issues.

Preferred

• Familiarity with Python or Java for automation, database integration, testing, or s