Business Systems Transition Developer

Location
Charlottesville, VA
Posted
Feb 28, 2018
Institution Type
Four-Year Institution

Working Title: Business Systems Transition Developer

Position Type: University Managerial and Professional Staff

Department: School of Nursing

Location: Charlottesville

Posting Date: 02-16-2018

Posting Summary:
This is a limited term position (2 years) responsible for the transition of legacy business systems to SAAS solutions and the Office 365 platform, upgrade and migration of MS-SQL 2012 database systems to MS-SQL 2016, and the redesign, upgrade, and complete documentation of legacy .NET and MS-SQL Reporting Services systems being retained as standalone, on-premise solutions. This position may be approved for telecommuting.

The employee is conversant in Office 365 development, and experienced in dissecting, developing, and documenting solutions delivered in C#, ASP.NET MVC, MS-SQL Reporting Services, and SQL Server Integration Services. The employee is an experienced MS-SQL database administrator, capable of migrating legacy MS-SQL 2012 instances and databases, including stored procedures, backups, scheduled jobs, and other automated procedures, into the MS-SQL 2016 platform.

Examples of work to be performed include:

Reprogram retained legacy standalone applications to work in a well-defined microservices model. Thoroughly investigate, dissect, and document solutions, including codebases, database relationships, dependencies, and system inter-relationships. Re-engineer solutions, primarily in the current .NET framework, to separate out deprecated and transitioned services, to upgrade codebase to the current .NET framework, to improve efficiency of retained modular services, and to support configurable deployments, future upgrades, and Disaster Recovery.

Maintain well-documented, versioned code repositories in Microsoft Team Foundation Services.

Working with system owners, stakeholders, and users, port existing standalone custom-developed solutions to SAAS solutions. The initial focus will be porting departmental HR, Compliance Management, Workload Management, and Identity Management solutions to cloud-based, enterprise solutions. Work closely with enterprise systems administrators to facilitate the transition of services and solutions. Technologies to be supported include Workday, TAMS (Teaching Assignment platform), Fischer Identity, and others to be determined.

Fully support end-user adoption of SAAS solutions, including training, troubleshooting, and data migration. Advocate on behalf of the department and stakeholders with enterprise systems administrators.

Transition some legacy on-premise, custom solutions previously developed in .NET to Office 365 solutions. Transition workflows and data streams from standalone, integrated MS-SQL solutions into Office 365 solutions.

Fully dissect and document existing and new complex interrelationships and workflows between MS-SQL database instances, SAAS solutions, custom-developed applications, external data warehouses (including Oracle databases), and MS SQL Reporting Services.

Install, configure, and secure MS-SQL 2016 database instances. Apply CIS security standards to SQL servers.

Migrate MS-SQL 2012 databases into MS-SQL 2016 database instances. Create or re-create scheduled tasks, backup jobs, tuning jobs, data transfer jobs (import and/or export), etc. in MS-SQL 2016 instances. Update legacy application solutions' codebases or configuration files to point to MS-SQL 2016 instances. Maintain systems up-time at 99.00 SLA during migrations.

Migrate MS-SQL 2012 Reporting Services solutions to MS-SQL 2016 Reporting Services.

Prepare Disaster Recovery documentation, and perform tabletop Disaster Recovery exercises to demonstrate full recoverability of MS-SQL 2016 database solutions. Conduct at least one full-scale SQL server Disaster Recovery tabletop exercise per year. Accession Disaster Recovery documentation into the Information Technology Information Library.

Required Knowledge, Skills and Abilities:
Ability to develop, implement, and maintain custom-developed standalone and Web applications using the .NET Framework and MS-SQL database technologies. Ability to develop applications in the Visual Studio suite.

Extensive programming experience in C#. Knowledge of object-oriented programming paradigms. Knowledge of and experience with C++ and Java for developing applications. Knowledge of OLEDB, ODBC, and ADO. Knowledge of HTML, DHTML, XHTML, and XML in an IIS and Apache web environment.

Knowledge of MS-SQL database management systems, data normalization, relational diagrams, and T-SQL. Ability to generate complex T-SQL code and to program Stored Procedures and SQL Server Integration Services packages. Ability to administer MS-SQL 2016.

Analytical and critical thinking skills to understand the business environment, and to translate needs to solutions. Ability to resolve complex business and technical needs.

Communication skills to code, test, certify, maintain, and document programs, solutions, scripts, change orders, project files, etc.

Knowledge of industry best practices and relevant information security concepts.

Keen ability to work independently, as a member of a project team, and with stakeholders and broader teams.

Demonstrated excellent verbal and written communication skills.

E-mail a Friend: jobs.virginia.edu/applicants/Central?quickFind=83901

PI101382434