SQL/.NET Developer

Title: SQL/.NET Developer

Location: Boston, MA

Long Term Contract

Our client has an opening for a software engineer to join our application development team. The new team member will support both a legacy system, and will participate in an initiative that is underway to rewrite the current system with modern, secure technology. The current system utilizes a two-tier architecture using an Oracle database and PowerBuilder technologies.

The Engineer will assist with data maintenance of the current system, support the migration to the new system, and transition to the team providing post implementation development and support of the new system.

Current System Responsibilities:

The Senior Engineer will engage in all activities and collaborate in a team environment with other developers, management, and end users to provide daily support to system users.

The engineer is expected to learn business processes and use this knowledge to analyze and resolve system and data problems.

Manage daily ticket requests from users

Coordinate development activities and tickets with an internal SOC Help Desk team who provide phone and email support to users

Respond to data related issues as a result of data transfers from external agencies

Create ad hoc reports and data extracts

Participate in the full life cycle of development activities – define, develop, test, install, document, and maintain

Maintain a source control and inventory system to ensure proper version control

Develop a collection of specialized software tools for access to central records

Evaluate feasibility of enhancements requested by the user community

Respond to upgrades needed to comply with new state regulations

New System Initiative:

The current system will be replaced with a customized application developed by a third-party vendor using the .NET Framework and a SQL Server database.

The Senior Software Engineer will provide technical and business subject matter expertise to the vendor for application and database design, database migration, and will participate with testing.

Throughout the length of the project, the engineer will actively participate with the incremental knowledge transfer of the source code from the vendor to the development team.

At project completion, the Senior Software Engineer will be a member of the team responsible for ongoing support and development of the system, including enhancements to functionality and features.

Required Database Skills:

Expertise in query writing; able to quickly follow and represent database design

Comfort and expertise in database management via direct UPDATES, embedded SQL and dynamic SQL such as stored procedures

Ability to document database design (ERD, dataflow)

Experience in transforming business requirements to data objects and relationships

Applied use and understanding of database principles – entities, relationships, indexes, triggers, normalization

Expert-level SQL Server DB experience is a must

Oracle database experience is a plus

Required Programming Skills:

Proven ability to reverse-engineer existing software systems to provide support and updates

Experience designing, re-designing or updating legacy software systems

Senior-level proficiency with object-oriented programming languages and concepts such as the .NET development suite, Java, C++, Ruby, or Python 3.0

Demonstrated proficiency with integrated developer environments

PowerBuilder knowledge highly preferred

Experience with Integrated Developer Environments

Experience creating and maintaining data forms with tools such as .NET data binding for Windows applications, or PowerBuilder data windows

Client-server development experience

Able to solve problems creatively and effectively

This is an onsite position and requires evening and weekend work during critical support periods. The engineer must demonstrate an excellent level of verbal, written, and client-facing communication skills, and must be able to work effectively with a wide-range of users. An interest in history, government, or civics a plus