Description

You will manage and maintain MS SQL Server databases and associated Access-based applications.

Responsibilities

• Develop and maintain MS SQL Server databases using Microsoft Master Data Services (MDS).
• Design and develop SSIS ETL packages to extract, transform, and load data into SQL Server 2014.
• Create database objects including tables, views, stored procedures, triggers, and functions using T-SQL.
• Integrate .NET front-end applications with SQL Server backends.
• Implement error handling, logging, and job scheduling via SQL Server Agent.
• Collaborate with developers, testers, and operations teams to resolve bugs and high-priority tickets.

Required Skills

• 5+ years of experience in database development and analysis.
• Proficiency in MS SQL Server Database management.
• Advanced T-SQL for creating complex database objects and maintaining efficiency.
• Experience with Microsoft Master Data Services (MDS).
• Hands-on experience designing and developing SSIS (ETL) packages.
• Ability to manage data integration using Inner and Outer Joins and index creation.
• Experience with SQL Server Agent for job scheduling.
• Bachelor’s degree in Computer Science or a related technical field.

Key Skills

Education

Bachelor’s degree its equivalent in Computer Science