Data Repository Manager / Administrator - 26043 in Suffolk, VA at Alion Science and Technology

Date Posted: 4/27/2018

Job Snapshot

  • Employee Type:
  • Location:
    Suffolk, VA
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:
  • Job ID:

Job Description


Position Summary

The Joint Training Data Services (JTDS) Database Administrator provides design, development, and deployment of enterprise data services and training repositories to support Joint Training activities. Joint Training requires data to define the operational environment including terrain, geospatial, force structure, logistics, unit & platform characteristics, weapons and sensor parametrics, human geography, weather and bathymetry.

JTDS includes a web portal, the Order of Battle Service (OBS), Force Management Service (FMS), Terrain Generation Service (TGS), and associated data repository management functions. Provides technical expertise for database design, implementation, information storage and retrieval, data flow and analysis.

Duties and Responsibilities

Works with customers to design data management, information life-cycle management, infrastructure design and security and data integrity controls.

Develops database documentation, procedures and policies. Works with the system administrator to manage user and application security levels for the database.

Supports applications development teams to ensure data designs will operate efficiently once implemented, including overall database design, helping developers tune queries, assigning proper indexes, and the creation of triggers and stored procedures.

Responsible for the overall configuration management of the database technologies, including initial database installations, upgrades to new product releases and the installation of service packs.

Monitors and analyzes database performance, producing reports and recommendations for improvements as needed.

Investigates database faults, diagnoses bugs, researches moderately complex problems with vendors and works to restore database function during outages.

Manages backup and recovery of the database, including establishing standards and schedules for database backups, developing recovery procedures for each database and ensuring that the backup schedules meet recovery requirements.

May also develop and manage data replication procedures and tools.

Responsible for storage management monitoring, planning for space requirements and adding new storage space as needed.

Conducts technical reviews of systems and databases to provide support to customers.

Performs additional duties and responsibilities as assigned.

Education and Experience

Bachelor’s degree in related discipline plus five or more years of directly related experience working with databases.

In some cases, educational requirements may be adjusted or waived for more than 9 years applicable work experience. Work experience may be adjusted for highly specialized knowledge or uniquely applicable experience for positions involving new technology or labor market shortages as reflected by 
market survey data.

Knowledge, Skills, Abilities

Ability to tailor a system to meet specific organizational needs.

Maintains an understanding of relational principles, general DBA techniques and practices, as well as the ability to understand moderately complex relationships dictated by the data schema.

Experience or knowledge in Oracle, PostgreSQL, preferred; SQL Server, MySQL or other software is acceptible.

Knowledge of secure operating systems as well as data security.

Two years of professional experience in M&S system design is desired.

Two years of professional experience with development in a Linux/UNIX environment is desired. 

Strong written and oral communication skills and ability to work in a team environment is required. 

Military domain experience is a plus. 

On-site support required.  Interface with customers on a daily basis.

Shell scripting is a plus.

System interface development experience is a plus.

Security:  Must hold and maintain, at minimum, an Active Secret security clearance.



Diversity Statement

Women, minorities, individuals with disabilities and veterans are encouraged to apply.  Alion will provide a reasonable accommodation to individuals with disabilities and disabled veterans who need assistance to apply.  Please visit the Alion Careers site for more information

U.S. Citizenship Required.

Next Steps

Join Our Talent Network

Join Our Talent Network

Join the Alion Science and Technology Corporation Talent Network today and stay up-to-date on our openings as they continue to become available! As a member of our network, you will receive alerts with new job opportunities that match your interests and have the ability to share job opportunities through social media or email. Join now!

Whether you choose to apply or just leave your information, we look forward to staying connected
with you.