Systems Engineer (SQL)
New
J
JobgetherGovernment IT
Based in the United StatesFull-TimeMiddle
Salary140,000 - 175,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- At least 5 years of overall professional experience in engineering; at least 5 years of experience in SQL Server database administration and analysis support within DoD or federal IT systems.
- Required Skills
- AWSMicrosoft AzureMicrosoft SQL Server
Requirements
- Have at least 5 years of overall professional engineering experience.
- Have at least 5 years of SQL Server database administration and analysis support experience in DoD or federal IT systems.
- Have experience with database architecture, replication, encryption, security, LDAP and certificate-based authentication, disaster recovery, COOP, high availability, and failover management.
- Have experience with current or recent Windows Server operating systems and SQL Server 2016 or later.
- Have hands-on expertise with Azure IaaS, PaaS, and Managed Instances, and experience administering and optimizing AWS databases.
- Demonstrate advanced T-SQL skills, including complex queries, stored procedures, triggers, and functions.
- Have experience with performance tuning, query optimization, indexing, partitioning, and resource management.
- Have experience configuring SQL Server backup, recovery, high availability, and disaster recovery solutions, including Failover Cluster Instances.
- Be proficient in PowerShell scripting for server administration and automation.
- Have experience with DBCC commands, SQL Server Profiler, Extended Events, and Dynamic Management Views.
- Have data modeling experience, including conceptual, logical, and physical models; SQL Server Data Tools is preferred.
- Be able to perform root cause analysis and resolve complex database and infrastructure issues.
- Have technical documentation, analytical, communication, and problem-solving skills.
- Be eligible for IT I clearance with a Critical Sensitive designation.
- Hold a DoD-approved 8140/8570 baseline certification at Category IAT Level II and at least one qualifying Computing Environment certification: Oracle OCP Database version 19 or higher, MCSA: SQL Server 2016 DBA, OCP SA, OCI Foundations 2020, or Microsoft Azure Database Administrator Associate or higher. Must also meet DLA Computing Environment certification requirements for the DBA Administrator role/function.
Responsibilities
- Provision, install, configure, operate, and maintain systems hardware, software, databases, and related infrastructure.
- Plan, implement, administer, and support database operations.
- Design, develop, and optimize SQL Server databases on Azure IaaS, PaaS, and Managed Instances.
- Administer AWS database environments, including provisioning, configuration, optimization, security, and availability.
- Develop, debug, and optimize T-SQL queries, stored procedures, triggers, and functions.
- Tune database performance through query optimization, index management, partitioning, and resource analysis.
- Configure and maintain database backup, restoration, recovery, high-availability, and disaster-recovery solutions.
- Implement database security and encryption, including TDE, Always Encrypted, and column-level encryption.
- Monitor and troubleshoot databases using DBCC commands, SQL Server Profiler, Extended Events, Dynamic Management Views, execution plans, and system logs.
- Maintain database models, schemas, data dictionaries, diagrams, scripts, and technical documentation.
View Full Description & ApplyYou'll be redirected to the employer's site
