Database Developer

CACI International

418d • $82,100 - $172,400

About The Position

The Database Developer at CACI International is responsible for managing and optimizing large-scale databases, particularly in the financial sector. This role involves designing PostgreSQL tables, developing SQL functions, and ensuring data accuracy and integrity throughout various processes. The position requires collaboration with legal teams to provide data support for investigations and audits, while also focusing on performance optimization and routine database maintenance.

Requirements

• 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 on multiple tasks concurrently.

Nice To Haves

• Understanding of Bank Terms and/or Finance and Accounting procedures.
• Proficient in multiple computing languages such as Python, C#, Ruby, Powershell, and Java.

Responsibilities

• 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, 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.
• Design, implement, optimize, and decompose very large databases.
• Manage and maintain large-scale database environments consisting of Oracle, MySQL, PostgreSQL, and Microsoft SQL Server databases.
• Read scripts written by other programmers and make modifications.
• Find innovative ways to overcome speed issues to make data queries efficient and dynamic.
• Write and execute stored procedures utilizing PG SQL, T SQL, and/or PL SQL.
• Research and clearly articulate recommended solutions.
• Simplify and optimize complex queries through rewrites, leveraging materialized views for efficiency.
• Conduct routine database maintenance, including purging old data and maintaining backup and recovery procedures.
• Troubleshoot performance issues with SQL tuning tools.

Benefits

• Healthcare benefits
• Wellness programs
• Financial benefits
• Retirement plans
• Family support
• Continuing education opportunities
• Flexible time off benefits

What This Job Offers

• Job Type: Full-time
• Industry: Professional, Scientific, and Technical Services
• Education Level: No Education Listed