Roles & Responsibilities: This position requires a strong background administering, maintaining, and enhancing Microsoft SQL Server databases and ASP.net / C-sharp web applications. The candidate will be responsible for the implementation and maintenance support for two (2) MS SQL databases and the associated web interface application that are written in ASP.net and C-sharp. Responsibilities and core tasks include:
Update and maintain the SQL database including all database objects, triggers, stored procedures, indexes, functions, permissions, and constraints.
Update, redesign, and implement changes to the database and associated web application based on requested and approved changes to the system. This requires making changes to the database as well as the web application (ASP.net and C-sharp coding) to support the requested changes.
Perform routine data cleansing, eliminating redundant and obsolete information.
Collect and provide monthly reports on system (application) usage.
Perform requirements analysis, data migrations, system testing, and troubleshooting.
Create and maintain system documentation, including all technical system documentation. Create new documentation when necessary.
Provide tutorials for end users on system use to address operational and administrative needs.
Implement and maintain version control for the database and associated web application code.
Perform corrective maintenance to resolve any faults identified within the system.
Perform daily, proactive database maintenance to ensure system effectiveness and reliability, including database tuning and backups.
Provide briefings, research, and analysis for senior management regarding the application.
Provide compliance monitoring, tracking, and support services to help ensure all DoD IA standards, governance policies, and directives are being adhered to.