Database Specialist

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 #J-18808-Ljbffr