SQL Database Administrator

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