Location
Herndon, VA | United States
Job description
The Database Engineer/Developer will be responsible for understanding of the Consular Systems Modernization (CSM) program technical requirements, architecture of the system, data model, interfaces and applications. As part of the modernization program, the Database Engineer/Developer will be responsible for the design, development, installation, and maintenance of database management systems to include data definition, data modeling, design and implementation, security, and monitoring. The Database Engineer/Developer will participate in development and solution enhancement activities as part of an Agile development team.
GENERAL DUTIES: - Work with the system engineering team to understand customer business needs and priorities
- Define system and technical requirements, including both functional and non-functional, to support database management system development within the SAFe Agile methodology
- Develop conceptual, logical, and physical designs for database solutions
- Develop and maintain database solutions for managing structured and unstructured data
- Develop and maintain database solutions for data ingestion (batch and streaming)
- Develop and maintain database scripts supporting ETL processes and functions
- Monitor and tune database solutions for optimal performance
- Develop and maintain secure database solutions that are compliant with DISA STIG and NIST specifications (security controls)
- Develop automated tests that can be incorporated into CI/CD pipeline
- Support CI/CD initiatives and utilize static code analyzers to ensure high quality source code
- Author clear documentation for database solutions, including data dictionaries, data catalogs, and design artifacts
- Integrate database solutions with the software applications and/or platforms
- Support software testing activities, including IV&V, and provide timely software defect resolutions
- Monitor production and non-production database solutions for performance and troubleshoot issues as required
- Provide production and operational support, as needed, to ensure deployed database solutions meet functional and non-functional requirements
- Develop and maintain backup/restore solutions to support production and non-production database solutions
REQUIRED QUALIFICATIONS:
- Bachelor's degree in a related field and nine (9) years’ experience or no degree with additional 4 years of experience
- At least 5 years of experience with developing relational database management systems (RDBMS) using Oracle, PostgreSQL, MySQL, or Microsoft SQL Server in a production environment
- Experience in software development and maintenance projects with involvement in requirements management, technical design/development, and deployment steps within SDLC
- Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment
- Experience designing database solutions using conceptual, logical, and physical diagrams.
- Experience with developing database solutions involving storage of structured and unstructured data, data ingestion via batch and streaming, and ETL processes
- Excellent communication skills, both verbally and in writing
- Experience supporting database engineering activities for software projects specializing in development of enterprise web applications within an Agile environment
DESIRED QUALIFICATIONS:
- Experience with enterprise software system modernization efforts
- Experience developing database solutions in an incremental manner using the SAFe Agile methodology
- Experience in cloud-based environments including the development of database solutions that are based on a hybrid-cloud architecture
- Experience developing database solutions for high volume, highly available, and secure software system
- Experience developing database solutions in a secure environment that are required to meet DISA STIG and NIST specifications (security controls)
- Knowledge of software development methodologies, practices, and tools
- Ability to work independently and in a team environment
CLEARANCE:
Job tags
Salary
