Gallagher
Database Administrator
Gallagher, Rolling Meadows, Illinois, United States, 60008
Introduction :
Join our growing team of dedicated professionals at Gallagher Bassett, who guide those in need to the best possible outcomes for their health and wellbeing. You'll be part of a resilient team that works together to redefine the boundaries of excellence. At our organization, we value collaboration and making a positive impact in the lives of our clients and claimants, offering you the opportunity to join a team where your skills and dedication can truly make a difference. GUIDE. GUARD. GO BEYOND.
We believe that every candidate brings something special to the table, including you! So, even if you feel that youre close but not an exact match, we encourage you to apply.
Overview :
Gallagher Bassett, a division of Arthur J. Gallagher & Co, is seeking a highly skilled and experienced MSSQL Database Administrator to join our growing team. As a MSSQL Database Administrator, you will play a crucial role in maintaining and optimizing our company's Microsoft SQL Server databases, ensuring their security, performance, and availability. Your expertise will contribute to the ongoing success of our business operations.
How you'll make an impact :
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.
About you : Knowledge, Skills and Abilities: 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. Credentials and Experience: Typically requires a Bachelor's degree and 3+ years of experience in database analysis and physical database design. Equivalent professional experience may be substituted in lieu of education. 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 #LI-NP1 Compensation and benefits : On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the
minimum core benefits
youll get, depending on your job level these benefits may improve: 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 Other benefits include: 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 And more... We value inclusion and diversity Click Here to review our U.S. Eligibility Requirements Inclusion and diversity (I&D) is a core part of our business, and its embedded into the fabric of our organization. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work. Gallagher embraces our employees diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest. Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as protected characteristics) by applicable federal, state, or local laws. Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.
About you : Knowledge, Skills and Abilities: 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. Credentials and Experience: Typically requires a Bachelor's degree and 3+ years of experience in database analysis and physical database design. Equivalent professional experience may be substituted in lieu of education. 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 #LI-NP1 Compensation and benefits : On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the
minimum core benefits
youll get, depending on your job level these benefits may improve: 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 Other benefits include: 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 And more... We value inclusion and diversity Click Here to review our U.S. Eligibility Requirements Inclusion and diversity (I&D) is a core part of our business, and its embedded into the fabric of our organization. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work. Gallagher embraces our employees diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest. Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, color, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non-conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as protected characteristics) by applicable federal, state, or local laws. Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.