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.REQNUMBER: 2401008
SAIC is a premier technology integrator, solving our nation’s most complex modernization and systems engineering challenges across the defense, space, federal civilian, and intelligence markets. Our robust portfolio of offerings includes high-end solutions in systems engineering and integration; enterprise IT, including cloud services; cyber; software; advanced analytics and simulation; and training. We are a team of 23,000 strong driven by mission, united purpose, and inspired by opportunity. Headquartered in Reston, Virginia, SAIC has annual revenues of approximately $6.5 billion. For more information, visit saic.com. For information on the benefits SAIC offers, see Working at SAIC. EOE AA M/F/Vet/Disability