Senior SQL Server Developer

Seeking a Senior SQL Server Developer is the expert for a technical development or execution environment product or set of products. The primary responsibility is to ensure the availability and facilitate the productive use of a product for Application Teams or end users. May own part of a product, all of one, or several products depending on the nature of the product(s) and their use. Responsible for collaborating with Technical Architecture Specialist, System Specialists, Programmers, and vendors to ensure and enhance the use of the product and effect migration to new versions of a product. Skills in MS-Access, SQL Server (TSQL), ETL, OnBase, Azure ADO.

Interview: Teams

Location: Columbus, OH

Posting: 788699

Work: Hybrid

Role and Experience

• Responsible for functioning as the Technical SME on an enterprise-wide system.
• Responsible for implementations of products/services
• Provide direct technical expertise to Executive applications involving national security
• Make sound recommendations on functional and technical improvements to the product.
• Analyze the functional and technical impact of product planning decisions.
• Develop appropriate functional and usability standards for products.
• Track and document expected volume and type of use of the product.
• Participate in product design reviews to verify that design meets quality standards and functional/technical requirements.
• Perform impact analyses on production fixes and enhancements to establish priorities.
• Provide basic product support and provide accurate and complete answers to detailed product questions in a timely manner.
• Provide effective on-site product support as needed.
• Accurately sets severity of identified defects.
• Provide input to training and / or documentation materials regarding latest technical and functional design changes.
• Document all work for future reference.
• Review the system test approach and conditions used as the basis for detailed test scenarios.
• Microsoft Access user interface with a SQL Server backend (known as RBDMS) that is to be converted to a web-based application hosted within the Azure cloud.
• Legacy system is a Microsoft Access user interface with a SQL Server backend.
• Define a roadmap to sunset the legacy system.

Deliverables Goals

• Evaluate, identify, and resolve the current bi-direction sync issues between the RICS system tables and data fields and the RBDMS tables and data fields.
• Create roadmap to sunset active RBDMS functionality being used by DOGRM program areas.
• Act as a proxy Product Owner with RICS vendor through attending standups, defining features, user stories and acceptance criteria requirements in Azure ADO for development of approved RICS enhancements.
• Assume lead role working with business leads to test and validate RICS developed enhancements.
• Manage existing OnBase taxonomy including identifying and submitting additional new OnBase document groups and document types as required.