SQL Developer

Responsibilities:

• 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.

Required Skills:

• Experience with MS-Access & SQL Server (TSQL) development. Required 7 Years
• Experience with creating Stored Procedures and Triggers to assist with creating bi-directional sync between RICS and JMT. Required 7 Years
• Experience creating SQL queries to perform data clean up or orphan data. Required 7 Years
• Experience creating ETL process between systems. Required 7 Years
• Ability to resolve OnBase issues when transferring legacy documents (RBDMS) into OnBase with RICS taxonomy. Required 5 Years
• 3 Years experience one who has live the Agile/SCRUM software methodology. Required 3 Years
• Document all requirements in ADO. Required
• Someone who can use Visio to document the sync process. Required