Senior Database Administrator and Reporting Engineer

Job ID: 111313

DRS RADA Technologies, a subsidiary of Leonardo DRS, is focused on proprietary radar solutions and legacy avionics systems supporting the defense industry globally. The company is a global pioneer of AESA tactical radars for active military protection, counter-drone applications, critical infrastructure protection, and border surveillance. 

Job Summary

This role requires the candidate to dual-hat as a report writer while actively engaging in the planning and structuring of a data warehouse aimed at supporting future capabilities such as Business Intelligence (BI) and Artificial Intelligence (AI). The ideal candidate should have extensive experience with Power BI, high proficiency with SQL. The individual must have a keen interest in building out a data warehouse conducive to a rapidly expanding business, dealing with diverse data types and structures; including but not limited to Engineering and Manufacturing data.

Job Responsibilities

• Design and generate reports for critical business functions, examples such as Sales Reporting, Labor Efficiency, and Program status, while building the foundation for a comprehensive data warehouse.
• Responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software
• Deep understanding and operational knowledge of ERP systems, particularly Deltek Costpoint, are essential
• Contribute expertise to the use of the Atlassian suite, especially JIRA, for project tracking and management processes
• Oversee installation, configuration and upgrade of database serve r software and related products
• Design, code, and schedule scripts/jobs to update, maintain, or transfer databases and simplify data entry for users
• Monitor access time, perform validation checks and use other methods to monitor and analyze database performance
• Maintain and document database objects (e.g. scripts, views, jobs, indexes, etc). Ensure that documentation is up to date, complete, and aligns with established standards
• Take appropriate measures to ensure acceptable performance, sustainability, and scalability
• Perform complex technical trouble shooting and provide consultation to development teams
• Develop and apply procedures relating to database and application security including access controls
• Establish, test and maintain disaster recovery and archive procedures
• Design archive, recovery and load strategies
• Interface with database vendors for technical support
• Evaluate and provide guidance around the selection and implementation of database features and database related third-party products
• Maintain documentation for database configuration and architecture
• Coordinate with end users and technical staff to implement and maintain systems that utilize industry best practices to meet business objectives, while maintaining the security and integrity of the data, system and network
• Develop project plans, provide direction and coordinate project activities associated with the installation, evaluation, implementation, and maintenance of business solutions and when required, manage a small project team to implement chosen solutions that require Information Technology expertise
• Review and monitor the progress of projects to ensure accuracy and timeliness and provide periodic reports to management
• Provide functional direction and technical expertise to less experienced personnel
• Prepare, coordinate and support user training and documentation and provide technical assistance for postimplementation support issues
• Provide service desk and technical support to users
• Devise solutions to system-related problems and issues through coordination with users, other system analysts or engineers to assess and identify probable conflicts and investigate diverse data elements and sources
• Work with management to define appropriate standards, policies, procedures, software tool sets, and supporting peripherals to facilitate the management, accountability, functionality, and security of systems
• Provide ongoing trend analysis for determining current needs and future resource requirements
• Support, communicate, reinforce and defend the mission, values and culture of the organization

Job Responsibilities Part II

• Lead the design and development of architectural layouts or enhancements to databases
• Review description of changes to database design to understand changes and how they will affect data stores in terms of physical characteristics
• Maintain timely and accurate helpdesk records using the ticket management system
• Assist with the detailed project planning efforts on larger projects, and may act as a project manager on smaller efforts