Grinnell Chamber

Database Administrator

Full time
Posted: 05/23/2024
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.

 

Key Responsibilities

  • Develop and review database policies
  • Backup and restore databases
  • Ensure availability of databases
  • Review and build stored procedures, functions, and views for optimum performance
  • Manage resources including the resource governor
  • Design and review schemas
  • Patch and configure SSMS, SSIS, and SSRS
  • Monitor, patch, and configure Quest Spotlight
  • Establish security and maintain parameters
  • Administer the data warehouse
  • Administer and maintain enterprise reporting systems
  • College computing systems integration

Requirements

Minimum Qualifications:

  • Bachelor’s degree and five years of experience in this related environment or an equivalent combination of education and experience.
  • 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 Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI.
  • 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.
  • Strong ability to adapt to changing situations
  • Champion of diversity, equity, and inclusion

Preferred Qualifications

  • Experience working with Azure SQL technology stack.

Copyright 2024 Grinnell Area Chamber of Commerce. All Rights Reserved