Senior SQL Developer

JOB TITLE: Senior SQL Developer

JOB LOCATION: Jamaica Plain, MA

WAGE RANGE*: $75-$80

JOB NUMBER: ITS77-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 PowerShell 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 VB.Net WinForms, 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 WebLogic 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, requirements and technical specifications, and emails/texts as well as clear verbal communications in meetings, teleconferences, and training. They must be capable of translating complex technical issues into logical, concise, and understandable communique for varied audiences. They must exemplify an understanding of the lines of authority within the technical team, ensuring proper escalation of issues and risks and informing management, and technical team members on a need-to-know basis.

Expertise : Act as an SME on all new LIMS and other related application-specific processes: Do a deep-dive on technical areas and then teach other team members.

Technical Issues: They must keep on top of all open and emerging technical issues: documenting, tracking and keeping the Project Manager informed. Enhance existing functionalities in DPH LIMS Systems using the Admin Console as well as .NET, .Net Core, VB.Net, C#, SQL, SSRS, Oracle, and JAVA. Document and standardize incoming and outgoing data feeds. Should provide a weekly technical status update.

Application Upgrades and Releases: Keeps close monitoring of all minor and major software updates and releases: Planning, managing technical risk, advising management, and leading the technical effort.

Code Review: Institute and participate in recurring code review sessions.

Research: Research and analyze new applications and tools when necessary: Taking advantage of opportunities to research technology.

On-Call: The Senior App Dev on the LIMS Team must be available as the first line of response to any technical issue or emergency that occurs during the formal workday or after hours.

Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities

* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.

#Dice