Share this Job
Apply now »

Database Administrator (DBA)

84212

Zurich is currently searching for a Database Administrator to join our Enterprise Data Management team supporting our multi-terabyte Data Warehouse. This position will be based out of our North American headquarters in Schaumburg, IL.  

 

This position will be part of an Enterprise Data Management Team that will be responsible for leveraging the value of the data assets throughout the organization and will facilitate the development/implementation of the desired end-state data environment.  The Enterprise Data Management Team will also be responsible for improving the organization's decision-making capabilities by providing high quality, transparent data within the data applications as well as data warehouse and associated data marts.

 

The Database Administrator will build, monitor, maintain and operationally support our Yellowbrick data warehouse, in conjunction with other relational databases.  This role will work with data modelers, data engineers, application owners and infrastructure teams.

 

Responsibilities may include, but not necessarily limited to, the following:

 

  • Optimizes and tunes database systems, such as Yellowbrick, SQL Server, DB2 and Oracle.
  • Pro-actively monitors performance and capacity.
  • Performance tuning & query optimization.
  • Ensures adherence of storage, archiving, and back-up recovery procedures.
  • Backup recovery testing of recovery procedures and archiving databases.
  • Disaster recovery testing.
  • Database replication.
  • Troubleshoots database issues and performs database impact analysis for proposed changes.
  • Controls access permissions and privileges.
  • Alter tables and schema structure as required.
  • Works with the application development teams to develop stored procedures, triggers, and code to support enterprise applications, as well as to enforce coding standards.
  • Executes database release management processes and coordinates maintenance of development, testing and production environments.
  • Create physical database from the logical model, ensuring that all standards and guidelines are followed.

 

Basic Qualifications: 

 

  • Bachelor’s Degree and 7 or more years of experience in the Application Design and Development area
    OR
  • High School Diploma or Equivalent and 9 or more years of experience in the Application Design and Development area     

 

Preferred Qualifications: 

 

  • Experience in administering multi-terabyte databases (PostgreSQL, Yellowbrick, DB2, SQL Server, Oracle)
  • Proficiency with SQL, PL/SQL, PL/pgSQL, UNIX Shell, PowerShell, PERL.
  • Experience in administering a multi-terabyte data warehouse is preferred.
  • Strong communication skills and ability to work effectively across multiple business and technical teams.
  • Ability to thrive in a fast-paced, tight deadline delivery timeline.
  • Aptitude to independently learn new technologies


As a condition of employment at Zurich, employees must adhere to our COVID-related health and safety protocols (https://www.zurichna.com/careers/faq), including, without limitation, a requirement that employees attest as to their vaccination status with a YES/NO, and upload proof of vaccination status, or negative COVID test results when allowable, to a third-party vendor. These are continuously re-evaluated and the requirements may change at any time.  
 
A future with Zurich. What can go right when you apply at Zurich?

 

Now is the time to move forward and make a difference. At Zurich, we want you to share your unique perspectives, experiences and ideas so we can grow and drive sustainable change together. As part of a leading global organization, Zurich North America has over 150 years of experience managing risk and supporting resilience. Today, Zurich North America is a leading provider of commercial property-casualty insurance solutions and a wide range of risk management products and services for businesses and individuals. We serve more than 25 industries, from agriculture to technology, and we insure 90% of the Fortune 500®. Our growth strategy is not limited to our business. As an employer, we strive to provide ongoing career development opportunities, and we foster an environment where voices are diverse, behaviors are inclusive, actions drive equity, and our people feel a sense of belonging. Be a part of the next evolution of the insurance industry. Join us in building a brighter future for our colleagues, our customers and the communities we serve. Zurich maintains a comprehensive employee benefits package for employees as well as eligible dependents and competitive compensation. Please click here to learn more.
 
As a global company, Zurich recognizes the diversity of our workforce as an asset. We recruit talented people from a variety of backgrounds with unique perspectives that are truly welcome here. Taken together, diversity and inclusion bring us closer to our common goal: exceeding our customers’ expectations. Zurich does not discriminate on the basis of age, race, ethnicity, color, religion, sex, sexual orientation, gender expression, national origin, disability, protected veteran status or any other legally protected status. EOE disability/vet 
 
Zurich does not accept unsolicited resumes from search firms or employment agencies. Any unsolicited resume will become the property of Zurich American Insurance. If you are a preferred vendor, please use our Recruiting Agency Portal for resume submission. 
 
Location(s): AM - Schaumburg
Remote Working: No
Schedule: Full Time
 
Linkedin Recruiter Tag: #LI-MD1 


Nearest Major Market: Chicago

Apply now »