Position Summary As the organizational expert in the field, performs design,
development, monitoring and maintenance of the most 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 Consults with customers at the highest level 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. Consults with 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. Designs and analyzes 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. Communicates analysis to management. Investigates
database faults, diagnoses bugs, researches highly 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 state-of-the-art support to customers. Provides guidance to less
experienced Database Administrators. JITC & ATEC experience preferred.
Applicants must hold at least a secret clearance and eligible to obtain a TS
clearance after employment. Education and Experience Masters degree in related
discipline plus 10 to 12 years of directly related experience working with
databases. Professional certification(s) may be required. In some cases,
educational requirements may be adjusted or waived for more than 20 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. Expert knowledge of relational principles, general DBA techniques and
practices, as well as the ability to understand extremely complicated
relationships dictated by the data schema. Expert 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.