Database Developer (PostgreSQL)

Employer
CACI
Location
Ashburn, VA, United States of America
Posted
Nov 23, 2022
Closes
Dec 23, 2022
Ref
271162
Function
IT
Hours
Full Time
Database Developer (PostgreSQL)

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: None

Employee Type: Regular

Percentage of Travel Required: Up to 10%

Type of Travel: Local

General Description

What you'll get to do:
  • Designing, developing and implementing custom software and database application capabilities for a variety of legacy and modernized systems with limited oversight
  • Real time Data streaming from Oracle to PostgreSQL
  • SQL Query performance tuning
  • Data streaming using Kafka / AWS DMS
  • Extract, Transform and load data using scripts / ETL software
  • Migrate tables and triggers from Oracle to PostgreSQL
  • Data validation scripts
  • Support application team for Database design
  • Production data modification scripts
  • Maintain data dictionary across organization using Collibra software
  • Active participation in release and sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases
  • Ensuring product quality and timeliness of work, providing advice and guidance, resolving problems to meet objectives, and providing periodic performance reports
  • Developing new and refining existing process to enhance quality and productivity


You'll Bring These Qualifications:
  • Must be a U.S. Citizen with the ability to pass CBP background investigation, criteria will include:
    • 3-year check for felony convictions
    • 1-year check for illegal drug use
    • 1-year check for misconduct such as theft or fraud
  • College degree (B.S.) in Computer Science, Software Engineering, Information Management Systems or a related discipline. Equivalent professional experience will be considered in lieu of degree
  • Professional Experience: at least seven (7) years related Database developer experience.


These Qualifications Would be Nice to Have:
  • Experience with Data streaming from Oracle to PostgreSQL
  • Ability to apply advanced principles, theories, and concepts, and contribute to the development of innovative principles and ideas
  • Direct experience providing production support for PostgreSQL and Oracle database
  • Programming background in Java, Python
  • Technical Certifications, such as OCP or AWS certification
  • Experience with PostgreSQL and Oracle Database Development including Stored Procedures, Constraints, Joins, Keys, Indexes, Triggers and Data Import/Export.
  • Experience using Data streaming technologies like AWS, DMS, or Kafka
  • AWS Cloud Database (RDS) experience, especially PostgreSQL and Oracle
  • Knowledge of large scale data migration from Oracle to PostgreSQL
  • Working experience with advanced procedures/functions concepts and features such as Analytic Functions and Hierarchical Queries with Oracle and PostgreSQL
  • Experience with database tools like TOAD, SQL Developer and PGadmin
  • Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections
  • Experience with database design and stored SQL procedures
  • Excellent written and verbal communication skills
  • Highly responsible, team-oriented individual with very strong work ethic and a self-starter


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.

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.

Pay Range: The proposed salary range for this position is $65,300-$134,000. There are a host of factors that can influence final salary including, but not limited to, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, geographic location, 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. Employment benefits include health and wellness programs, income protection, paid leave and retirement and savings.

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.

Similar jobs