Senior Database Administrator (Geospatial)

About the role

CACI is hiring a Senior Database Administrator in Fort Bragg to support a growing custom geospatial database environment. The role involves creating and managing database objects, constraints, dependencies, relationships and storage structures, and integrating multiple ESRI, ArcGIS and messaging applications into a common centralized database. It is a regular, full-time position requiring up to 10% travel outside the continental US and a minimum TS/SCI clearance.

Key responsibilities

• Manage geospatial database schema objects, data modeling and architecture, advising the software development team and supporting the application support team through the software development lifecycle.
• Implement and troubleshoot triggers, views, stored procedures and data integrity constraints, and resolve database issues.
• Analyze, design, build, test and implement solutions, with strong SQL and/or PostgreSQL expertise.
• Write technical documentation and work collaboratively in a team.
• Troubleshoot technical issues, resolve project challenges and propose process improvements.

Required profile

• TS/SCI clearance; must obtain and maintain the appropriate DODD 8570.01 certification.
• 8 years of progressive experience designing, developing and modifying Microsoft SQL and/or PostgreSQL databases for enterprise architecture.
• Highly proficient in administering and deploying open-source and commercial GIS server equipment for intelligence organizations.
• Ability to direct subordinates and strong oral and written communication skills.
• Expert ability to manage static and dynamic streaming geospatial data.
• Bachelor's degree and three additional years of experience in database administration, intelligence systems architecture and geospatial systems are highly desirable.

Required skills

• SQL tuning and expert SQL and/or PostgreSQL
• XML basics
• Use of vendor customer support
• Geospatial database administration and GIS server deployment

What we offer

• Proposed pay range of $85,800 - $180,200, depending on experience, skills and contract terms.
• Healthcare, wellness, financial, retirement, family support, continuing education and time-off benefits.
• A culture of integrity, a flexible time-off benefit and learning resources.