at Hub International in Chicago, Illinois, United States
Job Description
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, SQ
