Senior Database Administrator

CACI•Fayetteville, NC

5d•$85,800 - $180,200•Onsite

About The Position

You will support a growing custom geospatial database environment by creating and managing database objects, constraints, dependencies, relationships, and both traditional and large object storage structures and interpret new requirements and identify solutions to meet those requirements. In addition, you will be supporting the design and integration of multiple ESRI, ARCGIS, and messaging applications into a common centralized database configuration. You must have expertise in SQL tuning and a basic understanding of XML technologies, as well as be able to demonstrate the capability to effectively utilize customer support from vendor companies.

Requirements

TS/SCI clearance.
Perform advanced level planning, development, implementation, and maintenance of an enterprise level database environment.
8 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.
Strong oral and written communication skills and be capable of effectively directing subordinates.
High level/expert ability to manage and work with static and dynamic streaming geospatial oriented data.
Required to obtain and maintain currency of the appropriate level certification in accordance with DODD 8570.01.

Nice To Haves

Bachelor's degree and three additional years of general experience in the fields of database administration, intelligence systems architecture and geospatial systems experience are highly desirable.
Network+ and Microsoft Certified Solutions Associate (MCSA).

Responsibilities

Strong understanding of geospatial database schema object management, data modeling and architecture.
Leverage experience and knowledge to provide advice to the software development team and support the application support team throughout the staging and production cycle through the software development lifecycle (LDC).
Implement and troubleshoot triggers, views, stored procedures and data integrity constraints.
Identify and troubleshoot database issues.
Analyze, design, build, test and implement solutions.
Expert understanding of Structured Query Language (SQL) and/or PostgreSQL.
Excellent communication skills to include technical writing and the ability to work in a collaborative team environment.
Ability and willingness to continue to expand knowledge and experience base, be detail oriented, and prioritize and complete assigned tasks within required deadlines.
Exceptional problem solving and decision-making capabilities, including troubleshooting technical issues, successfully resolving project issues and challenges, and developing creative solutions for process improvement and understanding user requirements.