Lead Database Administrator

$79,500 - $155,000/Yr

Arthur J. Gallagher - Dallas, TX

Full-time - Mid Level

Dallas, TX

Insurance Carriers and Related Activities

About the position

The Lead Database Administrator at Gallagher Bassett is responsible for maintaining and optimizing Microsoft SQL Server databases to ensure their security, performance, and availability. This role involves collaborating with development teams, providing technical support, and participating in disaster recovery planning, contributing significantly to the company's operational success.

Responsibilities

• Install, configure, and maintain Microsoft SQL Server databases and related components.
• Monitor and optimize database performance, including index tuning, query optimization, and resource utilization.
• Ensure high availability and disaster recovery of databases through backup strategies, replication, and failover clustering.
• Support Shadowbase implemented to synchronize data between HPE NonStop and MSSQL environments.
• Administer database security measures, including user management, permissions, and roles, and ensure adherence to regulatory requirements and company policies.
• Develop and maintain documentation for database environments, processes, and procedures.
• Collaborate with development teams to design, implement, and troubleshoot database-related issues in applications.
• Provide technical support and training to end-users and other IT staff as needed.
• Plan and execute database migrations, upgrades, and decommissioning.
• Participate in an on-call rotation to support critical business operations and troubleshoot production issues.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• A minimum of 3 years of experience as a Database Administrator, specifically working with Microsoft SQL Server.
• In-depth knowledge of SQL Server architecture, T-SQL, and SQL Server Management Studio (SSMS).
• Experience with SQL Server performance tuning and optimization tools, such as Profiler, Execution Plans, and Extended Events.
• Experience with cloud-based SQL Server solutions, such as Azure SQL Database or Amazon RDS for SQL Server.
• Familiarity with High Availability (HA) and Disaster Recovery (DR) solutions for SQL Server, including Always On Availability Groups, Failover Clustering, and Log Shipping.
• Strong understanding of database security best practices, including encryption, auditing, and access controls.
• Proficient in Windows Server administration and PowerShell scripting.
• Excellent problem-solving, analytical, and communication skills.
• Ability to work independently and as part of a team, managing multiple tasks and deadlines.

Nice-to-haves

• Prior experience with MSSQL database administration is a must.
• Strong working knowledge of project tracking, reporting and management.
• Familiarity and experience using workload automation and job scheduling software.
• Experience in an environment that operates 24x7x365.

Benefits

• Medical/dental/vision plans, which start from day one!
• Life and accident insurance
• 401(K) and Roth options
• Tax-advantaged accounts (HSA, FSA)
• Educational expense reimbursement
• Paid parental leave
• Digital mental health services (Talkspace)
• Flexible work hours (availability varies by office and job function)
• Training programs
• Gallagher Thrive program - elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing
• Charitable matching gift program