Microsoft SQL Developer (SSIS Specialist)

13 Minutes ago • 5 Years + • $100,000 PA - $120,000 PA

Job Summary

Job Description

We are seeking a highly skilled 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, responsible for designing, developing, and maintaining robust data solutions. This role requires a proactive problem solver who can dive into complex codebases, identify root causes, and optimize performance across systems, supporting business-critical operations.
Must have:
  • Design, build, and optimize MS SQL and Sybase stored procedures, triggers, functions.
  • Set up and maintain MS SQL linked servers for cross-server data access.
  • Perform advanced SQL scripting for data manipulation and reporting.
  • Develop, modify, and troubleshoot complex SSIS packages for ETL.
  • Configure and manage MS SQL Agent Jobs for scheduled data operations.
  • Set up and maintain Windows Task Scheduler jobs for automation.
  • Write and maintain Windows batch scripts for process orchestration.
  • Configure OS-level ODBC data sources for external connectivity.
  • Analyze and resolve errors in complex code and system behavior.
  • Monitor and tune performance of queries and processes.
  • 5+ years in MS SQL Server and Sybase database development.
  • Proficiency in T-SQL, stored procedures, triggers, and functions.
  • Hands-on SSIS package development and maintenance experience.
  • Familiarity with linked server 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.
Perks:
  • Hybrid Work Model
  • Business Casual Dress Code, including jeans
  • 401 (k) Matching Program
  • Professional Development Reimbursement
  • Flexible Personal/Vacation Time Off
  • Sick Leave
  • Paid Holidays
  • Medical
  • Dental
  • Vision
  • Employee Assistance Program
  • Parental Leave
  • Committed to Celebrating the Variety of Backgrounds, Talents, and Experiences of Our Employees
  • Hands-On, Team-Customized Training, including SS&C University
  • Discounts on fitness clubs, travel, and more!

Job Details

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.

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Union, New Jersey, United States

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

As a leading financial services and healthcare technology company based on revenue, SS&C is headquartered in Windsor, Connecticut, and has 27,000+ employees in 35 countries. Some 20,000 financial services and healthcare organizations, from the world's largest companies to small and mid-market firms, rely on SS&C for expertise, scale, and technology.

Denver, Colorado, United States (Hybrid)

Union, New Jersey, United States (Hybrid)

Bangkok, Thailand (Hybrid)

Bucharest, Bucharest, Romania (On-Site)

Kansas City, Missouri, United States (Hybrid)

Pune, Maharashtra, India (On-Site)

Dublin, Ohio, United States (On-Site)

Union, New Jersey, United States (On-Site)

Waltham, Massachusetts, United States (On-Site)

View All Jobs

Get notified when new jobs are added by SSC Technologies

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug