Advanced Database Design Engineer

Advanced Database Design Engineer

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

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

Salary Note : This estimate represents the typical salary range for this position based on experience and other factors (geographic location, etc.). Actual pay may vary. This job posting will remain open until the position is filled. Combined Salary Range : USD $103,254.00 - USD $114,547.00 / Yr.

Company Overview : 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