Grinnell Chamber

Database Administrator

Full time
Posted: 10/29/2020
Grinnell, IA
Human Resources

Description

The Database Administrator (DBA) is one of two such positions responsible for providing technical support for the enterprise database environment including overseeing the development, organization, and integration of databases; the assessment and implementation of new database-related technologies; and providing Information Technology Services (ITS) with a long-term perspective on the relationship of database technology to operational opportunities. The incumbent will strive to ensure that the college’s database systems offer the highest levels of reliability, security, business continuity, and performance possible. The DBA works collaboratively to help achieve an environment that meets current, and prepares for future, business objectives and security requirements. They will train technical support and applications staff to use on-line processing databases and environments to their maximum effect; provide and support tools to assist in the management of the database and transaction processing environment; provide a working model of the college’s transaction processing environment for capacity assessment and planning; and support the integration of campus systems with the Operational Data Store and data warehouse.

Requirements

Minimum Qualifications: Five years of experience or an equivalent combination of education and experience

Preferred Qualifications

  • Experience working with outside vendors and consultants.
  • Knowledge and experience with MySQL.
  • In-depth understanding of data warehouse and business intelligence tools, technologies, architecture, and trends in data and information management.
  • Capacity to think broadly and creatively as a problem solver; collaboratively develop and implement plans; and to convey enthusiasm.
  • Ability to work well independently and collegially in a team environment with a variety of people.
  • Ability to analyze a problem and devise a programmatic solution.
  • Knowledge and experience with Extract, Transform, and Load (ETL) processes.
  • Knowledge and experience with relational databases.
  • Knowledge and experience with reporting and business intelligence platforms.
  • Knowledge and experience working with Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
  • Knowledge and experience working with dimensional modeling and star schema methodology.
  • Experience working with outside vendors and consultants.
  • Demonstrated customer service orientation.
  • Excellent written and verbal communications skills.

Copyright 2021 Grinnell Area Chamber of Commerce. All Rights Reserved