Talent.com
SQL Database Developer II
SQL Database Developer IIMassachusetts School Building Authority • Boston, MA, US
[error_messages.no_longer_accepting]
SQL Database Developer II

SQL Database Developer II

Massachusetts School Building Authority • Boston, MA, US
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Description

Job Description
Job Title: SQL Database Developer 2
Department: Information Technology
Reports To: Development Lead
FLSA: Exempt
Hours per Week: 37.5
Status: Full-Time
Grade: 12

Position Summary
The SQL Database Developer II is responsible for the design, development, testing, implementation and support of Microsoft SQL-based relational databases and the suite of MSBA Applications. These databases are used to collect and analyze data gathered through the MSBA’s custom web applications that are both internal and client-facing. This position is also responsible for developing and supporting complex data sets utilizing various reporting platforms.

This position will ensure that data is available to all users and administer the database systems through security, backup and recovery, tuning, automation and disaster recovery planning and testing for MSBA database environments. Working with the IT team, the SQL Database Developer II will participate in the full development life cycle to meet the business objectives of the MSBA.
Essential Functions and Responsibilities
  • Design, develop, test, and implement changes and enhancements to current and developing SQL Databases as required
  • Develop an understanding of MSBA business processes and workflows to align database architecture with such processes and workflows.
  • Support business and client users of the web application through “back-end” database problem solving and troubleshooting of various complex issues as they arise
  • Work with Web development team to design and develop application business and data layers.
  • Write and maintain comprehensive documentation, including database dependencies, database inventory, basic database troubleshooting, and daily database operations documents.
  • Maintain and optimize the databases, data sources and Query server performance, including migrating new changes from online databases to the query database server
  • Design and implement new tables to store data and related performance monitoring
  • Design appropriate indexes for new tables, and analyze existing indexes for improvement
  • Code stored procedures of high complexity to meet business requirements
  • Work to implement and maintain SSRS reports ensuring they are of the highest data and visual quality
  • Oversee database performance issues and guide optimizations in systems design
  • Implement physical data model and data access layer
  • Deliver work products that meet specifications, are free of defects, and have excellent performance
  • Cultivate and maintain strong relationships with co-workers and project teams
  • Support development and ongoing maintenance of MSBA Applications
  • Keep up to date with database development best practices
  • Support the operational strategies and priorities of the MSBA.
  • Perform other duties as assigned
Required Education, Experience, and Skills
  • Four-year degree in technical discipline and 7+ years of relevant professional experience in SQL database development
  • Ability to work hybrid work schedule - minimum of two (2) in-office days per week
  • Strong Microsoft Windows and SQL Server 2017(and above) and T-SQL programming skills
  • Follow proper application, operations, standards, policies, and procedures. Ensure that the integrity and consistency of company databases is maintained.
  • Experience planning, testing and implementing database software upgrade cycles.
  • Minimum 5 years of working in an object-oriented environment, hands-on experience with ASP.Net or Core, VB .Net, C# and Visual Studio 2017 (or above).
  • Experience with versioning control environments, such as Azure DevOps, Git, TFS is a must.
  • Highly experienced in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
  • Experience in Database Design, Development, and Administration.
  • Experience with web-enabled enterprise applications, protocols and standards
  • Practical database administration experience
  • Experience in architecting, designing and implementing complex databases
  • Experience in code migration, database change management and data management through the various stages of the development lifecycle
  • Strong communication skills and the ability to work both independently and as part of a team.
  • Strong analytical and problem-solving skills
  • A task driven mindset as well as effective multitasking and follow-up skills
  • Professional interpersonal, team-oriented style; ability to work and build trust with a diverse range of people
  • Ability to work with tight deadlines
  • Exhibit a professional ‘can-do’ attitude and flexible work style approach.
  • Ability and willingness to proactively research and/or resolve issues
  • Ability to be reliable and punctual
Preferred Education, Experience, and Skills
  • Relevant Microsoft Certifications
  • Masters in technical discipline
  • Experience with cloud-based services and solutions
  • Experience with network/storage architecture
  • Experience with BI reporting tools such as Tableau and Power BI
  • Experience with Project Management Methodologies like Agile and ITIL
This job description is intended to be general and will evolve over time. The description is subject to periodic updating. At management’s discretion, the employee may be assigned different or additional duties from time to time.
[job_alerts.create_a_job]

SQL Database Developer II • Boston, MA, US

[internal_linking.similar_jobs]

Director of Cloud Database Platforms & DBaaS

LumenBoston, MA, United States
[job_card.full_time]

The Director, Cloud Database Platforms & DBaaS leads the strategy, modernization, and operational excellence of Lumen’s enterprise data platform ecosystem.This includes relational databases, NoSQL ...[internal_linking.show_more]

 • [job_card.promoted]

Data Integration Developer

Compunnel, Inc.Boston, MA, United States
[job_card.full_time]

We are seeking a highly motivated and experienced Data Integration Developer to support Global Distribution projects, with a primary focus on Global Sales & Marketing systems.This role involves dev...[internal_linking.show_more]

 • [job_card.promoted]

Python/SQL Full stack developer (Fixed income Market Data pricing)

Cyber Space Technologies LLCBoston, MA, United States
[job_card.full_time]

Python/SQL Full stack developer (Fixed income Market Data pricing).Location: Boston (Complete onsite).Interviews will be conducted in person in Boston office.Strong Python/SQL developer with 1-2 ye...[internal_linking.show_more]

 • [job_card.promoted]

Lead Data Infra Engineer: Scalable Pipelines & Lakehouse

MagnaCareBoston, MA, United States
[job_card.full_time]

A healthcare technology firm in Boston is seeking a Senior Data Engineer to lead data infrastructure initiatives.This role involves designing and optimizing data systems that enhance healthcare ana...[internal_linking.show_more]

 • [job_card.promoted] • [job_card.new]

Database Cleanup Analyst, Legal Records Specialist

The First Church of Christ, ScientistBoston, MA, United States
[job_card.full_time]

Database Cleanup Analyst, Legal Records Specialist.The Database Clean Up Analyst - Legal Records Specialist reviews all legacy "work in progress" database records documents in the M-Files enterpris...[internal_linking.show_more]

 • [job_card.promoted]

Sr. Tableau Developer - 10+ yrs

Trident ConsultingBoston, MA, United States
[job_card.full_time]

Location: Boston, MA – 3 days onsite (remote possible for now, but may require onsite in a few months).Collaborate with analysts and business users to support BI reporting needs via Tableau and Pow...[internal_linking.show_more]

 • [job_card.promoted]

Data Integration Developer

Integrated Resources Inc.Boston, MA, United States
[job_card.full_time]

A Few Words About UsIntegrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms.IRI has built its reputation on excelle...[internal_linking.show_more]

 • [job_card.promoted] • [job_card.new]

Healthcare Interface Developer (Rhapsody) - On-Call

South Shore HealthWeymouth, Massachusetts, United States
[job_card.full_time]

A healthcare organization is seeking an Interface Analyst / Developer in Weymouth, MA to provide support for new interfaces and maintain existing ones.The role requires considerable experience in R...[internal_linking.show_more]

 • [job_card.promoted]

Senior Database / ETL Engineer (MariaDB)

Big ResourcingBoston, MA, United States
[job_card.full_time]

Location: Remote – India (UK Shift).BigRio is a remote-based technology consulting firm headquartered in Boston, MA.We specialize in delivering advanced software solutions that include custom, clou...[internal_linking.show_more]

 • [job_card.promoted]

Software Developer, FinTech Data & Cloud Solutions

PathstoneBoston, MA, United States
[job_card.full_time]

An innovative investment management firm is seeking a Software Developer in Boston, Massachusetts.The ideal candidate will have robust experience in software development, focusing on client-facing ...[internal_linking.show_more]

 • [job_card.promoted]

Coding Specialist II, Remote

Mass General Brigham (Enterprise Services)Somerville, Massachusetts, United States
[filters.remote]
[job_card.full_time]

Summary: Responsible for ensuring proper coding compliance, documentation accuracy, and adherence to coding guidelines and regulations.Does this position require Patient Care? No Essential Function...[internal_linking.show_more]

 • [job_card.promoted]

Backend Engineer II - Growth & Data-Driven APIs

WhoopBoston, MA, United States
[job_card.full_time]

A health technology company in Boston seeks a Software Engineer II to develop scalable backend solutions that enhance user acquisition and member growth.Responsibilities include building APIs, coll...[internal_linking.show_more]

 • [job_card.promoted]

Senior Backend Data Engineer – AWS ETL & Pipelines

TekValue IT SolutionsBoston, MA, United States
[job_card.full_time]

A leading IT solutions company is seeking a Senior Technical Recruiter to join their dynamic team.This hybrid position, located in Boston, Richmond, or McLean, demands experience in backend or data...[internal_linking.show_more]

 • [job_card.promoted]

Hospital Itemized Bill Reviewer – Coding & Billing Expert

Zelis Healthcare Inc.Boston, MA, United States
[job_card.full_time]

A leading healthcare solutions company is looking for an Itemized Bill Review Facility Reviewer in Boston, MA.This role involves analyzing inpatient and outpatient claims, ensuring adherence to cod...[internal_linking.show_more]

 • [job_card.promoted]

Real-Time BI Developer — Hybrid, Actionable Insights

Franklin FitchBoston, MA, United States
[job_card.full_time]

A leading retailer in Boston is seeking a Business Intelligence Developer.This role is key to advancing their data strategy through robust BI infrastructure and real-time analytics.The successful c...[internal_linking.show_more]

 • [job_card.promoted]

Data Architect

MaplecroftBoston, MA, United States
[job_card.full_time]

Cloud Native AWS Data Architect.The ideal candidate will bring strong expertise in.AWS data services, big data processing, data modeling, enterprise analytics, and cloud-native architectures.This r...[internal_linking.show_more]

 • [job_card.promoted] • [job_card.new]

Medical Coder II/III

CodaMetrixBoston, Massachusetts, United States
[job_card.full_time]

CodaMetrix is revolutionizing Revenue Cycle Management with its AI-powered autonomous coding solution, a multi-specialty AI-platform that translates clinical information into accurate sets of medic...[internal_linking.show_more]

 • [job_card.promoted]

Senior Oracle DBA & Database Architect (Remote)

Compunnel Inc.Boston, MA, United States
[filters.remote]
[job_card.full_time]

Get notified about new Oracle Database Consultant jobs in.Oracle Database Consultant Jobs in United States.Senior DBA / Database Architect (North Carolina).Senior Oracle/PGSQL Database Admin and Au...[internal_linking.show_more]