Sql database administrator

The CompanyCrum & 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: positionWe 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 Core IT 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 ServerApply 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/ConfigurationConfigure and maintain MSSQL Security controls.Manage and Administer Database Maintenance PlansPerform MSSQL Server Activity MonitoringMonitor 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 possibleEngage with application stakeholders and development teams for database activities.Support application teams for any application/database upgradesProvide database support, including ad hoc data requests, database query, MSSQL profiling, index optimization, and stored procedure design.Work with C&F compliance team and Pw C for SOX audits. Meet with Pw C 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 (Service Desk 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 administrationDeep knowledge of MSSQL Server 2016, 2017, 2019 and 2022 databasesExperience with SSRS, SSIS, and SSAS.Experience in MSSQL Database design and creationFamiliarity with relational and dimensional data modellingExperience with MSSQL Server Transactional replicationUnderstanding of ETL processes and SSIS toolExpertise 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 Power ShellAbility to communicate effectively with senior IT managersStrong organizational and problem-solving skillsAbility to think creatively and analyticallyExperience in Azure/AWS or other cloud is a plus.Knowledge of Service Desk Plus, Jira, Confluence and Solar Winds a plus.Must be a team player