Database Architect/Engineer

<strong class="jdheader">Introduction</strong><br><br><div class="ewa-rteLine"><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what’s right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you’ll find more than a job; you’ll find a culture built on trust, driven by collaboration, and sustained by the belief that we’re better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you’ll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you’re encouraged to be yourself, supported to succeed, and inspired to keep learning. That’s what it means to live The Gallagher Way.</span></div> <br><strong class="jdheader">Overview</strong><br><br><p style="margin-bottom: 13.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">The SQL Server Database Architect/Engineer will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.</span></p><p style="margin-bottom: 13.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.</span></p> <br><strong class="jdheader">How you'll make an impact</strong><br><br><ul><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Refine and automate regular processes, track issues, and document changes</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Assist developers with complex query tuning and schema refinement.</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Perform scheduled maintenance and support release deployment activities after hours.</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.</span></li></ul> <br><strong class="jdheader">About You</strong><br><br><p style="margin: 0px;"><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Required:</span><br><br></p><ul><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Bachelor's degree in engineering and related fields</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">5+ years MS SQL Server Administration experience required</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with backups, restores and recovery models</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with Failover clustering and SAN replication</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with SQL Server merge, peer to peer, or transactional replication</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with LINQ, Entity Framework, NHibernate, or other ORMs</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with Service Broker</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience with Analysis Services, Integration Services, or Reporting Services</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Writing T-SQL from scratch, C# code, or generally building anything from scratch</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Troubleshooting application logic or why numbers don’t add up in a report</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Experience working with Windows server, including Active Directory</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Excellent written and verbal communication</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Flexible, team player, “get-it-done” personality</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Ability to organize and plan work independently</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Ability to work in a rapidly changing environment</span></li><li style="margin: 0in 0in 10.15pt 22.5pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: #303030;">Ability to multi-task and context-switch effectively between different activities and teams</span></li></ul> <br><strong class="jdheader">Compensation and benefits</strong><br><br><p style="margin-bottom: 8.0pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: black;">We offer a competitive and comprehensive compensation package. The base salary range represents the anticipated low end and high end of the range for this position. The actual compensation will be influenced by a wide range of factors including, but not limited to previous experience, education, pay market/geography, complexity or scope, specialized skill set, lines of business/practice area, supply/demand, and scheduled hours. On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.  </span></p><p style="margin-bottom: 8.0pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: black;">Below are the <strong>minimum core benefits</strong> you’ll get, depending on your job level these benefits may improve: </span></p><ul><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Medical/dental/vision plans, which start from day one!</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Life and accident insurance</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">401(K) and Roth options</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Tax-advantaged accounts (HSA, FSA)</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Educational expense reimbursement</span></li><li><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif;">Paid parental leave</span></li></ul><p style="margin: 0px;"><strong><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Other benefits include:</span></strong></p><ul><li><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Digital mental health services (Talkspace)</span></li><li><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Flexible work hours (availability varies by office and job function)</span></li><li><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Training programs</span></li><li><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing</span></li><li><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Charitable matching gift program</span></li><li><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">And more...</span></li></ul><p style="margin: 0px;"><em><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">**The benefits summary above applies to fulltime positions. If you are not applying for a fulltime position, details about benefits will be provided during the selection process.</span></em></p><p style="margin: 0px;"> </p><p style="margin: 0px;"><strong style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span>We value inclusion and diversity</span></strong></p><p style="margin-bottom: 8.0pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><a href="https://www.isrvr.com/is/DigitalAssets/EligiblityRequirements/index.html" target="_blank" rel="noopener">Click Here</a> <span style="color: black;">to review our U.S. Eligibility Requirements</span></span></p><p style="margin-bottom: 8.0pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: black;">Inclusion and diversity (I&D) is a core part of our business, and it’s 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. </span></p><p style="margin-bottom: 8.0pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: black;">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.</span></p><p style="margin-bottom: 8.0pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: black;">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. </span></p><p style="margin-bottom: 8.0pt;"><span style="font-size: 10pt; font-family: arial, helvetica, sans-serif; color: black;">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.</span></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...