CACI is currently looking for a motivated, career and customer-oriented Mid-level of Database Developer 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 developer responsible for activities associated with delivery of customer-defined systems and software projects; basic responsibilities include:
Data analysis, database design and development.
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
Applicable combination of education and experience:
Database Developer T3 - College degree (B.S.) and 5 years of experience
Database Developer T4 - College degree (B.S.) and 7 years of experience
Proficient understanding of Microsoft SQL Server 2008 or above.
Basic understanding of Microsoft SQL configuration
Able to quickly understand requirements for business applications and procedures
Able to prioritize, track, and complete tasks according to Sprint deadlines with limited oversight.
Able to work in an Agile environment where priorities and deadlines may chance regularly.
Strong written/oral communication skills
Flexibility to work within technical framework with evolving business requirements
Undergraduate degree required in math, computer science, engineering, or related discipline with an information technology focus (preferred).
Experience with SQL 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.
Understanding of all elements of the software development life cycle, including planning, development, requirements management, CM, quality assurance, and release management
Demonstrate ability to solve complex problems providing creative and ingenious solutions
Must be available to work a hybrid schedule with an on-site requirement in Sterling, VA
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, structural/non-structural data, and some state-of-the-art BI platforms
Knowledge about data format transformation and import/export across various database platform
Basic knowledge about object-oriented DB, image/video data, and meta data.
Experience with scripting languages, such as DOS, Bash, or PowerShell
Acts independently to expose and resolve problems
This position is contingent on funding and may not be filled immediately. However, this position is representative of positions within CACI that are consistently available. Individuals who apply may also be considered for other positions at CACI.________________________________________________________________________________________
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:
$86,600 - $181,800CACI 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.