Database Specialist
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
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 employerFSA 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 stakeholdersProvide weekly, monthly, quarterly data reports to fulfill contract requirements or as requested by program stakeholdersProvide 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, JOBsStrong expertise in Structured Query Language (SQL)
Working knowledge of PostgreSQL and Postgres tools PGAdmin, PSQLWorking knowledge of Liquibase
Expertise in Excel for reporting purposes
Familiarity with Python programming language
Familiarity with Sharepoint
Must have strong organizational skills