MS SQL Database Developer | OLTP & OLAP, Performance Tuning, High Availability, Data Migration

Location: Bengaluru - Bellandur (GTP)

Time Type: Full time

Job Description

Job Summary
Synechron is seeking an experienced MS SQL Database Developer to join our data management team. In this role, you will design, develop, and optimize enterprise-level SQL Server solutions for both OLTP and OLAP environments. Your expertise will support high-availability, secure, and scalable data systems that drive critical business insights and operational efficiency. You will work collaboratively with cross-functional teams to implement best practices, enhance performance, and ensure data integrity across a broad range of projects.

Software Requirements

• Required: MS SQL Server (2016, 2019 or later), SQL Management Studio, SQL Profiler, T-SQL, Windows Server, Backup/Restore tools

• Preferred: Azure SQL Database, SQL Server Always On, Database Migration tools, DataETL tools (SSIS, Data Factory)

• Experience level: 5+ years of direct experience in SQL Server database development, performance tuning, and high-availability configurations

Overall Responsibilities

• Design, implement, and manage MS SQL Server databases supporting OLTP and OLAP workloads

• Develop and optimize complex stored procedures, triggers, views, and functions to support transactional and analytical processes

• Perform query tuning, indexing, partitioning, and other optimization techniques to enhance database performance and scalability

• Support data integration workflows, ETL processes, and data migration activities

• Ensure data security, quality, and compliance through proper configuration, auditing, and access controls

• Manage backup and recovery strategies to ensure high database availability and disaster recovery readiness

• Collaborate with development teams to support application performance and resolve database-related bottlenecks

• Maintain comprehensive documentation for database schemas, procedures, and operational standards

Technical Skills (By Category)

• Programming Languages:

  • Essential: T-SQL, SQL scripting, Transact-SQL programming

  • Preferred: PowerShell, Python (for automation and scripting)

• Databases/Data Management:

  • SQL Server (2016/2019+), database schema design, normalization, scalability, and indexing strategies

  • Experience with NoSQL solutions such as MongoDB is a plus

• Cloud Technologies:

  • Basic familiarity with cloud-based SQL services like Azure SQL Database (preferred)

• Frameworks and Libraries:

  • Not applicable; focus on SQL and database administration tools

• Development Tools & Methodologies:

  • SQL Server Management Studio, SQL Profiler, Data Migration tools, Agile methodologies, automated deployment practices

• Security & Compliance:

  • Implementation of role-based access control, auditing, encryption, and compliance standards (e.g., GDPR, HIPAA)

Experience Requirements

• 5+ years of experience designing, developing, and optimizing MS SQL Server databases

• Proven expertise in performance tuning, indexing, and query optimization for large-scale databases

• Hands-on experience implementing high-availability solutions such as Always On, replication, or clustering

• Experience working with OLTP and OLAP databases in enterprise environments

• Industry experience in finance, healthcare, or large-scale enterprise sectors is a plus; alternative backgrounds acceptable

Day-to-Day Activities

• Develop, implement, and optimize SQL Server database schemas, procedures, and functions

• Monitor database performance, analyze workload, and perform query tuning and indexing

• Support data migration, ETL processes, and data warehouse activities

• Configure and maintain high-availability, backup, and disaster recovery solutions

• Troubleshoot and resolve database performance issues, deadlocks, and security concerns

• Collaborate with application developers, BI teams, and data analysts to meet project requirements

• Document database structures, configurations, and operational procedures

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field; equivalent work experience accepted

• 5+ years of professional experience in enterprise MS SQL Server database development and management

• Certifications such as Microsoft Certified: Azure Database Administrator Associate or similar are advantageous

• Strong expertise in query tuning, performance optimization, and high-availability configurations

• Excellent analytical and problem-solving skills, with attention to detail

• Ability to work independently and collaboratively within a team environment

Professional Competencies

• Critical thinking with a focus on performance and security optimizations

• Strong communication skills to optimize stakeholder engagement and documentation

• Ownership attitude and proactive approach for continuous improvement

• Adaptability to evolving data environments and enterprise standards

• Ability to prioritize tasks effectively and manage multiple projects efficiently

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice