Apply on Employer Site

General Dynamics Mission Systems · 4 weeks ago

Advanced Database Design Engineer

Scottsdale, AZ

Full-time

Hybrid

Mid, Senior Level

$106K/yr - $117K/yr

5+ years exp

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. They are seeking an experienced Azure Database Administrator / Data Engineer to manage and optimize their data infrastructure across cloud and on-premises environments.

AerospaceBusiness Information SystemsInformation ServicesInformation TechnologyNational SecuritySensor

No H1B

Security Clearance Required

U.S. Citizen Only

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

Qualification

Azure SQL Database ManagementDatabase DesignSQLT-SQLVersion Control (Git)Project Management (Jira)BackupDisaster RecoveryAnalytical SkillsCommunication SkillsCollaboration SkillsProblem-Solving Skills

Required

Requires a Bachelors 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)

Preferred

Department of Defense Secret security clearance is preferred at time of hire

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

Benefits

Flexible work environment

Highly competitive benefits

Company

General Dynamics Mission Systems

Glassdoor3.9

General Dynamics Mission Systems designs and delivers critical systems and products for defense and cybersecurity customers. It is a sub-organization of General Dynamics.

Founded in 1952

Fairfax, Virginia, USA

10001+ employees