Senior SQL Developer

JOB TITLE:

Senior SQL Developer

JOB LOCATION:

Jamaica Plain, MA
   
   WAGE RANGE*: $75-$80
   
   JOB NUMBER: ITS
77-EHS-FY26-APP DEV – 009 - LAB

REQUIRED EXPERIENCE:

Bachelor's degree in computer science, Computer Information Systems, Information Management or related field or equivalent work experience.
   Ability to drive complex system integration projects and transition businesses to new application platforms.
   Minimum 5 years of experience in an Application Lead role. Experience in:
   SDLC
   Solution assessment and validation.
   
   Technical Requirements / Specifications Development and Management.
   8+ years of professional experience doing Microsoft SQL Server (2008, 2012 or greater) database management & database administration.
   Expertise with relational database design, capacity planning, security, and other distributed data issues.
   5+ years of experience with T-SQL and Power Shell Scripts, ETL is required.
   Strong working knowledge of query, index and DB I/O performance tuning, and Stored Procedures and SQL coding is required.
   Ability to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.
   Troubleshooting and resolving database blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, Data issues etc.
   Possessing a strong understanding of database administrator methodologies.
   Understanding of project management and the software development lifecycle.
   Experience working in a PMO environment.
   Experience working with software vendors.
   Possessing a strong understanding of testing methodologies for functional, systems, integration, performance, and user acceptance.
   Evidence of ability to work within a team and promote a collaborative work environment.
   Experience in maintaining a high level of customer satisfaction.
   Possess organizational, presentational and customer service skills.
   Possess excellent problem-solving, analytical and time management skills
   
   Desirable
   Experience working in the Healthcare Industry.
   Experience working for State Agencies.
   Experience working in a Lab environment.

JOB DESCRIPTION
   
   Provides analytical support for conceptualization, development, and implementation of complex systems of multiple inter-linked programs. In-depth knowledge of all phases of client/server applications technology. Responsible for the analysis, design, coding, debugging, testing and documentation of computer programs. Broad experience in programming graphical user interfaces (GUI). Extensive knowledge and skill with object-oriented programming, relational database structures and Structured Query Language (SQL).

May act as team or project leader on major applications projects.​
   
   Technical Role :
   The Senior App Dev must act as an SME on all new and existing DPH LIMS systems and other related application-specific processes:
Technical application support for the DPH disease surveillance system using  Win Forms, C#, .Net Framework 3.0 or greater, .Net Core, C1 component or any 3 rd party .net components, TFS, Azure, Java, SQL script, Oracle, Selenium and Eclipse in Windows and UNIX environments. Assists in the development and implementation using Web Logic application server, XML, SFTP and SOAP. Assists in database design and database reporting process, using Oracle, SQL Server, BI, Jasper and SQL reporting services.

Support ancillary applications and data feeds including Electronic Laboratory Reporting system (ELR), Rhapsody and others and create and maintain related technical documentation.
   
   Ownership:
   Senior App Dev must lead technical projects, work-streams, and activities. They must take ownership technical issues: shepherding them through to resolution and marshaling technical resources including staff, tools and documentation to meet project and operational objectives.
   
   Modeling :
The Senior App Dev must provide an example to technical team members on how to: troubleshoot issues, deal with customers professionally and with integrity, be accountable to the customer, stakeholders, team members and the project manager. They must encourage good intra-team relations, sharing of work tasks and knowledge. They must be willing to handle tasks themselves, share tasks jointly with other team members, and delegate and assign tasks fairly and equitably among team members.

Coaching:

The Senior App Dev must be consistently sharing technical knowledge, coaching, mentoring, and directing technical team members to resources and opportunities for professional growth including shadowing the Technical Lead. Ideally, for every practicing Technical Lead there should be at least one team member identified informally by management as the Technical Lead "in training " who can serve as a back-up.
   
   Communications:
The Senior App Dev must be adept in all forms of communications:
Writing concise technical explanations,…