Database Programmer

SUMMARY OF POSITION: Under general direction maintain software environments for development and testing. The database programmer will set up and maintain development and test environments and will execute test plans and test cases from specifications and compile results as well as perform basic programming or scripting tasks.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Maintain SQL server databases, create and maintain SQL views, stored procedures, triggers, and scripts using best practices

• Assist with development of web services, APIs, and other integration services and applications

• Builds and maintains reports and data extraction processes through SQL, SSRS, Jenzabar, InfoMaker, and other BI tools as needed

• Assists in the validation of reports, scripts and processes ensuring data integrity and privacy prior to releasing information.

• Responsible for periodic review of data security and privacy practices, to include but not limited to user, group, and role based permissions on tables, views, stored procedures and systems that access the data.

• Participate in all aspects of software development including requirements analysis, effort estimation, technical investigation, software design and implementation, unit testing, and error correction

• Play a key role in the design, development and deployment of Jenzabar and integration platforms.

• Create and document detailed software designs

• Research and evaluate emerging technologies that impact our business and design solutions that allow us to integrate with existing systems to business requirements.

JOB QUALIFICATIONS:

Minimum qualifications:

• Bachelor's degree in computer science or information technology

• Four years experience working with SQL, APIs, and ETL

Preferred qualifications:

• Experience working with Jenzabar

• Project management experience.

Knowledge/Skills/Abilities:

• Strong analytical skills

• Working knowledge of Identity and Access Management

• Ability to communicate with self-awareness, sensitivity, and professionalism in a diverse work environment.

• Ability to prioritize work effectively and be self-motivated to work independently and follow-through to meet department deadlines.

• Ability to deliver high-level customer service and technical support

• Excellent written and verbal communication skills.

• Experience with troubleshooting and correcting systems related issues

• Familiarity with project management methodology and ability to both lead, and participate in, projects.

• Well-grounded philosophy of honesty, integrity and respect

• Demonstrated ability to establish and maintain effective working relationships with various constituents including both internal to the organization and with the public

• Ability to work with and engage a diverse group of people

• Ability to work independently yet value and support a team-based environment

• Demonstrated professionalism and positive attitude

GUIDELINES AND SUPERVISION: The Database Programmer will report to the Chief Information Officer and should be able to work autonomously with limited supervision. The position requires the use of sound independent judgment and the ability to work both independently and as a member of the Campus Technology team. The Database Programmer must maintain strict confidentiality of records and respect and that all aspects of the office work will be accomplished with the highest professional standards.

Work Schedule: The university's operating hours are Monday through Thursday 8am -5pm and Friday 8am through 1pm. This position requires occasional weekends and hours outside of regular business hours.

Licenses: None required

DISCLAIMER: The preceding job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this classification. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.

We believe that a diverse faculty and staff are essential to achieving academic excellence; thus, we strongly encourage applications from candidates from all racial, ethnic and cultural backgrounds.