Job Description
SS&C Technologies is Hiring for Devops Engineer
Position: DevOps Engineer (PowerShell Specialist with SQL Server)
SS&C Advent, a global leader in automated solutions for investment professionals, seeks a proficient DevOps Engineer specializing in PowerShell and SQL Server. This full-time position offers an exciting opportunity to work in SS&C’s fast-paced environment, leveraging cutting-edge technologies (PowerShell, Jenkins, SQL Server 2019, PostgreSQL, MongoDB, Kubernetes) as part of a dynamic team supporting Advent Software’s Corporate and SaaS private cloud offerings.
Company Overview: SS&C is a Fortune 1000 company headquartered in Windsor, Connecticut, with over 20,000 employees across 90 offices in 35 countries. We provide investment and financial services and software to over 18,000 organizations globally, ranging from large institutions to local firms in financial services and healthcare industries.
Job Responsibilities:
- Develop new automation processes for 500+ production database servers to streamline troubleshooting and upgrades.
- Automate installation and configuration tasks using PowerShell for large-scale database server deployments.
- Enhance and manage existing automation frameworks to optimize efficiency and reduce manual efforts.
- Take ownership of and improve the DBA portal to support health checks, onboarding, monitoring, upgrades, and migration-related tasks.
- Provide production support for SQL Server, PostgreSQL, MongoDB, and Kubernetes environments.
- Participate in on-call rotation for production support during non-standard hours (3 PM IST to 12:30 AM IST) and weekends.
- Plan and execute schedules for database upgrades, migrations, and onboarding processes.
- Proactively monitor database performance using advanced monitoring and alerting tools.
- Investigate and resolve database outages, providing Root Cause Analysis (RCA) as needed.
- Mentor team members on best practices in automation scripting (PowerShell, Jenkins).
Qualifications:
- Proficiency in PowerShell scripting is essential.
- Experience with SQL Server, JavaScript, Jenkins, and .NET for automation deployments preferred.
- Demonstrated success in implementing complex automation processes.
- Strong problem-solving skills with a focus on delivering business solutions.
- Minimum of 2 years’ experience supporting client-facing production database servers.
- Bachelor’s degree in a related field.
- Excellent communication skills, including technical documentation experience.
- Proactive in updating skills through continuous learning and professional development activities.
Application Process: SS&C Technologies, Inc. does not accept unsolicited resumes from recruitment agencies. We offer competitive benefits, including health, dental, 401k, and professional development opportunities. SS&C is committed to equal employment opportunity and does not discriminate based on race, color, religion, gender, age, marital status, sexual orientation, national origin, disability, veteran status, or any other protected classification under applicable laws.