About This Role
This role provides contractor support services for the Naval Supply Systems Command (NAVSUP) Business Systems Center (BSC) team, focusing on designing, implementing, securing, and sustaining databases and data-management capabilities. The position involves database design and development, performance tuning, testing, backup and recovery, release support, documentation, and coordination with application-development teams.
Responsibilities
- Design and implement databases to meet application requirements
- Develop and implement database objects, including stored procedures, functions, triggers, views, and schemas
- Create and maintain data models to ensure data consistency and integrity
- Implement database security measures, including authentication, authorization, and access controls, in compliance with applicable DoD and DoN policies
- Optimize database performance through indexing, caching, and query optimization
- Maintain current database design, development, and implementation documentation, including entity-relationship diagrams and data-flow diagrams
- Develop and execute database test plans, including unit, integration, and performance testing
- Collaborate with application developers to ensure database designs meet application requirements
- Develop and implement backup and recovery plans that protect data integrity and availability
- Manage database instances, including their creation, configuration, and deletion
- Use the enterprise-wide version-control system and support secure, quality-controlled CI/CD builds, testing, and deployments
- Identify, define, or modify interfaces with other systems and applications, ensuring agreements are formally documented with the interfacing system or application
- Support production outages, development of release packages, work-item updates in the designated tool, and internal review or change boards
- Conduct quality audits of NAVSUP products, perform causative research on errors, and provide corrective action
- Maintain a professional relationship with clients, team members, and internal and external agencies and organizations
Requirements
- Two or more years of experience and knowledge performing database administration, data management, database engineering, or related software-engineering activities
- Knowledge of the design and implementation of computer and database-management systems
- Knowledge of current software and database engineering methodologies, design techniques, and applicable software and database standards
- Experience using Structured Query Language (SQL) and Microsoft SQL Server database-development capabilities
- Experience with Microsoft development tools and the analysis, development, maintenance, and testing of database-supported applications
