Expert Level Database Analyst / Administrator (DBA)

ADP, Inc.; Fort Campbell North (KY); On-site; USD 110,000 - 150,000; Full time

Job summary

Cruz Associates Inc. is seeking an Expert Level Database Analyst / Administrator for a position located at Fort Campbell, KY in support of the 160th Special Operations Aviation Regiment (SOAR).

The role involves managing automated databases across aviation logistical support systems, advising customers, and contributing to database architecture, performance, and security. The DBA will assist in design strategies and troubleshooting for production environments.

Qualifications

• Bachelor’s Degree in Computer Science, Information Systems, or related technical discipline or equivalent.
• Working knowledge of relational database management systems.
• Working knowledge of SQL Server 2008, SQL programming, stored procedures and database security.
• Basic understanding of Data Maintenance, Database Performance Tuning, and Process Improvement.
• Possesses a Secret or Interim Secret security clearance.

Responsibilities

• Prepare logistical statistical data for 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.
• Develop and maintain installation and configuration procedures for databases.
• Provide daily operations support for databases and database servers.
• Manage Microsoft SQL Server database systems with high data integrity and availability.
• Perform routine data queries to provide data reports for trending and analysis.

Skills

Relational databases

Data analysis

Security best practices

Education

Bachelor’s Degree in Computer Science / Information Systems or related field

Tools

SQL Server 2008

SSRS

SSIS

SQL Programming

Stored Procedures

Job description

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

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

Full-Time Regular Fort Campbell, KY, US

Responsibilities:

• Prepare logistical statistical data for 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:

• Bachelor’s Degree in Computer Science, Information Systems, related technical discipline, or equivalent technical training or work experience.
• Working knowledge of relational database management systems.
• Working knowledge of SQL Server 2008, SQL Programming, Stored Procedures and Database Security.
• Basic understanding of Data Maintenance, Database Performance Tuning, and Process Improvement.
• Possesses a Secret or Interim Secret security clearance.