Infrastructure Application and Database Subject Matter Expert (SME) Lead - Microsoft SQL Server

• Provide hands-on technical leadership for the administration, maintenance, security, and performance of DLA Enterprise Microsoft SQL Server database infrastructure.
• Install, configure, provision, patch, upgrade, migrate, consolidate, monitor, and decommission SQL Server databases, instances, and associated infrastructure.
• Design, implement, and operate SQL Server solutions on Microsoft Azure IaaS, Azure PaaS, Azure SQL Database, Azure SQL Managed Instance, AWS, VMware, and Windows Server.
• Configure and maintain SQL Server Always On Availability Groups, Windows Server Failover Clustering, Failover Cluster Instances, replication, log shipping, and high-availability/failover configurations.
• Implement, manage, monitor, and test database backups, transaction-log backups, restoration procedures, recovery operations, and disaster-recovery capabilities.
• Diagnose and resolve database performance problems using query execution plans, indexing, statistics, resource utilization analysis, Extended Events, Dynamic Management Views (DMVs), SQL Server Query Store, and SQL Server performance diagnostics.
• Develop, troubleshoot, maintain, and optimize T-SQL queries, stored procedures, functions, triggers, and complex database operations.
• Perform database consistency validation and maintenance using DBCC commands, index maintenance, and SQL Server health and performance tools.
• Administer SQL Server database storage, file allocation, capacity management, transaction logs, memory utilization, and performance configurations.
• Implement and manage Transparent Data Encryption (TDE), Always Encrypted, column-level encryption, role-based access control, authentication, and SQL Server auditing.
• Configure and maintain SQL Server Database Mail, alerts, notifications, and automated operational monitoring.
• Develop and maintain PowerShell scripts for database administration, server configuration, monitoring, data acquisition, automation, and operational reporting.
• Lead database migrations, infrastructure modernization, software upgrades, configuration changes, and deployment activities with minimal impact to mission-critical services.
• Implement database-specific DISA STIGs, cybersecurity controls, security patches, vulnerability remediation, and audit-support documentation.
• Develop and maintain System Security Plans (SSPs), POA&Ms, technical procedures, configuration documentation, database inventories, and change records.
• Direct SQL Server incident response, database outage recovery, root cause analysis, vendor escalation, and operational restoration.
• Manage incidents, tasks, change requests, and technical support tickets in ServiceNow, ensuring established response and resolution thresholds are achieved.
• Develop, execute, and validate COOP and Disaster Recovery procedures, including RTO/RPO requirements and restoration testing.
• Coordinate with DLA application, Windows, Active Directory, cybersecurity, networking, backup, storage, and cloud infrastructure teams.
• Mentor database administrators and systems engineers, establish technical standards, and lead complex infrastructure engineering and modernization activities.
• Provide operational briefings, technical reporting, standard operating procedures, system performance assessments, and quarterly technical training.
• Participate in scheduled rotating after-hours on-call support and mission-critical incident resolution.

PioneerTech is seeking a senior Microsoft SQL Server Database Infrastructure SME Lead to support DLA’s enterprise database infrastructure. This position requires extensive hands-on SQL Server database administration, infrastructure engineering, performance optimization, cybersecurity, and high-availability operations, combined with technical leadership of database administrators and systems engineers.

Candidate MUST Have Skills, Certifications, and Clearance

• 10+ years of database administration and infrastructure management experience, focused on Microsoft SQL Server supporting DoD, federal, or comparable enterprise production environments.
• Expert-level hands-on administration of Microsoft SQL Server 2016 and later, including installation, configuration, provisioning, upgrading, patching, migrations, troubleshooting, and performance optimization.
• Experience with Microsoft SQL Server deployments across on-premises, virtualized, and cloud environments.
• Demonstrated expertise with Microsoft Azure Infrastructure as a Service (IaaS), Platform as a Service (PaaS), Azure SQL Database, and Azure SQL Managed Instance.
• Hands-on experience implementing SQL Server Always On Availability Groups, Windows Server Failover Clustering, Failover Cluster Instances, backup/recovery, replication, and disaster recovery.
• Advanced proficiency in SQL Server architecture, T-SQL, stored procedures, functions, triggers, query optimization, indexing, resource management, and performance troubleshooting.
• Strong Microsoft Windows Server administration capabilities, including Active Directory, PowerShell, authentication, network connectivity, and infrastructure security.
• Experience with database cybersecurity, encryption, access controls, auditing, DISA STIGs, vulnerability remediation, and DoD security requirements.
• Demonstrated experience directing technical teams and resolving complex production database incidents.
• DoD 8570/8140 IAT Level II certification, including Security+ CE or accepted equivalent.
• Qualifying Computing Environment certification: MCSA SQL Server 2016 DBA, Microsoft Azure Database Administrator Associate or higher, or another explicitly accepted RFQ-listed certification.
• Must possess the required IT-II security eligibility/clearance or qualifying Tier 3/NACLC/ANACI investigation at proposal submission.
• Ability to support DLA NIPRNET/SIPRNET environments and scheduled after-hours operations., * Microsoft Azure Database Administrator Associate or advanced Microsoft data-platform certification.
• Extensive production experience with SQL Server 2019/2022 and Azure SQL Managed Instances.
• Advanced experience deploying and tuning Always On Availability Groups and Failover Cluster Instances.
• Experience operating SQL Server on AWS database services and hybrid cloud infrastructure.
• Experience with MariaDB, MySQL, and other approved relational database platforms.
• Experience with database capacity planning, license management, enterprise database consolidation, and performance automation.
• Demonstrated DoD/DLA enterprise database operations experience.
• Experience leading large SQL Server infrastructure migrations and designing secure, resilient, highly available database solutions.
• Strong vendor-management, technical documentation, mentoring, communication, and production-incident leadership capabilities.

• 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

License/Certification:

• DoD 8570/8140 Level II (Required)

Pioneer Technologies, Inc. (PioneerTech) is an information technology services company delivering enterprise IT infrastructure, systems engineering, cloud modernization, cybersecurity, application support, and technical program services to federal and Department of Defense customers.