SQL System Engineer

ESM•Arlington, VA

14h

About The Position

Enterprise Solutions and Management (ESM) is hiring a SQL System Engineer to support an enterprise-level program in a federal environment. The role is responsible for provisioning, operating, installing, configuring, and maintaining systems hardware, software, and related infrastructure. It provides technical support, guidance, and hands-on delivery for database planning, implementation, and ongoing operation, and participates in technical research and development to support continued infrastructure innovation. The engineer ensures systems and related procedures adhere to organizational values and regulatory requirements, documents specifications, project plans, configurations, test plans, and results, and communicates complex ideas and project objectives, scope, and status to varied audiences and project teams. The position supports enterprise SQL Server environments across on-premises and cloud platforms. Work encompasses database design, administration, performance optimization, security, monitoring, backup and recovery, high availability, and disaster recovery. The role also involves planning and implementing databases and application server implementations, and contributing to large technology projects that support business initiatives. Other duties may be assigned.

Requirements

At least five years of overall professional experience in the engineering field.
At least 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 as a 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.
Demonstrated experience planning, implementing, and negotiating large technology projects in support of business initiatives.
A DoD-approved 8140/8570 Baseline Certification at Category IAT Level II.
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.
Minimum Top Secret clearance.
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, including queries, stored procedures, triggers, and functions.
Knowledge of 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 Transparent Data Encryption (TDE), Always Encrypted, and column-level encryption.
Knowledge of SQL Server monitoring and diagnostic tools, including SQL Server Profiler, Extended Events, Dynamic Management Views (DMVs), and DBCC commands.
Ability to independently manage and support enterprise SQL Server environments across cloud and on-premises platforms.
Ability to design and implement scalable, secure, and highly available database solutions.
Ability to analyze complex database requirements and develop effective 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.
Ability to communicate effectively with team members, team lead, management, and government customers.
Ability and desire to research and develop creative solutions to unique problems with minimal supervision.
Ability to adapt to change and tolerate stressful situations.
Ability to stand, walk, and sit; communicate verbally in person and by telephone; use hands to finger, handle, or feel objects or controls; and reach with hands and arms.
Regularly required to stoop, kneel, bend, crouch, and lift up to 25 pounds.
Vision abilities required include close vision, distance vision, depth perception, color vision, and the ability to adjust focus.
May require extensive walking, including stairs, throughout offices and between buildings, and use of public transportation, a personal vehicle, or a Government vehicle to travel to local and/or remote office locations.

Nice To Haves

Positive, self-motivated, and proactive approach.

Responsibilities

Provision, operate, install, configure, and maintain systems hardware, software, and related infrastructure.
Provide technical support, guidance, and hands-on delivery for database planning, implementation, and ongoing operation.
Conduct technical research and development to enable continuing infrastructure innovation.
Ensure 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.
Communicate complex ideas, issues, and designs to varied audiences, and communicate project objectives, scope, and status to project teams.
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.
Perform root cause analysis and troubleshoot database and performance issues using diagnostic tools, execution plans, and system logs.
Implement database security and encryption solutions to protect sensitive data.
Configure SQL Server 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.
Plan and implement databases and/or application server implementations and contribute to large technology projects supporting business initiatives.
Initiate, plan, mentor, execute, control, and deliver working projects.