Data Engineer

DMI•Remote,

16d•$100,521 - $125,652•Remote

About The Position

DMI, LLC is seeking a Data Engineer to join their team. This role involves comprehensive database management and administration, including monitoring, integration, replication, notification, analysis, tuning, problem resolution, reporting, and production support. The Data Engineer will be responsible for performing SQL server software upgrades, service packs, and version updates, including testing and evaluating patching strategies. They will coordinate with functional DBAs on database operations, hardware architecture, and security. Key tasks include creating primary database storage structures, database objects, and migration scripts. The role also requires designing efficient database architecture, maintaining performance and tuning, optimizing database performance, security, and user access, and coordinating storage allocation and forecasting space requirements. Identifying long-running single queries, scheduling, automating, executing, and monitoring job and system performance, and performing capacity planning are also essential duties. The Data Engineer will modify database structures, provide database application support (including schema changes in production, testing, and staging instances), develop backup and recovery procedures, and establish security roles and database access rights and controls. Identifying blocking transactions when required is also part of the responsibilities.

Requirements

Bachelor's Degree
5+ years database management and administration experience.
1+ years experience with a federal agency or federal contractor
3+ years Information Technology Experience
Must be a U.S. Citizen

Responsibilities

Database monitoring, integration, replication, notification, analysis, tuning, problem resolution, reporting and production support
Performing SQL server software upgrades; service packs and versions including testing and evaluation of patching strategies
Coordinating with functional DBA's on database operations, hardware architecture, and security
Creating primary database storage structures, database objects, migration scripts to modify structures and objects
Designing efficient database architecture and maintain performance and tuning
Optimizing database performance, security, and user access
Coordinating allocation of storage and forecasting space requirements
Identifying long running single queries
Scheduling, automating, executing and monitoring job and system performance
Performing capacity planning
Modifying database structures
Providing database application support. Schema changes in prod, testing, staging, instances, etc.
Developing backup and recovery procedures
Establishing security roles and database access rights and controls
Identifying blocking transactions when required.