Overview
Join to apply for the Database Administrator role at CACI International Inc
CACI is seeking a motivated, career- and customer-oriented Database Administrator (DBA) with Agile methodology experience to join the Customs and Border Protection (CBP) Land Border Integration (LBI) Integrated Traveler Initiative 2.1 (ITI2.1) team in Northern Virginia. The team supports best practices in Agile software development and hardware integration for the Department of Homeland Security (DHS). The ITI2.1 team supports the mission to safeguard the American people and enhance the Nation's safety, security, and prosperity.
What You'll Do
The ideal candidate will have an understanding of Agile Software Development practices and experience delivering releasable software. In this role, they will perform complex Oracle database related assignments essential to the production and development of Database Management Systems (DBMS) applications. Responsibilities include applying knowledge of database technologies, development methodologies, and performing database programming (PL / SQL) and support (maintenance of database dictionaries, monitoring standards and procedures, file design and storage, and integration of systems of database design).
- Serve as a database specialist responsible for activities associated with delivery of customer-defined systems and software projects.
- SQL Server database administration : daily tasks, security configuration, performance tuning, database mirroring, backup and recovery in on-premise and cloud environments.
- Lead database analysis, design and development, security support, and performance monitoring and tuning.
- Support installation of database software and migrations to new data management system software levels; test migrations for data reliability and functionality.
- Analyze, design, modify, and maintain database structures.
- Design and implement procedures to save, retrieve, and recover databases from hardware and software failures.
- Maintain security and integrity controls; evaluate and recommend database software packages; implement strategic goals for applications.
- Prepare and develop database documentation, procedures, and definitions for data dictionaries.
- Perform logical and physical data modeling; design relational and physical data models.
- Monitor database performance and implement efficiency improvements.
- Assist in modifying existing databases and database management systems; develop standards, guidelines, policies, and procedures to ensure integrity of the database environment.
- Design, create, and maintain databases in a client / server environment; review and ensure integrity via standardized tools.
- Ensure assignments conform to database administration guidelines, standards, and procedures for development, testing, and migration using Agile practices.
- Respond to complex customer-reported production problems; review database design and provide recommendations for improvements.
- Establish short- to mid-term operational plans; may develop stored procedures and / or triggers using PL / SQL.
- Implement and maintain smooth operation and physical design of databases.
Qualifications
Must be a U.S. Citizen with the ability to pass CBP background investigation (3-year felony check, 1-year illegal drug use check, 1-year misconduct check).Bachelor's degree in computer science, Software Engineering, Information Management Systems or a related discipline and 7 years of professional experience.Experience with SQL Server and Oracle RDBMS (12c or higher) on Linux and Windows Server environments.Ability to monitor database performance and growth; create alerts when limits are exceeded.Solid understanding of common DBA tasks including shutdown / startup, backups, tablespace management, performance tuning, materialized views, Data Guard, and partitioning.Excellent written and verbal communication skills; ability to convey technical information to customers and management at all levels.Strong development background with at least 10 years of experience, preferably with incremental software development projects using an Agile Scrum approach.Understanding of the full software development lifecycle (planning, requirements, configuration management, quality assurance, release management).High level of responsibility, teamwork, self-starter attitude.More than 5 years of Oracle experience; ability to solve complex problems with creative solutions.Bonus (Nice to Have)
Advanced degree in MIS or Computer Science preferred.Experience in data modeling (normalized, dimensional), data architecture, reference and master data management; proficient in backup and recovery automation and operations.Knowledge of SQL Server, Hadoop, NoSQL, MongoDB, Kafka, and modern BI platforms.Experience with data format transformation and import / export across database platforms.Oracle environment experience with at least two of : Oracle Real Application Clusters, Oracle Advanced Replication, external interfaces, Microsoft Team Foundation Server.Experience with scripting languages (DOS, Bash, PowerShell).Ability to work independently to identify and resolve problems; DBA-related certifications.Hybrid schedule with on-site requirement in Sterling, VA.What You Can Expect
A culture of integrity. At CACI, character and innovation are central to our mission and values. 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. We value the unique contributions of every employee and offer a flexible time off benefit and access to learning resources to help you grow.
A focus on continuous growth. We will advance our nation's missions and opportunities for your career and our legacy.
Your potential is limitless. So is ours.
Pay Range
The proposed salary range for this position is $103,800 - $218,100, with final pay influenced by location, experience, and qualifications. We offer comprehensive benefits including healthcare, wellness, retirement, education, and time off.
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.
Seniority level : Mid-Senior level
Employment type : Full-time
Job function : Information Technology
Industries : IT Services and IT Consulting
Referrals increase your chances of interviewing at CACI International Inc by 2x
Washington, DC; Chantilly, VA; Arlington, VA; Fairfax, VA; Adelphi, MD – location-based ranges shown on the original posting may vary.
J-18808-Ljbffr