SS&C is a global provider of investment and financial services and software for the financial services and healthcare industries.
Named to Fortune 1000 list as top U.S. company based on revenue, SS&C is headquartered in Windsor, Connecticut and has 20,000 employees in over 90 offices in 35 countries.
Some 18,000 financial services and healthcare organizations, from the world's largest institutions to local firms, manage and account for their investments using SS&C's products and services.
Job Description Get To Know The Team : SS&C Technologies is seeking an experienced Senior Database Administrator to join our mainframe Db2 for z/OS Database Application Support team.
The ideal candidate will be a seasoned Senior DBA professional, have experience working directly with application development teams, and strong support skills troubleshooting Db2 for z/OS issues including performance.
This position will require off-hours availability and periodic 24 x 7 on-call rotation support.
Why You Will Love It Here Flexibility : Hybrid Work Model & a Business Casual Dress Code, including jeans Your Future: 401k 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 Diversity & Inclusion: Committed to Welcoming, Celebrating and Thriving on Diversity Training: Hands-On, Team-Customized, including SS&C University Extra Perks: Discounts on fitness clubs, travel and more What You Will Get To Do: Design and develop data storage systems, processes and enhancements for company's complex high traffic, business critical internet site communications and/or network-based (cloud) product systems.
Lead the design of enterprise storage environments, including enterprise storage arrays, fiber channel switches and Network Attached Storage (NAS) physical and virtual tape devices.
Develop solutions and processes for reliable and stable data storage management, security, backup, restoration, archiving and replication.
Assist with the implementation of new or additional storage technology to improve infrastructure service locally and remotely.
Lead small, moderately complex projects or working on complex tasks that require a high degree of judgement, resourcefulness, and self-initiative.
Demonstrate specialized expertise to evaluate wide-ranging and complex issues and develop creative solutions.
Recommend new procedures.
What You Will Bring: 7 years of overall IT experience on IBM mainframe, with 3 years on Db2 for z/OS Deep knowledge of Db2 for z/OS database components and concepts Proficient in Db2 for z/OS DDL, DML, DCL Mastery of IBM DB2 utilities: Unload, Load, REORG, Image Copy, RUNSTATS Ability to analyze, diagnose and resolve database issues and assist applications teams with database-related application issues.
Experience in evaluating, designing, and deploying high performance logical and physical database designs to support our application partners.
Experience managing and migrating database change requests from client teams and to meet project deadlines or resolve support issues Ability to analyze, test, and recommend new database features, functionality, and products that can yield improvements for the database environment Ability to perform database recoveries and support Disaster Recovery.
Excellent communication skills, written and interpersonal using all communications technology platforms available.
Experience with IBM Db2 Version 12.
Experience with IBM Db2 Administration Tool.
Experience with a database performance monitoring tools like Query Monitor, DB2 Explain, SQL Performance Analyzer, and access path evaluation.
SQL query development, performance analysis, and remediation skills.
Experience with mainframe data integration with cloud and other open environments.
REXX, ISPF, CLIST, or other database automation development skills/experience.
Experience with Data Studio, DSM, Native SQL Stored Procedures, User Defined Functions Experience with IBM Infosphere Data Replication (IIDR/CDC) Thank you for your interest in SS&C To further explore this opportunity, please apply through our careers page on the corporate website at www.ssctech.com/careers.
Rk-LI 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.