Cruz Associates, Inc. logo

Expert Database Analyst / Administrator (DBA)

Cruz Associates, Inc.

Fort Campbell, KYFull-time$7.25/hrTracked 1w agoSeen in employer's feed 5 days ago

Most applications go out cold — see where you stand first. No sign-up to start.

At a glance

Compensation
$7.25/hr
Location
Fort Campbell, KY
Schedule
Full-time
Work Authorization
Not specified

Requirements

Credentials this posting asks for.

Secret clearanceBachelor's degree

Job overview

Cruz Associates, Inc. is hiring an Expert Database Analyst / Administrator (DBA). Cruz Associates Inc. seeks an Expert Database Analyst / Administrator at Fort Campbell, KY to manage and control automated aviation logistical databases, provide technical guidance, develop reports and packages, and ensure security, performance, and daily operations support for the 160th Special Operations Aviation Regiment.

Key focus areas include Prepare logistical statistical data for analysis, Create and manage SSRS reports for multiple customers and subject areas, and Create and manage SSIS packages for multiple databases.

Preferred (not required): SSRS, SSIS, Microsoft SQL Server, and SQL Server 2008.

Skills & qualifications

RequiredNice to have

Skills

SSRSSSISMicrosoft SQL ServerSQL Server 2008SQL ProgrammingStored ProceduresDatabase SecurityRelational Database Management SystemsData MaintenanceDatabase Performance TuningProcess ImprovementBackup and RecoveryInstallation and Configuration ProceduresSystem Log MonitoringData Flow MonitoringTroubleshootingStatistical Data AnalysisReport Creation

Qualifications

Bachelor's DegreeBachelor's Degree in Computer Science or Information Systems or Related Technical DisciplineEquivalent Technical Training or Work ExperienceWorking Knowledge of Relational Database Management SystemsWorking Knowledge of SQL Server 2008, SQL Programming, Stored Procedures and Database SecurityBasic Understanding of Data Maintenance, Database Performance Tuning, and Process ImprovementSecret or Interim Secret Security Clearance

Full job description

Experience Required

None

Minimum Education Required

Bachelor's Degree

Compensation

$7.25 / hourly

Hours Per Week

40

Number Of Positions

1

Work Schedule and Shift Requirements

First (Day)

Job Description

Cruz Associates Inc. of Yorktown, VA has an open position for an Expert 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.

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.

Cruz Associates, Inc. is an Equal Opportunity Employer and is fully committed to attracting, retaining, developing and promoting the most qualified employees without regard to their r ace, gender, color, r eligion, s exual orientation, national origin, age, physical or mental disability, citizenship status, veteran status, or any other characteristic prohibited by state or local law.

Job Type

Full time

Benefits Offered

Not specified

Veteran Preference

No

Place of Work

On-site

Requisition ID

1060

You've read the whole posting — now see how you match it.