This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

The hottest job offers in the state of Virgina

To post a job, login or create an account |  Post a Job

New

Sr. SQL DBA – TS/SCI

InSequence, Inc.

This is a Full-time position in Alexandria, VA posted June 11, 2021.

InSequence Overview: At InSequence, we engineer outcomes for your most demanding technology problems.

We hire talented professionals to bridge the technology gap between desired business results and actual implementation.

Our clients range from large government agencies to enterprises that utilize vast amounts of technology and data.

They turn to us for our proven solutions and engineering mindset to manage technology that is predictable, scalable, and reliable.

Clearance Required: TS/SCI Duties include: The UFS Microsoft SQL Database Engineer is responsible for installing and configuring SQL, leveraging monitoring utilities to maximize availability while minimizing false alarms and deploying database change scripts provided by developers and third-party vendors in the areas of VDI, Infrastructure and SharePoint services.

This position will review options and determine effective ways to increase performance, including making hardware or VM recommendations, server configuration changes, index, SQL query and/or database structure changes.

This position will also provide support for scheduled maintenance, upgrades, outages and unexpected interruptions of service.

* 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.

Required : * Must currently possess a TS/SCI with Poly to be considered* Bachelor’s (or equivalent) plus 8+ years of experience, including 6+ years working as a Microsoft SQL Server Database Administrator (DBA).* 6+ years w/ Development and integration of SQL database services in an enterprise environment.* 3+ years working w/ large databases (1 TB+)* 3+ years working in a clustered Windows environment.* 2+ years working w/ AlwaysOn Availability Groups.* 3+ years w/ SQL Server Integration Services (SSIS)* 3+ years w/ SQL Server Reporting Services (SSRS* Required Certification: Sec+ Preferred:* Experience with installing and configuring Microsoft SQL instances for one or more of the following areas:* Virtual Desktop Infrastructure (VDI) Support Services* Infrastructure Services* SharePoint Services Perks: * 100% Employer paid healthcare, dental, and vision insurance * 5% 401k match * Profit Sharing & Stock Options* 3 weeks of PTO & 10 Federal Holidays* Continuous training & education Powered by JazzHR xXtwhRIgUF