CACI International Inc · 3 hours ago
Database Developer
Remote (Any State)
Full-time
Remote
Mid, Senior Level
$82K/yr - $172K/yr
7+ years exp
Maximize your interview chancesInformation TechnologyService Industry
No H1B
Security Clearance Required
Insider Connection @CACI International Inc
Get 3x more responses when you reach out via email instead of LinkedIn.
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, 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.
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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
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 concurrently.
Preferred
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.
Benefits
Healthcare
Wellness
Financial
Retirement
Family support
Continuing education
Time off benefits
Company
CACI International Inc
At CACI International Inc (NYSE: CACI), our 24,000 talented and dynamic employees are ever vigilant in delivering distinctive expertise and differentiated technology to meet our customers’ greatest challenges in national security.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
unknown2003-01-10IPO
Leadership Team
John Mengucci
President & CEO
Darryl W Burke
Senior Vice President & Air Force Client Executive
Recent News
Washington Technology
2024-11-21
Company data provided by crunchbase
