What You’ll Get to Do:
CACI International, Inc. is seeking a full-time Database Administrator to join our team in Augusta, Georgia. The candidate will work on Fort Gordon, which is located near Augusta, Georgia.
More About the Role:
Responsible for installation, replication configuration, SSL, query analysis / indexing and other performance tuning for enterprise database technologies (Primarily Oracle MySQL and PostgreSQL databases). Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; and participating in professional societies. Identifies customer database requirements. Defines optimal conceptual, logical and physical data models that address customer requirement and balances performance (e.g., indexes, views, snapshots) and storage (e.g., normalization, de-normalization). Incorporates security, back-up, and disaster recovery into database designs. Establishes database parameters that maximize database performance. Installs, configures, and patches database management systems (DBMS). Writes database documentation, including data standards, procedures and definitions for the data dictionary (metadata). Controls access permissions and privileges. Ensures that storage and archiving procedures are functioning correctly. Conducts capacity planning. Communicates regularly with technical, applications and operational staff to ensure database integrity and security. Provides Tier III support for the application technology stack. Applies application, security, and database patches. Verifies shell/SQL scripts, packages, and stored procedures for system enhancements. Installs and configures third party products that integrates with the underlying application.
You’ll Bring These Qualifications:
Must have an active Top Secret / SCI Clearance.
Must be 8570 IAT Level II compliant: such as Security+ CE
Bachelor's Degree and 4- 6 years of related experience or 9-12 years related experience
Knowledge of current solutions for high availability, resiliency, disaster recovery, replication, backup strategies, security, and performance tuning with various DBMS systems such as MySQL 5.7 and 8, PostGres/GIS, and SQLServer.
Must be able to identify, implement, and troubleshoot potential improvements in implementation of the above solutions.
Must be able to implement the use of alternate authentication methods such as LDAP and PKI with DBMS systems
Must be able to setup mentioned DBMS systems and have the ability to research, setup and test any others that may improve our data storage, search, and retrieval environment.
Willingness to branch out from database work to assist integrating with applications, working within SPLUNK to show trends and identify irregularities.
These Qualifications Would be Nice to Have:
VMware ESXi: able to deploy and manage Linux guest hosts in a virtual environment
Puppet Configuration Management
Linux & Windows Shell Scripting: Bash, PowerShell
Unix/Linux administration skills (preferably Red Hat Enterprise Linux / CentOS)
Experience with Geo-Server, Geo Web Cache and Open-Layers GIS Tools: ArcGIS, Google Earth along with respective plug-ins or Python scripting
Statistical data management and extraction utilizing Spunk.
Capacity management & planning
Basic understanding of LDAP
Knowledge of other programming languages & tools (e.g., Java, Perl, Python)
Knowledge of Microsoft Enterprise Windows, Active Directory integration
Knowledge and ability to work with technologies such as Elastic Search, SOLR, and other search technologies a plus.
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.