Senior SQL Server Database Administrator

Job Locations US-MA-Needham
FLSA Status
Regular Full-Time


About Enservio: 


Enservio, Inc., a Solera Holdings Inc. company, is a leader who is transforming the $15B insurance market.  Our company has solved a decades-old challenge in the insurance industry: property contents valuation – basically, if you’ve lost something how does it get valued? Enservio provides a complete range of software and service solutions to the country’s largest insurers to accurately answer this key question and help people get their lives back together. The company’s technology products include consumer-facing web applications, enterprise SaaS applications and industry-leading business intelligence and predictive analytics, including our latest fraud detection and alternative payment offerings.


Senior SQL Server DBA 


The Senior SQL Server DBA is responsible for managing the SQL Server relational database environment (2008 R2, 2014 and 2016) hosted on the Microsoft Windows 2008R2/2012/2016 platform running on an all-virtualized platform utilizing VMWare ESX in a 24 x 7 environment. The Senior SQL Server DBA works in coordination with other DBAs, as well as other tech ops and engineering team members to best meet database administration responsibilities while strongly supporting department and company goals. Core responsibilities include, but are not limited to implementation, performance tuning, ongoing maintenance, backup/ recovery, security, auditing, production support, migration, On-Call support and architecting adequate technical solutions that best suits the client’s requirements and needs. 

Position 80s

Primary Responsibilities: 

  • Creates processes and procedures to minimize any potential downtime scenarios. 
  • Creates standards for SQL Server database administration that supports the use of optimal database server resources and performance. 
  • Facilitates server-side database development when needed. 
  • Implements and maintains automated database maintenance plans and backup routines using standard methodologies. 
  • Monitors database/ application growth and server resources to ensure optimum performance and availability. 
  • Listen well to others and share ideas in a constructive manner within the DBA, IT, and Engineering teams
  • Collaborates, coordinates and cohesively works with Database Administrators and Applications/ Business teams to support enterprise applications. 
  • Prioritizes tasks effectively to operate in a timely, accurate and professional manner. 
  • Provides accurate status updates to management. 
  • Routinely evaluates/ implements improved methods or processes for administering and maintaining databases and servers. 
  • Troubleshoots minor to major problems on an as-needed basis – often requiring time sensitive response and pro-active communication to different groups within the organization Requirements 
  • Participate in 24x7 On Call rotation 



  • Bachelor's Degree in MIS or Computer Science related field. Proven experience and/ or certification can be substituted for a Bachelor's Degree. 
  • 10+ years DBA experience with Microsoft SQL Server in a production environment is required, with experience in SQL server versions 2008 R2, 2014 & 2016.
  • 8+ years of experience configuring, implementing and supporting large highly available SQL Server environments, including experience with Failover Cluster and database mirroring/ always on is required. 
  • 8+ years of experience with SQL Server troubleshooting; ability to proactively identify, troubleshoot and resolve live database systems issues. 
  • Strong working knowledge of query, index and DB I/O performance tuning, and Stored Procedures and SQL coding is required. 
  • Database migration/ upgrade experience.
  • Ability to cope with multiple demands and produce extremely precise, detailed and confidential work. 
  • Ability to facilitate discussion, to teach, and to train concepts related to data retrieval, data analysis, data integrity and analytical information systems in RDBMS environments. 
  • Ability to manage all DB maintenance activities including backups, indexing, integrity and consistency checks. 
  • Ability to work collaboratively with other internal departments and entities. 
  • Deep understanding of database design principals. 
  • Excellent organizational skills and the ability to prioritize work effectively. 
  • Knowledge of disaster recovery principles and practices, including planning, testing, backup/ restore using disk-based backup solutions. 
  • Self-motivated and able to manage multiple tasks simultaneously with little direction. 
  • Strong organizational, analytical, and communication skills, both oral and written, are required. 


Nice to Haves: 

  • Experience working with MySQL and MongoDB database environments
  • Experience working with data analytics teams and business intelligence tools
  • Experience with SQL Server Reporting Services, SQL Server Integration Services and/or SQL Server Analysis Services.
  • Experience with Powershell
  • Experience running and supporting very large data warehouse databases (OLAP, Big Data) is a plus. 
  • Experience running and supporting very large databases under high transaction rates (OLTP, VLDB). 
  • Working knowledge of Firewall and network security concepts 
  • Working knowledge of Windows Server management such as disk administration, general performance health counters and overall server configuration 
  • General knowledge of Networking concepts such as subnetting, IPV4 routing protocols and overall network connectivity.
  • Understanding of current hardware systems, RAID and disk subsystems commonly used in fault tolerant production environments. 
  • Understanding and experience with SAN hardware and administration. 
  • Understanding of Virtual Server environments. 




Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed