Financial Systems Database Developer
Summary
On-site developer in Doral, FL (SECRET clearance required) who maintains and enhances CTIMS, a Microsoft Access relational database supporting USSOUTHCOM's TCA and debit card programs. Day-to-day work involves integrating the system with government financial platforms like GFEBS, building workflows and financial reporting, and maintaining data in SharePoint.
Position Title: Financial Systems Database Developer
Location: Doral, FL
Clearance required: SECRET
Scope of Work: Maintains and enhances the Cloud-based TCA Information Management System (CTIMS), a Microsoft Access relational database used to manage the TCA and USSOUTHCOM Debit Card Programs. Develops IT solutions that integrate CTIMS with GFEBS, DTS, TED, SOCIUM, C2IE, DDS, and Meta Bank to a level of accuracy that is financially auditable and maintains 99% system availability.
Responsibilities include (but are not limited to):
- Provide and modify CTIMS tools to capture TCA event information and manage 1,400 to 1,700 multi-year concepts.
- Build electronic staffing/workflow, user permissions, workload queues, and approval messaging in CTIMS.
- Develop financial reporting tools and reconciliations to comply with governmental accounting formats.
- Integrate GFEBS financial data into CTIMS and reconcile discrepancies daily; update WBS codes and the CTIMS-GFEBS interface each fiscal year.
- Integrate and update CTIMS data weekly with TED, SOCIUM, and C2IE, including XML import compatibility.
- Develop and maintain the Debit Card module, integrating GFEBS, DDS, and bank data into a single display.
- Pull and post DTMO per diem tables, develop training materials, and train CTIMS users.
- Maintain CTIMS at 99% operational availability, apply Microsoft Office and software updates, and adhere to SOUTHCOM SEI policy.
- Migrate prior-year CTIMS data to SharePoint and maintain the TCA SharePoint site.