Database Specialist / Administrator
The Database Specialist / Administrator supports the Department of the Interior’s (DOI) Office of Special Trustee for American Indians (OST). The OST is in the process of converting historical documents stored at the American Indian Records Repository (AIRR) to electronic records. The collection of documents contains materials related to Indian Trust, education and other topics received from across the United States reaching back into the 18th Century. The Database Specialist / Administrator will be an expert in Open Database Connectivity (ODBC), Web-database Services, SQL, and associated products such as Tableau. This individual will work to define and support the single truth dataset within OST.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include the following. Other duties may be assigned.
Responsible for the integration of CNI Core Competencies into daily functions, including: commitment to integrity, knowledge / quality of work, supporting financial goals of the company, initiative / motivation, cooperation / relationships, problem analysis / discretion, accomplishing goals through organization, positive oral / written communication skills, leadership abilities, commitment to Affirmative Action, reliability / dependability, flexibility and ownership / accountability of actions taken.
Develops an internal / external web portal solution in support of the Digital Center of Excellence. The portal will serve as the main interface for OST, BIA, BIE, AS-IA and other party Tribal and non-Tribal records. The Portal will also serve as a research center for those seeking access in support of research needs as well as a processing portal for records requests and management of records. The portal will replace the existing Versatile platform and will be developed and reside in a fully compliant existing cloud instance provided by the OST.
Administrates organization's database, using database management system to organize and store data.
Ascertains user requirements, creates computer databases, and tests and coordinates changes.
Interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.
Ensures performance of database.
Performs day-to-day database maintenance, including data archival, data recovery, anomaly detection and data entry.
Develops systems and process to monitor data integrity issues.
Defines and champions database best practices.
Troubleshoots and resolves operational problems.
Tests new applications and procedures. Corrects data as required and provides feedback to appropriate personnel.
Accumulates and stores data from diverse sources.
Analyzes information, runs queries to ensure accuracy and generates regular and customized reports.
Creates reports as may be required of system data problems.
Proactively reviews and improves overall system data processes to ensure high integrity of information.
Monitors quality assurance efforts.
Ensures the information provided is consistent, timely, and accurate.
Responsible for aiding in own self-development by being available and receptive to any training made available by the company.
Plans daily activities within the guidelines of company policy, job description and supervisor’s instruction in such a way as to maximize personal output.
Responsible for keeping own immediate work area in a neat and orderly condition to ensure safety of self and coworkers. Will report any unsafe conditions and/or practices to the appropriate supervisor and human resources. Will immediately correct any unsafe conditions to the best of own ability.
Bachelor’s degree in MIS, Computer Science or a similar field of study preferred, but not required. Minimum of five (5) years’ relevant experience (or an equivalent combination of education and experience).
CERTIFICATES / LICENSES / REGISTRATION
JOB SPECIFIC KNOWLEDGE / SKILLS / ABILITIES
Knowledge in Microsoft Access and Visual Basic for Applications, Microsoft SQL and Oracle or UNIX-based systems (such as CUADRA STAR)
Knowledge of database concepts, object and data modeling techniques and design principles with an understanding of different data structures and their benefits / limitations under particular use cases
Knowledge of software programming, development, review, audit, testing, configuration management requirements and changes
Knowledge of computer hardware, systems software, and computer systems architecture and integration
Ability to work independently or as part of a cross-functional team
Excellent communication and documentation skills
Excellent critical thinking and problem-solving skills
Detail-oriented with ability to prioritize tasks
Ability to read, analyze, and interpret general business periodicals, professiona1journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
The physical demands described here are representative of those that must be met by an employee to perform successfully the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job. Work is primarily performed in an office environment. Regularly required to sit. Regularly required use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers printers and light traffic.