Database Engineer/Backend Developer

General Dynamics Information Technology is a global technology and professional services company supporting essential government programs. They are seeking a seasoned database engineer to maintain reliable and secure database management systems, provide reports and dashboards, and improve complex data models.

Responsibilities:

• Install, upgrade, and maintain databases (servers and instances), indexes, and related processes, including backup and recovery
• Conduct performance tuning of database systems
• Develop automated mechanisms (stored procedures, function, and ad hoc scripts) for monitoring, maintenance and routine tasks
• Perform vulnerability management and continuous optimization of database security
• Diagnose and troubleshoot database errors
• Analyze data to create and manage reports, visualizations, and dashboards
• Understand complex data schemas and create enterprise data models
• Develop and support data integration mechanisms with other systems
• Develop and maintain database and system documentation

Requirements:

• Database Architecture
• Technical Solutions
• Web Applications
• 8 + years of related experience
• US Citizenship Required
• Install, upgrade, and maintain databases (servers and instances), indexes, and related processes, including backup and recovery
• Conduct performance tuning of database systems
• Develop automated mechanisms (stored procedures, function, and ad hoc scripts) for monitoring, maintenance and routine tasks
• Perform vulnerability management and continuous optimization of database security
• Diagnose and troubleshoot database errors
• Analyze data to create and manage reports, visualizations, and dashboards
• Understand complex data schemas and create enterprise data models
• Develop and support data integration mechanisms with other systems
• Develop and maintain database and system documentation
• Database Administration and Engineering
• Microsoft SQL Server 2019+ (Standalone and Always on Availability Groups instance configurations)
• SQL Server Management Studio
• PowerShell
• ElasticSearch and/or AWS OpenSearch for indices and index management
• Data analysis and documentation (models, dictionaries, flows, statistical reporting, etc.)
• Backend Development/IT Systems Administration
• Windows/IIS server administration
• Patching team-managed server applications, and reviewing and validation enterprise server patching
• Log management and analysis
• Cloud services (AWS preferred): Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS)
• DevOps – deployment management, configuration management, release coordination, cloud network operations, Agile concepts and frameworks
• Has demonstrated experience owning a technical task from discovery to resolution and leading response actions while coordinating with technical and non-technical teams
• Applies good judgement with personal initiative, adopting a 'first do no harm' perspective
• Maintains commitment to quality and continuous improvement
• Demonstrates capacity for deep, critical thinking while maintaining an understanding of business needs
• US Citizenship
• Ability to obtain and maintain an Agency specific Public Trust clearance
• Experience using AI tools for heavy data analysis, data normalization efforts, etc
• Experience preparing data for FOIA request responses
• Power BI or similar business intelligence and visualization tools
• Microsoft .NET/C# web applications development (including MVC and Web APIs)
• Front end JavaScript or TypeScript frameworks such as AngularJS/Angular 2+
• Entity Framework code first development workflow
• Azure DevOps (ADO)
• Familiarity with Splunk