Applications Developer

Position Description: Inserso is seeking an Applications Developer to provide support to our USCG FORCECOM customer located at 301 Main Street Norfolk VA. Responsibilities This role will include, but will not be limited to the following responsibilities: Designs, implements, and maintains databases with respect to access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods Applies knowledge and experience with database technologies, development methodologies, and front-end (e.g., Access)/back-end programming languages (e.g., SQL). Provide day-to-day Microsoft SQL and Microsoft Access development support services, willing to interchange between challenging development work as well as routine tasks Assist with the migration of older non-supported database versions (e.g., MS Access 2003) to currently supported versions (e.g., MS Access 2016) Defining and maintaining an organized file structure and assigning user access rights Track and document all problems along with providing recommendations and resolution methods for USCG review Provide live/production database and application administration, support and management for approved databases and applications that are based on the locally installed MS Office Suite, as well as SharePoint Server Provide troubleshooting and resolution of mainly technical errors/failures On a routine basis, download reports and/or run ODBC queries from external databases; and import these into the internal database Occasionally design Excel-based reports via external data sources; and assist in the design of BI data cubes Assist in the administration of related FORCECOM SharePoint sites, lists and libraries, which includes maintaining and updating existing sites, lists and libraries, setting up new sites, lists, libraries, user groups, and setting permissions Monitor the host database server/files to ensure maximum performance and availability for users Be proficient with Microsoft Office technology (including MS Access, SharePoint Designer, Excel and Word) and shall produce documentation and reports using this technology as requested by the government Required Experience and Abilities Superior written and verbal communication skills Experience in a rapid paced, time sensitive, high-quality environment Good technical writing, presentation, and documentation skills Must have excellent team and collaboration skills Attention to detail and follow-through Ability to work with minimal supervision Ability to perform requirements gathering and interpretation of client needs Technical Skills At least 5-7 years of database engineering, application development experience, centered around Microsoft SQL and Microsoft Access- linking tables from various platforms, designing relational queries, forms, reports, and VBA macros/modules Proficient with Microsoft SQL Server, and knows the concept of relational databases and how to relate tables Basic Oracle DBA experience a plus Familiarity with MS Excel 'external data' reporting capabilities, especially working with pivot-tables; and some familiarity working with BI data cubes (Cognos preferred) Basic SharePoint familiarity, especially on designing/configuring lists, libraries and familiarity with the workflow concept Willing to learn InfoPath Designer if required for future projects Proficient in all Microsoft programs (i.e. Excel, Word, PowerPoint, Outlook) Required Certifications Microsoft DBA Certification Security Certification within 90 days of hire Security Requirements DOD Secret Clearance (can start with an Interim DOD Secret)