Position Summary Under general supervision, designs, develops, monitors and
maintains moderately complex 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. 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. JITC & ATEC experience preferred. Applicants must hold at least
a secret clearance and eligible to obtain a TS clearance after employment.
Education and Experience Bachelor¿s degree in related discipline plus 2 to 4
years of directly related experience working with databases. In some cases,
educational requirements may be adjusted or waived for more than 7 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. Excellent communication and interpersonal
skills. 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 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.
Women, minorities, individuals with disabilities and veterans are encouraged
to apply.
U.S. Citizenship Required.