7 days old

Senior SQL Server Developer

Boston, MA 02110
  • Job Code
  • Payrate
    $45 To $50
job summary:

The Office of Data Management and Outcomes Assessment (ODOMA) of the Massachusetts Department of Public Health (MDPH) is seeking to rebuild a large, complex clinical and administrative database holding the Center for Health Information and Analysis (CHIA) Case Mix data, including all Hospitalizations (HDD), Outpatient Observations (OP), and Emergency Department (ED) visits across Massachusetts from the late 1980's to present. This database needs to be restructured to align with business needs. The Senior SQLServer Developer shall work closely with the DPH IT and Business teams and will be responsible for the proper re-design, development, documentation, support, maintenance and enhancements to the current database and application environments.

location: Boston, Massachusetts
job type: Contract
salary: $45 - 50 per hour
work hours: 9 to 5
education: Bachelors

Database Architecture Re-Design and Development:

This project will involve restructuring the database into a relational structure, with views and lookups as needed. Particular focus will be on improving efficiency and streamlining annual upload of case mix files.

Database Security and Minimal Access:

Ensuring the database limits access and complies with state, federal and MDPH guidelines, regulations and laws are essential. This project will involve working closely with MASS IT and EOHHS IT to ensure the database is secure and access is limited to authorized parties only. In addition, this will involve the creation of user-based access levels within MDPH.



  • Review the current database architecture, re-design & develop the new database to improve the efficiency, usability and streamline data import and export processes.
  • Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions.
  • Document specific requirements for data integration, including file format, fields, etc.
  • Develop ETL processes for the import and export of data between the DPH internal systems using SQL Server Integration Services (SSIS) and advanced T-SQL to include stored procedures, user-defined functions, views, etc.
  • Design, develop, revise and maintain a wide variety of custom SSRS reports to support our business.
  • Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports.
  • Develop data warehouse objects and processes for the purpose of supporting business intelligence, including ETL, fact/dimension tables, and cubes.
  • Research, analyze, document, and maintain internal Applications and Database architectures.
  • Assist with RICE (Reports, Integrations, Conversions, and Enhancements) through the use of current tools.
  • Provide technical assistance and information to technical and non-technical users.
  • Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper data security standards set forth by the organization.
skills: Experience and Skills:

  • Experience with SQL Server databases and their native utilities (Query Analyzer, Analytical Workbench, Etc.)
  • Advanced SQL query-writing skills, Linux/Unix scripting, and automated job scheduling.
  • Experience in ETL Development using standard tools like SSIS, SSAS, or other open source ETL tools.
  • Knowledge of file and file transmission protocols (SFTP, Web Services, etc.).
  • Strong knowledge of networking protocols and ODBC, JDBC connectivity as it relates to user based connectivity.
  • Knowledge of applications security including authentication and role based access control within the DB.
  • Robust data modeling and database design experience.
  • Strong adherence to source control, version management, or configuration management practices.
  • Experienced in providing ongoing maintenance and support of IT systems and User communities.
  • Capable of working independently or as part of a large team.
  • Experience in maintaining the confidentiality of sensitive information.
  • SQL Development - ability to write, review and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints).
  • Expert level knowledge of T-SQL, sqlcmd, bcp, sqldiag, tablediff and other programing and diagnostics experience.
  • Understanding of Data encryption, TDE, and key management - Intermediate level knowledge/experience.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Strong knowledge of Database server administration and in virtual environments.
  • Strong understanding of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
  • Knowledge of database native tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, and system specs).
  • Working knowledge Database Error and Exception Handling.
  • Knowledge of Base SAS programming and migration of SAS procs to SQL is a Plus.
  • Qualifications:
  • 8+ years of Database development experience with Microsoft SQL-Server in OLTP/OLAP environments using T-SQL, SSIS, SSRS and SSAS.
  • 8 Years of experience in implementing complex ETL processes.
  • 5+ years of experience in database architecture and administration, SQL tuning, expdp/impdp, SQL loader, Erwin/Data modeler, OEM and ADDM/AWR generation.
  • Advanced understanding of data warehouse and ETL concepts.
  • Bachelor's degree or equivalent work experience is required.
  • Strong adherence to source control, version management, or configuration management practices.
  • Exceptional analytical and problem-solving skills.
  • Ability to communicate effectively both verbally and in writing.
  • Capable of working independently and as part of a team.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.


Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior SQL Server Developer

Randstad Technologies
Boston, MA 02110

Share this job

Senior SQL Server Developer

Randstad Technologies
Boston, MA

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast