[Hiring] Systems Engineer @Goldbelt

Role Description

The Systems Engineer is responsible for effective provisioning, operation, installation/configuration, and maintenance of systems hardware/software/related infrastructure.

• Provide technical support, guidance, and hands-on delivery in the planning, implementation, and ongoing operation of databases.
• Participate in technical research and development to enable continuing innovation within the infrastructure.
• Ensure that 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.
• Depict complex ideas, issues, and designs to varied audiences; communicate project objectives, scope, and status to project teams.

Qualifications

• Experience with current/recent versions of Windows Server operating systems.
• Hands-on experience utilizing SQL Server 2016 and above.
• Develop and optimize SQL server databases on Azure Infrastructure as a Service (IAAS) platform.
• Implement and manage SQL database solutions with built-in high availability, scalability, and security features offered by Azure Platform as a Service (PAAS).
• Proficient in designing, implementing, and managing SQL Server databases on Azure Managed Instances.
• Experience in AWS Database administration including provisioning, configuring, and optimizing databases ensuring high availability, scalability, and security.
• Expertise in T-SQL programming, including proficient writing, debugging, and optimizing complex queries, stored procedures, triggers, and functions to support application requirements and enhance database performance.
• Demonstrated ability in Database performance tuning, utilizing advanced techniques such as query optimization, index management, partitioning, and resource utilization analysis.
• Experience in setting up and configuring SQL backup and recovery operations.
• Conduct thorough systems analysis to assess database requirements, identify opportunities for optimization, and recommend strategic solutions.
• Proficient in creating comprehensive system documentation including database schemas, data dictionaries, entity-relationship diagrams, and process flows.
• Experience in creating and using PowerShell scripts for server management and data acquisition.
• Experience with SQL High Availability solutions and technologies for ensuring database availability, failover, and data protection.
• Experienced in configuring, managing, and maintaining Fail Over Cluster Instances.
• Proficient in utilizing DBCC Commands for database consistency checks, index maintenance, performance tuning, and troubleshooting.
• Proficient in configuring and managing SQL Server Trace and Monitoring tools.
• Skilled in conducting thorough Root Cause Analysis of database issues and performance bottlenecks.
• Proficient in Data Modeling techniques including conceptual, logical, and physical data modeling.
• Experienced in implementing Database encryption solutions such as Transparent Data Encryption (TDE).
• Proficient in configuring and managing SQL Server Database Mail.

Requirements

• Five (5) years of overall professional experience in the engineering field.
• Five (5) years’ experience in SQL Server database administration and analysis support with DoD or Federal IT systems.
• Requires experience serving in the following roles:
  • Database Architect
  • Replication Expert
  • Database Encryption Expert
  • LDAP/Certificate Authentication Expert
  • Disaster Recovery/COOP expert
  • Database Security Expert
  • High Availability Expert

Security/Certification Requirements

• Sensitivity Level: Critical Sensitive IT I Clearance: Must be eligible for IT I.
• Must have a DoD Approved 8140/8570 Baseline Certification: Category IAT Level II.
• Must have (one of the following) Computing Environment (CE) certifications:
  • Oracle OCP DB (version 19 or higher)
  • MCSA: SQL 2016 DBA
  • OCP SA
  • OCI Foundations 2020
  • MS: Azure DBAA or higher
• DLA CE Cert IA Role/Function: DBA Admin.

Benefits

• The annual salary for this position is $140,000 to $175,000.
• Comprehensive benefits package, including:
  • Medical, dental, and vision insurance
  • 401(k) plan with company matching
  • Tax-deferred savings options
  • Supplementary benefits
  • Paid time off
  • Professional development opportunities