Job Title: Database Administrator
Job ID: 2489
Job Location: Fort Leavenworth, KS
Program: Student Management System (SMS) Support
Clearance Requirement: IT Level II Security Clearance
Secret Clearance with grant IT-2 or NAC-LC / T3 Investigation - Must have a favorable background investigation to access the non-classified internet protocol router network (NIPRNET).
IndraSoft, Inc. is seeking a highly-qualified Database Administrator for our project at Fort Leavenworth, KS. The selected candidate will provide refinements and update current capabilities to the Student Management System database in response to changes in the existing system requirements, new requirements, or changes in business processes. Support client schools on Student Management System with business analysis, administration, training and technical support.
Provide backend database administration and support for variety of applications. Must perform administrative and configuration management, support trouble shooting, optimize and test for performance; support software development efforts; support quality documentation of all aspects of database operations and sustainment.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Bachelor’s Degree in computer science or equivalent.
5+ years’ experience of database administration experience and MS SQL database management.
Familiarity with Department of Defense authentication systems (e.g. AKO), data models, terminology and information security requirements.
Must be willing to OBTAIN the following certifications (after start):
MCSA 461 Querying SQL Server
MCSA 462 Administering Microsoft SQL Server Databases
MCSE 464 Developing Microsoft SQL Server Databases
IT Level II Security Clearance
Secret Clearance with grant IT-2 or
NAC-LC / T3 Investigation
Essential Functions and Responsibilities:
Configure, operate, maintain, backup and administer a Database using current Army supported Microsoft Server SQL and Microsoft Windows Server operating systems. Database server includes the SMS Database as well as 12 other databases to support students, staff and faculty.
Plan, design, enforce and audit security controls, policies and procedures which safeguard the integrity of and access to data.
Responsible for configuration, operation and maintenance of SMS Database, ensuring that data is stored and secured according to DoD regulations, and Higher Learning Commission accreditation policies and best practice with the industry database management techniques. This includes but is not limited to, encryption of sensitive data elements such as personally identifiable information (PII), normalizing the database, performance monitoring and fine-tuning of database operations and access control security to provide data confidentiality as well as availability for authorized users.
Responsible for keeping software up to date with required STIG’s and Certificate of Noteworthiness.
Ensure continuous database availability with encryption of the database. The database will be normalized to unbundle any overlapping entities and eliminate redundancies, incompleteness and anomalies.
Maintain the SMS Database and database server with an availability rate of 98% or better with no loss of data or data integrity, outside of scheduled routine maintenance window; encrypt sensitive data within the SMS Database IAW all applicable policies; normalize the SMS Database.
SMS Technical Documentation for each data restoration, configuration, interface, and operation of the server and database. Written document detailing the technical diagrams, specifications, and architecture of the system, which includes details of each SQL query, functions, external system integration (e.g. Blackboard, Nelson-Denny), and other capabilities.
Submit the technical documentation within 5 business days of a change to the server or database.
Documented COOP and Schedule of backup and data restoration procedures, to include daily, incremental, and full back up schedules.
Provide weekly reports on the verification of weekly backup data and test data restoration procedures on the testing and transfer to the back-up server.
Responsible for administering, creating, and maintaining all databases required for development, testing, and production usage.
Installing database releases, patches, and performing database upgrades and or migrations.
Performing capacity planning to create and maintain databases.
Controlling migrations of programs, database changes, and data changes throughout the development cycle.
Establishing and administering database users and roles.
Managing and tuning database imports, exports, log files, and objects.
Monitoring performance, background processes, database views, schema objects, table space, indexes, logs, and synonyms.
Accessing and analyze cache file utilization and performance.
Tuning PL-SQL statements, database performance and maintaining stored procedures.
Creating and maintaining documents depicting database design, operation plans, security plans, and monitoring plans.
Additional responsibilities as assigned by management.
While performing duties of the job, incumbent will be exposed to Normal demands associated with an office environment. Ability to work on computer for long periods, and communicate with individuals by telephone, email and face to face. This position requires incumbent to have the ability to stand, walk, sit, use hands to finger, handle or feel objects, tools, or controls, reach with hands and arms, talk and hear. Employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust and focus.
Work Environment: The noise level in the work environment is usually moderate.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information.