What You’ll Get to Do:
CACI is looking for a junior/mid-level Database Administrator to provide hands-on support and subject matter expertise in a fast paced, dynamic environment. Responsibilities will involve Operations & Maintenance (O&M) and system engineering support to two government agency’s financial management and ERP systems.
More About the Role:
Under general supervision, designs, develops, monitors and maintains moderately complex database management systems and related components underlying business applications.
Responsible for end-to-end support, administration and configuration management of databases.
Develops database documentation, procedures and policies. Works with the system administrators to manage user and application security levels for the database.
Supports applications development teams to ensure data designs will operate efficiently once implemented, including overall database design, helping developers tune queries, assigning proper indexes, and the creation of triggers and stored procedures.
Monitors and analyzes database performance, producing reports and recommendations for improvements as needed.
Manages backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensuring that the backup schedules meet recovery requirements.
May also develop and manage data replication procedures and tools.
Responsible for storage management monitoring, planning for space requirements and adding new storage space as needed.
Creating new databases, database objects, tablespaces etc. from command line and/or using OEM.
Estimating database size based on current and projected growth requirements.
Performing database startup, shutdown, back-up, and recovery.
Writing scripts to monitor and generate alerts on usage of tablespaces, and validity of objects.
Monitoring growth of tablespaces, adding and removing datafiles.
Managing schemas, users, roles and permissions at database and object level.
Documenting and applying STIGS, CPU and Oracle DBMS patches.
Implementing and monitoring database administration best practices.
Performing export and import of individual tables, schemas, or full database refresh as required.
You’ll Bring these Qualifications:
US Citizen with a current Top Secret or TS/SCI clearance. Must be able to obtain Counterintelligence (CI) polygraph.
Bachelor's Degree. 3-5+ years' experience in Database Administration
Excellent communication and interpersonal skills.
Maintains an understanding of relational principles, general DBA techniques and practices, as well as the ability to understand moderately complex relationships dictated by the data schema.
What We Can Offer You:
We’ve been named a Best Place to Work by the Washington Post.
Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.
We offer competitive benefits and learning and development opportunities.
We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.
For over 55 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.
CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities.