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: . 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

Apply Now