AmTrust Financial Services, Inc. · 21 hours ago
Senior Database Administrator
AmTrust Financial Services, Inc. is seeking a highly skilled SQL Server Database Administrator to manage complex database environments. The role involves ensuring high availability, implementing disaster recovery strategies, and optimizing database performance while supporting various lines of business within the organization.
FinanceFinancial ServicesInsurance
Responsibilities
Installing and configuring SQL Server instances on a cluster environment. Creating and managing Always-On AG for critical databases between datacenters
Responsible for troubleshooting and resolving Cluster issues, WSFC, different failover modes and read-only replicas to ensure High Availability and DR
Implement, monitor, and maintain housekeeping and optimization jobs, ensuring peak performance of all SQL Servers including Performance Tuning recommendations
Proficient in T-SQL and Powershell scripting, using monitoring tools to track database health and performance. Working closely with application developers, system and network admins to ensure seamless database operations
Manages database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and integrity constraints in accordance with the existing Software Change Management processes
Monitors database and replication servers for resource utilization. Handles testing, reporting, backup/restore. Manages database distribution, security, and access requirements
Provide support to all lines of business and all departments with their specific or customized SQL solutions for On-Prem and Azure including PostgreSQL
Ensure that all SQL Servers are operating within a secure environment and that AmTrust’s disaster recovery requirements are always met
Implement, maintain and regularly review security and related data access rights within the AmTrust’s SQL Server environment to support Audits. Sets up access privileges to databases. Creates and maintains user profiles for database access, including login and password. Performs backup and recovery, configures database parameters
Provide support to non-relational database systems like MongoDB, including other NoSQL databases like Cosmos DB, Redis
Performing month end close processes, Patching and Other Maintenance outside normal business hours as part of On-Call Off hour support
Maintaining SQL security standards and policies
Providing support, training, and knowledge transfer with other members of the team
Own strategy around the data warehouse in terms of system monitoring, capacity planning, disaster recovery, and architecture
Monitor and optimize query performance and data processing workflows within Azure Synapse Analytics to meet business requirements
Performs other functionally related duties as assigned
Qualification
Required
Possess a bachelor's degree or higher from an accredited college or university in Engineering, Computer Science, or Information Technology
8+ years of hands-on experience working with database (Microsoft (2016, 2019 and 2022), Azure, PostgreSQL, MongoDB) technologies and excellent multitasking skills and task management strategies and managing SQL Server Always-On Availability Groups for High Availability and Disaster Recovery
Proficiency in Backup and Recovery, SQL query optimization, data warehousing concepts, and performance tuning
Ability to analyze SQL Server Performance metrics (cpu, memory, disk i/o, and n/w) and query store to identify performance bottlenecks and optimize queries, indexes, and execution plans
Ability to do performance tuning and database development and to perform system monitoring and address various issues in the system with expert knowledge of SQL monitoring software (Quest Foglight /SolarWinds DPA/ SQL Diagnostic Manager)
Understanding of Relational, Virtualization, Data Lake/Warehouse, In-Memory and Azure Cloud Data Platforms along with AWS and GCP
Understanding of various relational and non-relational database technologies for on-prem and cloud along with their benefits, downsides, and best use-case
Experience in designing and architecting end-to-end analytics solutions in Azure Synapse
Experience in designing and orchestrating data pipelines to load data efficiently in Synapse dedicated SQL Pool
Experience in Azure Data Lake, Azure Data Factory, Azure data flow, Azure functions and Databricks
Experience with Logical and Physical data modelling
Preferred
A master's degree can serve as a substitute for some experience
Certified Microsoft Database Administration, ITIL Certification
Azure DP-300 Certification
Benefits
Medical & Dental Plans
Life Insurance, including eligible spouses & children
Health Care Flexible Spending
Dependent Care
401k Savings Plans
Paid Time Off
Company
AmTrust Financial Services, Inc.
AmTrust Financial Services, Inc., through its subsidiaries, operates as a multinational property and casualty insurance company.
H1B Sponsorship
AmTrust Financial Services, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2023 (3)
2022 (5)
Funding
Current Stage
Public CompanyTotal Funding
unknown2006-11-13IPO
Leadership Team
Recent News
2025-11-07
2025-11-05
Company data provided by crunchbase