Senior Database Administrator

Cruz Associates, Inc.; Fort Campbell North (KY); On-site; USD 85,000 - 110,000; Full time

Job summary

Cruz Associates Inc. seeks a Senior Database Administrator to manage and optimize SQL Server databases in support of aviation logistics at Fort Campbell, KY.

The role requires ensuring data integrity, availability, and security for mission-critical systems across multiple customers and environments. You will perform performance tuning, design and implementation of backup/recovery procedures, develop SSRS reports, review data structures, and advise on best practices in database architecture.

Qualifications

• Bachelor's degree in a technical field or equivalent experience.
• Strong knowledge of relational databases and SQL Server.
• Minimum 4 years of experience in military aviation maintenance/logistics databases.

Responsibilities

• Prepare logistical data for analysis and reporting.
• Create and manage SSRS reports for multiple customers.
• Create and manage SSIS packages across databases.
• Review database design and systems integration.
• Develop backup, security, and recovery procedures.
• Ensure data integrity and availability of production databases.
• Provide daily operations support for databases and servers.
• Assist in troubleshooting and performance improvements.
• Maintain SQL standards and guidelines.
• Provide data analysis and trends to stakeholders.

Skills

Relational databases

SQL programming

Performance tuning

Backup & recovery

Data analysis

Troubleshooting

Education

Bachelor's degree in computer science or related field

Secret clearance eligibility

Tools

SSRS

SSIS

SQL Server

Job description

Cruz Associates Inc. of Yorktown, VA has an open position for aSenior Database Administrator.The job location is at Fort Campbell, KY in support of the 160 th Special Operations Aviation Regiment (SOAR).

Scope of Performance

The Senior Database Administrator will provide management and control of automated databases for a myriad of aviation logistical support systems.The Senior DBA will provide advice, technical knowledge, guidance and assistance to customers (internal and external) on automated logistical systems.The Senior DBA will participate in database architecture, performance, security, and design strategy for projects, as well as assist in troubleshooting and support of underperforming aspects of the production database environments.

Responsibilities

• Preparelogisticalstatisticaldatafor analysis.
• Create and manage SSRS reports for multiple customers and subject areas.
• Create and manage SSIS packages for multiple databases.
• Review database design and systems integration.
• 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 routine clerical, administrative, and logistics tasks as required in support of the Aviation Maintenance and Sustainment Office (AMSO).

Education and Experience

• Bachelors Degree in Computer Science, Information Systems, related technical discipline, or equivalent technical training or work experience.
• Working knowledge of relational database management systems
• Minimum 4 years experience in military aviation maintenance and logistics database management.
• Working knowledge of SQL Server, SQL Programming, Stored Procedures and Database Security.
• Understanding of Data Maintenance, Database Performance Tuning, and Process Improvement.
• Ability to obtain and maintain a Secret security clearance.