SQL Server DBA

Company: GDHinc.
Location: Boston
Posted on: March 20, 2023

Job Description:

Our client has an opening for a SQL Server Database Administrator (DBA). The selected candidate's tasks will include but are not limited to definition and design of enhancement to existing databases, daily performance monitoring of data base activity, weekly review and tuning of database indexes, troubleshooting of reported problems, and patching as required.

Primary Responsibilities:

• Provide database administration services in support of web and client server applications. Must be able to provide both production and development DBA support tasks.
• Creating and maintaining database documentation, such as data dictionaries, entity relationship diagrams, data models, and stored procedures.
• Install, configure, upgrade and maintain databases on Windows (preferred) or other platforms.
• Administer database users, manage database objects, and configure client network.
• Perform logical and physical database design.
• Implement and enforce security for all the databases.
• Perform database monitoring and tuning using DMVs, Perfmon, profiler and other tools.
• Perform database refreshes of Development and QA databases.
• Work with the application development team on production release deployments.
• Provide support and consultation to the application development team in all database related areas including table and index design and creation and SQL tuning.
• Install and configure DBA management tools.
• Troubleshoot and correct database issues in an efficient and timely manner.
• Perform backup and recovery of databases.
• Support all nightly database maintenance and administration jobs.
• Maintain all production job scripts assigned to the database team.
• Proactively monitor databases and identify potential problems.
• Enforce all database architecture and relevant procedures according to established policies.
• Create, troubleshoot and deploy SSIS/SSRS solutions for data exports/imports and reporting needs.
• Must have worked in Microsoft clustering of SQL databases, Always ON high availability solutions.
• Position will report to the Senior Database Administrator.
  The selected candidate must be able to manage database related services from the planning phase through the implementation and management phases. He or she will interface with other team members, management, and end-users on a regular basis. After hours, availability is required in order to respond to emergencies, production releases, and to perform database maintenance that cannot be completed during normal business hours.
  
  Qualifications/ Skills:
  
  --- 5+ years Database Administration experience; should have experience in test, development and production instances.
  
  --- In-depth knowledge of SQL server versions 2012/2016 and above, with SSIS/SSRS
  
  --- Experience with databases migrations of SQL Servers from older to newer versions
  
  --- Experience in configuring and maintaining SQL Always ON is required.
  
  --- Ability to execute performance monitoring and necessary adjustments.
  
  --- Excellent knowledge of backup and recovery scenarios and backup tools.
  
  --- Highly self-motivated individual who has the ability to work independently as well as in a team environment.
  
  --- Excellent verbal and written communication skills; ability to think strategically with technical vision; proven project management and leadership skills; attention to detail and strong organizational skills.
  
  --- Oracle experience a plus.
  
  #LI-JG2

Keywords: GDHinc., Boston , SQL Server DBA, IT / Software / Systems , Boston, Massachusetts