Digital Prospectors Senior SQL Server Database Administrator in Boston, Massachusetts

Senior SQL Server Database Administrator

Boston, Massachusetts

Job Type: Contract

Recruiter: Chip Clarke at

Phone: 6032157063

Find your job at

Job Title: Senior SQL Server Database Administrator

Location : Boston, MA 02116

Duration: 6+ Months


The primary responsibilities of the Microsoft SQL Server Senior Database Administrator will be to perform SQL Server Database Administration and Application Development activities with duties including: performance tuning, operating platforms, data modeling, design, development, monitoring, database capacity and utilization, server applications security, archiving, backups, disaster recovery, and documentation based on policies, industry best practices, and customer based business requirements; construct and maintain data systems to ensure efficient data access and usage, security (permission and access) and protection of the data; working on the physical data models and architecture with the team; collaborating with the data stewards to ensure policies, definitions, and rules reflect attributes; perform data integrity and quality audits, developing Database Administration policies and procedures as needed.

The candidate must also be able to work with a highly skilled team in a fast-paced environment helping to upgrade older versions of Microsoft SQL Server databases (2005, 2008) to Microsoft SQL Server 2014. This candidate must have a strong DBA background as well as experience implementing similar projects. The selected candidate will be required to participate in database and impacted application analysis. Upon signoff of the analysis, the candidate is expected to create DBA scripts and execute necessary steps to upgrade the database to the new environment. The candidate will need to work in a tight cross team collaboration to ensure undisruptive business operation during the upgrade.

RESPONSIBILITIES include, but not limited to, the following:

Primary Responsibilities

  • Managing and maintaining the current database deployment process

  • Managing and maintaining user set up / access

  • Scripting and troubleshooting database code fixes

  • Troubleshooting performance issues

  • Perform some Data Analysis

Server Planning

  • Plan, allocate, install, and configure SQL Servers (with appropriate patch level)

  • Plan and implement development, staging, and production database environments

  • Plan, implement, and maintain Backup and Disaster Recovery solutions

Database Administration

  • Plan, create, implement, monitor, and maintain backups; restore databases as requested

  • Plan, create, implement, and maintain database maintenance plans, including DBCC, defragging indices, etc.; including all supporting documentation.

  • Plan, monitor, request allocation and maintain appropriate amounts of disk storage for all SQL Servers; communicate storage estimates to Network Solutions group

  • Ensure optimal database and/or server performance, availability, and capacity utilization through proper server configuration, hardware recommendations, software utilities (e.g. defrag utility), individual issue resolution, etc.

  • Maintain proper patch levels on SQL Servers

  • Provide technical support, troubleshooting and resolution for database related issues

  • Create new databases as requested

  • Review query plans, optimize index usage, perform TSQL code review and optimization as needed

SQL Server Security Administration

  • Maintaining proper server, database and data access controls

  • Perform internal security audits and scans, identify vulnerabilities

  • Plan and recommend SQL Server security strategy

  • Organize and facilitate external audits


  • Develop comprehensive understanding of current database systems

  • Participate in strategic planning of database technology usage such as SQL Server version levels, hardware levels, job automation, failure notifications, server monitoring, etc.

Additional Responsibilities:

SQL Server Upgrades

  • Install and configure new SQL 2014 Servers (both stand alone and clustered)

  • Install and configure new SQL 2014 SSRS, SSAS, SSIS

  • Perform database upgrades

  • Perform and manage SQL server database backups

  • Analyze database and application dependencies

  • Setup procedures to proactively monitor databases from a performance, diagnostic and capacity management perspective

  • Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention

  • Assess risks and plan upgrading strategy

  • Be active team collaborator and contributor

  • Create documentation


The candidate must have ten or more years of experience as a Microsoft SQL Server Database Administrator

  • The candidate must have experience in the upgrade of SQL Server databases

  • Proficiency in all DBA tasks with Microsoft SQL Server versions 2000 thru 2014

  • Proficiency in the configuration and use of the SQL Server Monitoring tools preferably Redgate

  • Expert knowledge of SSIS, SSRS and SSAS (minimum of 10 years experience)

  • Understanding and ability to implement database security best practices

  • Excellent attention to details as well as an ability to see a big picture

  • Ability to work on agile projects

  • The candidate must have strong analytical, detailed, problem solving, troubleshooting, and organizational skills

  • Solid oral and written communications skills with technical and non-technical individuals in a positive and professional manner in a highly dynamic environment.

  • Familiarity with all phases of the software development life cycle while working within a software development organization.

  • Ability to work independently with limited supervision and guidance.

  • A Bachelor’s degree or equivalent combination of experience and education is required.

  • Minimum of five years’ experience with T-SQL and SQL Server Management Studio within a SQL Server environment, ranging from SQL Server 2005, 2008 & 2012. Good knowledge of MSSQL Server 2014.

  • Experience with configuration management tools, i.e. Visual SourceSafe, Team Foundation.

  • Minimum 5 years’ experience with a scripting or .Net language for managing SQL command files and C# programs used in an automated database build environment.

POST-OFFER BACKGROUND CHECK IS REQUIRED. An essential function of this job is physical attendance. Digital Prospectors is an Equal Opportunity Employer which includes providing equal employment opportunity for all protected classes including veterans and individuals with disabilities.

Make this your next career move as one of our many long-term contractors or employees!


Founded in 1999, Digital Prospectors is an award-winning recruiting and consulting firm that specializes in placing contract, contract-to-hire and direct hire engineers into rewarding opportunities with our impressive and ever-growing client base. We believe that all people should love their jobs.

Come see why Digital Prospectors has been voted “ Best Staffing Firm to Temp For ” by Staffing Industry Analysts, " Best of Staffing " for candidate satisfaction by Inavero /, " Top Temporary Placement Firm " by Boston Business Journal, " Best Company To Work For " by Business NH magazine, " Excellence in IT and Engineering Staffing ” by TechServe Alliance, " Top IT Services Company " by Inc. Magazine, " Most Reliable Staffing Agency " in Forbes Magazine and " Top Ranked Staffing Firm " by Staffing Industry Analysts.

Phone: 603-772-2700