Systems Engineer (SQL)

Goldbelt, Inc.•De Leon Springs, FL

19h

About The Position

The Systems Engineer is responsible for provisioning, operating, installing, configuring, and maintaining systems hardware, software, and related infrastructure. The role provides technical support and hands-on delivery for database planning, implementation, and ongoing operation, and contributes to infrastructure research and development. The position ensures systems and related procedures meet organizational values and regulatory requirements, documents specifications and project materials, and communicates project objectives and status to varied audiences. The position is contingent upon the successful award of a contract currently under bid.

Requirements

Five years of overall professional experience in the engineering field.
Five years of experience in SQL Server database administration and analysis support with DoD or Federal IT systems.
Experience with current or recent versions of Windows Server operating systems.
Hands-on experience with SQL Server 2016 or later.
Ability to develop and optimize SQL Server databases on Azure Infrastructure as a Service and implement and manage SQL database solutions using Azure Platform as a Service high-availability, scalability, and security features.
Proficiency designing, implementing, and managing SQL Server databases on Azure Managed Instances.
Experience in AWS database administration, including provisioning, configuring, and optimizing databases for high availability, scalability, and security.
Expertise in T-SQL programming, including writing, debugging, and optimizing complex queries, stored procedures, triggers, and functions.
Database performance-tuning experience using query optimization, index management, partitioning, and resource-utilization analysis.
Experience setting up and configuring SQL backup and recovery operations.
Ability to analyze systems and database requirements, identify optimization opportunities, and recommend strategic solutions to improve data management, performance, and efficiency.
Proficiency creating system documentation, including database schemas, data dictionaries, entity-relationship diagrams, and process flows.
Experience creating and using PowerShell scripts for server management and data acquisition.
Experience with SQL high-availability solutions and technologies for database availability, failover, and data protection.
Experience configuring, managing, and maintaining Fail Over Cluster Instances for high availability and disaster recovery.
Proficiency using DBCC commands for consistency checks, index maintenance, performance tuning, and troubleshooting.
Proficiency configuring and managing SQL Server monitoring tools, including SQL Server Profiler, Extended Events, and Dynamic Management Views.
Experience conducting root cause analysis of database issues and performance bottlenecks using diagnostic tools, query execution plans, and system logs.
Proficiency in conceptual, logical, and physical data modeling, using tools such as SQL Server Data Tools.
Experience implementing database encryption solutions such as Transparent Data Encryption, Always Encrypted, or column-level encryption.
Proficiency configuring and managing SQL Server Database Mail for automated notifications, alerts, and reports.
Experience serving in the roles of Database Architect, Replication Expert, Database Encryption Expert, LDAP/Certificate Authentication Expert, Disaster Recovery/COOP Expert, Database Security Expert, and High Availability Expert.
Must be eligible for IT I clearance; the position has a Critical Sensitive sensitivity level.
Must have a DoD-approved 8140/8570 baseline certification at Category IAT Level II.
Must have one of the following Computing Environment certifications: Oracle OCP DB (version 19 or higher), MCSA: SQL 2016 DBA, OCP SA, OCI Foundations 2020, or MS: Azure DBAA or higher.

Responsibilities

Provision, operate, install, configure, and maintain systems hardware, software, and related infrastructure.
Provide technical support, guidance, and hands-on delivery in planning, implementing, and operating databases.
Participate in technical research and development to enable continuing infrastructure innovation.
Ensure system hardware, operating systems, software systems, and related procedures adhere to organizational values and regulatory requirements.
Document specifications, project plans, configurations, test plans, and results.
Explain complex ideas, issues, and designs to varied audiences and communicate project objectives, scope, and status to project teams.