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

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 support activities.
• •Experience developing scripts for database monitoring, validation, deployment, backup verification, or routine administration.
• •Knowledge of additional scripting or programming languages used in the assigned technology environment.

Databases/Data Management

Essential

• •Strong knowledge of Microsoft SQL Server and relational database concepts.
• •Experience with database design, normalization, data modelling, schemas, tables, relationships, constraints, indexes, and transactions.
• •Experience with query optimization, execution plans, indexing strategies, performance monitoring, and database troubleshooting.
• •Experience ensuring data integrity, consistency, availability, and accuracy.
• •Experience implementing or supporting database backup, recovery, and restoration processes.
• •Understanding of database capacity, storage, availability, and operational support requirements.

Preferred

• •Experience with Oracle or MySQL.
• •Familiarity with replication, clustering, partitioning, high availability, disaster recovery, or database scaling.
• •Experience with ETL, data migration, data integration, reporting, or data-quality processes.
• •Exposure to relational and non-relational database technologies.

Cloud Technologies

Essential

• •Ability to understand how deployment environments, infrastructure, availability, security, monitoring, and resource capacity affect database operations.
• •Ability to collaborate with infrastructure and cloud teams on database implementation and support activities.

Preferred

• •Experience supporting Microsoft SQL Server databases in cloud or hybrid environments.
• •Familiarity with managed database services, cloud storage, cloud monitoring, backup, recovery, and access management.
• •Awareness of cloud resource optimization, storage efficiency, and sustainable database operations.

Frameworks and Libraries

Essential

• •Experience working with SQL Server database tools, database drivers, stored procedures, functions, and application integration components.
• •Ability to evaluate database dependencies, interfaces, schema changes, and compatibility considerations.
• •Understanding of database connectivity and integration with software applications.

Preferred

• •Familiarity with database migration, deployment, testing, monitoring, or automation frameworks.
• •Experience with data-access libraries, ORM tools, ETL frameworks, or reporting components.
• •Exposure to reusable database-development standards and configuration-driven deployment practices.

Development Tools and Methodologies

Essential

• •Experience with database design, development, implementation, optimization, troubleshooting, and maintenance.
• •Ability to follow software development lifecycle, change-control, release, testing, and documentation practices.
• •Experience collaborating with cross-functional teams on database-related initiatives.
• •Ability to support incident inve