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

Overview

Design, implement, maintain, and optimize Microsoft SQL Server database solutions that support business applications and technology initiatives, with a focus on SQL Server development, performance optimization, data integrity, security, troubleshooting, and backup management.

What you'll do

• 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.

What you'll need

• Practical experience with Microsoft SQL Server, including database development, administration support, query optimization, troubleshooting, backup, recovery, and performance monitoring.
• Strong experience writing, reviewing, optimizing, and troubleshooting SQL queries, stored procedures, views, functions, and related database objects using SQL/T-SQL.
• Strong knowledge of database concepts and experience with SQL Server or comparable platforms.
• Experience designing tables, relationships, indexes, constraints, schemas, and data access structures.
• Experience analyzing execution plans, identifying bottlenecks, optimizing queries, and improving database performance.
• Knowledge of access controls, authentication, authorization, permissions, encryption, auditing, and secure data-handling practices.
• Experience implementing, monitoring, testing, or supporting database backup and recovery processes.
• Familiarity with SQL and at least one additional language such as Python or Java.
• Experience working with the Microsoft SQL Server versions, database tools, operating systems, monitoring tools, and development environments used by the assigned Synechron project.
• Experience with database normalization, data modelling, schemas, tables, relationships, constraints, indexes, and transactions.
• Experience ensuring data integrity, consistency, availability, and accuracy.
• Understanding of database capacity, storage, availability, and operational support requirements.
• Understanding of database connectivity and integration with software applications, including evaluating dependencies, interfaces, schema changes, and compatibility considerations.
• Ability to follow software development lifecycle, change-control, release, testing, and documentation practices.
• Ability to support incident investigation, root-cause analysis, defect resolution, and operational improvements.
• Knowledge of database security best practices, including least-privilege access, role-based access, and secure data handling.
• Awareness of encryption, auditing, credential management, sensitive-data protection, and access reviews.
• 3+ years of experience in database development, database administration, SQL development, or a related field.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field; or equivalent relevant professional experience may be considered.

Nice to have

• 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.
• Familiarity with Python or Java for automation, database integration, testing, or support activities.
• Experience supporting Microsoft SQL Server databases in cloud or hybrid environments.
• Experience with data-access libraries, ORM tools, ETL frameworks, or reporting components.
• Experience with database deployment automation, schema migration, continuous integration, or continuous delivery.
• Exposure to Agile development practices and iterative delivery.
• Experience implementing encryption, data masking, auditing, secrets management, certificate management, or privileged access controls.
• Industry experience in technology, software development, financial services, enterprise applications, or data-intensive environments.
• Certification in database management, Microsoft SQL Server, data engineering, or a related discipline.

Details

• Location: Bengaluru - Bellandur (GTP).