Microsoft SQL Developer (SSIS Specialist)

Union, OH - USA

Monthly Salary: $ 120000 - 120000

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

As a leading financial services and healthcare technology company based on revenue SS&C is headquartered in Windsor Connecticut and has 27000 employees in 35 countries. Some 20000 financial services and healthcare organizations from the worlds largest companies to small and mid-market firms rely on SS&C for expertise scale and technology.

Job Description

Job Title: Microsoft SQL Developer (SSIS Specialist)

Location: Union NJ (Hybrid)

Get To Know Us:

We are seeking a highly skilled and detail-oriented Microsoft SQL Developer with deep experience in SQL scripting database architecture and ETL processes using SSIS. The ideal candidate will have a strong background in both MS SQL Server and Sybase and will be responsible for designing developing and maintaining robust data solutions that support business-critical operations. This role requires a proactive problem solver who can dive into complex codebases identify root causes and optimize performance across systems.

Why You Will Love It Here!

Flexibility: Hybrid Work Model and Business Casual Dress Code including jeans

Your Future: 401 (k) Matching Program Professional Development Reimbursement

Work/Life Balance: Flexible Personal/Vacation Time Off Sick Leave Paid Holidays

Your Wellbeing: Medical Dental Vision Employee Assistance Program Parental Leave

Wide-Ranging Perspectives: Committed to Celebrating the Variety of Backgrounds Talents and Experiences of Our Employees

Training: Hands-On Team-Customized including SS&C University

Extra Perks: Discounts on fitness clubs travel and more!

What You Will Get To Do:

Database Development & Maintenance:

Design build and optimize stored procedures triggers and functions in MS SQL and Sybase environments

Set up and maintain MS SQL linked servers and develop scripts that leverage cross-server data access

Perform advanced SQL scripting for data manipulation transformation and reporting

ETL & SSIS Package Management:

Develop modify and troubleshoot SSIS packages for complex ETL workflows

Review and enhance package logic configuration and performance

Collaborate with stakeholders to ensure data pipelines meet business requirements

Automation & Scheduling:

Configure and manage MS SQL Agent Jobs for scheduled tasks and data operations

Set up and maintain Windows Task Scheduler jobs for auxiliary automation

Write and maintain Windows batch scripts for file handling and process orchestration

System Integration & Connectivity:

Configure ODBC data sources at the OS level to support external data connectivity

Ensure seamless integration between internal databases and third-party systems

Troubleshooting & Optimization:

Analyze code and system behavior to identify and resolve errors or unexpected outcomes

Monitor performance and implement tuning strategies for queries and processes

What You Will Bring:

5 years of experience in MS SQL Server and Sybase database development

Strong proficiency in T-SQL stored procedures triggers and functions

Hands-on experience with SSIS package development and maintenance

Familiarity with linked server configurations and cross-server scripting

Experience with SQL Agent Jobs and Windows Task Scheduler

Basic knowledge of Windows batch scripting and ODBC setup

Proven ability to analyze and debug complex codebases

Excellent problem-solving and communication skills

#LI-DS3

#LI-Hybrid

Unless explicitly requested or approached by SS&C Technologies Inc. or any of its affiliated companies the company will not accept unsolicited resumes from headhunters recruitment agencies or fee-based recruitment services.

SS&C offers excellent benefits including health dental 401k plan tuition and professional development reimbursement plan.

SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race color religious creed gender age marital status sexual orientation national origin disability veteran status or any other classification protected by applicable discrimination laws.

Salary is determined by various factors including but not limited to relevant work experience job related knowledge skills abilities business needs and geographic regions.

NY: Salary range for the position: 100000.00 USD to 120000.00 USD.

Required Experience:

Unclear Seniority