Database Administrator (Full-time, 12 months, P4 Career Level, Exempt)
Grinnell College

Job Info

---

Job Title:

Database Administrator (Full-time, 12 months, P4 Career Level, Exempt)

Department:

Information Technology Service

Job Summary:

ABOUT GRINNELL COLLEGEGrinnell College is a private liberal arts college located in Grinnell, Iowa and is ranked #11 on the U.S. News and World Report's list of Best National Liberal Arts Colleges. Grinnell College is a top ranked Liberal Arts institution that values diversity, equity, inclusion, social justice, intellectual freedom, and social responsibility. We seek candidates that align with these values and have the ability and desire to advance our values and belonging within our community and the communities we engage. Ideal candidates will be prepared to collaborate and contribute to the mission and values of the college across all constituencies. POSITION SUMMARYThe 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

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.

Link to Job Description:

Database Administrator

FLSA Category:

Exempt

Staff/Faculty:

Staff

Employment Status:

Full-Time

Employment Category:

Regular

Special Instructions to Applicants:

Selected candidate must successfully pass a background check prior to first day of employment.

Open Until Filled:

No

Posting Number:

S01038

Diversity Statement:

Grinnell College is committed to establishing and maintaining a safe and nondiscriminatory educational and working environment for all College community members. It is committed to a policy of nondiscrimination in matters of admission, employment, and housing, and in access to and participation in its education programs, services, and activities. The College does not discriminate on the basis of race, color, ethnicity, national origin, age, sex, gender, sexual orientation, gender identity or expression, marital status, veteran status, pregnancy, childbirth, religion, disability, creed or any other protected class. Discrimination and harassment on any of the bases covered by state or federal antidiscrimination statutes is unlawful and a violation of Grinnell College policy.

---