Senior Database Administrator

CACI; Liberty (NC); On-site; USD 86,000 - 180,000; Full time

Job summary

CACI is seeking a Senior Database Administrator to manage a geospatial database environment, optimize SQL performance, and integrate ESRI ArcGIS applications within a centralized architecture in the United States. The role requires strong SQL skills, data modeling expertise, and the ability to work across development and operations teams.

The ideal candidate will demonstrate experience with geospatial data, XML basics, and IT security clearances (TS/SCI).

Qualifications

• TS/SCI clearance required.
• 8 years of experience with MS SQL and/or PostgreSQL.
• Proficient in administering GIS server equipment.
• Strong oral and written communication skills.
• Expert in managing static and dynamic geospatial data.
• Must obtain currency for DoD 8570.01 per DoD instruction.

Responsibilities

• Understand geospatial database schema object management, data modeling and architecture.
• Advise software development and support teams through the SDLC and manage triggers/views/procedures.
• Analyze, design, build, test and implement SQL solutions; ensure data integrity.
• Collaborate effectively in a team and prioritize tasks to deadlines.
• Solve problems and develop creative process improvements.

Skills

TS/SCI clearance

SQL & PostgreSQL expertise

Geospatial data modeling

SQL tuning

Strong communication

Team collaboration

Problem solving

XML basics

Education

Bachelor's degree (desirable)

Tools

ArcGIS / ESRI GIS server

Open source GIS tools

Job description

Job Title: Senior Database AdministratorJob Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: TS/SCIEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: Outside Continental US

The Opportunity

• 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.

Responsibilities

• You must have a strong understanding of geospatial database schema object management, data modeling and architecture.
• You will leverage your 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, and identify and troubleshoot database issues.
• You should possess the ability to analyze, design, build, test and implement solutions and have an expert understanding of Structured Query Language (SQL) and/or PostgreSQL. You should have excellent communication skills to include technical writing and the ability to work in a collaborative team environment.
• You should have the ability and willingness to continue to expand your knowledge and experience base to be detail oriented and to prioritize and complete assigned tasks within required deadlines.
• You should have 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.

Qualifications

Required:

• TS/SCI
• Shall perform advanced level planning, development, implementation, and maintenance of an enterprise level
• Have 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
• Shall be highly proficient in administering and deploying open source and commercial off the shelf (COTS) GIS server equipment in support of intelligence organizations. Should possess strong oral and written communication skills and be capable of effectively directing subordinates
• Shall possess 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
• undefined

Desired:

• 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)

What You Can Expect

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you’ll be part of a high-performing group dedicated to our customer’s missions and driven by a higher purpose – to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You’ll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground — in your career and in our legacy.

Pay Range

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

The proposed salary range for this position is:

$85,800 - $180,200

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.