Senior SQL & Data Platform Architect (Hybrid)

Overview Highly skilled SQL Server Database Administrator with extensive experience in designing, implementing, installing, and managing complex large scale database environments. Proven experience in ensuring high availability, implementing robust disaster recovery strategies, and optimizing database performance monitoring. Proficient in Always-On Availability Groups, Windows Clusters, Query Optimization, Index design, and troubleshooting complex database performance issues by recommending fixes and tuning complex SQL queries. To assist with the day-to-day support of all AmTrust SQL servers and databases. Administering and supporting all SQL servers and databases within the organization (On-Prem and Azure). Working with DBA team to support all lines of business and all departments with their specific or customized SQL solutions. Providing support and training to other members of the DBA team. Maintains a solid understanding of AmTrust’s mission, vision, and values. Upholds the standards of the AmTrust organization. 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. The expected salary range for this role is ($87,600.00 - $125,000.00) Please note that the salary information shown above is a general guideline only. Salaries are based upon a wide range of factors considered in making the compensation decision, including, but not limited to, candidate skills, experience, education and training, the scope and responsibilities of the role, as well as market and business considerations.

#LI-IT1

#LI-HYBRID

#AmTrust Qualifications 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 What We Offer AmTrust Financial Services offers a competitive compensation package and excellent career advancement opportunities. Our benefits include: Medical & Dental Plans, Life Insurance, including eligible spouses & children, Health Care Flexible Spending, Dependent Care, 401k Savings Plans, Paid Time Off. AmTrust strives to create a diverse and inclusive culture where thoughts and ideas of all employees are appreciated and respected. This concept encompasses but is not limited to human differences with regard to race, ethnicity, gender, sexual orientation, culture, religion or disabilities. AmTrust values excellence and recognizes that by embracing the diverse backgrounds, skills, and perspectives of its workforce, it will sustain a competitive advantage and remain an employer of choice. Diversity is a business imperative, enabling us to attract, retain and develop the best talent available. We see diversity as more than just policies and practices. It is an integral part of who we are as a company, how we operate and how we see our future. #J-18808-Ljbffr AmTrust Financial