Senior Database Engineer (MS SQL Server / SSIS)

Job Description – Senior Database Engineer (MS SQL Server / SSIS)

Job Title: Senior Database Engineer – MS SQL Server / SSIS

Experience: 3+ Years

Location: Banashankari, Bengaluru

Employment Type: Full-Time

Work Mode: Work from Office

Budget: 8 LPA

Samiteon is a global IT services and consulting company with over 20 years of industry experience, delivering innovative solutions across Salesforce, ERP, Data Science, ML/AI, custom application development, and staff augmentation services. The company serves clients across the US, India, UK, and Europe, with expertise spanning industries such as FinTech, Healthcare, Manufacturing, E-Commerce, and Education

Job Summary

We are seeking an experienced Senior Database Engineer with strong expertise in Microsoft SQL Server and SSIS (SQL Server Integration Services) to design, develop, optimize, and maintain enterprise-grade database solutions.

The ideal candidate should possess deep knowledge of SQL development, ETL processes, performance tuning, OLTP systems, and database optimization, along with the ability to translate complex business requirements into scalable and efficient database solutions.

Key Responsibilities

• Design, develop, and maintain complex stored procedures, functions, triggers, views, and SQL queries

• Develop and manage ETL workflows using SSIS

• Analyze and optimize existing SQL code for performance, scalability, and reliability

• Work closely with business stakeholders to understand requirements and convert them into technical database solutions

• Ensure data validation, data quality, and governance standards across systems

• Collaborate with application and frontend teams to provide required database objects and integrations

• Support and maintain OLTP systems ensuring high availability and transaction efficiency

• Troubleshoot database issues and resolve performance bottlenecks

• Participate in database schema design, indexing strategies, and normalization

• Monitor and optimize query execution plans, indexing, and resource utilization

• Maintain proper technical documentation for database processes, ETL workflows, and business logic

• Support release management and deployment activities for database changes

Mandatory Skills

• Strong hands-on experience with Microsoft SQL Server

• Expertise in SSIS (SQL Server Integration Services)

• Advanced proficiency in:

o Stored Procedures

o Functions

o Views

o Triggers

o Complex SQL Queries

• Strong experience in:

o SQL Performance Tuning

o Query Optimization

o Execution Plan Analysis

o Index Optimization

• Experience working with OLTP / transactional database systems

• Strong understanding of:

o Data Validation

o Data Quality

o Data Governance

• Ability to convert business requirements into optimized database solutions

• Strong troubleshooting and analytical skills

Good to Have Skills

• Experience with Azure SQL or cloud-based database platforms

• Understanding of Data Warehousing concepts

• Exposure to Power BI or reporting platforms

• Knowledge of CI/CD pipelines for database deployments

• Familiarity with application or commerce platforms

Qualifications

• Bachelor’s or Master’s degree in:

o Computer Science

o Information Technology

o Data Engineering

o Related technical field

Required Experience

• 3+ years of experience in SQL Server database development

• Strong enterprise-level experience in:

o Database Engineering

o SSIS Development

o Performance Optimization

o OLTP Systems

Key Competencies

• Strong analytical and problem-solving abilities

• Excellent communication and stakeholder interaction skills

• Ability to work independently and collaboratively

• Detail-oriented with strong focus on data accuracy and system performance

• Proactive and solution-driven mindset