Data Engineer / DBA - TS/SCI w/ Poly

Data Engineer / DBA - TS/SCI w/ Poly

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: TS/SCI with Polygraph

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Local

CACI is seeking a Data Engineer / DBA to join our Luke program in Bethesda, MD to be a part of a larger team of software developers and support real mission initiatives. You will deliver services within a cloud environment, while working within an Agile project team. You will also be responsible for participating in collaborative discussions and helping to establish DB administration norms and practices to ensure consistency across the multiple development and integration efforts.

Luke is an Enterprise IT Program that supports and enables the ODNI to lead resource, performance, and financial management decision making across the IC. As a member of an agile team you will work with the government customer to help shape a new phase of applications into the cloud environment.

You will work closely with multiple contractor teams and the customer to transform approved requirements into features during each sprint. You will help to develop the new suite of applications one sprint at a time. Invent your future and make a lasting impact at CACI.

Duties Include but are not Limited to:

.
• .

  Provide technical expertise and support in the use of PostgreSQL DBMS

  .
.
• .

  Create and maintain database objects such as tables, views, index, constraints for data platform and custom applications

  .
.
• .

  Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications

  .
.
• .

  Create views to drive front-end data analytics and reporting

  .
.
• .

  Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools

  .
.
• .

  Enhance and maintain logical and physical database designs from application requirements

  .
.
• .

  Design and implement automation using SQL scripts and database functions

  .
.
• .

  Respond to user reported errors in a timely manner

  .
.
• .

  Monitor systems performance and identifying problems that may arise

  .
.
• .

  Liaison with developers and IT project managers

  .
.
• .

  Recommend changes and enhancements for database performance and protection

  .
.
• .

  Maintain an awareness of trends and developments in database development and administration

  .
.
• .

  Leverage experience to provide support in the areas of data mapping, data extraction, transformation, and loading (ETL)

  .
.

Required Qualifications:

.
• .

  Active TS/SCI w/ Poly

  .
.
• .

  8 years of job-related experience

  .
.
• .

  Bachelor’s degree in computer science, software engineering, or related field of study

  .
.
• .

  5 years of experience in administering on-prem/cloud based multiuser environment with expertise in planning, designing, building, and implementing complex database systems

  .
.
• .

  Experience with AWS RDS or Aurora for PostgreSQL

  .
.
• .

  Familiar with open-source DBMS tools such as pgAdmin, pgModeler, or DBeaver

  .
.
• .

  Experience with data modeling and Entity-Relationship Diagrams (ERDs)

  .
.
• .

  Experience with Structured Query Language (SQL)

  .
.
• .

  Possess analytic problem-solving skills

  .
.
• .

  Knowledge of computer software applications, including database technologies and programming languages

  .
.
• .

  Experience implementing and deploying databases in Amazon Web Services (AWS)

  .
.

Nice to have qualifications:

.
• .

  Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools

  .
.
• .

  Implemented automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production and non-production environments

  .
.
• .

  Administrated PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment

  .
.
• .

  Experienced with optimizing database performance through exhaustive proactive testing and ongoing real-time monitoring

  .
.
• .

  Experienced in SQL scripting and database functions

  .
.
• .

  Experience in testing database security and enterprise policy guidelines according to established best practices

  .
.
• .

  Monitored and maintained the backups for database recoverability for all production databases

  .
.
• .

  Experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of PostgreSQL DB

  .
.
• .

  Excellent verbal and written communication skills

  .
.
• .

  Experience with AGILE / DEVOPS

  .
.
• .

  AWS Certified Solutions Database – Specialty

  .
.
• .

  AWS Certified Solutions Data Analytics – Specialty

  .
.

What we can offer you:

At CACI, our philosophy of employee development and advancement rests on a cultural foundation of providing unlimited and equal opportunity for growth, recognition, and rewards. We provide the environment, support and responsive, available management to nurture and stretch your abilities. We also offer a career mobility program to make it easy to build a dynamic career at CACI and offer flexible work schedule arrangements to support work/life balance.

.
• .

  CACI has been named one of Fortune magazine’s World’s Most Admired Companies for 2022

  .
.
• .

  CACI also has more than 20 Communities of Practice to share and gain skills and knowledge regarding various technologies and topics including SAP, Salesforce, Agile Development, and many more. The associated Learning Academies provide training and certifications to gain additional skills and build your brand.

  .
.
• .

  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

  .
.
• .

  With over 25,000 employees worldwide, CACI has been named a Best Place to Work by the Washington Post

  .
.
• .

  For over 55 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success

  .
.

Company Overview: 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 an Equal Opportunity Employer – Females/Minorities/Protected Veterans/Individuals with Disabilities.

As a federal contractor, CACI is subject to any federal vaccine mandates or other customer vaccination requirements. All new hires are required to report their vaccination status.