CACI has an outstanding opportunity for select expert GIS data-base administrators that want to make a difference in the defense of the nation by applying their talents and experience in a fast-paced dynamic environment in support of US Special Operations Command.
Requirements
- 7+ years of progressive experience performing complex analysis, design, development, and modification to improve efficiency of Microsoft SQL and/or PostgreSQL databases in support of enterprise architecture
- highly proficient in administering and deploying open source and commercial off the shelf (COTS) GIS server equipment in support of intelligence organizations
- expert ability to manage and work with static and dynamic streaming geospatial oriented data
- expert understanding of Structured Query Language (SQL) and/or PostgreSQL
- Network+
- Microsoft Certified Solutions Associate (MCSA)
- SQL Server 2016 certifications
Responsibilities
- creating and managing database objects, constraints, dependencies, relationships, and both traditional and large object storage structures
- interpret new requirements and identify solutions to meet those requirements
- supporting the design and integration of multiple ESRI, ARCGIS, and messaging applications into a common centralized database configuration
- SQL tuning
- geospatial database schema object management, data modeling and architecture
- implement and troubleshoot triggers, views, stored procedures and data integrity constraints
- identify and troubleshoot database issues
Other
- Active TS/SCI
- Required to obtain and maintain currency of the appropriate level certification in accordance with DODD 8570.01
- strong oral and written communication skills
- capable of effectively directing subordinates
- excellent communication skills to include technical writing and the ability to work in a collaborative team environment
