SQL/.NET Developer

Overview:

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

Skills:

SQL,ASP.NET