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
