Unlock your potential as a key player in our success story!
We're looking for dynamic and organized Database Engineers to join our team. If you thrive in a fast-paced environment, excel at managing priorities, and are ready to join a high-speed technical team, this is the opportunity you've been waiting for. Join us on the journey to efficiency, excellence, and endless possibilities!
You must have an active TS/SCI clearance to apply.
Our Database Engineer will manage and provide access to geospatial data and geospatial services as directed by collaborative customers. The support provided to our partners by this position is Overseas Contingency Operations (OCO) qualifying, per the OCO Guidelines. Tasks are to be completed on a weekly basis, unless specifically stated otherwise.
Responsibilities:
* Maintain the Enterprise Geospatial Information System (GIS) database of GIS vector and raster data. Report monthly technical performance. (CDRL D013)
* Ensure Enterprise GIS databases are operational at least 95% of the time; Enterprise GIS database is accessible by all NST Analysts.
* Utilize program scripts to ingest data sources into Relational Database Management System (RDBMS) tables for analysis and rendering. Scripts are delivered on average, once per month. Report monthly technical performance. (CDRL D013)
* Design, build, test, and implement queries, views, materialized views, procedures, and other database mechanisms to support customer needs.
* Design database procedures to interact with external APIs, including authentication and data transfer.
* Review and update data storage schemas to allow data flexibility as mission requirements evolve.
* Perform extract, transform, and load (ETL) tasks on the Enterprise GIS database. Timelines to complete ETL tasks will be agreed upon and established by the Government.
* Manage data, script, scheduled procedure, and account replication between Oracle Spatial and PostgreSQL/postGIS databases.
* Provide support to IT systems including day-to-day operations, monitoring, and routine GIS and problem resolution for all client/server/storage/network devices and mobile devices.
* Monitor and improve electronic cross-communications (e.g. scripts, APIs) between the RDBMS, IC GIS Portal, local and non-local GIS server suites, and GIS Desktops.
* Develop recommendations for database and data sources solutions based on user feedback and mission requirements.
Required Skills:
* Significant relevant experience with the following applications:
* Experience using Microsoft Office suite applications
* Experience using Oracle RDBMS
* Experience using PostgreSQL RDBMS
* Ability to create and run PowerShell applications
* Experience in Windows/Linux Administration
* Experience using Tomcat and JBoss Servers
Benefits include:
* Medical, Dental, and Vision Insurance
* Life, AD&D, and Short-Term Disability Insurance
* 401(k)
* Paid Time Off
* Paid Holidays
* Employee Assistance Program
* Free Training Portal
Commitment to diversity
All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law.
#J-18808-Ljbffr