Job Information
State of Colorado (Auraria) IT Database Administrator in Denver, Colorado
(Auraria) IT Database Administrator
Print (https://www.governmentjobs.com/careers/colorado/jobs/newprint/4661869)
Apply
(Auraria) IT Database Administrator
Salary
$5,776.00 Monthly
Location
Denver, CO
Job Type
Full Time
Job Number
AHEC-4283-09.2024
Department
Auraria Higher Education Center
Division
Auraria Business Services Division
Opening Date
09/18/2024
Closing Date
10/2/2024 11:59 PM Mountain
FLSA
Determined by Position
Type of Announcement
This position is open only to Colorado state residents.
Primary Physical Work Address
777 Lawrence Way Denver, CO 80204
Department Contact Information
Mary Kate Schwien - MaryKate.Schwien@ahec.edu
How To Apply
Please submit an online application for this position at https://www.governmentjobs.com/careers/colorado. Reach out to the Department Contact to apply using a paper application, including any supplemental questions. Failure to submit a complete and timely application may result in the rejection of your application. Applicants are responsible for ensuring that application materials are received by the appropriate Human Resources office before the closing date and time listed.
Description
Benefits
Questions
Department Information
Welcome to the Auraria Campus locatedin 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 theCommunity College of Denver, Metropolitan State University of Denver,and theUniversity of Colorado Denver. Learn more about us through this link: The Auraria Campus (https://aurariacampus.edu/)
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 (https://www.ahec.edu/ahec-staff/human-resources/current-employees/non-classified-benefits) .
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 anIT Database Administratorwho 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.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
Professional Requirements:
A bachelor's degree from an accredited institution in Computer Science or a related field.Ora 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/
Applicant Checklist & Minimum Qualifications:
E-mail Address:
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 atMaryKate.Schwien@ahec.edu
Please note that each agency's contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon.
01
Rules of Conduct and Ethical Principles: By submitting this application, applicant acknowledges that the holding of State employment is a public trust and that State employees shall carry out their duties for the benefit of the people of the State of Colorado. § 24-18-103(1), C.R.S. Applicant warrants that they have read and understand the rules of conduct and the ethical principles for State employees as set forth in §§ 24-18-104, 24-18-105, 24-18-108, and 24-18-201, C.R.S. Here is the link for the Colorado Revised Statutes: https://leg.colorado.gov/agencies/office-legislative-legal-services/colorado-revised-statutes. Conflict of Interest: A conflict of interest occurs when an individual or organization has a conflict between competing interests. By submitting this application, applicant hereby discloses the following personal or professional interests, obligations, commitments, or relationships (either personal or professional) that could create the perception of conflicts of interest with their duties at AHEC:
Required Question
Agency
State of Colorado
Address
See the full announcement by clicking
the "Printer" icon located above the job title
Location varies by announcement, Colorado, --
Website
https://careers.colorado.gov/
Apply
Please verify your email addressVerify Email