Hub International - Chicago, IL
posted 4 months ago
At HUB International, we are a team of entrepreneurs dedicated to empowering our clients by protecting businesses and individuals in our local communities. As the 5th largest global insurance and employee benefits broker, we provide a comprehensive array of services including property, casualty, risk management, life and health, employee benefits, investment, and wealth management products. Our structure allows our teams to maintain their unique regional culture while leveraging support from our corporate centers of excellence. The Database Administrator (DBA) position is crucial for implementing various DBA initiatives and assisting with the administration and troubleshooting of our Production, Test, and Development SQL environments. This role supports database deployment, availability, growth, and upgrades, ensuring that our SQL infrastructure is robust and efficient. The DBA will perform lead roles in implementing SQL projects, coordinating with application owners, developers, and vendors to schedule maintenance windows, and validating application operational status. In addition to these responsibilities, the DBA will work closely with server, security, and backup teams to manage VM server setups, security protocols, and disaster recovery strategies. The role requires providing administrative support to the SQL environment, which includes installing, monitoring, and supporting SQL server instances and various SQL components such as SSIS, SSRS, and SSAS. The DBA will also be responsible for database migrations, user administration, and troubleshooting connectivity and performance issues. This position requires a proactive approach to database management, including monitoring data storage capacity and maintaining inventory documentation of all SQL databases. The DBA will also be expected to write T-SQL code and stored procedures to automate and support DBA tasks, and will be required to be on-call for database support as needed.