Demo

Database Administrator (On-Site)

Avenu Insights & Analytics
Quincy, MA Full Time
POSTED ON 2/28/2025
AVAILABLE BEFORE 5/20/2025

Job Description

Job Description

Job Summary :

This client-facing technical support position involves SQL Server database script writing, software deployments, testing, troubleshooting and report maintenance for the newest unclaimed property management system used by state governments. Excellent written and oral communications skills along with strong task organization skills are required.

Key Responsibilities :

  • Install, configure, and maintain SQL Server databases in on-premises and cloud environments.
  • Manage database backups, restorations, linked servers, and database mail to ensure data integrity and availability.
  • Develop, optimize, and maintain SQL scripts, stored procedures, triggers, views, and functions to enhance application functionality.
  • Design and implement database structures, indexes, and schema modifications to support evolving business needs.
  • Monitor database performance, security, and capacity planning , ensuring high availability and reliability.
  • Troubleshoot database issues and provide proactive solutions to maintain system efficiency.
  • Collaborate with software developers to ensure optimal database performance and seamless integration with applications.
  • Implement best practices for database security and compliance , ensuring adherence to company and industry standards.
  • Support internal stakeholders and state administrators with database-related queries, demonstrating strong customer service and professionalism.
  • Document database configurations, procedures, and policies to streamline operations and knowledge transfer .

Perform other duties as assigned.

Qualifications & Skills :

  • 3 years of experience as a Database Administrator (DBA) with a strong focus on database development .
  • Expertise in SQL Server administration, including installation, configuration, and management .
  • Strong proficiency in T-SQL programming , including writing and optimizing stored procedures, functions, triggers, and complex queries .
  • Experience with database development , including designing and modifying schemas, tables, and relationships.
  • Hands-on experience with performance tuning, indexing strategies, and query optimization .
  • Familiarity with data backup, recovery, and disaster recovery planning .
  • Ability to troubleshoot database connectivity, locking, deadlocks, and other performance issues .
  • Understanding of database security best practices and role-based access control.
  • Strong analytical and problem-solving skills with the ability to work independently and collaboratively.
  • Excellent written and verbal communication skills , with the ability to interact with both technical and non-technical stakeholders.
  • Experience with cloud-based databases (Azure SQL, AWS RDS) is a plus.
  • Education & Experience

  • BA or BS degree
  • 3 years of experience as a Database Administrator (DBA) with a strong focus on database development.
  • Expertise in SQL Server administration, including installation, configuration, and management.
  • Strong proficiency in T-SQL programming, including writing and optimizing stored procedures, functions, triggers, and complex queries.
  • Experience with database development, including designing and modifying schemas, tables, and relationships.
  • Hands-on experience with performance tuning, indexing strategies, and query optimization.
  • Familiarity with data backup, recovery, and disaster recovery planning.
  • Ability to troubleshoot database connectivity, locking, deadlocks, and other performance issues.
  • Understanding of database security best practices and role-based access control.
  • Strong analytical and problem-solving skills with the ability to work independently and collaboratively.
  • Excellent written and verbal communication skills, with the ability to interact with both technical and non-technical stakeholders.
  • Experience with cloud-based databases (Azure SQL, AWS RDS) is a plus.
  • Work Environment

  • Some travel may be required for client service delivery.
  • Professional on-site office setting.
  • Supportive team environment with use of Microsoft Teams for meetings.
  • Physical Demands

  • Must be able to remain in a stationary position for most of the day
  • Constantly operates a computer and other office productivity machinery, such as a printer / copy machine
  • This position needs to occasionally move about inside the office
  • The person in this position frequently communicates via telephone
  • Avenu Summary :

    With the backing of four decades of public sector expertise and corporate capability, Avenu has successfully supported government services. Avenu was honored and recognized for four (4) consecutive years as a GovTech 100 Company representing the top 100 companies focused on making a difference in and selling to state and local government agencies across the United States.

    Avenu is committed to helping communities thrive and brings a wealth of experience combined with innovation. Today, Avenu offers more administrative and financial support to government officials than any other organization. And with a responsive, client-focused approach, we foster partnerships that give our customers the certainty they need to accomplish more.

    Avenu offers a competitive benefits and compensation package and are looking for team members who will thrive in our dynamic environment.

    Avenu is an Equal Opportunity Employer. Selection for a position will be made without regard to race, religion, national origin, sex, political affiliation, marital status, non-disqualifying physical handicap, and age.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Database Administrator (On-Site)?

    Sign up to receive alerts about other jobs on the Database Administrator (On-Site) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $96,598 - $126,350
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $130,034 - $179,473
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $73,046 - $96,976
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $57,222 - $76,505
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Avenu Insights & Analytics

    Avenu Insights & Analytics
    Hired Organization Address Birmingham, AL Full Time
    Job Summary: The Revenue Supervisor is responsible for managing the Revenue Department staff, overseeing daily operation...
    Avenu Insights & Analytics
    Hired Organization Address Birmingham, AL Full Time
    Job Description Job Description Job Summary : As a Business License Administrator in a dynamic call center environment, ...
    Avenu Insights & Analytics
    Hired Organization Address Germantown, TN Part Time
    Job Summary: You create amazing experiences for our library patrons – especially children, parents, and caregivers. You ...
    Avenu Insights & Analytics
    Hired Organization Address Chicago, IL Full Time
    Job Description Job Description Job Summary : Join our team as a Document Scanner and play a vital role in preserving hi...

    Not the job you're looking for? Here are some other Database Administrator (On-Site) jobs in the Quincy, MA area that may be a better fit.

    Database Administrator

    hackajob, Boston, MA

    Database Administrator

    Satine Technologies, Cambridge, MA

    AI Assistant is available now!

    Feel free to start your new journey!