Advanced Database Design Engineer

CLEARANCE REQUIREMENTS:: [Department of Defense Secret security clearance is preferred at time of hire.] Applicants selected will be subject to a U.S. Government security investigation and must meet eligibility requirements for access to classified information. Due to the nature of work performed within our facilities, U.S. citizenship is required.

We are seeking an experienced and forward-thinking Azure Database Administrator / Data Engineer to manage and optimize our data infrastructure across cloud and on-premises environments. This role requires a hybrid skill set, encompassing robust Azure SQL Server database management, logical data modeling, large dataset organization, and a solid understanding of version control and project management tools. The ideal candidate will ensure data integrity, security, performance, and availability, while also collaborating closely with development and IT teams to support application needs and drive data initiatives.

Key Responsibilities

• Azure SQL Database Management: Administer, monitor, and maintain Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure VMs, ensuring high performance, availability, and security.
• Database Design and Schema Management: Design and implement logical and physical database schemas, including tables, indexes, views, and relationships, to support application requirements and business needs.
• Data Organization and Management: Organize and manage large datasets, implementing data standards, procedures, and definitions for data elements to ensure data integrity and quality.
• Performance Tuning and Optimization: Proactively monitor database performance, identify bottlenecks, and implement optimizations, including query tuning and indexing strategies.
• Backup and Disaster Recovery: Develop, manage, and test robust backup and recovery plans and disaster recovery procedures to ensure business continuity and minimize data loss.
• Security and Access Control: Implement and manage security measures, including user access controls, permissions, and data encryption, to safeguard sensitive information and ensure compliance.
• Version Control and Project Management: Utilize Git for source code/version control of database scripts and schema changes, and manage tasks, issues, and project workflows within Jira.
• File Server Knowledge: Understand and manage data storage across traditional file servers and integrate storage solutions with cloud platforms like Azure Storage Accounts (BLOB, File Share).
• Collaboration and Support: Work closely with software engineers, data analysts, and IT staff to ensure seamless integration of database systems with applications and provide technical support.
• Automation and Scripting: Design and develop scripts (e.g., PowerShell, T-SQL) to automate routine database management tasks and improve operational efficiency.

Required Skills and Qualifications

• Proven experience as a Database Administrator or Database Engineer, with a strong focus on Microsoft SQL Server technologies and the Azure platform.
• Expertise in SQL and T-SQL, including writing complex queries, stored procedures, and performing query optimization.
• Hands-on experience with database design, data modeling, and schema management best practices.
• Familiarity with file server management and cloud storage solutions.
• Proficiency with version control systems, specifically Git.
• Experience using project and issue tracking software, such as Jira.
• Strong analytical and problem-solving skills, with impeccable attention to detail.
• Excellent communication skills, capable of collaborating effectively with cross-functional teams and explaining technical concepts to non-technical stakeholders.
• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).

Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate, are a plus.

Target salary range: USD $103,254.00/Yr. - USD $114,547.00/Yr.

General Dynamics Mission Systems (GDMS) engineers a diverse portfolio of high technology solutions, products and services that enable customers to successfully execute missions across all domains of operation. With a global team of 12,000+ top professionals, we partner with the best in industry to expand the bounds of innovation in the defense and scientific arenas. Given the nature of our work and who we are, we value trust, honesty, alignment and transparency. We offer highly competitive benefits and pride ourselves in being a great place to work with a shared sense of purpose. You will also enjoy a flexible work environment where contributions are recognized and rewarded. If who we are and what we do resonates with you, we invite you to join our high-performance team!

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans