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 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.
Since this position can be worked in more than one location, the range shown is the national average for the position.
The proposed salary range for this position is:
$82,100-$172,400CACI 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.