Database Administrator
Job Category: Information Technology
Time Type: Full time
Minimum Clearance Required to Start: None
Employee Type: Regular
Percentage of Travel Required: Up to 10%
Type of Travel: Local

CACI is currently looking for a motivated, career and customer-oriented Database Administrator (DBA) with Agile methodology experience to join our Customs and Border Protection (CBP) Land Border Integration (LBI) Integrated Traveler Initiative 2.1 (ITI2.1) team in Northern Virginia! Join this passionate team of industry-leading individuals supporting the best practices in Agile Software Development and hardware integration for the Department of Homeland Security (DHS).
As a member of the ITI2.1 Team, you will support the men and women charged with safeguarding the American people and enhancing the Nation’s safety, security, and prosperity. CBP Officers and Border Patrol agents are on the front lines, every day, protecting our national security by combining customs, immigration, border security, and agricultural protection into one coordinated and supportive activity.
CACI agile programs thrive in a culture of innovation and are constantly seeking individuals who can bring creative ideas to solve complex problems, both technical and procedural at the team and portfolio levels. The ability to be adaptable and to work constructively with a technically diverse and geographically separated team is crucial.

The ideal candidate will have an understanding of Agile Software Development practices and experience delivering releasable software. In this role, they will have the opportunity to perform complex Oracle database related assignments essential to the production and development of Database Management Systems (DBMS) applications. They will apply knowledge and experience with database technologies, development methodologies, and perform database programming (PL/SQL) and support (includes maintenance of database dictionaries, overall monitoring of standards and procedures, file design and storage, and integration of systems of database design).

Serves as a database specialist responsible for activities associated with delivery of customer-defined systems and software projects; basic responsibilities include:

• Responsible for SQL server Database administration, daily database administration tasks, database and server security configuration, performance tuning, database mirroring, database backup and recovery procedures in premise and cloud environment.
• Lead database analysis, design and development, security support, and performance monitoring and tuning.
• Supports the installation of database software and migrations to new data management system software levels and tests the migrations to ensure data reliability and functionality.
• Analyzes, designs, modifies, and maintains database structures.
• Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.
• Maintains security and integrity controls.
• Evaluates and recommends database software packages for potential acquisition, and implements strategic goals for applications
• Prepares and develops database documentation, procedures, and definitions for data dictionaries.
• Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.
• Performs database performance monitoring and implements efficiency improvements.
• Assists in modifying existing databases and database management systems.
• Assists in developing standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment
• Designs, creates, and maintains databases in a client/server environment.
• Reviews and ensures integrity via standardized support tools.
• Ensures that assignments are performed in accordance with database administration guidelines, standards and procedures for database development, implementation, testing, and migration using Agile Software Development practices.
• Responds to complex customer-reported systems problems in production.
• Reviews database design and provide recommendations/guidance regarding enhancements and/or improvements.
• Establish short to midterm operational plans
• May develop stored procedures and/or triggers using PL/SQL.
• Implements and maintains smooth operation and physical design of databases