DATABASE DEVELOPER/PROGRAMMER I/II

Position Information

Position Information

Position Number 75110
Type of Recruitment External
Position Title DATABASE DEVELOPER/PROGRAMMER I/II
Position Summary

The Database Developer/Programmer is responsible for designing, developing and testing database solutions and bi-directional ETL (extract, transform, and load) processes between various CMU systems; is part of a team supporting interfaces and processes for the movement of data between systems, as well as helping develop reports and dashboards for data presentation and is a primary resource for technical support and maintenance of data structures and interfaces. Also assists with research and development to enable continuing innovation within OIT’s infrastructure.

Required Qualifications

Database Developer/Programmer I

Associate’s degree, preferably in Computer Science or Information Systems, or equivalent work experience.
One year of experience related to database design and development, SQL programming, or ETL work.
Familiarity with MS SQL Server Integration Services (SSIS)
Excellent, effective verbal and written communication skills.
Good interpersonal skills that can foster, demonstrate, and promote excellence in a team environment.
Ability to communicate clearly and effectively and project a positive and professional attitude.
Ability to research and resolve complex technical issues.
Self-motivated and able to work both independently and as part of a team.
Ability to learn quickly, meet established deadlines, and demonstrate strong problem solving and critical thinking skills.
Ability to manage timelines and deliverables, to create and manage task lists, and to meet work and project schedules as determined by others.
Ability to perform the essential functions of the job.

Database Developer/Programmer II

All the qualifications of Database Developer Programmer I, plus:
Bachelor’s degree, preferably in Computer Science or Information Systems, or equivalent work experience.
Two additional years of experience related to the design and development of databases and data interfaces.
Ability to work with user offices and subject matter experts in creating solutions using core supported systems.
Ability to participate in cross-functional teams to solve complex business or systems issues.
Ability to recommend and implement changes in development, maintenance and overall system standards.

Preferred Qualifications


Prior work experience in the higher education environment.
Familiarity with reporting tools such as Microsoft’s PowerBI or Reporting Services
Familiarity with Customer Relationship Management (CRM) Systems
Ability to gather and analyze user needs and create specifications to meet user requirements.

Duties & Responsibilities

Database Developer/Programmer I

Designs, develops, and maintains complex database solutions for data delivery among various university systems.
Documents and tests data interface procedures.
Troubleshoots and resolves data interface issues.
Participates in determining testing approaches and test planning and assists in creating test procedures.
Works closely with OIT staff and vendors to provide seamless support of data systems on behalf of end users.
Ensures the complete backups of relevant data systems and assists in creating and maintaining technical documentation
Routinely monitors database jobs and interfaces and investigate discovered issues or events.
Maintains a positive, service oriented approach with all faculty, staff, and students.
Acts as a technical resource for projects that involve data interfaces.
Other duties as assigned.

Database Developer/Programmer II

All the duties of Database Developer/Programmer I, plus:
Establishes best practices and provides primary support of ETL processing among systems.
Interacts with a variety of internal and external users to gather requirements and develops technical designs and solutions.
Reconciles complicated data and processing problems.
Analyzes existing systems for optimization and processes improvement opportunities.
Assists in establishing system specifications and infrastructure.
Assists in establishing and testing disaster recovery policies and procedures.

Supervision Exercised

None.

Message to Applicants

You must submit an on-line application in order to be considered as an applicant for this position.

Cover letters may be addressed to the Hiring Committee.

Employee Group Professional & Administrative -Salary
Staff Pay Level<br><br><a href=
Pay Range $45,000-$75,000
Division Academic Affairs
Department Data Warehouse - OIT
Position Status Regular
Position End Date
Employment Status Full-Time
FTE 1.0
Position Type 12 month
Weekly Work Schedule M-F, 8a-5p; evenings and weekends as needed
At Will? No
Location Mount Pleasant, MI
About the Department
About CMU

Founded 125 years ago, Central Michigan University is a major, national university with 26,000 students, more than 30 remote locations in the U.S. and Canada, and 225,000 alumni worldwide.

CMU offers more than 200 academic programs at the undergraduate, master’s, specialist and doctoral levels. Academic excellence is found in programs considered among the best in the nation, such as engineering, information systems, neuroscience, physician assistant, physical therapy, sales, logistics, fashion merchandising and design, advertising, marketing, public relations, and broadcasting. Central has been a pioneer in extended learning for nearly 50 years, and its online programs for undergraduates and the military, as well as its online MBA and online graduate education for teachers and school leaders, are nationally ranked.

Central Michigan University expands its academics with immersive, hands-on opportunities such as research, volunteering, study abroad, internships and leadership experiences.

The fourth-largest university in Michigan began with the mission of addressing a demand for teachers prepared and qualified to lead classrooms and educate future generations. That commitment to fulfilling unmet needs continues today through many newer programs, including our College of Medicine, which in May 2017 graduated its first class of doctors dedicated to serving medically underserved communities.

Employees have access to fitness facilities and a nationally recognized wellness program as well as health care and benefits that exceed regional, state and national norms.

With student-athletes who are expected to perform equally well in the classroom and on the field, CMU is a member of the NCAA Division I Mid-American Conference. CMU Athletics regularly earns accolades for student excellence in the classroom (almost 30 percent of our students were honored in spring 2017 for GPAs of 3.5 or higher) and on the field, with frequent men’s and women’s championship seasons in sports such as football, basketball, gymnastics, field hockey, soccer, baseball and softball, and wrestling.

Central is located in a quaint, tight-knit community in the heart of central lower Michigan. Our community offers a robust mix of outdoor opportunities, family attractions. and restaurants and brew pubs. Mount Pleasant’s small-town life is complemented by cultural activities on campus, including concerts, plays and guest speakers. Mount Pleasant is an hour or two from most Michigan destination spots, including Detroit, Grand Rapids, Lansing and Ann Arbor, as well as the state’s sunset beaches, golf and ski resorts, and our famous “Up North” communities, state parks and lakes.

EEO Statement

CMU, an AA/EO institution, strongly and actively strives to increase diversity and provide equal opportunity within its community. CMU does not discriminate in employment against persons based on age, color, disability, gender, gender identity/gender expression, genetic information, familial status, height, marital status, national origin, political persuasion, race, religion, sex, sexual orientation, veteran status, or weight (see http://www.cmich.edu/ocrie.)

If you wish to see “EEO is the Law” posters, please click here.

Posting Begins 10/29/2017
Posting Ends
Open Until Filled Yes

Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. * How did you learn of this vacancy? Please indicate specific source (i.e., CMU website, Lansing State Journal, etc.):

    (Open Ended Question)

  2. * Are you currently an internal employee of CMU according to the <a href="https://www.cmich.edu/fas/hr/Documents/internal-candidate.pdf#search=definition%20of%20internal">university's definition</a>?
    • Yes
    • No
  3. * If yes, to which employee group do you belong? (If not applicable, select "Not Applicable").
    • Not Applicable
    • Office Professional
    • P&A, SO or Faculty
    • Public Broadcasting
    • Police
    • Service Maintenance
    • Supervisory/Technical
  4. Do you have an associate's degree or higher or equivalent work experience?
    • Yes
    • No
  5. Do you have at least one year of experience related to database design and development, SQL programming or ETL work?
    • Yes
    • No

Optional & Required Documents

Required Documents
  1. Resume/Curriculum Vitae
  2. Cover Letter
Optional Documents