Under immediate supervision, assists with the design, development, monitoring and maintenance of database management systems and related components underlying business applications. Responsible for end-to-end support, administration and configuration management of databases and the servers they run on.
Duties and Responsibilities
Works with customers to design data management, information life-cycle management, infrastructure design and security and data integrity controls.
Drafts 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.
Assists with 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, drafting reports and recommendations for improvements as needed.
Investigates database faults, diagnoses bugs, researches problems of limited complexity with vendors and works to restore database function during outages.
Assists with 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 manage data replication procedures and tools.
Assists with 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.
Education and Experience
Bachelor's degree in related discipline plus 0 to 2 years of directly related experience working with databases.
In some cases, educational requirements may be adjusted or waived for more than 5 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
Excellent communication and interpersonal skills.
Familiar with relational principles, general DBA techniques and practices, as well as the ability to understand relationships dictated by the data schema.
Knowledge is required in the following technologies: SQL Server - Transact SQL (authoring procs, type of parameters, use of functions, error handling, transaction statement, table variables and SQL - DB Design, identity columns, relationships, indexes, triggers and constraints.
A security clearance of an appropriate level may be required after employment.
Women, minorities, individuals with disabilities and veterans are encouraged to apply.
U.S. Citizenship Required.
Alion creates alliances between science and big government. Alion Science and Technology is an employee-owned development and research...