Database Administrator

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. 

What you’ll get to do: 

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 

You have: 

• Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria includes, but not limited to: 

• 3-year check for felony convictions 

• 1-year check for illegal drug use 

• 1-year check for misconduct such as theft or fraud  

• Bachelor’s degree in computer science, Software Engineering, Information Management Systems or a related discipline and 7 years of professional experience

• Experience with QL Server and Oracle RDBMS (version 12c or higher) running on Linux and Windows Server environments 

• Ability to monitor database performance and growth (scale) and create alerts when they go beyond control limits. 

• Solid understanding of and ability to perform common database administration tasks including, shutdown, start-up, cold back-ups, tablespace management, performance tuning, managing materialized views, data guard, and table partitioning. 

• Must have excellent written and verbal communication skills the ability to convey technical information as necessary 

• Must be able to work with customers and management of all levels. 

• Strong development background, with a minimum of ten (10) solid years of experience preferably with incremental software development projects using an Agile Scrum approach 

• Understanding of all elements of the software development life cycle, including planning, development, requirements management, CM, quality assurance, and release management 

• Highly responsible, team-oriented individual with very strong work ethic; self-starter 

• More than five (5+) years related Oracle experience 

• Demonstrate ability to solve complex problems providing creative and ingenious solutions 

Bonus would be having:  

• ·Advanced degree in MIS or Computer Science preferred. 

• Nice to have experience in data modeling (normalized, dimensional), data architecture, reference, and master data management Proficient in automating, implementing, and supporting backup and recovery operations 

• Technology Nice to have – SQL Server, Hadoop, NoSQL, MongoDB, Kafka, and some state-of-the-art BI platforms 

• Knowledge about data format transformation and import/export across various database platform 

• Possess a working knowledge in an Oracle environment with at least two of: Oracle Real Application Clusters, Oracle Advanced Replication, information exchanges (external interfaces), Microsoft Team Foundation Server 

• Experience with scripting languages, such as DOS, Bash, or PowerShell 

• Acts independently to expose and resolve problems 

• DBA related Technical Certifications 

• Must be available to work a hybrid schedule with an on-site requirement in Sterling, VA

-

________________________________________________________________________________________

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. 

 

Your potential is limitless. So is ours.

Learn more about CACI here.

________________________________________________________________________________________

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. Learn more here.

The proposed salary range for this position is:

$103,800 - $218,100

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.