Database Engineer/Backend Developer

General Dynamics Information Technology•USA VA Home Office (VAHOME), VA

1d•Remote

About The Position

Come join our high performing team, supporting an essential government program, with a mission to support law enforcement in solving missing persons cases. We are seeking a seasoned database engineer with a track record of unwavering commitment to maintaining reliable and secure database management systems. We need a data expert who provides a variety of reports and dashboards for the business. The candidate must understand complex data models, maintain them, and develop and implement ways to improve them.

Requirements

Database Administration and Engineering
Microsoft SQL Server 2019+ (Standalone and Always on Availability Groups instance configurations)
SQL Server Management Studio
PowerShell
ElasticSearch and/or AWS OpenSearch for indices and index management
Data analysis and documentation (models, dictionaries, flows, statistical reporting, etc.)
Backend Development/IT Systems Administration
Windows/IIS server administration
Patching team-managed server applications, and reviewing and validation enterprise server patching
Log management and analysis
Cloud services (AWS preferred): Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS)
DevOps – deployment management, configuration management, release coordination, cloud network operations, Agile concepts and frameworks
US Citizenship
Ability to obtain and maintain an Agency specific Public Trust clearance

Nice To Haves

Experience using AI tools for heavy data analysis, data normalization efforts, etc.
Experience preparing data for FOIA request responses
Power BI or similar business intelligence and visualization tools
Microsoft .NET/C# web applications development (including MVC and Web APIs)
Front end JavaScript or TypeScript frameworks such as AngularJS/Angular 2+
Entity Framework code first development workflow
Azure DevOps (ADO)
Familiarity with Splunk

Responsibilities

Install, upgrade, and maintain databases (servers and instances), indexes, and related processes, including backup and recovery
Conduct performance tuning of database systems
Develop automated mechanisms (stored procedures, function, and ad hoc scripts) for monitoring, maintenance and routine tasks
Perform vulnerability management and continuous optimization of database security
Diagnose and troubleshoot database errors
Analyze data to create and manage reports, visualizations, and dashboards
Understand complex data schemas and create enterprise data models
Develop and support data integration mechanisms with other systems
Develop and maintain database and system documentation

Benefits

Variety of medical plan options, some with Health Savings Accounts
Dental plan options
Vision plan
401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match
Full flex work weeks where possible
Variety of paid time off plans, including vacation, sick and personal time, holidays
Paid parental, military, bereavement and jury duty leave
15 days of paid leave per calendar year to be used for vacations, personal business, and illness
10 paid holidays per year
Paid leave and paid holidays are prorated based on the employee’s date of hire
GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees
Short and long-term disability benefits
Life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance