Database Specialist

Xenith Solutions; Virginia (IL); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical/Dental/Vision benefits paid by

FSA or HSA available

Unlimited PTO

401(k) matching up to 4%

Tuition/Certification reimbursement

Job summary

Xenith Solutions is seeking a Database Specialist to join our team supporting federal initiatives. You will handle full lifecycle database management for ACRIMe and CAII systems, creating ERDs, data dictionaries, and data models using Oracle tools, and writing PL/SQL/SQL for Oracle and PostgreSQL databases.

You will also perform database changes with Liquibase, maintain audit logs and reports, and provide DBA support for development and testing environments.

Qualifications

• Experience with Oracle databases and related tools (SQL Developer, SQL Plus, SQL Loader).
• Working knowledge of PostgreSQL and PGAdmin/PSQL.
• Familiar with Liquibase for DB changes.
• Proficient in data reporting with Excel.
• Knowledge of Python basics and SharePoint.

Responsibilities

• Provide full lifecycle database management support for ACRIMe and CAII systems.
• Develop and maintain ERD, data dictionaries, and data models using Oracle SQLDeveloper Data Modeler.
• Write PL/SQL and SQL scripts for Oracle and PostgreSQL databases.
• Perform structural changes to databases using Liquibase where appropriate.
• Maintain audit logs and reports for users and transactions, including external entities.
• Conduct ad-hoc data queries, data fixes and data analysis as requested by stakeholders.
• Provide weekly, monthly, quarterly data reports to fulfill contract requirements.
• Provide DBA support for Development and Testing environments.

Skills

SQL proficiency

Python basics

Excel reporting

SharePoint familiarity

Organizational skills

Tools

Oracle SQLDeveloper

SQL Plus

SQL Loader

Import/Export

JOBs

PGAdmin

PSQL

Liquibase

Job description

About Xenith Solutions

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 Aff