Systems Engineer - Microsoft SQL Server Database Infrastructure

PioneerTech is seeking a highly skilled Microsoft SQL Server Database Systems Engineer to provide hands-on engineering and operational support for the DLA Enterprise Database Infrastructure Support program. The position emphasizes installation, configuration, database performance optimization, high availability, cloud database administration, cybersecurity, operational monitoring, and rapid resolution of production database infrastructure issues., * Perform hands-on installation, provisioning, configuration, administration, monitoring, maintenance, and troubleshooting of DLA Microsoft SQL Server infrastructure.

• Install, configure, patch, upgrade, migrate, and support Microsoft SQL Server 2016 and later on Windows Server and cloud-based infrastructure.
• Deploy, administer, monitor, and optimize databases within Microsoft Azure IaaS, Azure PaaS, Azure SQL Database, Azure SQL Managed Instance, AWS, and VMware environments.
• Configure and maintain SQL Server Always On Availability Groups, Windows Failover Clustering, Failover Cluster Instances, replication, log shipping, and failover solutions.
• Implement and validate database backup, transaction-log backup, database restoration, recovery, and high-availability procedures.
• Monitor and optimize SQL Server performance using query execution plans, Dynamic Management Views (DMVs), Extended Events, SQL Server Query Store, index statistics, resource utilization, and system diagnostic tools.
• Develop, maintain, troubleshoot, and optimize T-SQL queries, stored procedures, triggers, functions, and database scripts.
• Perform database consistency checks, index maintenance, storage monitoring, and diagnostics using DBCC commands and SQL Server database utilities.
• Analyze database performance bottlenecks involving SQL queries, CPU, memory, disk I/O, transaction logs, indexing, locking, storage, and network resources.
• Configure and administer database access controls, authentication, roles, permissions, encryption, auditing, and secure connectivity.
• Implement Transparent Data Encryption (TDE), Always Encrypted, column-level encryption, and database security controls as required.
• Configure SQL Server Database Mail, automated alerts, notifications, and monitoring to support timely incident identification and response.
• Develop and maintain PowerShell scripts for Windows Server and SQL Server administration, monitoring, configuration, data acquisition, and automation.
• Support enterprise database infrastructure migrations, cloud modernization, server upgrades, database consolidation, and application release activities.
• Apply DISA STIGs, software security updates, vulnerability remediation, and approved DoD database configuration standards.
• Diagnose and resolve database outages, performance issues, configuration problems, connectivity failures, and application/database integration issues.
• Create, track, update, and resolve incidents, tasks, change requests, and service tickets through ServiceNow, adhering to DLA operational SLAs.
• Develop and maintain database documentation, schemas, data dictionaries, entity-relationship diagrams, configuration records, process flows, and operational procedures.
• Support database security assessments, SSP documentation, POA&M tracking, and security compliance activities.
• Participate in the development, testing, and execution of COOP and Disaster Recovery procedures, including RTO/RPO analysis and database restoration testing.
• Coordinate with SQL Server SME Leads, database administrators, Windows Server engineers, Active Directory administrators, AWS/Azure cloud teams, networking, backup/storage, cybersecurity, and application development teams.
• Conduct root cause analysis of production issues and implement preventative corrective actions to improve database reliability, scalability, and availability.
• Perform database system health checks, reporting, incident follow-up, and documentation of performance improvements.
• Participate in rotating on-call support and mission-critical database outage recovery activities.

• Five (5) years of professional engineering experience.
• Five (5) years of Oracle and/or SQL Server database administration and analysis support, with significant hands-on Microsoft SQL Server database capabilities.
• Strong experience administering SQL Server 2016 and later, including database installation, provisioning, configuration, monitoring, upgrading, patching, migration, and troubleshooting.
• Experience administering SQL Server in Windows Server environments and on Microsoft Azure IaaS, PaaS, Azure SQL Database, and Azure SQL Managed Instance.
• Hands-on expertise with SQL Server Always On Availability Groups, Windows Server Failover Clustering, Failover Cluster Instances, replication, backup/recovery, and high availability.
• Advanced proficiency in T-SQL programming, stored procedures, triggers, database functions, database performance analysis, indexing, and query optimization.
• Experience implementing SQL Server backup/restore, database consistency validation, storage administration, database security, and enterprise operational monitoring.
• Experience with Windows Server, Active Directory, PowerShell, virtualization, cloud database services, and enterprise network connectivity.
• At least five years supporting DoD or federal IT systems.
• Experience implementing DISA STIGs, database security controls, encryption, auditing, vulnerability remediation, and secure configurations.
• DoD 8140/8570 IAT Level II certification, including Security+ CE or accepted equivalent.
• One qualifying Computing Environment certification: Oracle OCP Database 19 or higher, MCSA SQL 2016 DBA, OCP SA, OCI Foundations 2020, or Microsoft Azure Database Administrator Associate or higher, as specified in the RFQ.
• Must be eligible for Critical Sensitive IT-I access and meet applicable federal investigation requirements.
• Ability to troubleshoot critical database outages, restore services, and participate in emergency response and after-hours support., * Microsoft Azure Database Administrator Associate or advanced Microsoft database certification.
• Production SQL Server 2019/2022 and Azure SQL Managed Instance experience.
• Advanced SQL Server Always On, Failover Cluster Instance, replication, and database recovery expertise.
• Experience administering databases on AWS and managing hybrid cloud or multi-cloud infrastructure.
• Knowledge of MariaDB, MySQL, and other approved open-source relational database technologies.
• Experience with SQL Server Data Tools, advanced query optimization, data modeling, partitioning, indexing, and capacity planning.
• Experience implementing database performance automation and secure operational monitoring.
• Familiarity with Windows Server authentication, LDAP, Active Directory integration, and certificate-based authentication.
• Experience with DoD/DLA production database support and DISA cybersecurity controls.
• Demonstrated success resolving complex SQL Server incidents in high-availability enterprise environments.
• Strong documentation, problem-solving, cross-team collaboration, and technical communication skills.

• 401(k)
• 401(k) matching
• Dental insurance
• Health insurance
• Life insurance
• Paid time off
• Tuition reimbursement
• Vision insurance

PioneerTech is an Equal Opportunity Employer.

Pay: $135,000.00 - $170,000.00 per year

Pioneer Technologies, Inc. (PioneerTech) delivers enterprise IT infrastructure services, systems engineering, cloud solutions, application modernization, cybersecurity, and technical support to federal and Department of Defense customers.