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
Skills Required
- Strong expertise in Oracle and Oracle tools, including SQL Developer, SQL Plus, SQL Loader, Import, Export, and Jobs
- Strong expertise in SQL
- Working knowledge of PostgreSQL and PostgreSQL tools, including pgAdmin and PSQL
- Working knowledge of Liquibase
- Expertise in Excel for reporting
- Familiarity with Python
- Familiarity with SharePoint
- Strong organizational skills
What We Do
Xenith Solutions LLC is a Service-Disabled Veteran-Owned Small Business. We value our employees and provide 100% employee premium paid health insurance, dental and vision care. We also offer our employees unlimited Paid Time Off (PTO). We do not want our employees to worry about caring for themselves or their families as well as ensuring they have ample time off to recharge. Xenith provides 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.
.png)
