Database Dsgn Eng Sr Prin

BAE Systems - Sterling, VA

Full-time - Senior

Sterling, VA

Computer and Electronic Product Manufacturing

About the position

BAE Systems is seeking a Senior Principal Database Design Engineer to design, implement, and maintain robust databases that support customer applications. This role focuses on ensuring data integrity, security, and availability while optimizing database performance and integrating data from various sources into a data warehouse. The ideal candidate will have extensive experience in database administration, performance tuning, and business intelligence tools, contributing to the overall success of the organization by providing data-driven insights and collaborating with cross-functional teams.

Responsibilities

• Design, implement, and maintain robust, scalable, and performant databases to support customer applications, ensuring data integrity, security, and availability.
• Optimize database performance by fine-tuning queries, indexing strategies, and database configurations.
• Design and build data pipelines to integrate data from disparate sources into a single data warehouse.
• Ensure data quality and consistency across all stages of the ETL process.
• Monitor database performance and proactively identify and resolve issues to minimize downtime.
• Implement backup and recovery strategies to safeguard data integrity and availability.
• Perform regular database maintenance tasks such as backups, restores, and integrity checks.
• Utilize tools like Report Builder, Microsoft SQL Server Reporting Services (SSRS), and Microsoft SQL Server Management Studio (SSMS) to create informative reports, ensuring data accuracy and integrity.
• Utilize PowerBI Report Builder for crafting custom paginated reports.
• Provide data-driven intelligence to key stakeholders throughout the business.
• Conduct analysis and routine KPI reporting to support business operations.
• Collaborate with cross-functional teams to define and implement CI/CD pipelines for database changes and version control processes.
• Automate routine database administration tasks and create scripts to streamline processes and improve efficiency.
• Troubleshoot and consult with project teams for resolution on the most complex technical issues or business situations and make recommendations to improve or enhance existing architectural direction for future system offerings.

Requirements

• Bachelor's degree in a technical discipline from an accredited college or university is required.
• Minimum of 5 years' experience with database support, including MS SQL Server, PostGRES, DB2, and Cassandra.
• 2+ years of experience with Business Intelligence tools such as PowerBI, Tableau, Qlik.
• Understanding of administration of database management systems (DBMS) such as MySQL or Microsoft SQL Server, DB2.
• Demonstrated expertise in PowerBI Report Builder.
• Knowledge of database design and development concepts.
• Familiarity with database performance tuning and optimization techniques.
• Knowledge and familiarity with MS SQL Report Builder.
• Familiarity with SQL and database scripting languages such as T-SQL, PL/SQL, or SQL*Plus.
• Must be a self-starter with excellent communication skills, both written and verbal.
• Ability to work seamlessly in a cross-functional team environment as well as independently.
• Excellent problem-solving skills.
• Willingness to learn business operations of a complex Model Based Systems Engineering software enterprise.