Cruz Associates Inc. of Yorktown, VA has an open position for an Aviation Maintenance Database Analyst/Administrator. The job location is at Fort Campbell, KY in support of the ARSOAC Aviation Maintenance Directorate (AAMD).

Scope: The Logistics Database Analyst/Administrator is an entry level position that provides management and control of automated logistical systems primarily related to aircraft support systems and supply support. Provide advice, technical knowledge, guidance, and assistance to all hardware customers (internal and external) at other installation staff agencies, functional specialists, and managers in performing their duties more effectively as pertains to a variety of automated logistical systems. Assist with the database performance by planning, developing, managing, and securing databases. This includes the participation in the architecture and design strategy for individual projects and subject areas, as well as troubleshooting and support of underperforming aspects of the production database environments.

Responsibilities:

• Prepare logistical statistical data for analysis.
• Create and manage SQL Server Reporting Services for multiple customers and subject areas.
• Create and manage SQL Server Integration Services for multiple databases.
• Review database design and systems integration of.
• Make recommendations regarding enhancements and/or improvements.
• Develop and manage database utilization policies, procedures, security, backup, and recovery.
• Maintain design structure by directing implementation of SQL standards and guidelines.
• Provide information by collecting, analyzing, and summarizing database performance and trends.
• Provide data correction and validation.
• Monitor system logs, data flows, and external connections.
• Test and troubleshoot system errors.
• Provides information by collecting, analyzing, and summarizing database performance and trends.
• Provide daily operations support for databases and database servers.
• Manage Microsoft SQL Server database systems while insuring high levels of data integrity and availability.
• Perform basic data queries to provide data reports used for trending and analysis.
• Provides copy of databases to customers as authorized by the Government.
• Develop and maintain installation and configuration procedures.
• Perform regular file archival and purge as necessary.
• Perform other duties as required.
• Perform routine clerical, administrative, and logistics tasks as required in support of the AAMD.

Education and Experience-Required:

• Ability to obtain and maintain a Secret security clearance.
• Bachelor's Degree in Computer Science, Information Systems, or related technical discipline.
• Working knowledge of relational database management systems.
• Working knowledge of SQL Server 2012/2017, SQL Programming, Stored Procedures and Database Security.
• Understanding of Data Maintenance, Database Performance Tuning, and Process Improvement.