Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior SQL Server Database Developer / DBA

Ahead LLC

Job Description

Job Description

The Senior SQL Server Database Developer / DBA will design, develop, troubleshoot, and optimize complex database solutions while helping ensure the performance, reliability, and integrity of production databases.

This role combines database development and database administration responsibilities with a strong emphasis on testing discipline, attention to detail, problem-solving, and effective communication. The position works closely with Java application developers to support Java-based applications and ensure effective interaction between application code and SQL Server. A strong understanding of application-to-database integration is important to supporting application performance, reliability, and ongoing development.

SCHEDULE -This is a full-time, exempt position. The employee is expected to be available during the department’s standard business hours and work the time necessary to effectively perform the responsibilities of the position.

LOCATION - This position is Hybrid. Candidate must be able to regularly commute to our New Bedford, MA location. 

DUTIES/ RESPONSIBILITIES

  • Develop, maintain, and troubleshoot complex T-SQL queries, stored procedures, views, functions, and triggers.
  • Design efficient solutions involving complex joins, CTEs, temporary tables, window functions, aggregations, and other advanced SQL techniques.
  • Develop complex reports and reporting queries involving large volumes of data and detailed business requirements.
  • Perform large-scale data updates, corrections, conversions, and cleanup operations safely and efficiently.
  • Thoroughly test and validate database code and data-modification scripts before production execution, including verifying affected records, row counts, totals, and business rules.
  • Use appropriate safeguards such as transactions, rollback strategies, backups, staging tables, and validation queries for significant production changes.
  • Troubleshoot and optimize database performance using execution plans, indexing, statistics, and other SQL Server performance-tuning techniques.
  • Support DBA responsibilities including database maintenance, backups/restores, security, monitoring, recovery, and SQL Server Agent jobs.
  • Work closely with Java application developers to troubleshoot application/database issues, understand data-access patterns, and develop efficient database solutions. Familiarity with JDBC, connection pooling, transactions, ORM frameworks, and application/database performance issues is a strong plus.
  • Participate in code reviews, technical design discussions, and development of database standards and best practices.
  • Clearly communicate database designs, issues, risks, and recommendations to both technical and non-technical team members.

REQUIRED SKILLS/ABILITIES

  • Experience with Java/JDBC and Java database frameworks, SSIS, SSRS, Power BI, SQL Server Always On, Azure SQL, ETL/data integration, source control, CI/CD, and data warehousing is desirable.
  • Treats data accuracy and production safety as critical responsibilities, carefully analyzing, testing, validating, and verifying significant database changes rather than assuming code is correct because it executes successfully.

EDUCATION AND EXPERIENCE

  • Significant experience (5+ years) as a SQL Server Database Developer and/or DBA.
  • Expert-level T-SQL skills and extensive experience with stored procedures, views, functions, triggers, and complex reporting.
  • Strong understanding of relational database design, transactions, locking/blocking, indexing, execution plans, and performance optimization.
  • Experience working with large databases and safely performing high-volume production data modifications.
  • Strong SQL Server administration, backup/recovery, security, and maintenance knowledge.
  • Exceptional analytical, troubleshooting, testing, and validation skills.
  • Strong communication skills and demonstrated ability to collaborate effectively with application developers.
  • Ability to independently analyze complex problems while recognizing when additional review or approval is appropriate.

PHYSICAL DEMANDS

  • Ability to stand or sit for extended periods of time.
  • Regularly required to sit, stand, and walk.
  • Ability to lift up to 25 pounds.

WORK ENVIRONMENT

  • Exposure to moderate noise level.
  • Office environment 

VISION REQUIREMEN T

  • Close and Distance Vision.
  • Color vision.

PERSONAL PROTECTIVE EQUIPMENT

  • Closed-toe footwear is required when entering the Production Floor (as needed).

OUR BENEFITS

  • Medical, Dental, and Vision Insurance (eligible after 30 days)
  • 401(k) Plan with Company Match
  • Company-Paid and Voluntary Insurance Options at Discounted Rates
  • Paid Time Off (PTO)
  • Paid Sick Time
  • Paid Holidays
  • Employee Product Discounts

Ahead, LLC is an Equal Opportunity Employer and a socially responsible company.  We are committed to providing equal employment opportunities to all applicants and employees without regard to race, color, religion, sex, sexual orientation, national origin, age, disability, veteran status, or any other status protected by applicable federal, state, or local law.

Ahead, LLC participates in E-Verify,  We verify the identity and employment authorization of individuals hired for employment in the United States.

Completion of a post-offer background check is required for all positions . A satisfactory driving record is required for positions in which driving is an essential job function.

Vacancy posted 10 days ago
Similar jobs that could be interesting for youBased on the Senior SQL Server Database Developer / DBA in New Bedford, MA vacancy
  • $89.2k - $129.3k

     ...Position SummaryWe are seeking a Senior Oracle APEX and Database Administrator to support...  ...will work closely with DBA, middleware, and application...  ...database performance and tune SQL, memory, and storageManage...  ...WebLogic or application server configurations for APEX/ORDSCoordinate... 
    Senior
    SQL
    Full time
    Temporary work
    Part time
    Casual work

    Stantec

    Dartmouth, MA
    10 hours ago
  • $132.23k - $176.31k

     ...future of AI‑ready connectivity, join us today. The Role The Senior Lead Marketing Data Platform Architect is responsible for...  ...and enterprise-scale data platforms. ~ Advanced data modeling, SQL, and data architecture expertise. ~ Experience designing AI-driven... 
    Senior
    SQL
    Full time
    Temporary work

    Lumen

    North Dartmouth, MA
    2 days ago
  • $77.2k - $96.5k

     ...Proficiency with Oracle Cloud reporting tools: OTBI, BI Publisher, FBDI, and/or ADFDI ~ Ability to write and troubleshoot complex SQL queries ~ Experience configuring AR, AP, GL, Projects, Costing, and Fusion Tax ~ Familiarity with Oracle Integration Cloud (OIC),... 
    Senior
    SQL
    Full time
    Shift work

    World Wide Technology

    North Dartmouth, MA
    3 days ago
  • $90.8k - $136.2k

     ...in both to write requirements that hold up in the real world. ~ Experience with query languages and data analysis; familiarity with SQL, MongoDB querying, Amplitude, Splunk, and/or Figma is helpful. ~ Systems analysis: ability to analyze and understand complex IT... 
    Senior
    SQL
    Full time
    Flexible hours
    Shift work

    World Wide Technology

    North Dartmouth, MA
    4 days ago
  • $96.4k - $144.6k

     ...supplier master data governance. Working knowledge of Oracle technical tools including OTBI, BI Publisher, FBDI/ADFDI, and strong SQL for data analysis, reconciliation, and troubleshooting. Finance and accounting business process knowledge, including Procure-to-Pay... 
    Senior
    SQL
    Full time
    Remote work
    Flexible hours
    Shift work

    World Wide Technology

    North Dartmouth, MA
    4 days ago
  • Job DescriptionADP is hiring a Bilingual Senior Workforce Manager Support ConsultantAre you...  ....Manage risk, identify gaps, and develop solutions for large scale changes impacting...  ...Strong data analysis skills including Excel, SQL queries and related tools.YOU'LL LOVE WORKING... 
    Senior
    SQL
    Permanent employment
    Temporary work
    Flexible hours

    ADP - Automatic Data Processing

    Dartmouth, MA
    4 days ago
  • $137.48k - $175.02k

     ...DoingJoin our Digital Technology team as a Senior Lead Software Developer and drive innovation across global...  ..., leveraging your expertise in SQL and Python. You’ll champion development...  ...Solid understanding of data modeling, databases, and analytics solutionsPerformance optimization... 
    Senior
    SQL
    Full time
    Worldwide
    Flexible hours

    Acushnet Holdings Corp

    Fairhaven, MA
    10 hours ago
  • $105.4k - $158.1k

     ...every day.Your OpportunityThe Senior Ethical Hacker will conduct...  ...Validate various app services, databases, Kubernetes, serverless...  ...the internal training lab so developers and security champions can staycurrent...  ...writing XSS attacks, System/SQL injection payloads or... 
    Senior
    SQL
    Full time
    Temporary work
    Part time
    Casual work

    Stantec

    Dartmouth, MA
    10 hours ago
  •  ...ensure our suite of products is developed to comply with clients’ needs...  ...configuring the software. A Senior (Technical) Implementation Consultant...  ...and how this impacts the database, customizing templates,...  ...preferably JavaScript and/or SQL.Experience implementing or training... 
    Senior
    SQL
    Temporary work
    Work at office

    ADP - Automatic Data Processing

    Dartmouth, MA
    3 days ago
  •  ...structure to complex problems. The role involves writing complex SQL to access data in our warehouse, while also building and...  ...modern data stack. Responsibilities: Audience Targeting: Develop and implement audience segmentation strategies using advanced SQL... 
    SQL
    Full time

    FocusKPI

    North Dartmouth, MA
    5 days ago
  • $15 per hour

     ...Responsibilities Assist in designing and developing interactive Power BI dashboards and...  ...large datasets from various sources (Excel, SQL, SharePoint, etc.). Collaborate with team...  .... Qualifications ~ Current junior, senior, or recent graduate in Computer Science,... 
    SQL
    Remote job
    Hourly pay
    Internship
    Live in

    Reli Group Inc

    North Dartmouth, MA
    2 days ago
  •  ...attention to detail Bonus: Knowledge of usability testing methods and tools Basic programming or scripting experience in Python, SQL, or JavaScript Experience with Sitecore or other Content Management Systems Company Description At Beckman Coulter... 
    SQL
    Remote job
    Internship
    Worldwide

    Danaher

    North Dartmouth, MA
    3 days ago
  • $120k - $140k

     ...efficiency and sustainability for commercial vehicle fleets, by developing innovative hardware and data analytics solutions. Inventors of...  ...ensure technical success. Build advanced analytical models using SQL, Python, and Excel to demonstrate product value. Monitor... 
    SQL
    Remote job
    Full time
    H1b

    Aperia Technologies

    North Dartmouth, MA
    5 days ago
  •  ...UWEP supports the department by assisting with maintaining and developing league-wide dashboards. The Participant will assume an integral...  ...Tableau, or another data visualization software. Familiarity of SQL, or other programming languages. We are an equal opportunity... 
    SQL
    Remote job
    Work experience placement
    Internship

    United Soccer League (USL)

    North Dartmouth, MA
    3 days ago
  • $40 per hour

     ...statistical analysis, and analytics skills, contributing to a comprehensive understanding of complex datasets. Substantial experience in SQL, along with a solid foundation in at least one programming language (Python or R) Preferred (not required): Familiarity with... 
    SQL
    Remote job
    Full time
    Summer work
    Casual work
    Internship
    Summer internship
    Live in
    Work at office

    Airbnb

    North Dartmouth, MA
    3 days ago
  •  ...the opportunity to collaborate closely with senior engineers and product leaders as part of your team. Together, you'll develop and enhance Instacart's marketplace systems....  ...in Python and fluency in data manipulation (SQL, Pandas) and Machine Learning (scikit-learn,... 
    SQL
    Permanent employment
    Full time
    Work at office
    Remote work
    Work from home
    Flexible hours

    Instacart

    North Dartmouth, MA
    5 days ago
  • $100.39k

     ...organizations. Ideal candidates will possess the ability to design, develop and deploy innovative solutions to address operational...  ...2029 Preferred Qualifications ~ Experience in SQL or other relational databases - Knowledge of Excel - Experience prioritizing and... 
    SQL
    Full time
    Summer work
    Internship
    Local area
    Monday to Friday

    Amazon

    North Dartmouth, MA
    5 days ago
  •  ...applications under the guidance of experienced developers and analysts. Support the documentation of...  ...programming languages such as Java, JavaScript, SQL, Python, or similar. Basic understanding of relational databases and familiarity with writing or reading simple... 
    SQL
    Remote job
    Full time
    Internship
    Work at office
    Flexible hours

    Zimmer Biomet

    North Dartmouth, MA
    5 days ago
  • $200k

    Job TitleThis position is eligible for the Education Debt Reduction Program (EDRP), a student loan payment reimbursement program. You must meet specific eligibility requirements per VHA policy and submit your EDRP application within four months of appointment. Program ...
    Senior
    Work at office

    US Government Jobs

    New Bedford, MA
    5 days ago
  • $77.2k - $115.8k

     ...assessing functional impact and coordinating regression testing. Develop and maintain functional documentation including BRDs, FDDs,...  ...maintaining reports and dashboards using OTBI and BI Publisher; write SQL queries for data extraction, validation, and issue resolution.... 
    SQL
    Full time
    Remote work
    Shift work

    World Wide Technology

    North Dartmouth, MA
    1 day ago
  • $110k - $120k

     ...roof, the people building and supporting our products are close to both the process and the decisions behind it.About the RoleAs a Senior Quality Systems Specialist at Lexington Medical, you will be the hands-on owner of our Quality Management System, working directly... 
    Senior

    Lexington Medical, Inc.

    New Bedford, MA
    2 days ago
  • $126.52k - $168.68k

     ...ownership, deliver meaningful impact, and help shape the future of AI‑ready connectivity, join us today. The Role Identifies and develops new Large Enterprise sales opportunities, provides product solutions, ensures customer satisfaction, and maintains positive... 
    Senior
    Full time
    Temporary work
    Remote work
    Work from home

    Lumen

    North Dartmouth, MA
    3 days ago
  •  ...Senior CounselorThe Vet Center Senior Counselor provides direct counseling services, outreach, referral, and follow-up care coordination...  ...direct readjustment counseling to eligible clients and for developing staff performance through training and clinical supervision.Direct... 
    Senior
    Traineeship
    Remote work
    Monday to Friday
    Night shift
    Weekend work

    US Department of Veterans Affairs

    New Bedford, MA
    1 day ago
  • $90k - $140k

     ...Job Description Job Description Our client , a global engineering and manufacturing company seeks a  SENIOR QUALITY ENGINEER  for a direct hire opportunity to join a  high tech team that is supporting aerospace and medical industries in the production of ceramics... 
    Senior

    Envision Staffing Solutions

    New Bedford, MA
    13 days ago
  • $126.52k - $168.68k

     ...the chance to help lead that change. As an Account Director Senior Large Enterprise, you will own growth across large, important,...  ...position. Anticipate needs before they become formal requirements; develop points of view and use cases that connect modernization to... 
    Senior
    Full time
    Contract work
    Temporary work

    Lumen

    North Dartmouth, MA
    5 days ago
  • $132.3k - $176.4k

     ...The Business Development Account Director is accountable for developing and implementing the overall market penetration and growth strategy...  ...opportunities for target government organizations and briefs senior management on high dollar opportunities Develops and maintains... 
    Senior
    Full time
    Contract work
    Temporary work

    Lumen

    North Dartmouth, MA
    2 days ago
  • $90 - $105 per hour

     ...the Johnson Space Center in Houston, TX What You'll Be Doing Develop and maintain SE&I product schedules to support key program milestones and ensure timely delivery of products. Offer senior-level integration systems test and validation (T&V) support, including... 
    Senior
    Hourly pay
    Part time
    Casual work
    Work at office
    Immediate start
    Remote work
    Relocation package
    Flexible hours

    The Aerospace Corporation

    North Dartmouth, MA
    5 days ago
  •  ...company striving to make a difference every day, we are seeking a Senior Machine Learning Scientist to help build and maintain our...  ...machine learning models at training and inference time.Design, develop, and maintain tools and infrastructure for training, deploying,... 
    Senior
    Work experience placement

    Oxipital AI Inc.

    New Bedford, MA
    2 days ago
  • Senior Financial Analyst — Contract Overview Join a corporate FP&A team as a Senior Financial Analyst supporting high-impact, project...  ...workflows and governance, enhance capital tracking and reporting, develop management tools and dashboards, and identify opportunities to... 
    Senior
    Contract work
    Immediate start
    Flexible hours
    3 days per week

    DeWinter Group

    Fairhaven, MA
    5 days ago
  • STAFF/SENIORACCOUNTANT Burke& Lamb, PC a growing CPA firm is seeking a highly motivated professional tojoin our team in New Bedford, MA. With offices in New Bedford, MA andNantucket, MA we service clients throughout the South Coast, Cape, and the Islands.We provide audit...
    Senior

    BURKE & LAMB PC

    New Bedford, MA
    6 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior SQL Server Database Developer / DBA. Be the first to apply!