Type of Requisition:
RegularClearance Level Must Currently Possess:
NoneClearance Level Must Be Able to Obtain:
NonePublic Trust/Other Required:
OtherJob Family:
IT Infrastructure and OperationsJob Qualifications:
Skills:
Database Architecture, Technical Solutions, Web ApplicationsCertifications:
NoneExperience:
8 + years of related experienceUS Citizenship Required:
YesJob 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
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
Scheduled Weekly Hours:
40Travel Required:
NoneTelecommuting Options:
RemoteWork Location:
Any Location / RemoteAdditional Work Locations:
