Database Developer
CACI is currently looking for a motivated, career and customer-oriented Mid-level 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 convictions1-year check for illegal drug use1-year check for misconduct such as theft or fraudApplicable combination of education and experience :Database Developer T3 - College degree (B.S.) and 5 years of experienceDatabase Developer T4 - College degree (B.S.) and 7 years of experienceProficient understanding of Microsoft SQL Server 2008 or above.Basic understanding of Microsoft SQL configurationAble to quickly understand requirements for business applications and proceduresAble 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 change regularly.Strong written / oral communication skillsFlexibility to work within technical framework with evolving business requirementsUndergraduate 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 environmentsAbility 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 managementDemonstrate ability to solve complex problems providing creative and ingenious solutionsMust be available to work a hybrid schedule with an on-site requirement in Sterling, VABonus 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 operationsTechnology Nice to have SQL Server, Hadoop, NoSQL, MongoDB, Kafka, structural / non-structural data, and some state-of-the-art BI platformsKnowledge about data format transformation and import / export across various database platformBasic knowledge about object-oriented DB, image / video data, and meta data.Experience with scripting languages, such as DOS, Bash, or PowerShellActs independently to expose and resolve problemsThis 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.