Database Engineer
Core
Design and develop software solutions utilizing an Oracle database backend for law enforcement data management and analytics.
Role type
Database Engineer
Builds
Relational database models, queries, and stored procedures for investigative data tools
Domain
Law enforcement / Data engineering
Required skills
Advanced SQL, relational data modeling, Oracle/PostgreSQL, indexing strategies, query optimization, data integrity checks, schema design, performance tuning, stored procedure development
Preferred skills
Oracle or PostgreSQL certification, experience with partitioning, familiarity with database monitoring tools
Technologies
Oracle, PostgreSQL, SQL
Responsibilities
Design and implement moderately complex SQL queries, views, and stored procedures; Optimize existing database structures, queries, and indexes; Perform regular data quality checks and resolve data integrity issues; Support application developers by advising on data access patterns and query design; Contribute to relational data modeling decisions; Participate in code reviews for database changes; Investigate and resolve database-related defects; Maintain thorough documentation of schemas and procedures; Mentor junior Database Engineers
Seniority
Mid-level, hands-on IC
