Database Engineer/Backend Developer
Role details
Job location
Tech stack
Job description
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.
Essential Duties
- 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
Technical Experience/Technologies
- 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
Requirements
Do you have experience in Data modeling projects?, * Has demonstrated experience owning a technical task from discovery to resolution and leading response actions while coordinating with technical and non-technical teams
- Applies good judgement with personal initiative, adopting a "first do no harm" perspective
- Maintains commitment to quality and continuous improvement
- Demonstrates capacity for deep, critical thinking while maintaining an understanding of business needs
Desired Experience and Skills
- 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
Other Requirements
- US Citizenship
- Ability to obtain and maintain an Agency specific Public Trust clearance
Work Requirements Years of Experience 8 + years of related experience
- may vary based on technical training, certification(s), or degree
Benefits & conditions
(part of General Dynamics) 3.73.7 out of 5 stars Indiana $130,900 - $177,100 a year, The likely salary range for this position is $130,900 - $177,100. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.