A cover letter is required for consideration for this position. For the Career Portal system to accept a cover letter, please include a cover letter as the first page of your resume document. The cover letter should specifically address why you are interested in this position, describe specific skills and experiences in your history, and directly relate them to the responsibilities of, and qualification for this position.
We are seeking a Database Analyst/Programmer Senior to join the Technical Services Group (TSG) at Survey Research Operations (SRO). TSG is responsible for the development and support of systems and tools used to manage survey and data collection operations and processes including respondent contact, sample management, computer assisted data collection, resource management, reporting, and quality assurance. The Database Analyst/Programmer Senior will serve as a primary or backup Database Administrator as assigned and will build, update or maintain data intensive applications or utilities which directly depend on or interact with Microsoft SQL Server databases.
SRO is the operations branch of the Survey Research Center (SRC) at the Institute for Social Research (ISR). SRC is a national and international leader in interdisciplinary social science research involving the collection or analysis of data from scientific sample surveys.
Assist or lead in the design, creation, and maintenance of enterprise wide Microsoft SQL Server database environments while following ISR and University security and change control standards.
Assist or lead in the maintenance of multiple database environments as assigned, including database migrations, version upgrades, and the application of updates, maintenance packs, patches, and fixes.
Research and advise on the implementation of the latest MS SQL Server features.
Assist or lead in SQL Server performance monitoring and tuning.
Setup, implement, monitor, and troubleshoot key database system activities and functions including system backups, data recovery, database replication, and automated system notifications.
Design and implement scripts to automate repeatable database administration tasks and activities.
Create and share ongoing reports of database system status and health.
Assist or lead in the creation and documentation of key processes including workflows, key roles and responsibilities and communication protocols.
Participate in system planning and the setting of technical direction for database administration.
Perform application and database design reviews as requested, to ensure the proper implementation and enforcement of ISR and University security and data protection standards.
Mentor or train staff performing database administration activities.
Provide periodic after-hours, on-call support as necessary.
50% Develop, implement and maintain data intensive software applications and systems
Under general supervision, update, optimize, test, trouble-shoot and maintain legacy systems and applications.
Use up-to-date knowledge of programming languages and database technologies to develop, test and implement new client or web-based applications or utilities.
Create, update or review SQL queries, stored procedures and database views.
Gather and document application or database design requirements.
Design, update or modify databases for use with legacy and new applications and systems.
Liaise or consult with developers, DBA’s or system administrators to recommend or assist in making improvements in database or application design and performance.
Bachelor’s degree with a technical major, such as engineering or computer science, or an equivalent combination of education and experience.
Minimum of 5-7 years (3-5 years for intermediate level) of data-intensive software development and support experience including in-depth understanding and implementation of sophisticated SQL queries stored procedures.
Minimum of 3-5 years (1-3 years for intermediate level) of SQL Server database administration experience including experience supporting multiple database environments while following industry standard data and security protocols.
Experience with SQL performance tuning techniques including query planning and management and indexing techniques.
Experience working with Microsoft SSRS, SSIS or SSAS tools.
Ability to work on or lead collaborative teams which include internal and/or external stakeholders, and to use negotiation skills to gain agreement or cooperation among people with different interests.
Skill in communicating technical information in an easily understood manner to different audiences.
Strong attention to detail.
Ability to work on multiple concurrent projects.
Note: Examples of technical writing, SQL code, or other work product may be requested.
Master’s degree with a technical major, such as engineering or computer science, or an equivalent combination of education and experience.
Experience developing or supporting applications built on Microsoft Entity Framework.
Experience and knowledge in migrating code, database changes, data, and menus through the various stages of the development life cycle.
Microsoft Certified Database Administrator (MCDBA).
Some knowledge of the applications used for survey data collection in social research.
This position may be filled at either the intermediate or senior level based on qualifications and experience of the selected candidate. The salary range for senior level will be $75,000- $90,000 and for Intermediate will be $65,000 - $75,000.
The Institute for Social Research (ISR) at the University of Michigan seeks to recruit and retain a diverse workforce as a reflection of our commitment to serve the diverse people of Michigan, to maintain the excellence of the university, and to ground our research in varied disciplines, perspectives, and ways of knowing and learning.
The University of Michigan is an equal opportunity/affirmative action employer.
Internal Number: 179601
About University of Michigan - Ann Arbor
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For" survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.