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.
Database Management
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.
Security and Compliance
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.
Non-Relational Databases
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.
Data Warehouse and Analytics
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.
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.
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.