Systems Engineer (SQL)
Required skills
- SQL Server 2016
- Azure Managed Instances
- AWS Database administration
- T-SQL
- SQL Server
- PowerShell
- SQL High Availability
- Fail Over Cluster Instances
- DBCC Commands
- SQL Server Profiler
Nice to have
- contract award
- mission assurance
- intelligence
- IT
- cyber security
- training
Role summary
Nisga'a Tek is seeking a Systems Engineer with SQL expertise to support a contract under bid. The role involves the provisioning, operation, and maintenance of systems hardware, software, and infrastructure, with a strong focus on SQL Server databases on Azure and AWS platforms. Responsibilities include technical support, database implementation, performance tuning, security features, backup and recovery, and comprehensive system documentation. The position requires 5 years of overall engineering experience and 5 years in SQL Server database administration, particularly with DoD or Federal IT systems. Candidates must be eligible for an IT I clearance and possess specific security certifications (DoD 8140/8570 IAT Level II and a relevant Computing Environment certification).
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.
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.
Originally posted on Himalayas
Similar roles
- IT Documentation SpecialistGoldbelt · Remote · Remote
- Cloud AdministratorGoldbelt · Remote · Remote
Systems EngineerBooz Allen Hamilton · Beavercreek, OH · Onsite
Chief Space Vehicle Systems EngineerSAIC · El Segundo, CA · Onsite- Physical Security Systems EngineerK Group Companies · Grand Rapids, MI · Onsite
Sr. EOIR Systems Engineering ManagerSanta Barbara Infrared, Inc. · Santa Barbara, CA · Onsite
