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]

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]

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]

Software Engineer II, Backend (Identity Decisioning)

AffirmBoston, MA, United States
[job_card.full_time]

Software Engineer II, Backend (Identity Decisioning).Affirm is reinventing credit to make it more honest and friendly, giving consumers the flexibility to buy now and pay later without any hidden f...[internal_linking.show_more]

 • [job_card.promoted]

Tableau Developer (SAP Financial data BI)

TechBiz Global GmbHBoston, MA, US
[job_card.full_time]

At TechBiz Global, we are providing recruitment service to our TOP clients from our portfolio.Tableau Developer (SAP Financial data BI).If you're looking for an exciting opportunity to grow in a in...[internal_linking.show_more]

ETL Developer

ManpowerGroup Global, Inc.Boston, MA, United States
[job_card.temporary]

Hybrid - Boston, MA - hybrid with 2 days a week onsite in Boston.Include answers to these questions on the Candidate Bid Sheet:.How many years of ETL development experience does the candidate have?...[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]

Senior Backend Software Developer - AI Solutions (Remote US)

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

Revvity Signals makes market‑leading software that empowers scientists across life science R&D, clinical research, and specialty chemicals to make better medicines and products, faster.Our flagship...[internal_linking.show_more]

 • [job_card.promoted]

Data Modeler - “Boston, MA” [Hybrid]

Saransh IncBoston, MA, United States
[job_card.full_time]

Location: “Boston, MA” [Hybrid and in-person interview is must].Key Qualifications / Responsibilities.Define and govern data modeling and design standards, tools, best practices, and related develo...[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]