1625 - Senior Database Developer

Sigma Defense is currently seeking a multi-faceted Senior Database Developer whose primary responsibilities include designing, developing, testing, deploying, maintaining, and improving the database 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 Server database development 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 Microsoft 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.Requirements5+ years of relevant experience5+ years of experience in database-oriented workExperience with Microsoft SQL Server, T-SQL development, SSIS and experience working on Relational Databases Ability to ensure robust stability of the system while identifying, researching, and developing improvementsIAT Level II, Cloud Certifications (Cloud+, AWS, etc.)Must be a U.S. citizenCandidate Differentiators: 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, especially Microsoft SQL Server and T-SQL developmentExperience with Integration Service (SSIS) packages and SQL Server Management Studio (SSMS)Database administration experience in an AWS environmentProactive, independent, flexible, team-player Experience working in an Atlassian environment, e.g., Bitbucket, Jira, Confluence, etcEducation Requirements: Bachelor's degree from an accredited college or university in Computer Science or related field of studyPersonnel Clearance Level:Candidate must possess or have the ability to obtain an active Secret security clearance or higher. Clearance may be sponsored for the right candidateEssential Job Duties (not all-inclusive):Set standards for database operations, programming, query processes, and securityModel, design, and construct large relational databases or data warehousesCreate and optimize data models for infrastructure and workflowDevelop stored procedures from scratch to support new developmentIntegrate new systems/modules with existing structure and refine system performance and functionalityDevelop stored procedures, functions, and triggers in support of the various modules within NTIRADevelop 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 modulesPerform sustainment of existing database with changesSalary Range: $90,000 - $105,000 annually.BenefitsDental and Vision InsuranceMedical Insurance to Include HSA, FSA, and DFSA PlansLife and AD&D coverageEmployee Assistance Program (EAP)401(k) Plan with Company Matching Contributions160 Hours of Paid Time Off (PTO)12 (Floating) HolidaysEducational AssistanceHighly Competitive Salary