Database Developer

Xenith Solutions is a small family focused business where we focus on taking care of our employees and customers equally. We are focused on serving Federal / Civilian, Defense, and Intelligence organizations with superior service. If you want to be a part of a rapidly growing business with an exceptional culture, then you want to be a part of the Xenith Solutions family.
Xenith Solutions is seeking an inspired candidate to join our team in support of a government contract for the Department of Homeland Security (DHS).
Job Description:
The focus of this Department of Homeland Security (DHS), Immigration and Customs Enforcement (ICE) 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; and execute targeted scripts for data corrections and migrations.
Additionally, the Database Developer / Engineer will leverage Liquibase and other approved automation tools to streamline database installations, schema changes, data migrations, and recurring data correction activities. Working collaboratively within an Agile development environment, this individual will ensure database solutions are secure, scalable, reliable, and optimized to support evolving ICE mission requirements.
Responsibilities, but not limited to:
The Database Developer / Engineer is responsible for managing and maintaining an organization's databases. The role involves ensuring data integrity, security, and optimal performance.
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
Required 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
Desired Qualifications:
Active DHS, ICE Background investigation
Experience operating in an Agile DevOps environment
Experience working in a Cloud environment (AWS, Azure, Oracle Cloud)
Critical Soft Skill Requirements:
Excellent active listening and verbal communication skills
Strong sense of collaboration, teamwork, and accountability
Strong business writing ability
Flexible and adaptable attitude
Can conform to shifting priorities, demands, and timelines
Ability to elicit cooperation from a wide variety of Stakeholders
Possession of excellent client-facing consulting, leadership, and analytic skills
Ability to discuss technical issues with non-technical, executive-level government officials
Ability to communicate issues, status, tradeoffs, and priorities
Leading and mentoring teams

Work arrangement
Yes