What You’ll Get to Do:
Join the FISMSS Project as a Mid-Level SQL Developer supporting financial management applications that help our Department of Defense customers analyze, report, and justify their budgets for congressional approval. We have been supporting our customers for almost 20 years with 5 applications across 6 different clients. We continue to develop and implement exciting and complex solutions to support the evolving needs of our customers.
You will be required to write stored procedures, functions, scripts, and views with extensive use of T-SQL programming in support of major application enhancements. You will work closely with Lead Developers to become familiar with other source systems which integrate with EAS in order to implement new data loads and make changes to existing ones. This role also requires the capability to debug and resolve data discrepancies during critical production support periods.
Additionally, you will be supporting a large-scale application re-write effort requiring analysis for creating new complex procedures to perform data integration, data mapping, and data transfer from source systems to the EAS database model.
This role requires strong technical skills and the ability to properly prioritize and multi-task. You must be able to work collaboratively with our project team in an Agile environment to ensure we are implementing optimal solutions for our customers.
More About the Role:
DESCRIPTION OF POSITION AND RESPONSIBILITIES:
As a Mid-Level SQL Developer, you will be responsible for the design, development and testing of the Microsoft SQL Server database application structure. Other responsibilities include monitoring databases on CACI and customer servers, evaluating database configurations and proactively suggesting improvements, troubleshooting and fixing issues, and evaluating Information Assurance vulnerabilities and implementing remedies. As part of the re-write effort you will help identify, prototype, and suggest alternatives to SQL Server such as Postgres, NoSQL, MySQL, etc.