Database Developer
Core
Design, develop, and maintain complex database objects, optimize performance, and manage data lifecycle for mission-critical systems supporting ICE operations.
Role type
Senior Database Developer / Engineer
Builds
Mission-critical databases, subsystems, and web services for ICE
Domain
Defense / Intelligence / Government
Required skills
Complex SQL development, Database architecture, Query optimization, Data management, Automated database deployment, Liquibase, Data archiving strategies, Data correction scripts, Schema management
Preferred skills
Agile DevOps environment experience, Cloud environment experience (AWS, Azure, Oracle Cloud), Active DHS/ICE Background investigation
Technologies
SQL, Liquibase, AWS, Azure, Oracle Cloud
Responsibilities
Analyze SQL query execution plans to identify and resolve performance bottlenecks; Develop and document comprehensive Data Archiving Plans; Design and implement data archiving processes for storage optimization and compliance; Develop, test, and execute SQL scripts for data corrections and migrations; Implement automated database installation and schema management processes; Design automated scripts to identify and correct data inconsistencies.
Seniority
Senior, hands-on IC