Offer summary

Qualifications:

Active Secret clearance is required., Bachelor’s degree in Computer Science, Cyber Security, Information Technology, Software Engineering, Information Systems, or Computer Engineering, or a degree in Mathematics or Engineering., 10+ years of SQL development experience in a web-based environment, including designing and implementing SQL stored procedures., Experience with SQL Server Integration Services (SSIS) and versioning software with Atlassian Bitbucket..

Key responsibilities:

Set standards for database operations, programming, and security.

Model, design, and construct large relational databases or data warehouses.

Develop stored procedures and SQL Server Integration Services packages to manage data.

Integrate new systems with existing structures and enforce versioning control for database changes.

Job description

cFocus Software seeks a NTIRA Database Architect, Senior to join our program supporting the US Navy. This position is remote. This position requires a Secret clearance.

Qualifications:

Active Secret clearance
Bachelor’s degree from an accredited college or university in Computer Science, Cyber Security, Information Technology, Software Engineering, Information Systems, or Computer Engineering degree; or a degree in a Mathematics or Engineering field.
10+ years of experience providing SQL development support in a web-based environment, including the ability to design, code, test and implement SQL stored procedures, consolidate views from multiple database tables, build complex queries from existing database tables, and design database tables and schemas to support web application development within a SQL Server database environment.
Experience with SQL Server Integration Service (SSIS) packages and SQL Server Management Studio (SSMS).
Experience designing, creating, and optimizing large relational databases or warehouses with integrated DOD and DON security standards.
Experience versioning software with Atlassian Bitbucket or similar Git based repository.
Experience with Atlassian Jira or similar issue and project tracking software.
Experience with Atlassian Confluence or similar knowledge management software.
Active DoD IAT II/III certification

Duties:

Set standards for database operations, programming, query processes, and security.
Model, design, and construct large relational databases or data warehouses.
Create and optimize data models for infrastructure and workflow.
Integrate new systems/modules with existing structure and refine system performance and functionality.
Develop stored procedures, functions, triggers in support of the various modules within NTIRA.
Develop and modify SQL Server Integration Services packages to import data from external data sources and subsequent stored procedures to process and move data into appropriate databases and database tables for the various modules.
Enforce versioning control for database changes