SQL System Engineer

Enterprise Solutions and Management (ESM) is a rapidly growing government contractor that provides strategic IT services that meet mission needs for Defense and Federal customers. We are hiring an SQL System Engineer to support an enterprise-level program within a federal environment.

Job Description and Responsibilities

The SQL System Engineer 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. The Systems Engineer shall 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. The Systems Engineer shall 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.

Required Knowledge, Skills and Abilities (KSA)

Knowledge

• 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.

Skills

• Skill in designing, implementing, administering, and optimizing SQL Server databases across on-premises and cloud environments.

• Skill in developing, debugging, and optimizing complex T-SQL queries, stored procedures, triggers, and functions.

• Skill in database performance tuning, index management, query optimization, and resource utilization analysis.

• Skill in configuring and managing SQL Server backup, recovery, high availability, and Failover Cluster Instances.

• Skill in using PowerShell to automate server administration, database management, and data acquisition tasks.

• Skill in performing root cause analysis and troubleshooting complex database and performance issues using diagnostic tools, execution plans, and system logs.

• Skill in implementing database security and encryption solutions to protect sensitive data.

• Skill in configuring SQL Server monitoring, alerts, and Database Mail notifications.

• Skill in developing database documentation, including schemas, data dictionaries, entity-relationship diagrams, and process flows.

• Skill in conducting database systems analysis and recommending solutions to improve performance, scalability, and operational efficiency.

Abilities

• 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 maintain database availability, data integrity, security, and operational continuity.

• Ability to communicate technical findings and recommendations to stakeholders and cross-functional teams.

Desired KSA

• Be a positive, self-motivated, and proactive person with the ability to adapt to change and tolerate stressful situations

• Candidate must communicate effectively with team members, team lead, management, and government customers

• Must have the ability and desire to research and develop creative solutions to unique problems with minimal supervision

Minimum Training, Education, and Certifications

• Five (5) years of overall professional experience in the engineering field.

• Five (5) years' experience in SQL Server database administration and analysis support.

• Must have at least five (5) years of experience working 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

• Expert knowledge and practical experience within DoD IT database management technology stacks, responsible for planning and implementing databases and/or Application Server implementations.

• Engineer must have demonstrated experience in planning, implementing and negotiating large sized technology projects in support of business initiatives. Experienced in initiating, planning, mentoring, executing, controlling, and delivery of working project.

• 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.

Minimum Clearance

• Top Secret

Physical Requirements

• Required to stand, walk and sit; communicate verbally both in person and by telephone; use hands to finger, handle or feel objects or controls; reach with hands and arms. Regularly required to stoop, kneel, bend, crouch and lift up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, color vision and the ability to adjust focus.

• Physical demands associated with this position include extensive walking (including stairs) throughout offices and between buildings. May require use of public transportation, personal or Government vehicle to drive to local and/or remote office locations.

Additional Requirements

• Other duties as assigned

ESM provides equal employment opportunity to all individuals regardless of race, color, creed, religion, gender, age, sexual orientation, national origin or ancestry, disability, genetic information, veteran status, gender identification or any other characteristic protected by state, federal or local law.