Systems Engineer (SQL)

Overview

Please note that this position is contingent upon the successful award of a contract currently under bid.

Global in service but local in approach, Nisga'a Tek is committed to high-quality service to those who defend us. Nisga'a Tek ensures mission assurance and execution for customers and warfighters. Providing intelligence, IT, cyber security, training, logistics, administrative, acquisition, and background investigation services.

Summary:

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

Responsibilities

Essential Job Functions:

• 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.
• Depicts complex ideas, issues and designs to varied audiences; communicates project objectives, scope and status to project teams.

Qualifications

Necessary Skills and Knowledge:

• 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 include 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 to optimize database performance and ensure scalability, responsiveness, and efficiency.
• 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 to enhance data management processes, system performance and overall efficiency.
• Proficient in creating comprehensive system documentation including database schemas, data dictionaries, entity-relationship diagrams, and process flows to facilitate clear communication promote knowledge sharing and ensure the accuracy and integrity of database structures and processes.
• 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 to ensure high availability and disaster recovery capabilities.
• 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 such as SQL Server Profiler, Extended Events, and Dynamic Management Views.
• Skilled in conducting thorough Root Cause Analysis of database issues and performance bottlenecks, utilizing diagnostic tools, query execution plans, and system logs to identify underlying problems and implement effective solutions.
• Proficient in Data Modeling techniques including conceptual, logical, and physical data modeling, utilizing tools such as SQL Server Data Tools.
• Experienced in implementing Database encryption solutions such as Transparent Data Encryption (TDE).
• Always Encrypted, or column-level encryption to safeguard sensitive data at rest and in transit.
• Proficient in configuring and managing SQL Server Database Mail to enable automated email notifications, alerts, and reports, ensuring effective communication and timely response to database events, errors, and performance issues.

Minimum Qualifications:

• 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; or MS: Azure DBAA or higher.
• DLA CE Cert IA Role/Function: DBA Admin

Pay and Benefits The annual salary for this position is $140,000 to $175,000.

At Goldbelt, we value and reward our team's dedication and hard work. We provide a competitive base salary commensurate with your qualifications and experience. As an employee, you'll enjoy a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) plan with company matching, tax-deferred savings options, supplementary benefits, paid time off, and professional development opportunities.

Essential Job Functions:

• 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.
• Depicts complex ideas, issues and designs to varied audiences; communicates project objectives, scope and status to project teams.

Necessary Skills and Knowledge:

• 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 include 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 to optimize database performance and ensure scalability, responsiveness, and efficiency.
• 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 to enhance data management processes, system performance and overall efficiency.
• Proficient in creating comprehensive system documentation including database schemas, data dictionaries, entity-relationship diagrams, and process flows to facilitate clear communication promote knowledge sharing and ensure the accuracy and integrity of database structures and processes.
• 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 to ensure high availability and disaster recovery capabilities.
• 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 such as SQL Server Profiler, Extended Events, and Dynamic Management Views.
• Skilled in conducting thorough Root Cause Analysis of database issues and performance bottlenecks, utilizing diagnostic tools, query execution plans, and system logs to identify underlying problems and implement effective solutions.
• Proficient in Data Modeling techniques including conceptual, logical, and physical data modeling, utilizing tools such as SQL Server Data Tools.
• Experienced in implementing Database encryption solutions such as Transparent Data Encryption (TDE).
• Always Encrypted, or column-level encryption to safeguard sensitive data at rest and in transit.
• Proficient in configuring and managing SQL Server Database Mail to enable automated email notifications, alerts, and reports, ensuring effective communication and timely response to database events, errors, and performance issues.

Minimum Qualifications:

• 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; or MS: Azure DBAA or higher.
• DLA CE Cert IA Role/Function: DBA Admin

Pay and Benefits The annual salary for this position is $140,000 to $175,000.

At Goldbelt, we value and reward our team's dedication and hard work. We provide a competitive base salary commensurate with your qualifications and experience. As an employee, you'll enjoy a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) plan with company matching, tax-deferred savings options, supplementary benefits, paid time off, and professional development opportunities.