Senior Database Administrator

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.

• 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 Postgre
  
  SQL.
• 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 Mongo
  
  DB, including other No
  
  SQL 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 - $)

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.

• 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, Postgre
  
  SQL, Mongo
  
  DB) technologies…