Offer summary

Qualifications:

Proficiency in Oracle and PostgreSQL database management., Experience with SQL, PL/SQL, and database scripting., Knowledge of database tools like SQL Developer and Liquibase., Strong organizational skills and familiarity with Python and SharePoint..

Key responsibilities:

Manage full lifecycle support for ACRIMe and CAII databases.

Develop and maintain database artifacts such as ERDs and data models.

Perform data queries, fixes, and analysis for stakeholders.

Provide support for development and testing database environments.

Job description

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 offers unmatched Benefits:

100% of Medical, Dental, and Vision benefits paid by employer
FSA or HSA available
Unlimited Paid Time Off (PTO)
401(k) matching (100% up to the first 4%) with NO vesting period
Tuition / Certification / Training reimbursement
Accident / Disability / Universal Life Insurance
And much more…

Xenith Solutions is seeking a Database Specialist to join our growing team of professionals supporting the best practices in full lifecycle agile software development, operations, and maintenance to the ICE OCIO’s Criminal Non-Citizen Identification Initiative (CNII) including the ACRIMe suite, External Search Services (ESS), NCIC Nlets Web Services (NNWS), Message Transfer Service (MTS), and ACRIMe Authorization Service (Auth).

Job Description

Provide full lifecycle database management support for ACRIMe and CAII systems.
Develop and maintain database artifacts including entity relationship diagrams (ERD), data dictionaries, and data models using tools like Oracle SQLDeveloper Data Modeler.
Write PL/SQL and SQL scripts to insert, update, delete, query, and analyze data within Oracle and PostgreSQL databases.
Perform structural changes to databases to improve performance and resolve defects using Liquibase where appropriate.
Maintain audit logs and reports for users and transactions, including those involving external entities (e.g., NCIC/Nlets).
Conduct ad-hoc data queries, data fixes and data analysis as requested by program stakeholders.
Provide weekly, monthly, quarterly data reports to fulfill contract requirements or as requested by program stakeholders.
Provide DBA support for Development and Testing environments. Creating and managing user IDs, managing data usage requirements, maintaining data structure and data.

Technical skills

Strong expertise in Oracle and Oracle tools SQL Developer, SQL Plus, SQL Loader, Import, Export, JOBs
Strong expertise in Structured Query Language (SQL)
Working knowledge of PostgreSQL and Postgres tools PGAdmin, PSQL
Working knowledge of Liquibase
Expertise in Excel for reporting purposes
Familiarity with Python programming language
Familiarity with Sharepoint
Must have strong organizational skills

Xenith Solutions LLC is a Service-Disabled Veteran-Owned Small Business founded in 2019. We provide comprehensive, timely and relevant Solutions and Business Consulting support to our customers as a key partner. Our leadership brings over a century of combined experience in Defense and Civilian markets. Our employees possess experience in all aspects of solution development from requirements creation, development, test and evaluation, fielding, and sustainment. At the core of our offerings, we provide strategy and technology solutions, giving our customers valuable insights and thought leadership on the best application of information technology to drive business objectives.

Xenith focuses on solving complex business challenges facing our customers. Our “Success Through Achievement” work ethic means our customer receive quality solutions through our commitment. We pride ourselves on tackling some of the most difficult operational requirements our customers have – ensuring an appropriate match between the mission requirements, financials, schedule, and security.

EEO

Xenith Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.

EEO IS THE LAW

If you are an individual with a disability and would like to request a reasonable accommodation as part of the employment selection process, please contact Xenith Solutions.

E-Verify

As a Federal Contractor, Xenith Solutions is required to participate in the E-Verify Program to confirm eligibility to work in the United States.

Affirmative Action Plan
As a federal government contractor and based on Executive Orders and applicable laws and regulations, Xenith Solutions develops and maintains annual written Affirmative Action Plans and endeavors to hire and advance qualified minorities, females, individuals with disabilities, and protected veterans.

Required profile