Database Administrator

Location
Washington, District Of Columbia
Posted
Sep 01, 2021
Closes
Oct 06, 2021
Ref
18489
Function
Administrative
Hours
Full Time
Summary

The Database Administrator will support the Department of Education by providing knowledge and experience in database administration tasks and technical expertise using at least one of the following DBMS products relevant to the specific task: ORACLE, SYBASE, SQL Server, or equivalent.

Responsibilities
  • Maintain and build/install databases on servers/clients on-premises and a cloud environment.
  • Maintain and create data dictionaries, users, nodes, instances, databases, tablespaces, containers, buffer pools, and logs.
  • Migrate data between databases, extract data from one system, and load into the database without constraints.
  • Write stored procedures and triggers to populate data from non-constraints tables to normalized tables with constraints.
  • Tune the database manager configuration and database configuration parameters, like buffer pools, shared memory variables, I/O variables, application heap, database heap size, logs, and sort area, to increase performance of the system.
  • Analyze the execution path of the query to determine the cost, indexing, and cardinality.
  • Write scripts to create instances, databases, scheduling online, offline backups and restoring databases, implement Active Standby Clustering, or Always on Clustering.
  • Provide highly technical expertise and guidance in the design, implementation, operation, and maintenance of database management systems (DBMS), evaluate, and recommend available DBMS products after matching requirements with system capabilities, determine file organization, indexing methods, and security procedures for specific applications.
  • Control the design and use of databases, control the global view of databases, control the access to the databases, assure the safekeeping of the databases (from accidental or intentional damage or loss), and monitor the use of databases.
  • Define all required database administration policies, procedures, standards, and guidelines. (i.e., data dictionary)
  • Other duties as assigned

Qualifications
  • Bachelor's degree in Computer Science, Information Systems, or related field and 6+ years of experience as a Database Administrator
  • 10+ years of Database Administrator experience may be used in lieu of degree.
  • Top secret clearance required.

Knowledge, Skills and Abilities
  • Ability to obtain Baseline IAT-II certification IAW DoD 8570.01-M requirements within 90 days of contract start.
  • Strong communications skills (both written and oral), strong customer service, and excellent interpersonal skills
  • Strong analysis and comprehension skills.
  • Ability to define and follow required database administration policies, procedures, standards, and guidelines.
  • Ability to provide DBMS recommendations to meet system and customer requirements.
  • Ability to provide technical knowledge and write technical documentation as required.
  • Ability to work nights, weekends, and holidays as required.
  • Ability to maintain top secret clearance.

#Chenega Agile Real Time Solutions, LLC

Similar jobs