Database Analyst /Programmer - Intermediate

Plateau Software Inc • Coronado, CA

just now • $110,000 - $120,000

About The Position

The Intermediate Database Analyst/Programmer will analyze requirements and design, code, test, debug and document custom or framework-based front-end script and markup language under the general supervision of the Project Manager.

Requirements

• Develop, and maintain applications with a focus on full stack development using modern frameworks and languages (e.g., C#, JavaScript, TypeScript, and .NET Core).
• Build and optimize responsive, user-friendly front-end interfaces leveraging JavaScript frameworks such as Angular, React, or Vue.js.
• Collaborate on back-end development tasks, including the creation and maintenance of APIs, microservices, and server-side logic using C# and .NET technologies.
• Ensure seamless integration of application components with enterprise databases such as SQL Server or NoSQL solutions as needed.
• Develop, test, and deploy scalable, secure, and modular code that aligns with defined software development standards and best practices.
• Support the modernization of legacy systems by implementing new technologies and tools where applicable.
• Troubleshoot and debug software issues across the stack to ensure high system availability and performance.
• Write detailed technical documentation for the full stack development lifecycle, including specifications, workflows, coding standards, and deployment procedures.
• Bachelor’s Degree in Computer Science or related area
• Minimum of 5 years of relevant experience can replace degree requirement
• Must have high-level written and verbal communication skills
• Must be able to obtain and maintain a SECRET security clearance.

Responsibilities

• Collaborate with end users to identify needs and opportunities for improved data Design, create, maintain, and manage Enterprise Data Warehouses (EDW), data lakes, data marts, Operational Data Stores (ODS), Extract Transform Load (ETL) solutions, XML, indexes, T-SQL and data manipulation scripts, stored procedures, views, functions, reports and forms.
• Apply Department of War (DoW) data standards to all software applications and database data elements, ensuring logical data models are fully attributed, normalized, and included in a data dictionary.
• Create data dictionaries for all database efforts that include the following information for each functional data element: the logical data element name, its definition that describes the meaning and the context of the data element in the system, the domain of the data element (the allowable values), the data type, length, and unit of measure.
• Assist in developing SOF Enterprise metadata standards and document all meta tags, where applicable, in an XML Schema (XSD file) and post to the Metadata Registry after being vetted through a configuration management process.
• Provide consulting services and technical support for database creation, modification, testing, administration, monitoring, tuning, backup, and recovery.
• Ensure maximum use of SQL Server Integration Services (SSIS) and SQL Server reporting Services (SSRS) for the integration and delivery of information.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level