SQL System Engineer

ESM•Arlington, VA

1d•$106,000 - $128,000

About The Position

Enterprise Solutions and Management (ESM) is hiring an SQL System Engineer to support an enterprise-level program in a federal environment. The role provides effective provisioning, operation, installation, configuration, and maintenance of systems hardware, software, and related infrastructure, along with technical support and hands-on delivery for database planning, implementation, and ongoing operations. The engineer participates in technical research and development to support continuing infrastructure innovation, and ensures systems, operating systems, software, and related procedures comply with organizational values and regulatory requirements. The role documents specifications, project plans, configurations, test plans, and results, and communicates complex ideas, issues, designs, objectives, scope, and project status to varied audiences and project teams. The position requires extensive SQL Server administration and engineering experience across cloud and on-premises platforms, including database design, optimization, security, high availability, and disaster recovery. A Top Secret clearance and specified DoD certifications are required. Physical duties include office and inter-building walking, including stairs, and lifting up to 25 pounds.

Requirements

Five years of overall professional experience in the engineering field.
Five years of experience in SQL Server database administration and analysis support.
At least five years of experience working with DoD or Federal IT systems.
Experience serving in roles including Database Architect, Replication Expert, Database Encryption Expert, LDAP/Certificate Authentication Expert, Disaster Recovery/COOP Expert, Database Security Expert, and High Availability Expert.
Expert knowledge and practical experience with DoD IT database management technology stacks, including planning and implementing databases and/or Application Server implementations.
Demonstrated experience planning, implementing, and negotiating large technology projects in support of business initiatives, and initiating, planning, mentoring, executing, controlling, and delivering working projects.
Knowledge of current Windows Server operating systems and Microsoft SQL Server 2016 or higher.
Knowledge of SQL Server deployment and administration across Azure IaaS, PaaS, Azure Managed Instances, and AWS environments.
Knowledge of T-SQL programming, database architecture, data modeling, indexing, partitioning, and performance optimization.
Knowledge of SQL Server backup, recovery, high availability, failover clustering, and disaster recovery technologies.
Knowledge of SQL Server security and encryption technologies, including TDE, Always Encrypted, and column-level encryption.
Knowledge of SQL Server monitoring and diagnostic tools, including SQL Server Profiler, Extended Events, DMVs, and DBCC commands.
Ability to independently manage and support enterprise SQL Server environments across cloud and on-premises platforms.
Ability to design scalable, secure, and highly available database solutions; analyze complex database requirements; and develop technical solutions.
Ability to identify performance bottlenecks, determine root causes, and implement corrective actions.
Ability to communicate technical findings and recommendations to stakeholders and cross-functional teams.
Must hold a DoD-approved 8140/8570 Baseline Certification: Category IAT Level II.
Must hold one of the following Computing Environment certifications: Oracle OCP DB (version 19 or higher), MCSA: SQL 2016 DBA, OCP SA, OCI Foundations 2020, or MS: Azure DBAA or higher.
Must have a Top Secret clearance.
Able to stand, walk, and sit; communicate verbally in person and by telephone; use hands to finger, handle, or feel objects or controls; reach with hands and arms; and regularly stoop, kneel, bend, crouch, and lift up to 25 pounds.
Required vision abilities include close vision, distance vision, depth perception, color vision, and the ability to adjust focus.
Position requires extensive walking, including stairs, throughout offices and between buildings; may require public transportation or driving a personal or Government vehicle to local or remote offices.

Nice To Haves

Positive, self-motivated, and proactive, with the ability to adapt to change and tolerate stressful situations.
Communicates effectively with team members, team lead, management, and government customers.
Able and willing to research and develop creative solutions to unique problems with minimal supervision.

Responsibilities

Provision, operate, install, configure, and maintain systems hardware, software, and related infrastructure.
Provide technical support, guidance, and hands-on delivery in database planning, implementation, and ongoing operation.
Participate in technical research and development to enable continuing infrastructure innovation.
Ensure system hardware, operating systems, software systems, and procedures adhere to organizational values and regulatory requirements.
Document specifications, project plans, configurations, test plans, and results.
Communicate project objectives, scope, status, and complex technical ideas, issues, and designs to project teams and varied audiences.
Design, implement, administer, and optimize SQL Server databases across on-premises and cloud environments.
Develop, debug, and optimize T-SQL queries, stored procedures, triggers, and functions.
Tune database performance; manage indexes; optimize queries; and analyze resource utilization.
Configure and manage SQL Server backup, recovery, high availability, and Failover Cluster Instances.
Use PowerShell to automate server administration, database management, and data acquisition tasks.
Troubleshoot complex database and performance issues using diagnostic tools, execution plans, and system logs; conduct root cause analysis and implement corrective actions.
Implement database security and encryption solutions and configure monitoring, alerts, and Database Mail notifications.
Develop database documentation, including schemas, data dictionaries, entity-relationship diagrams, and process flows.
Analyze database systems and recommend improvements to performance, scalability, and operational efficiency.
Maintain database availability, data integrity, security, and operational continuity.
Perform other duties as assigned.