Engineering Tech Lead, Network and Infrastructure Automation
Freddie Mac
AnsibleJenkinsPython
SQL Developer, SSIS Specialist
SS&C Technologies
full-time
Posted on:
Location Type: Hybrid
Location: Union • New Jersey, New York • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
ETLMS SQL ServerSQLSSIS
About the role
- 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
- 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
- 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
- Configure ODBC data sources at the OS level to support external data connectivity
- Ensure seamless integration between internal databases and third-party systems
- Analyze code and system behavior to identify and resolve errors or unexpected outcomes
- Monitor performance and implement tuning strategies for queries and processes
Requirements
- 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
Benefits
- Flexibility : Hybrid Work Model and 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
- Discounts on fitness clubs, travel, and more!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
MS SQL ServerSybaseT-SQLstored procedurestriggersfunctionsSSISETLWindows batch scriptingODBC
Soft skills
problem-solvingcommunication
