General DescriptionDepartment: Geriatrics Monday-Friday 8:30a.m.-5:00p.m. 37.5 hrs.
General Description: Position plays a key technical role in the data management, implementation and operation of data processes and applications for the Center on Aging and Health (COAH), reports to the Center's Director. He/she is responsible for the complete life cycle for all projects. This individual will work with individual research project leaders to assess content needs and accessibility issues, and implement new IT technologies that will facilitate data collection, archiving, sharing, and security. Specifically, s/he will lead the data management technical issues and the corresponding design, development, documentation, testing, and maintenance of various web-based (ASP and ASP.Net) applications; develop and maintain MS Access and SQL Server databases; develop detailed and well-documented automated routines for updating Center databases; apply high-level programming knowledge and analytic thinking to define and discern key aspects of complex technical or procedural problems arising in the day to day operation of center applications, and develops an integrated solution within a broad technical and business context; and troubleshoot and resolve computer-related issues within the Center. This individual is expected to work independently, has wider range of autonomy and is responsible for meeting deliverables without supervision. Advises the supervisor on priorities and proposed solutions.
Duties and Responsibilities:
As part of primary duties this position will:
Manage the SQL Server database, create dataset and merge data between different databases as per research project leader's request, and create database application as per the research project leader's request. Maintain //apu Server Platform and //lenny Database Server Platform, secure database data, make sure DAS and EC system accessible. Design, development, documentation, testing, implementation, and maintenance of an ASP.Net application for browsing Center data as documented in multiple SQL Server databases. Design, development, documentation, testing, implementation new ASP.Net applications for data entry and data tracking for multiple SQL Server databases Create test plans and perform unit, system, and integration testing. Maintain and port to ASP.Net an existing ASP application for submitting proposals to access center data for further study (Data Acquisition System - DAS, EC System). Development, maintenance, testing and deployment of SQL Server database objects (views, UDFs, stored procedures) employed by web applications. Develop T-SQL routines for integration of data from multiple large-scale population studies. Provide broad technical support and focused training to functional users. Mentor lower level IT personnel as well as user community. Be a mentor / team leader / oversee work of more junior staff.