Database Developer

Database Developer

Job Category: Information Technology

Time Type: Full time

Minimum Clearance Required to Start: NACI

Employee Type: Regular

Percentage of Travel Required: None

Type of Travel: None

* * *

The Opportunity:
• Work with data from financial institutions to determine data types and ensure proper data organization.

• Design and create PostgreSQL tables to store and manage large datasets for financial records.

• Develop SQL functions, stored procedures, and triggers to automate data ingestion and transformation workflows.

• Identify and extract critical financial data, including customer profiles, accounts, deposits, loans, and collateral, ensuring accuracy and completeness.

• Export data in Unicode-delimited DAT file format for attorney and analyst review.

• Maintain data accuracy and integrity across all ingestion, transformation, and export processes.

• Optimize SQL queries for improved performance when handling large datasets.

• Provide data support for legal investigations and audits, ensuring timely and relevant information is available.


Responsibilities:
• Designing, Implementing, Optimizing, and Decomposing very large databases.

• Manage and maintain large-scale database environment consisting of Oracle, MySQL, and PostgreSQL and Microsoft SQL Server databases.

• Read script written by other programmers and make modifications.

• Find innovative ways to overcome speed issues to make data queries efficient and dynamic even when combining large quantities of data.

• Read and write SQL.

• Write and execute stored procedures utilizing PG SQL, T SQL, and/or PL SQL.

• Experience writing and executing stored procedures.

• Research and clearly articulate, verbally and in writing, recommended solutions.

• Simplify and optimized complex queries through rewrites, leveraging materialized views for efficiency.

• Conduct routine database maintenance, including purging old data, reorganizing tables, and maintaining backup and recovery procedures.

• Troubleshoot performance issues with SQL tuning tools and explain analyze in both oracle and Postgres respectively.

• Configure Greenplum database systems, including setting up database clusters and networking configurations.


Qualifications:

Required: 

• 7+ years’ experience as a Database Administrator or similar roles.

• Strong knowledge of various database management systems, including Oracle, MySQL, Microsoft SQL Server.
• Solid understanding of database architecture and data modeling principles.

• Experience utilizing command-line interfaces, scripting, and queries.

• Experience with task automation via PowerShell, Python, Bash, and REST.

• MCSA: SQL Server Administration (current version), or related certification such as PostgreSQL Certified Engineer.

• Prior experience in software development efforts, designing conceptual data models & system architecture, and user interfaces.

• Strong problem solving and root-cause analysis skills.

• Self-motivated and able to prioritize and manage workload and meet critical project milestones and deadlines.

• Demonstrated aptitude for analytical thinking, problem-solving, and working multiple tasks concurrentl

Desired:
• Understanding of the Bank Terms, and/ or Finance and Accounting procedures

• Proficient in multiple computing languages. Examples would be, Python, C#, Ruby, Powershell, and Java

-

_____________________________________________________________________________

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 o