Systems Engineer, SQL

This is a fully remote position, open to applicants in United States.

📋 Description

• Provision, operate, install/configure, and maintain systems hardware, software, and associated infrastructure.

• Deliver technical support, guidance, and hands-on assistance for planning, implementing, and managing databases.

• Engage in technical research and development to foster ongoing infrastructure innovation.

• Ensure compliance of system hardware, operating systems, software systems, and related procedures with organizational values and regulatory standards.

• Document specifications, project plans, configurations, test plans, and outcomes.

• Illustrate complex concepts, issues, and designs to diverse audiences.

• Communicate project goals, scope, and progress to project teams.

⛳️ Requirements

• A minimum of five (5) years of professional experience in the engineering sector.

• Five (5) years of experience in SQL Server database administration and analysis support within DoD or Federal IT systems.

• Proven experience serving as a Database Architect, Replication Expert, Database Encryption Expert, LDAP/Certificate Authentication Expert, Disaster Recovery/COOP Expert, Database Security Expert, and High Availability Expert.

• Familiarity with current/recent versions of Windows Server operating systems.

• Practical experience with SQL Server 2016 and later versions.

• Experience in developing and optimizing SQL Server databases on Azure IaaS and managing SQL database solutions utilizing Azure PaaS features for high availability, scalability, and security.

• Proficiency in designing, implementing, and managing SQL Server databases on Azure Managed Instances.

• Experience in AWS database administration, including the provisioning, configuration, and optimization of databases for high availability, scalability, and security.

• Expertise in T-SQL programming, encompassing complex queries, stored procedures, triggers, and functions.

• Proven skills in database performance tuning, query optimization, index management, partitioning, and resource utilization analysis.

• Experience in establishing and configuring SQL backup and recovery operations.

• Systems analysis expertise in evaluating database requirements and proposing optimization solutions.

• Proficiency in creating database schemas, data dictionaries, entity-relationship diagrams, and process flows.

• Experience in developing and using PowerShell scripts for server management and data acquisition.

• Familiarity with SQL High Availability solutions and technologies.

• Experience in configuring, managing, and maintaining Failover Cluster Instances.

• Proficiency in utilizing DBCC commands.

• Proficiency in configuring and managing SQL Server Profiler, Extended Events, and Dynamic Management Views.

• Experience in conducting Root Cause Analysis for database issues and performance bottlenecks.

• Proficiency in data modeling using tools such as SQL Server Data Tools.

• Experience in implementing database encryption solutions, including TDE, Always Encrypted, or column-level encryption.

• Proficiency in configuring and managing SQL Server Database Mail.

• Must be eligible for IT I Critical Sensitive clearance.

• Must possess a DoD Approved 8140/8570 Baseline Certification: Category IAT Level II.

• Must hold one of the following CE certifications: Oracle OCP DB (version 19 or higher), MCSA: SQL 2016 DBA, OCP SA, OCI Foundations 2020, or MS: Azure DBAA or higher.

• DLA CE Cert IA Role/Function: DBA Admin.

🏝️ Benefits

• Medical, dental, and vision insurance.

• 401(k) plan with company matching.

• Tax-deferred savings options.

• Supplementary benefits.

• Paid time off.

• Professional development opportunities.