The Database Engineer will analyze, design, develop, test, and deploy a database tool for use by our contractor team, likely using either a MS Access front end client with a remote connection into the customer’s SQL Server or Oracle back end via an ODBC connection or the database hosted on a customer provided SharePoint web site. The tool must facilitate capturing, validating, tracking, and maintaining the current status of circuits/services transitioning off the legacy telecommunications contract.

Key Tasks and Responsibilities

· Work with the Project Manager and the Telecommunications Service Support Team (TSST) to translate business requirements into technical requirements.

· Develop the appropriate database framework using industry best practices, including all tables, queries, forms, reports, and underlying VBA code and stored procedures.

· Minimize latency experienced by end users via the remote connection

· Develop a robust user interface to support data entry and cutover scheduling with dynamic filtering, sorting, and reporting capabilities.

· Develop code to automatically parse and import standardized email documents from MS Outlook into MS Access tables using Power Apps (Power Automate).

· Develop processes whereby users can run standard reports as needed and export them to MS Excel or other identified format such as Power BI.

· Test and troubleshoot new versions prior to release and deployment to the users.

· Implement backup and restoral capabilities to insure against data loss and corruption.

· Provide solutions to a variety of technical problems of moderate scope and complexity where analysis of situations or data requires a review of a variety of factors.

· Contribute to the completion of milestones associated with the transition project.

Education & Experience

· Bachelor’s degree in a related field and 8 years of experience with different databases

· Requires MS Access or Excel VBA development experience.

· Requires SQL Server and/or Oracle experience

· Requires the ability to communicate effectively with functional leads and team members.

· Experience with Microsoft SharePoint development is strongly preferred.

· Experience with Microsoft Power Apps (Power Automate, Power BI) is strongly preferred.

· Experience/background supporting the Defense Information Systems Agency (DISA) and/or Defense Information Technology Contracting Organization (DITCO) is preferred.

Certifications

· None required but CompTIA Security+ certification is preferred.

Security Clearance

· US Citizenship is required. Candidates must undergo a favorably adjudicated National Agency Check with Inquiries (NACI) as a condition of employment.