Department Information
Welcome to the
Auraria Campus located in the Platte River Valley in downtown Denver. The Auraria Campus is the service provider for 38,000 students and approximately 5000 faculty and staff working at and attending the
Community College of Denver, Metropolitan State University of Denver, and the
University of Colorado Denver. Learn more about us through this link: The Auraria Campus
Auraria employees enjoy an excellent benefits package which includes paid vacation, holidays, and sick leave, discounted RTD Eco-Pass, BenefitHub (medical, dental, disability, life), and outstanding retirement plan. Learn more through this link: Non-Classified Benefits Package .
So, if you're interested in a great job working alongside great people, this may be the opportunity for which you've been waiting.
Description Of Job
The Auraria Campus is seeking an
IT Database Administrator who will be responsible for the installation, operation, and maintenance of the agency's (20+) SQL Database Servers, which facilitate several agency applications (EMS, TMA, MIP/Microix, MS Access Tables, Tableau, etc.).
MS SQL And Access Database Administration
- Install and maintain the performance of all agency databases servers.
- Develop processes for optimizing and maintaining database security.
- Performance tuning of database systems.
- Install, upgrade, and manage database applications.
- Diagnose and troubleshoot database errors.
- Recommend and implement emerging database technologies.
- Create and manage database reports, visualizations, and dashboards.
- Available for planned outages/upgrades and emergency response to critical situations during off hours as necessary.
- Maintain, update, and catalog all customized access databases, queries, and macros.
Database Application Support:
- Administers the Auraria Campus's Event Management System (EMS).
- Support and administration of both internal agency users and external campus constituents, external vendors, and others that facilitate the scheduling of all courses and events on campus.
- Oversees the system processes to facilitate the classroom/finals scheduling process in a timely manner to meet pre-specified deadlines each semester.
- Provides consultation and guidance to internal and external agencies regarding the policies, configuration, and operation of the internal system as well as similar external systems when requested.
- Direct and assist institutions with functional testing of the systems while evaluating updates and upgrades to their student information.
TMA Work Order System:
- Act as Primary Database Administrator for the Facilities Management TMA Work Order system.
- Act as technical project lead to perform all tasks within all established change control guidelines for notification, testing, and scheduling.
- Provide troubleshooting support by working with end users, system documentation, and vendors.
Dashboarding System Integrations:
- Act as Primary D atabase Administrator for all agency technologies used for Dashboarding systems (Tableau, MS Access/Excel, Power BI, etc.)
- Perform all tasks related to data migrations, table mapping and the import/export processes needed to facilitate various agency Dashboards.
- Coordinates testing, scheduling , i nstall ation , configur ation , and monitor ing of developed processes.
- Provide troubleshooting support by working with end users, system documentation, and vendors. Properly document and archive all related coding, configuration information and procedures necessary to the ongoing successful operation of the agency dashboards.
Professional Requirements
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
- A bachelor's degree from an accredited institution in Computer Science or a related field. Or a year for year experience in an occupational field related to the work assigned to the position.
- Strong command of SQL and SQL server tools.
- Knowledge of database security, backup, and recovery, and performance monitoring standards.
- Understanding of relational and dimensional data modeling.
- PowerShell and Unix Shell scripting skills.
- Familiarity with SSAS, SSIS, and SSRS.
- Current working knowledge of Windows desktop and server operation systems.
- Experience with technology used at the Auraria Campus.
Preferred Qualifications:
- Manage and organize multiple tasks and priorities for multiple systems simultaneously.
- Must be customer service driven and have excellent interpersonal skills and the ability to collaborate and communicate with a diverse user audience and customer base.
- Good verbal and written communication skills are also required .
- Impeccable attention to detail.
- Have the ability to communicate with personnel from all area s of the organization to include IT T echnologists, end users, management, venders, and customers (CCD, MSU Denver, and UC Denver) .
- Must have the ability to manage projects effectively to implement technological solutions utilizing agency technologies.
Supplemental Information
Colorado Partnership For Quality Jobs And Services Act Information
After careful review of this position and the duties that it performs, it has been designated in accordance with the Colorado Partnership for Quality Jobs and Services Act as a "Not Covered" position, it does not fall in the category of employees that are eligible for representation by COWINS, also known as the union. To learn more about this designation please visit this link: http://coloradowins.org/
E-mail Address
Applicant Checklist & Minimum Qualifications:
All correspondence regarding your status in the selection/examination process will be conducted by email.
Applicant Checklist
We request that you include the following in your application:
- Cover Letter detailing how your experience & education meet minimum and preferred qualifications
- Resume detailing a summary of work history
Applications submitted will be reviewed and given consideration.
Minimum Qualifications
Your application as submitted is used to determine if you meet Minimum Qualifications. Please read the Minimum Qualifications and ensure that information in your application "draw correlations" to the Minimum Qualifications. Human Resources Analysts will not infer that you meet the Minimum Qualifications if information isn't detailed in your application.
*Years of experience will be expressed in terms of full-time equivalent service with full-time workload equal to one (1) Full-Time Equivalent (FTE) year. No more than 1.00 FTE year may be credited in any twelve (12) month period. Positions working 40 hours or less per week will be pro-rated (30 hrs/wk=0.75 FTE=9 mos credit; 20 hrs/wk=0.5 FTE=6 mos credit; 10 hrs/wk=0.25 FTE=3 mos credit.) *
Commitment To Equity, Diversity, And Inclusion
The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.
The Auraria Campus is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to Mary Kate Schwien at MaryKate.Schwien@ahec.edu