Database Engineer/Backend Developer

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

Personal Attributes

• 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