Apply on Employer Site

General Dynamics · 1 month ago

Advanced Database Design Engineer

USA-AZ-Scottsdale

Full-time

Hybrid

Senior Level

5+ years exp

General Dynamics is a leading company in high technology solutions, and they are seeking an Advanced Database Design Engineer to manage and optimize their data infrastructure. The role involves administering Azure SQL databases, designing database schemas, and collaborating with teams to ensure data integrity and performance.

AerospaceNational SecurityPublic Transportation

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Administer, monitor, and maintain Azure SQL Databases, Azure SQL Managed Instances, and SQL Server on Azure VMs, ensuring high performance, availability, and security

Design and implement logical and physical database schemas, including tables, indexes, views, and relationships, to support application requirements and business needs

Organize and manage large datasets, implementing data standards, procedures, and definitions for data elements to ensure data integrity and quality

Proactively monitor database performance, identify bottlenecks, and implement optimizations, including query tuning and indexing strategies

Develop, manage, and test robust backup and recovery plans and disaster recovery procedures to ensure business continuity and minimize data loss

Implement and manage security measures, including user access controls, permissions, and data encryption, to safeguard sensitive information and ensure compliance

Utilize Git for source code/version control of database scripts and schema changes, and manage tasks, issues, and project workflows within Jira

Understand and manage data storage across traditional file servers and integrate storage solutions with cloud platforms like Azure Storage Accounts (BLOB, File Share)

Work closely with software engineers, data analysts, and IT staff to ensure seamless integration of database systems with applications and provide technical support

Design and develop scripts (e.g., PowerShell, T-SQL) to automate routine database management tasks and improve operational efficiency

Qualification

Azure SQL Database ManagementDatabase DesignSQLT-SQLPerformance TuningBackupDisaster RecoverySecurityAccess ControlVersion Control (Git)Project Management (Jira)File Server KnowledgeAutomationScriptingAnalytical SkillsRelevant CertificationsCommunication SkillsCollaboration SkillsAttention to Detail

Required

Requires a Bachelor's degree in Engineering, or a related Science, Technology or Mathematics field

5+ years of job-related experience, or a Master's degree plus 3 years of job-related experience

U.S. citizenship is required

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)