1625 - Senior Database Developer

Sigma Defense•Suffolk, VA

6h•$110,000 - $120,000

About The Position

Sigma Defense is currently seeking a multi-faceted Senior Database Developer whose primary responsibilities include designing, developing, testing, deploying, maintaining, and improving the persistence layers of the NTIRA software system. The flexibility to proactively gather and balance current needs as well as providing forward-thinking improvements to the system will be a critical skill in this role. The bulk of the work will focus on working with a small team to provide SQL development support in a webbased 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. As such, there will likely be work outside the database domain required. NTIRA is a module-based decision aid tool to facilitate knowledge discovery and management for C5I stakeholders in requirements generation, acquisition management and resource planning. It allows stakeholders to share a working environment among the Fleet, Office of the Chief of Naval Operations (OPNAV), acquisition communities, and component commands to facilitate a common picture of individual platforms mission capabilities and identified shortfalls. This knowledge enables decision makers to select the most capable platform to fill mission needs and identifies capability gaps that steers Command, Control, Communications, Computers, Combat Systems, and Intelligence (C5I) Modernization. Equal Opportunity Employer/Veterans/Disabled: Sigma Defense Systems is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Requirements

7-10 years of relevant experience.
5+ years of experience in database-oriented work.
Experience working with SQL/web-based development.
Ability to ensure robust stability of the system while identifying, researching, and developing improvements.
IAT Level II, Cloud Certifications (Cloud+, AWS, etc.).
Must be a U.S. citizen.
Candidate must possess or have the ability to obtain an active Secret security clearance or higher.

Nice To Haves

Experience with Naval Tool for Interoperability and Risk Assessment (NTIRA).
Experience designing, creating, and optimizing large relational databases or warehouses with integrated DOD and DON security standards.
Experience with Integration Service (SSIS) packages and SQL Server Management Studio (SSMS).
Database administration experience in an AWS environment.
Proactive, independent, flexible, team-player
Experience working in an Atlassian environment, e.g., Bitbucket, Jira, Confluence, etc.

Responsibilities

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.
Develop stored procedures from scratch to support new development.
Integrate new systems/modules with existing structure and refine system performance and functionality.
Develop stored procedures, functions, and 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.
Perform sustainment of existing database with changes.