[Hiring] Database Developer @Xenith Solutions

Role Description

Xenith Solutions is seeking an inspired candidate to join our team in support of a government contract for the Department of Homeland Security (DHS). The focus of this effort is to deliver comprehensive technical services essential to the continued operation, maintenance, modernization, and enhancement of mission-critical systems, subsystems, databases, and web services.

The Database Developer / Engineer will provide advanced database development, engineering, performance optimization, and lifecycle management services in support of the ICE program. This position requires strong hands-on expertise in complex SQL development, database architecture, query optimization, data management, and automated database deployment and maintenance.

The successful candidate will:

• Design, develop, and maintain complex database objects, including stored procedures, triggers, functions, and views.
• Optimize database performance through detailed analysis of query execution plans.
• Develop and implement comprehensive data archiving strategies.
• Execute targeted scripts for data corrections and migrations.
• Leverage Liquibase and other approved automation tools to streamline database installations, schema changes, data migrations, and recurring data correction activities.
• Work collaboratively within an Agile development environment to ensure database solutions are secure, scalable, reliable, and optimized to support evolving ICE mission requirements.

Qualifications

• 5 years of related work experience executing the described job description.
• Bachelor’s degree in computer science, Information Technology, or a related field.
• DoD 8570 compliant IAT Level II certification, such as the CompTIA Security+ certification.
• Ability to obtain DHS Background Investigation.

Requirements

• Database Performance Optimization: Analyze SQL query execution plans to identify performance bottlenecks, optimize complex queries, and implement improvements to enhance database efficiency, responsiveness, and scalability.
• Data Archiving Strategy and Planning: Develop and document a comprehensive Data Archiving Plan that defines data retention requirements, archiving procedures, retrieval processes, and strategies for managing historical data.
• Data Lifecycle Management: Design, implement, and maintain data archiving processes to optimize database storage, preserve data integrity, and ensure compliance with applicable data retention and security requirements.
• Data Correction and Migration: Develop, test, and execute targeted SQL scripts to perform manual data corrections, resolve data inconsistencies, and support database migrations while ensuring accuracy, integrity, and minimal operational disruption.
• Automated Database Deployment: Implement and maintain automated database installation, configuration, and schema management processes using Liquibase to ensure consistent, repeatable, and version-controlled database deployments.
• Automated Data Corrections: Design, develop, and implement automated scripts and processes to identify, validate, and correct data inconsistencies, reducing manual intervention and improving overall data quality and operational efficiency.

Benefits

• Comprehensive, timely, and relevant Solutions and Business Consulting support.
• Commitment to quality solutions through a "Success Through Achievement" work ethic.
• Focus on solving complex business challenges facing customers.