The Company Crum & Forster (C&F), with a proud history dating to 1822, provides specialty and standard commercial lines insurance products through our admitted and surplus lines insurance companies. Approaching $5.7 billion in written premium as of 2024, C&F enjoys an “A” (Excellent) financial strength rating by A.M. Best. C&F is part of Fairfax Financial Holdings, a global organization with $33.3 billion in revenue as of 2024. Crum & Forster Services India (CFSI) is an India subsidiary of Crum & Forster Inc. The objective is to provide digital and IT services to C&F business units by creating autonomous squads focused on a specific product or a business team. For more information about Crum & Forster, please visit our website: www.cfins.com. The position We seek a highly motivated and experienced Database Administrator to be responsible for designing technical solutions and coordinating with the team to ensure timely and accurate implementations. The ideal candidate will be a self-starter who will work on designing, implementing, and maintaining MSSQL Database systems as well as numerous database and related projects. This role will provide Tier I & II support to Crum and Forster and its affiliates. Reporting to the Director of CoreIT MSSQL Database Administration, the ideal candidate is a MSSQL Database administrator with extensive knowledge and experience in managing numerous MSSQL environments. Key Responsibilities: Ensure database management and maintenance tasks are performed effectively. Install and configure MSSQL Server Apply MSSQL Server service packs and hotfixes. Ensure database patches are up to date. Perform installation, migration, and upgrade of databases. Manage MSSQL Agent job administration. Manage DB Mail Setup/Configuration Configure and maintain MSSQL Security controls. Manage and Administer Database Maintenance Plans Perform MSSQL Server Activity Monitoring Monitor Backup & Restore processes for all MSSQL databases. Monitor Space issues for all MSSQL server databases. Proactively monitor MSSQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible Engage with application stakeholders and development teams for database activities. Support application teams for any application/database upgrades Provide database support, including ad hoc data requests, database query, MSSQL profiling, index optimization, and stored procedure design. Work with C&F compliance team and PwC for SOX audits. Meet with PwC auditors to address any concerns. Secure database environments by developing policies, procedures, and controls such as data encryption, backup encryption, masking, minimum privilege. Prepare reports on database scalability and capacity planning as needed. Create standard database procedures to enhance scalability and the performance of existing database architecture. Identify and resolve database performance issues. Maintain database Disaster Recovery procedures to ensure continuous availability and speedy recovery of the database systems. Resolve day to day service requests (ServiceDesk Plus Tickets/Atlassian Jira tasks) Learn new database technologies and analyze such technologies to bring into scope of existing infrastructure. Responsible for maintaining 24/7 database availability. Follow weekly on call rotation. What are we looking for? Required Knowledge and Skills: 7+ years of experience in MSSQL server database administration Deep knowledge of MSSQL Server 2016, 2017, 2019 and 2022 databases Experience with SSRS, SSIS, and SSAS. Experience in MSSQL Database design and creation Familiarity with relational and dimensional data modelling Experience with MSSQL Server Transactional replication Understanding of ETL processes and SSIS tool Expertise in troubleshooting and performance monitoring MSSQL Server Database servers (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck, Capacity planning, etc.) Expertise in MS T-SQL and writing efficient stored procedures and MSSQL code. Experience in MSSQL Server upgrades, migration and consolidation. Experience in handling SOX applications. Experience with Solarwinds DPA is plus. Knowledge of PowerShell Ability to communicate effectively with senior IT managers Strong organizational and problem-solving skills Ability to think creatively and analytically Experience in Azure/AWS or other cloud is a plus. Knowledge of ServiceDesk Plus, Jira, Confluence and SolarWinds a plus. Must be a team player
The Company Crum & Forster (C&F), with a proud history dating to 1822, provides specialty and standard commercial lines insurance products through our admitted and surplus lines insurance companies. Approaching $5.7 billion in written premium as of 2024, C&F enjoys an A (Excellent) financial strength rating by A.M. Best. C&F is part of Fairfax Financial Holdings, a global organization with $33.3 billion in revenue as of 2024. Crum & Forster Services India (CFSI) is an India subsidiary of Crum & Forster Inc. The objective is to provide digital and IT services to C&F business units by creating autonomous squads focused on a specific product or a business team. For more information about Crum & Forster, please visit our website: www.cfins.com. The position We seek a highly motivated and experienced Database Administrator to be responsible for designing technical solutions and coordinating with the team to ensure timely and accurate implementations. The ideal candidate will be a self-starter who will work on designing, implementing, and maintaining MSSQL Database systems as well as numerous database and related projects. This role will provide Tier I & II support to Crum and Forster and its affiliates. Reporting to the Director of CoreIT MSSQL Database Administration, the ideal candidate is a MSSQL Database administrator with extensive knowledge and experience in managing numerous MSSQL environments. Key Responsibilities: Ensure database management and maintenance tasks are performed effectively. Install and configure MSSQL Server Apply MSSQL Server service packs and hotfixes. Ensure database patches are up to date. Perform installation, migration, and upgrade of databases. Manage MSSQL Agent job administration. Manage DB Mail Setup/Configuration Configure and maintain MSSQL Security controls. Manage and Administer Database Maintenance Plans Perform MSSQL Server Activity Monitoring Monitor Backup & Restore processes for all MSSQL databases. Monitor Space issues for all MSSQL server databases. Proactively monitor MSSQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible Engage with application stakeholders and development teams for database activities. Support application teams for any application/database upgrades Provide database support, including ad hoc data requests, database query, MSSQL profiling, index optimization, and stored procedure design. Work with C&F compliance team and PwC for SOX audits. Meet with PwC auditors to address any concerns. Secure database environments by developing policies, procedures, and controls such as data encryption, backup encryption, masking, minimum privilege. Prepare reports on database scalability and capacity planning as needed. Create standard database procedures to enhance scalability and the performance of existing database architecture. Identify and resolve database performance issues. Maintain database Disaster Recovery procedures to ensure continuous availability and speedy recovery of the database systems. Resolve day to day service requests (ServiceDesk Plus Tickets/Atlassian Jira tasks) Learn new database technologies and analyze such technologies to bring into scope of existing infrastructure. Responsible for maintaining 24/7 database availability. Follow weekly on call rotation. What are we looking for Required Knowledge and Skills: 7+ years of experience in MSSQL server database administration Deep knowledge of MSSQL Server 2016, 2017, 2019 and 2022 databases Experience with SSRS, SSIS, and SSAS. Experience in MSSQL Database design and creation Familiarity with relational and dimensional data modelling Experience with MSSQL Server Transactional replication Understanding of ETL processes and SSIS tool Expertise in troubleshooting and performance monitoring MSSQL Server Database servers (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck, Capacity planning, etc.) Expertise in MS T-SQL and writing efficient stored procedures and MSSQL code. Experience in MSSQL Server upgrades, migration and consolidation. Experience in handling SOX applications. Experience with Solarwinds DPA is plus. Knowledge of PowerShell Ability to communicate effectively with senior IT managers Strong organizational and problem-solving skills Ability to think creatively and analytically Experience in Azure/AWS or other cloud is a plus. Knowledge of ServiceDesk Plus, Jira, Confluence and SolarWinds a plus. Must be a team player Show more Show less
Crum & Forster Company Overview Crum & Forster (C&F) Crum & Forster (C&F), with a proud history dating to 1822, provides specialty and standard commercial lines insurance products through our admitted and surplus lines insurance companies. C&F enjoys a financial strength rating of A (Excellent) by AM Best and is proud of our superior customer service platform. Our claims and risk engineering services are recognized as among the best in the industry. Our most valuable asset is our people: more than 2000 employees in locations throughout the United States. The company is increasingly winning recognition as a great place to work, earning several workplace and wellness awards, including the October 2022 Great Place to Work Award for our employee-first focus and our steadfast commitment to diversity, equity and Inclusion. C&F is part of Fairfax Financial Holdings, a global, billion-dollar organization. For more information about Crum & Forster, please visit our website: www.cfins.com. The Position: We are looking for a Business Analyst having 5 to 9 years of strong experience working as a Business Analyst in the US P&C insurance industry, with a focus on Duck Creek Policy Administration System. The candidate should have In-depth knowledge and understanding of Commercial Lines & Personal Lines Products also having strong experience in Duck Creek Policy Administration System. Familiarity with insurance industry standards and best practices, including policy lifecycle, underwriting, rating. Relevant certifications in Duck Creek Policy Administration system would be a plus. Key Responsibilities: Work with Product Owner to conduct requirement elicitation, requirement gathering and documenting the requirements. To communicate and collaborate effectively with cross-functional teams and stakeholders at various levels. Track & maintained requirement specifications like BRD, FRD. Write user stories with clearly defined acceptance criteria and take care of backlog refinement. Participate in User Acceptance Testing along with Business/Ops users. Provide necessary support to Operations users in case of queries/issues reported in production. Work with Product Owner to perform backlog refinement and maintain Product Backlog. Required skills: Education: Bachelor's degree in computer science, Electrical/Electronic Engineering, Information Technology, or another related field or Equivalent Minimum of 5 Years of experience working in Duck Creek Policy Admin System. Strong analytical and problem-solving skills with the ability to conduct requirement elicitation, requirement gathering and documenting the requirements. Excellent communication and collaboration skills to work effectively with cross-functional teams and stakeholders at various levels. Ability to work independently with minimal supervision and manage multiple priorities in a fast-paced environment. Understand the Personal lines and commercial lines product. Strong understanding of rating, integrations, and Forms. Experience in working P&C Insurance domain is mandatory. Good at understanding and reviewing product requirements. Effective understanding of Business Analysis Process. Experience in delivering via Agile/Scrum methodology. Strong software development methodology understanding, and have assisted in the design, development or testing of a technology integration project. Strong problem solving and troubleshooting skills with the ability to exercise mature judgment. Strong analytical and technical skills. Should have good oral and written communication skills. Expertise in Jira tool. At C&F you will BELONG We value inclusivity and diversity. We are committed to equal employment opportunity and welcome everyone regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. If you require special accommodation, please let us know.
Crum & Forster Company Overview Crum & Forster (C&F), with a proud history dating to 1822, provides specialty and standard commercial lines insurance products through our admitted and surplus lines insurance companies. Approaching $4 billion in written premium as of 2021, C&F enjoys an A (Excellent) financial strength rating by A.M. Best. C&F is part of Fairfax Financial Holdings, a global organization with $23.8 billion in revenue as of 2021. Crum & Forster Services India (CFSI) is an India subsidiary of Crum & Forster Inc. The objective is to provide digital and IT services to C&F business units by creating autonomous squads focused on a specific product or a business team. For more information about Crum & Forster, please visit our website: www.cfins.com. The position We are seeking Full stack developers who have a real passion for technology, value life-long learning, and enjoy finding the right tool for the job. Applicants should be creative thinkers and strong problem solvers with meticulous attention to detail. As a Crum & Forster Full stack developer, you'll have the opportunity to be on the forefront of driving a major transformation with Crum & Forster. Key Responsibilities: Collaborate with and across Agile teams to design, develop test, implement, and support technical solutions in full-stack development tools and technologies. Collaborate with business users and product managers to collect project requirements in an organized and efficient way. Work with cloud native stack, build on AWS, use technologies like the Serverless framework and Amazon S3. Required Knowledge and Skills: At least 4+ years of experience. Familiarity with basic commands in Git. At least 2 year of experience with AWS, GCP. At least 4 years of experience in the following: JavaScript or TypeScript, Angular or React, Node.js. At least 4 years of experience with API designs, building and consuming REST web services, integration with databases. Familiarity building, testing, and deploying code using tools like AWS CodeBuild/CodeDeploy or Jenkins. Experience with server-side rendering frameworks (e.g. Nextjs). Experience with Postgres. Experience with AWS frameworks like serverless. At C&F you will BELONG We value inclusivity and diversity. We are committed to equal employment opportunity and welcome everyone regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. If you require special accommodation, please let us know.