Database Administrator

Database Administrator Job Category: Information Technology Time Type: Full time Minimum Clearance Required to Start: TS/SCI Employee Type: Regular Percentage of Travel Required: Up to 10% Type of Travel: Local * * * The Opportunity: CACI is seeking a cleared Database Administrator who will be responsible for installation, replication configuration, SSL, query analysis / indexing and other performance tuning for enterprise database technologies (Primarily Oracle MySQL and PostgreSQL databases) at Fort Eisenhower, GA. Responsibilities: * Establish and maintain security and integrity controls. * Formulate and monitor policies, procedures and standards relating to database management. * Propose and implement enhancements that will improve the performance and reliability of the system. * Maintain 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. * Identify customer database requirements and define 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). * Incorporate security, back-up, and disaster recovery into database designs as well as establish database parameters that maximize database performance. * Install, configure, and patche database management systems (DBMS) and write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata). * Control access permissions and privileges and ensure that storage and archiving procedures are functioning correctly. * Conduct capacity planning. * Communicate regularly with technical, applications and operational staff to ensure database integrity and security and provide Tier III support for the application technology stack. * Apply application, security, and database patches and verify shell/SQL scripts, packages, and stored procedures for system enhancements. * Install and configure third party products that integrates with the underlying application. Qualifications: Required: * Must have an active Top Secret / SCI Clearance and willingness to obtain a Poly. * Must be 8570 IAT Level II compliant: such as Security+ CE. * Must have Bachelor's Degree in a related field and 6 years of related experience or 10-15 years related experience. * DBMS systems such as MySQL 8, Postgres/GIS, and SQLServer. * Must be able to identify, implement, and troubleshoot potential improvements in implementation of the above solutions. * Must have knowledge of server certificates. * Must have experience with ATO processes and procedures associated with inspection preparation. * Must be able to implement the use of alternate authentication methods such as LDAP 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. Desired: * 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. * Statistical data management and extraction utilizing Spunk. * Basic understanding of LDAP. * Knowledge of other programming languages & tools (e.g., Java, Perl, Python. - ______________________________________________________________________________ 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 takes pride in fostering a diverse and accessible culture where every individual feels supported to chart their own path. 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: $78,000 - $163,800 CACI is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, age, national origin, disability, status as a protected veteran, or any other protected characteristic.