Skip to Main Content
← Back to Jobs

SQL Server Database Administrator

The Midtown Group Gaithersburg ,MD
  • Expired: 26 days ago. Applications are no longer accepted.
Job Description

Our client is in need of a SQL Server Database Administrator with a specific skill set to work with our database administrators for up to 2 years (through Dec 2021) or longer. Following are the objectives and requirements for this position:

KEY JOB FUNCTIONS

  • Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
  • Install SQL Server service packs and updates.
  • Configure and manage SQL Security settings and apply STIG settings.
  • Make system design recommendations according to Microsoft SQL Server best practices.
  • Manage database backup & recovery & DR planning.
  • Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
  • Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.
  • Utilize SQL Server Policy Based Management to validate configurations across the enterprise.
  • Troubleshoot application slowness and performance issues.
  • Responsible for T-SQL index & query tuning, and optimizing queries/indexes for very large databases, 30+ million record tables, multi-terabyte databases.
  • Responsible for database migrations and server upgrades.
  • Create and edit technical documentation as requested according to ATR standards.
  • Develop documentation and training of routine database administration tasks and train server operations staff on these tasks.
  • Responsible for ETL of large text files (1 TB +) into SQL Server
  • Author and modify SQL Server Reporting Services reports.
  • Responsible for SQL Server Capacity planning
  • Perform SQL Server integration with enterprise applications.
  • T-SQL Programming
  • Perform additional tasks as assigned
  • Provide weekly status reports to Government management. (we can tweak this, or remove it)
    • Operational Status Report
      1. Report will include the operational status for the week, downtime, job failures, restores performed, other issues, etc.
    • Engineering Status Report
      1. This report will include status updates on engineering tasks and projects.

OBJECTIVES

  • Support the ATR mission by ensuring system uptime, security, and data integrity requirements are met.

REQUIRED Qualifications

  • 4+ years working as a Microsoft SQL Server Database Administrator (DBA).
  • 4+ years w/ Development and integration of SQL database services in an enterprise environment.
  • 4+ years working w/ large databases (1 TB+)
  • 4+ years working in a clustered Windows environment.
  • 3+ years w/ SQL Server Integration Services (SSIS)
  • 3+ years w/ SQL Server Reporting Services (SSRS)

 

The Midtown Group

Why Work Here?

This company has plenty of room to grow and truly values their employees.

Address

0000
Gaithersburg, MD
USA

Website