What are the responsibilities and job description for the 1625 - Senior Database Developer position at Sigma Defense?
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.
- 5 years of relevant experience.
- 5 years of experience in database-oriented work.
- Experience 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 improvements.
- IAT Level II, Cloud Certifications (Cloud , AWS, etc.).
- Must be a U.S. citizen.
Candidate 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 development.
- 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.
Education Requirements:
- Bachelor's degree from an accredited college or university in Computer Science or related field of study.
Personnel 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 candidate.
Essential Job Duties (not all-inclusive):
- 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.
Salary Range: $90,000 - $105,000 annually.
- Dental and Vision Insurance
- Medical Insurance to Include HSA, FSA, and DFSA Plans
- Life and AD&D coverage
- Employee Assistance Program (EAP)
- 401(k) Plan with Company Matching Contributions
- 160 Hours of Paid Time Off (PTO)
- 12 (Floating) Holidays
- Educational Assistance
- Highly Competitive Salary
Salary : $90,000 - $105,000