• Job Description

  Req#: 48610618

  Description

  SAIC is seeking a Senior Database Administrator to work at the Department of Transportation headquarters in Washington D.C.

  This role is hybrid and requires 2 days per week on-site.

  Responsibilities:

  · Install, configure, and manage SQL Server instances (2019/2017/2016/2014/2012) in both prod/dev/test environments.

  · Deploy and manage SQL Server on various platforms, including VMWare, Azure (IaaS/PaaS), and on-premises.

  · Build and manage Azure managed instances and Azure managed databases.

  · Facilitate database migration from on-premises environments to Azure.

  · Execute SQL database upgrades, migrations, backups, and restores.

  · Administer user access by provisioning SQL logins and users based on project requirements.

  · Configure and troubleshoot database Always-on availability groups (AG) and AG-related issues.

  · Establish AG listeners and add databases to Always On while handling failover scenarios.

  · Implement and troubleshoot database mirroring solutions.

  · Configure and troubleshoot database log shipping setups.

  · Set up and troubleshoot database transaction replication configurations.

  · Manage SQL clusters and resolve cluster-related issues.

  · Monitor database conditions, proactively rebuild indexes, and perform routine maintenance tasks.

  · Utilize monitoring and performance tuning skills to schedule automated activities, including database health checks, disk space monitoring, job alerts, index monitoring, and statistics tracking.

  · Configure database mail for SQL job alerts.

  · Install and configure SQL Server Reporting Services (SSRS), including report deployment and server security management.

  · Apply Service Packs to SQL Server versions (2008R2, 2012, 2016, 2017, 2019) and patches to Windows Server versions (2003, 2003 R2, 2012, 2019).

  · Create and manage incident/changes using the Service Now ticketing system.

  · Provide exceptional on-demand customer service.

  · Collaborate with application teams to troubleshoot application issues from a database perspective.

  · Demonstrate expertise in Transparent Data Encryption (TDE).

  · Implement SQL Server Security Technical Implementation Guides (STIG) compliance.

  Qualifications

  Required Education and Experience:

  · Bachelor's Degree in technical discipline and 5+ of related experience; 10+ years of related experience is preferred.

  · Must be able to obtain and maintain a Public Trust clearance based on the Department of Transportation regulations.

  o Candidates must be a U.S. Citizen or Green Card holder who has resided in the United States for at least 3 years.

  Required Skills:

  · Strong understanding of SQL Cluster, including knowledge of Always-On Cluster and Distributed Always-On Cluster

  · Knowledgeable in SQL Replication

  · Experience working on on-premises to Azure Migration and Azure Managed Instance

  Desired Skills

  · SQL STIG (Security Technical Implementation Guides)

  · TDE (Transparent Data Encryption)

  · SQL Certified DP-300 Certification (a plus)

  
  Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.

• About the company

  SAIC is a premier technology integrator providing full life cycle services and solutions in the technical, engineering, intelligence, and IT markets.

Notice