Senior Database Administrator

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 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