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)
Inserso is an equal opportunity employer and does not discriminate on the basis of sex, age, race, color, religion, marital or veteran status, national origin, disability, obligation to serve the armed forces of the U.S., or any other characteristics by applicable federal, state or local laws. Reasonable accommodation will be made for qualified individuals with a disability, where such accommodations will not impose an undue hardship during the application process and on the job.