At HUB International , we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees. As a global firm, we offer employees resources in both technology and industry expertise, but we still maintain the local flavor of our offices. Our structure enables our teams to maintain their own unique, regional culture while leveraging support and resources from our corporate centers of excellence.

　　HUB is the 5th largest global insurance and employee benefits broker, providing a boundaryless array of property, casualty, risk management, life and health, employee benefits, investment and wealth management products and services. With over 17,000 employees in more than 550 offices throughout North America, HUB has grown substantially, in part due to our industry leading success in mergers and acquisitions.

　　Job Description

　　This position will implement various DBA initiatives and assist with the administering & troubleshooting of our Production, Test, and Development SQL environment in order to support DB deployment, availability, growth, and upgrades.

　　Duties and Responsibilities:

　　Perform lead DBA role in implementing various SQL projects.

　　Coordinate with application owners, developers, and vendors to schedule application maintenance window, identify application tier support resource, perform end user test and validate application operational status.

　　Work with server team, security team, and backup team as needed to perform various VM server, security, and DR setup.

　　Work with the DBA manager to develop various project implementation strategies.

　　Provide build documentation and status updates as required by the DBA manager.

　　Provide administrative support to the SQL environment. Tasks include:

　　Install, monitor and support SQL server instances including various SQL components i.e. SSIS, SSRS, and SSAS.

　　Install, monitor, and support various SQL High Availability and Disaster Recovery solutions

　　DB migration (i.e., to new servers), DB user administration

　　Support client application installations

　　Create new databases and overwrite Test DBs with copies of Production DBs

　　Backup/recover/rollback production, test, and development DBs

　　Troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (i.e. SQL cluster, AlwaysOn, Log Shipping, DB replication) and other issues in production and development. Coordinate/implement production fixes, or advise the application owner/administrator/developer, as appropriate.

　　Monitor & manage data storage capacity of production and test/development SQL Servers to support DB growth; coordinate drive expansions with Operations & Change Management Team.

　　Complete and maintain inventory documentation of all SQL databases at the data center and cloud. Work with DB/application owners to update status and complete missing information.

　　Decommission DBs: proactively identify obsolete DBs, obtain DB owner’s approval, archive & delete DB.

　　Write T-SQL code and stored procedures to monitor, automate and support DBA tasks.

　　Required to be on-call for database support

　　Ready to multi-task as needed

　　Other duties as required.

　　Continue to learn new technical skills, to allow for expansion and progression of duties.

　　Nights, weekends, and non-regular hours may be required.

　　Qualification Requirements:

　　Four (4) year degree in Computer Science, Information Systems Management, or equivalent work experience

　　At least 3 to 5 years of experience in a DBA role

　　Experienced in troubleshooting database performance issues and SQL performance tuning

　　Experienced in T-SQL programming

　　Strong asset: PowerShell or other programming languages; Windows Server administration, experience working in Active Directory

　　Other assets: Experience working in AWS and Azure cloud

　　Accountable – takes ownership of responsibilities & tasks

　　Ability to follow established workflow/implementation processes, and apply creative solutions where needed

　　Ability to multi-task and prioritize deliverables/responsibilities

　　Ability to work independently and as part of a team

　　Ability to function under close deadlines with minimal supervision and under potentially stressful situations

　　Has a demonstrated desire and capacity to learn new technical skills

　　Good verbal & written communication skills

　　Travel to corporate office and/or hub locations, as needed

　　JOIN OUR TEAM

　　Do you believe in the power of innovation, collaboration, and transformation? Do you thrive in a supportive and client focused work environment? Are you looking for an opportunity to help build and drive change in a rapidly growing and evolving organization? When you join HUB, you will be part of a community of learners and doers focused on helping our leaders maximize the potential of their employees.

　　Disclosure required under applicable municipal regulations in NY and NJ, as well as the law in Colorado: The expected salary range for this position is $90K to $140K and will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. HUB International is proud to offer comprehensive benefit and total compensation packages which could include health/dental/vision/life/disability insurance, FSA, HSA and 401(k) accounts, paid-time-off benefits, and eligible bonuses, equity and commissions for some positions.

　　Department Information Technology

　　Required Experience: 2-5 years of relevant experience

　　Required Travel: Negligible

　　Required Education: Bachelor's degree (4-year degree)

　　HUB International Limited is an equal opportunity and affirmative action employer that does not discriminate on the basis of race/ethnicity, national origin, religion, age, color, sex, sexual orientation, gender identity, disability or veteran's status, or any other characteristic protected by local, state or federal laws, rules or regulations. The EEO is the Law poster and its supplement is available here athttp://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm.

　　EEOAA Policy

　　E-Verify Program

　　We endeavor to make this website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the US Recruiting Team toll-free at (844) 300-9193 [email protected]. This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.

　　Hi, we’re HUB.

　　In a rapidly changing world, we advise businesses and individuals on how to prepare for the unexpected.

　　When you partner with us, you're at the center of a vast network of experts who will help you reach your goals through risk services, claims management, and compliance support.

　　And this gives you the peace of mind that what matters most to you will be protected — through unrelenting advocacy and tailored insurance solutions that put you in control.

　　About HUB International

　　Headquartered in Chicago, Illinois, HUB International Limited (HUB) is a leading full-service global insurance broker providing property and casualty, life and health, employee benefits, investment and risk management products and services. From offices located throughout North America, HUB’s vast network of specialists provides peace of mind on what matters most by protecting clients through unrelenting advocacy and tailored insurance solutions. For more information, please visit hubinternational.com.